View Single Post
Old May 9th, 2008, 05:33 PM   #1 (permalink)
crkgb
Junior Member
Verified Customer
 
Join Date: Apr 2008
Location: Seattle
Posts: 21
[Solved] MySQL error on comment deletion

Hello,

I tried deleted a comment in vbGallery and got this error:

Quote:
Database error in vBulletin 3.7.0:

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

MySQL Error : Unknown column 'pppcount' in 'field list'
Error Number : 1054
Request Date : Friday, May 9th 2008 @ 02:17:59 PM
Error Date : Friday, May 9th 2008 @ 02:18:00 PM
Script : http://www.xxxxx.com/testvb/gallery/newreply.php
Referrer : http://www.xxxxx.com/testvb/gall...o=editpost&p=1
IP Address : xx.xx.xx.xx
Username : crkgb
Classname : vB_Database
MySQL Version : 5.0.22-Debian_0ubuntu6.06.10-log
I checked the user table and it doesn't have the pppcount column. Was vbGallery installed incorrectly or where should I look for the solution?

Thank you.

Last edited by crkgb; May 9th, 2008 at 09:03 PM.
crkgb is offline   Reply With Quote