Bug Mysql Problem

[CubicWebs]

HabbFever Database Error

Warning: mysqli_query() [function.mysqli-query]: (42S22/1054): Unknown column 'dbtech_vbactivity_excluded_tmp' in 'field list' in [path]/includes/class_core.php on line 1391
Database error
The HabbFever database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the habbfeverforum.net home page, then try to open another page.
Click the Back button to try another link.
The habbfeverforum.net forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.


Database error in vBulletin 4.2.0:

Invalid SQL:

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

MySQL Error : Unknown column 'dbtech_vbactivity_excluded_tmp' in 'field list'
Error Number : 1054
Request Date : Wednesday, June 13th 2012 @ 03:42:01 PM
Error Date : Wednesday, June 13th 2012 @ 03:42:01 PM
Script : HabbFever Database Error
Referrer :
IP Address : *********
Username : Xen
Classname : vB_Database_MySQLi
MySQL Version : 5.5.23-55

 

[Fillip H.]

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

 

[CubicWebs]

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

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ATLTER TABLE user ADD dbtech_vbactivity_excluded_tmp ENUM('0','1') DEFAULT '0'' at line 1

when I try and add that

 

[Trekkan]

[URL=http://www.dragonbyte-tech.com/usertag.php?do=list&action=hash&hash=1064]#1064 [/URL] - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ATLTER TABLE user ADD dbtech_vbactivity_excluded_tmp ENUM('0','1') DEFAULT '0'' at line 1

when I try and add that

There's a typo from Fillip H., change first word of the query to "ALTER"

 

[CubicWebs]

There's a typo from Fillip H., change first word of the query to "ALTER"

Thank you