Status
Not open for further replies.

Jem

Customer
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 :​
 
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.
 
Code:
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.
 
Thank you, this has solved the issue. Once again, unbelievable timeliness and service from DragonByte.
 
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
 
Last edited:
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.
 
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?
 
Last edited:
Status
Not open for further replies.

Legacy vBActivity & Awards

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
1,723
Customer rating
0.00 star(s) 0 ratings
Back
Top