BUG in 1.5.7 - Cant delete thread or merge

[DJ XtAzY]

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]

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?do=newreply&noquote=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.