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:
http://www.photopost.com/forum/insta...n-3-8-0-a.html

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

i've attaches some images to help with my error
 

Attachment 3665

Attachment 3666

Attachment 3667

Attachment 3668

Attachment 3669

this is the php change to make it work
 

this is the php change to make it work

did you upgrade and then forget to run the vbgallery upgrade?

According to my information based on this error because your missing two fields that are created against the vb user table in the 2.0 upgrade you must be running a 2.0 database with 2.4.3 files

hey chuck,
i'm not sure what upgrade your talking. I've installed vbulletin 3.8.1 and then 2.4.3.
Then, ive applied those two small patches mentioned in this post:

http://www.photopost.com/forum/insta...n-3-8-0-a.html

Is there a patch i should download ?

Thanks

Try this in newreply.php in your gallery directory find this query

change to this

Very very strange...
Yes there is a BUG....
but why is it not affecting anyone else??????
probably because we are not deleting lool

open gallery/newreply.php
find
replace with:
if you are not sure.. just find the line and replace
TABLE_PREFIX . "user
with
TABLE_PREFIX . "ppgal_user
(there is no pppcount in the normal user table, only in ppgal_user)
it seems that 2.5 also needs that fix..

Luc

Luciano you posted at the same time as me ;)

Loooool chuck..
we posted at the same time :p
edit
twice!!!

Yes I had to go read the upgrade documentation because going line by line on the install script was not all too clear ;)

It works! Many thanks to all for the great support.

I'm on a deadline coz i have to open my board March 18, that's why i'm testing the hell out of vBGallery. hehehhe

I found two more refresh issues, i will post them as a new post.

Thanks

Have a good day.