PDA

View Full Version : Can someone tell me what this means


DarkDraco07
09-05-2002, 02:11 AM
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

Erwin
09-05-2002, 02:41 AM
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...

g-force2k2
09-05-2002, 05:42 PM
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

DarkDraco07
09-05-2002, 06:27 PM
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