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

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

err1.jpg

err2.jpg

err3.jpg

err4.jpg

err5.jpg

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

this is the php change to make it work

Chuck S · March 3rd, 2009, 11:20 PM

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

marcovb · March 4th, 2009, 12:09 AM

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:

Update for vBulletin 3.8.0?

Is there a patch i should download ?

Thanks

Chuck S · March 4th, 2009, 09:40 AM

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

Code:

Content visible to verified customers only.

change to this

Code:

Content visible to verified customers only.

Luciano · March 4th, 2009, 09:44 AM

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

Code:

Content visible to verified customers only.

replace with:

Code:

Content visible to verified customers only.

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

Chuck S · March 4th, 2009, 09:45 AM

Luciano you posted at the same time as me

Luciano · March 4th, 2009, 09:47 AM

Loooool chuck..
we posted at the same time

edit
twice!!!

Chuck S · March 4th, 2009, 09:50 AM

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

marcovb · March 4th, 2009, 11:26 AM

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

Chuck S · March 4th, 2009, 12:10 PM

Have a good day.