PDA

View Full Version : Error 1054 how to fix this?


BigJimTheLug
11-25-2006, 10:56 PM
This is the error I get at the moment, how do I repair it?

Thanks!


MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054

Here is the entire error, any help is appreciated.

Database error in vBulletin 3.6.3:

Invalid SQL:

SELECT * FROM search AS search
WHERE searchhash = '------remove this bit of code, might be important----'
AND userid = 1
AND completed = 1;

MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054
Date : Saturday, November 25th 2006 @ 09:58:09 PM
Script : http://www.puremarketprofits.com/search.php?do=process
Referrer : http://www.puremarketprofits.com/
IP Address :
Username : puremark
Classname : vB_database

harmor19
11-26-2006, 09:43 AM
Go into your ACP --> Maintenance --> Execute SQL Query

In the textarea paste this code.
Code:

ALTER TABLE search ADD completed tinyint(1) unsigned NOT NULL default '0'

Ziki
11-26-2006, 11:00 AM
You are missing a 'completed' row