MySQL error on comment deletion

[crkgb]

Hello,

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

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.

[crkgb]

I think I have found the cause of this, but I'm not sure where to fix it.

The SQL statement the way it is right now:

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

Correct SQL statement:

UPDATE LOW_PRIORITY rwvb_ppgal_user SET pppcount = pppcount-1 WHERE userid = '1';

So basically, I need to provide correct table prefix to the script. Is there a place to do it?

[crkgb]

I have found a fix for this:

In file: gallery/newreply.php

Find (around line 683):

$vbulletin->db->query_write("UPDATE LOW_PRIORITY " . TABLE_PREFIX . "user SET pppcount = pppcount-1 WHERE userid = '" . $vbulletin->userinfo['userid'] . "'");

Replace with:

$vbulletin->db->query_write("UPDATE LOW_PRIORITY " . TABLE_PREFIX . "ppgal_user SET pppcount = pppcount-1 WHERE userid = '" . $vbulletin->userinfo['userid'] . "'");

[Zachariah]

Good Find !

[dfidler]

Originally Posted by Zachariah

Good Find !

Implemented on my board as well; thanks. Will this fix be included in the next release or should I file this for later so as not to regress my board on the next upgrade?

Cheers,
Dave.