BUG in 1.5.7 - Cant delete thread or merge

when my mods were deleting or merging threads, they came across this error message

Database error in vBulletin 3.5.4:
Invalid SQL:
    UPDATE TABLEPREFIXuser AS user, post AS post
    SET
     `user.vbbux` = `user.vbbux` + `post.vbbux`
    WHERE
     post.threadid = '13790'
     AND user.userid = post.userid;
MySQL Error  : Table 'forums.TABLEPREFIXuser' doesn't exist
Error Number : 1146
Date         : Sunday, July 2nd 2006 @ 05:57:47 PM
Script       : http://xxx.xxx/inlinemod.php
Referrer     : http://xxx.xxx/inlinemod.php
IP Address   : 
Username     : 
Classname    : vB_Database_MySQLi

changing the word TABLEPREFIX to TABLE_PREFIX in files vbplaza_threaddata_delete.php and vbplaza_postdata_delete.php now gave me this error

Database error in vBulletin 3.5.4:

Invalid SQL:

				UPDATE user AS user, post AS post
				SET
					`user.vbbux` = `user.vbbux` + `post.vbbux`
				WHERE
					post.threadid = '13790'
					AND user.userid = post.userid;

MySQL Error  : Unknown column 'user.vbbux' in 'field list'
Error Number : 1054
Date         : Sunday, July 2nd 2006 @ 08:04:54 PM
Script       : http://xxx.xxx/inlinemod.php
Referrer     : http://xxx.xxx/inlinemod.php
IP Address   : 
Username     : 
Classname    : vB_Database_MySQLi

i also get strange html markups when editting posts

[CMX_CMGSCCC]

Yes, TABLEPREFIX should be TABLE_PREFIX.

It will be fixed in v1.5.8

-CMX

[Datacenter1.com]

I still getting this after 1.5.8 upgrade

Database error in vBulletin 3.5.4:

Invalid SQL:

				UPDATE user AS user, post AS post
				SET
					`user.vbbux` = `user.vbbux` + `post.vbbux`
				WHERE
					post.threadid = '3242'
					AND user.userid = post.userid;

MySQL Error  : Unknown column 'user.vbbux' in 'field list'
Error Number : 1054
Date         : Thursday, July 13th 2006 @ 08:50:09 PM

Any ideas how to fix this?

[SMO]

i get the error as well when deleting posts. I can delete the posts when vbbux is disabled.

[Nathan2006]

Originally Posted by Datacenter1.com

I still getting this after 1.5.8 upgrade

Database error in vBulletin 3.5.4:
 
Invalid SQL:
 
                UPDATE user AS user, post AS post
                SET
                    `user.vbbux` = `user.vbbux` + `post.vbbux`
                WHERE
                    post.threadid = '3242'
                    AND user.userid = post.userid;
 
MySQL Error  : Unknown column 'user.vbbux' in 'field list'
Error Number : 1054
Date         : Thursday, July 13th 2006 @ 08:50:09 PM

Any ideas how to fix this?

I'm getting the exact same error when trying to delete posts running 1.58 on 3.54

[Nathan2006]

Is there any fix for this?

I cannot keep disabling the product every time I want to delete a post

[DJ XtAzY]

yep same error message still

[Nathan2006]

Members are even getting errors while replying to threads

Is there ever going to be a fix for this?

My mods are going on at me cos they cannot delete anything

If I disable the Vplaza and re enable it then it keeps resetting my templates and I have to add all the code for everything again.

Database error in vBulletin 3.5.4:

Invalid SQL:

UPDATE user AS user, post AS post
SET
`user.vbbux` = `user.vbbux` + `post.vbbux`
WHERE
post.postid = '2050'
AND user.userid = post.userid;

MySQL Error : Unknown column 'user.vbbux' in 'field list'
Error Number : 1054
Date : Wednesday, July 26th 2006 @ 08:13:40 PM
Script : http://www.******.com/newreply.php
Referrer
:
http://www.******.com/newreply.php?d...quote=1&p=2048
IP
Address : **.*.**.**
Username : Mickey Mouse
Classname : vb_database

[moonclamp]

I'm having the same problem since upgrading to 1.5.8

Any ideas anyone as this is causing me real problems?

I also can't downgrade to an older version without getting a load of errors

EDIT

OK scrap that I think I found the fix.

https://vborg.vbsupport.ru/showthread.php?t=120624

(the first "table_prefix" part was already fixed, the removal of the ' wasn't

Thanks Geek

[Hoffi]

Use a good Editor like Dreamweaver and Use a Diresctory Search and Replace and Replace the `with nothing in every File in the Plugin Directory. Works for me. Bad Bug, really.