Bug MySQL Errors a plenty

[Jem]

Greetings,

I am installing the Lite version of this mod on a fresh install of 4.1.7pl2. I am receiving the following MySQL errors:

Instance 1

Database error in vBulletin 4.1.7:

Invalid SQL:

UPDATE user
SET dbtech_vbactivity_excluded_tmp = IF(dbtech_vbactivity_excluded = '1'
OR FIND_IN_SET(26, membergroupids)
OR usergroupid IN(26), '1', '0');

MySQL Error : Unknown column 'dbtech_vbactivity_excluded_tmp' in 'field list'
Error Number : 1054
Request Date : Thursday, December 8th 2011 @ 02:45:19 AM
Error Date : Thursday, December 8th 2011 @ 02:45:21 AM
Script : Log in - TTNB - vBulletin Admin Control Panel
Referrer : Log in - TTNB - vBulletin Admin Control Panel
IP Address : 98.226.57.73
Username : Say892
Classname : vB_Database_MySQLi
MySQL Version : 5.5.18-cll​

Instance 2

Database error in vBulletin 4.1.7:

Invalid SQL:

UPDATE user
SET dbtech_vbactivity_excluded_tmp = IF(dbtech_vbactivity_excluded = '1'
OR FIND_IN_SET(26, membergroupids)
OR usergroupid IN(26), '1', '0');

MySQL Error : Unknown column 'dbtech_vbactivity_excluded_tmp' in 'field list'
Error Number : 1054
Request Date : Thursday, December 8th 2011 @ 12:34:11 AM
Error Date : Thursday, December 8th 2011 @ 12:34:11 AM
Script : http://www.sadaar.com/ttnb2/cron.php?rand=1323304448
Referrer : Parties!!
IP Address : 173.215.177.6
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :​

Instance 3

Database error in vBulletin 4.1.7:

Invalid SQL:

UPDATE user
SET dbtech_vbactivity_excluded_tmp = IF(dbtech_vbactivity_excluded = '1'
OR FIND_IN_SET(26, membergroupids)
OR usergroupid IN(26), '1', '0');

MySQL Error : Unknown column 'dbtech_vbactivity_excluded_tmp' in 'field list'
Error Number : 1054
Request Date : Thursday, December 8th 2011 @ 12:26:03 AM
Error Date : Thursday, December 8th 2011 @ 12:26:03 AM
Script : http://www.sadaar.com/ttnb2/cron.php?rand=1323303959
Referrer : Skydust vs Aquires for #1 Tapper in the World
IP Address : 68.61.165.196
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :​

 

[Ozzy47]

Fillip H. will answer this once he gets up in the am, I am not sure what's going on but this is the first I have seen this reported.

 

[Fillip H.]

ALTER TABLE user ADD dbtech_vbactivity_excluded_tmp ENUM('0','1') DEFAULT '0'

For some reason, certain MySQL installations have problems creating ENUM columns. I've never been able to figure out why.

 

[Jem]

Thank you, this has solved the issue. Once again, unbelievable timeliness and service from DragonByte.

 

[Giorgos Antonopoulos]

i have the same problem how can i fix this?
thank you

Database error in vBulletin 4.1.10:

Invalid SQL:

UPDATE user
SET dbtech_vbactivity_excluded_tmp = IF(dbtech_vbactivity_excluded = '1'
OR FIND_IN_SET(6, membergroupids) OR FIND_IN_SET(23, membergroupids)
OR usergroupid IN(6,23), '1', '0');

MySQL Error : Unknown column 'dbtech_vbactivity_excluded_tmp' in 'field list'
Error Number : 1054

 

[Fillip H.]

Follow the instructions in my previous post on this page

 

[Giorgos Antonopoulos]

Follow the instructions in my previous post on this page

hi thank you is that inposible to help my step by step?were i found this code for edit?

ALTER TABLE user ADD dbtech_vbactivity_excluded_tmp ENUM('0','1') DEFAULT '0'

 

[bszopi]

Run that query in your database and it will add the appropriate column to the table.

 

[Giorgos Antonopoulos]

Run that query in your database and it will add the appropriate column to the table.

sory i am new i have only admin cp can this help?were i can run that query from admin cp or ftp?thank you again

 

[Fillip H.]

You can use the "Execute SQL Queries" function under the Maintenance menu group to run queries. You may need to add your userid to the relevant variable in /includes/config.php for that to be possible, though.

 

[Giorgos Antonopoulos]

Query
ALTER TABLE user ADD dbtech_vbactivity_excluded_tmp ENUM('0','1') DEFAULT '0'
RESTART

Confirm Query Execution
This query may modify data in your database. If this change is done in error, it is possible that you will not be able to recover from this change. Are you sure you wish to continue?
i have paste the code in the box
is that ok?
Now next restart or continue?

 

[Fillip H.]

Yes that is ok, continue

 

[Giorgos Antonopoulos]

Yes that is ok, continue

thank you so mats for your help all the best for you now works