PhotoPost Community - View Single Post - I have a database error when i'm trying to delete a message.

marcovb · March 3rd, 2009, 10:44 PM

I have a database error when i'm trying to delete a message.

I first click on the "Edit" icon (bottom right side of the post panel). Then i check the option to delete the message and i hit the button "Delete this Message". That's when the following error appears:
----------
Database error in vBulletin 3.8.1:

Invalid SQL:
UPDATE LOW_PRIORITY vb_user SET pppcount = pppcount-1 WHERE userid = '1';

MySQL Error : Unknown column 'pppcount' in 'field list'
Error Number : 1054
Request Date : Tuesday, March 3rd 2009 @ 10:33:15 PM
Error Date : Tuesday, March 3rd 2009 @ 10:33:15 PM
Script : http://www.rociojuradofanclub.com/fo...y/newreply.php
Referrer : http://www.rociojuradofanclub.com/fo...=editpost&p=40
IP Address :
Username : Fan Club
Classname : vB_Database_MySQLi
MySQL Version : 5.1.30
---------------

Then, when i hit refresh and go back, i notice that the message is gone. Why the error?

I've research the forum and found this post:
Update for vBulletin 3.8.0?

I've applied both patches. I don't get the error 'replace by zero' but i do get the delete error.

MotoUp speaks about ""ppgal_" in front of something", but i can't find anything.

Can anyone help me.

Thanks
Marco

March 3rd, 2009, 10:44 PM	#1 (permalink)
marcovb Member Join Date: Feb 2009 Posts: 31	I have a database error when i'm trying to delete a message. I have a database error when i'm trying to delete a message. I first click on the "Edit" icon (bottom right side of the post panel). Then i check the option to delete the message and i hit the button "Delete this Message". That's when the following error appears: ---------- Database error in vBulletin 3.8.1: Invalid SQL: UPDATE LOW_PRIORITY vb_user SET pppcount = pppcount-1 WHERE userid = '1'; MySQL Error : Unknown column 'pppcount' in 'field list' Error Number : 1054 Request Date : Tuesday, March 3rd 2009 @ 10:33:15 PM Error Date : Tuesday, March 3rd 2009 @ 10:33:15 PM Script : http://www.rociojuradofanclub.com/fo...y/newreply.php Referrer : http://www.rociojuradofanclub.com/fo...=editpost&p=40 IP Address : Username : Fan Club Classname : vB_Database_MySQLi MySQL Version : 5.1.30 --------------- Then, when i hit refresh and go back, i notice that the message is gone. Why the error? I've research the forum and found this post: Update for vBulletin 3.8.0? I've applied both patches. I don't get the error 'replace by zero' but i do get the delete error. MotoUp speaks about ""ppgal_" in front of something", but i can't find anything. Can anyone help me. Thanks Marco