Bug Database error when trying to update forum settings

[reeshe]

When trying to update my forums for usage:

Database error in vBulletin 4.1.10:

Invalid SQL:
UPDATE forum SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`dbtech_ajaxthreads_cannotautoupdate` = '0'
WHERE forumid = 51;

MySQL Error   : Unknown column 'dbtech_ajaxthreads_cannotautoupdate' in 'field list'
Error Number  : 1054
Request Date  : Sunday, February 19th 2012 @ 01:54:17 PM
Error Date    : Sunday, February 19th 2012 @ 01:54:17 PM
Script        : http://www.synciti.net/forum/admincp/ajaxthreads.php?do=forum
Referrer      : http://www.synciti.net/forum/admincp/ajaxthreads.php?do=forum

 

[Fillip H.]

ALTER TABLE forum ADD dbtech_ajaxthreads_cannotautoupdate ENUM('0','1') DEFAULT '0'

 

[reeshe]

Ran that..Now i get this one:

Database error in vBulletin 4.1.10:

Invalid SQL:
UPDATE forum SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`dbtech_ajaxthreads_cannotmanualupdate` = '0'
WHERE forumid = 51;

MySQL Error : Unknown column 'dbtech_ajaxthreads_cannotmanualupdate' in 'field list'
Error Number : 1054
Request Date : Sunday, February 19th 2012 @ 02:09:50 PM
Error Date : Sunday, February 19th 2012 @ 02:09:51 PM


Thanks for quick update

 

[Fillip H.]

Same query except replace "auto" with "manual"

 

[reeshe]

I assumed that but didn't want to break anything..lol. Thank you that worked perfectly.

 

[Kitch87]

Hi guys, I have this same problem, sorry for sounding a bit thick but where do I ALTER TABLE forum? Any help would be great, cheers

 

[Fillip H.]

You can use the "Execute SQL Queries" function in vBulletin under the Maintenance group, or phpMyAdmin if your server has that installed

 

[Kitch87]

You can use the "Execute SQL Queries" function in vBulletin under the Maintenance group, or phpMyAdmin if your server has that installed

OK, then what do I do, do I write something in Manual Query? Thanks for responding.

 

[Fillip H.]

First this:

ALTER TABLE forum ADD dbtech_ajaxthreads_cannotautoupdate ENUM('0','1') DEFAULT '0'

then click submit, then click confirm, then click restart, then enter this:

ALTER TABLE forum ADD dbtech_ajaxthreads_cannotmanualupdate ENUM('0','1') DEFAULT '0'

then click submit, then click confirm.

If you receive an error about "Table forum does not exist" then you need to open /includes/config.php and find me the "tableprefix" variable there, and tell me what that's set to

 

[Kitch87]

That worked fine, working great now, thanks for your help, very much appreciated.

 

[Taurus]

I am having the same issue. After trying to update the forum for usage I get this:

Database error in vBulletin 4.2.1:

Invalid SQL:
UPDATE vbforum SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`dbtech_ajaxthreads_cannotautoupdate` = '0'
WHERE forumid = 190;

MySQL Error : Unknown column 'dbtech_ajaxthreads_cannotautoupdate' in 'field list'
Error Number : 1054
Request Date : Tuesday, May 21st 2013 @ 03:46:20 PM
Error Date : Tuesday, May 21st 2013 @ 03:46:20 PM

I tried running the query as listed above, however I have a tableprefix of vb so I added that in the query like this, not sure if correct though:

ALTER TABLE vb forum ADD dbtech_ajaxthreads_cannotautoupdate ENUM('0','1') DEFAULT '0'

But then I get this message:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 'forum ADD dbtech_ajaxthreads_cannotautoupdate ENUM('0','1') DEFAULT '0'' at line 1

I hope you can help. Thanks.

 

[Fillip H.]

ALTER TABLE vbforum ADD dbtech_ajaxthreads_cannotautoupdate ENUM('0','1') DEFAULT '0'

 

[Taurus]

That sorted it thank you very much!