Mysql error anyone know?

AMDWarrior · 12-22-2006, 08:49 PM

On my forums ( I am using vbull) I am getting this error when people hit the new post button:

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

Anyone know what could cause this or how to fix it?

Dan · 12-22-2006, 08:50 PM

Try making a column named completed in your table..

AMDWarrior · 12-22-2006, 08:51 PM

Err I wish I knew what you were talking about...lol Im not too good with it where would I do this?

Dan · 12-22-2006, 09:07 PM

Does the error give you any more details such as line number, table name, etc?

AMDWarrior · 12-22-2006, 09:15 PM

This is the whole error;

Invalid SQL:
SELECT searchid FROM search AS search WHERE userid = 1 AND searchhash = 'b2fe47bc37c22c5d998608c24893d9dc' AND orderedids = '89,13,50,72,124,117,127' AND announceids = '' AND completed = 1;
????: NamePros.com http://www.namepros.com/programming/272241-mysql-error-anyone-know.html

MySQL Error : Unknown column 'completed' in 'where clause'
Error Number : 1054
Date : Friday, December 22nd 2006 @ 10:14:54 PM
Script : http://www.ufgy.com/search.php?do=getnew
Referrer : http://www.ufgy.com/
IP Address : xxxxxxxxxx
Username : AMDWarrior
Classname : vB_Database

baxter · 12-22-2006, 09:23 PM

its saying it can't find the column completed in the sql query, if you run this query it will add the column completed to your database.

Code:

ALTER TABLE `search` ADD `completed` TINYINT( 1 ) NOT NULL DEFAULT '0';

I don't use VB so I am assuming completed is supposed to be 0 or a 1

Cheers,

Baxter

AMDWarrior · 12-22-2006, 09:37 PM

Yep that fixed it. Thanks baxter, Rep added

12-22-2006, 08:49 PM	THREAD STARTER #1 (permalink)
AMDWarrior Senior Member Join Date: Jun 2006 Location: gamerchat.info Posts: 1,231	Mysql error anyone know? On my forums ( I am using vbull) I am getting this error when people hit the new post button: MySQL Error : Unknown column 'completed' in 'where clause' Anyone know what could cause this or how to fix it? __________________ Gaming Forums http://www.gamerchat.info http://www.pcdiscussion.net http://www.webmasterisland.net

12-22-2006, 08:51 PM	THREAD STARTER #3 (permalink)
AMDWarrior Senior Member Join Date: Jun 2006 Location: gamerchat.info Posts: 1,231	Err I wish I knew what you were talking about...lol Im not too good with it where would I do this? __________________ Gaming Forums http://www.gamerchat.info http://www.pcdiscussion.net http://www.webmasterisland.net

12-22-2006, 09:15 PM	THREAD STARTER #5 (permalink)
AMDWarrior Senior Member Join Date: Jun 2006 Location: gamerchat.info Posts: 1,231	This is the whole error; Invalid SQL: SELECT searchid FROM search AS search WHERE userid = 1 AND searchhash = 'b2fe47bc37c22c5d998608c24893d9dc' AND orderedids = '89,13,50,72,124,117,127' AND announceids = '' AND completed = 1; ????: NamePros.com http://www.namepros.com/programming/272241-mysql-error-anyone-know.html MySQL Error : Unknown column 'completed' in 'where clause' Error Number : 1054 Date : Friday, December 22nd 2006 @ 10:14:54 PM Script : http://www.ufgy.com/search.php?do=getnew Referrer : http://www.ufgy.com/ IP Address : xxxxxxxxxx Username : AMDWarrior Classname : vB_Database __________________ Gaming Forums http://www.gamerchat.info http://www.pcdiscussion.net http://www.webmasterisland.net

12-22-2006, 09:23 PM	#6 (permalink)
baxter NamePros Regular Join Date: Apr 2006 Posts: 363	its saying it can't find the column completed in the sql query, if you run this query it will add the column completed to your database. Code: ALTER TABLE `search` ADD `completed` TINYINT( 1 ) NOT NULL DEFAULT '0'; I don't use VB so I am assuming completed is supposed to be 0 or a 1 Cheers, Baxter __________________ Canadian Domain Registrar Ready.ca

12-22-2006, 09:37 PM	THREAD STARTER #7 (permalink)
AMDWarrior Senior Member Join Date: Jun 2006 Location: gamerchat.info Posts: 1,231	Yep that fixed it. Thanks baxter, Rep added __________________ Gaming Forums http://www.gamerchat.info http://www.pcdiscussion.net http://www.webmasterisland.net

12-22-2006, 08:50 PM	#2 (permalink)
Dan Buy my domains. Join Date: Feb 2006 Posts: 2,796	Try making a column named completed in your table..

12-22-2006, 09:07 PM	#4 (permalink)
Dan Buy my domains. Join Date: Feb 2006 Posts: 2,796	Does the error give you any more details such as line number, table name, etc?

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)