Errors after upgrading

mindcry · January 6th, 2008, 01:02 PM

Whenever I try and update counters I get the following error. Seems like one of the fields were not implemented. I am sure this is a simple alter table command but I need to know what the field details should be.

Database error in vBulletin 3.6.5:

Invalid SQL:
UPDATE user SET pppcount = '0' WHERE userid = '1';

MySQL Error : Unknown column 'pppcount' in 'field list'
Error Number : 1054
Date : Sunday, January 6th 2008 @ 01:59:49 PM
Script : http://domain.com/admincp/vba_galler...pdateuserposts
Referrer : http://domain.com/admincp/vba_galler...do=maintenance
IP Address : x.x.x.x
Username : usename
Classname : vB_Database

mindcry · January 6th, 2008, 05:03 PM

also getting another one...

Database error in vBulletin 3.6.5:

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

MySQL Error : Unknown column 'pppcount' in 'field list'
Error Number : 1054
Date : Sunday, January 6th 2008 @ 03:09:12 PM
Script : http://www.domain.com/gallery/newreply.php
Referrer : http://www.domain.com/gallery/newrep...ditpost&p=3260
IP Address : x.x.x.x
Username : username
Classname : vB_Database

Zachariah · January 6th, 2008, 05:04 PM

What version of the gallery do you have installed ?

mindcry · January 6th, 2008, 05:08 PM

v2.4.1

Zachariah · January 7th, 2008, 10:31 PM

your good to go

Ghostsuit · May 7th, 2008, 12:12 PM

Hi Zachariah, just got the same error when I tried to delete a post.

On 3.7.0 and version 2.4.3

Zachariah · May 7th, 2008, 03:40 PM

Quote:

Originally Posted by Ghostsuit

Hi Zachariah, just got the same error when I tried to delete a post.

On 3.7.0 and version 2.4.3

Ghost,

/gallery/newreply.php
find:

Code:

Content visible to verified customers only.

Change to:

Code:

Content visible to verified customers only.