Helpful Information
 
 
Category: vBulletin 3 Discussion
Can someone tell me what this means

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT storep FROM userfield WHERE userid=1
mysql error: Unknown column 'storep' in 'field list'

mysql error number: 1054

Date: Wednesday 04th of September 2002 09:03:48 PM
Script: http://www.darknemesis.com/forums/forums/newthread.php
Referer: http://www.darknemesis.com/forums/newthread.php?action=newthread&forumid=2

The storep column is missing in your db. You have 2 choices - ADD that column back (ie. reinstall whatever hack that is) OR remove the query from your newthread.php - open that file up and look for storep and remove that query line (if you no longer have that hack).

Looks like you are upgrading or moving files to a new db or something...

if you're going to readd it DD07

run the query:

ALTER TABLE user ADD storep int(10) NOT NULL DEFAULT '0'

else if you decide to remove take out the storep update in the newreply as well... and remove the queries too ;) regards...

g-force2k2

thanks, i decided to make everyone re-register because this whole moving user/posts is messin up my boards. i have to remake my new boards cuz they got messed up after all this










privacy (GDPR)