Mysql error anyone know?

Ampedhosting · 12-22-2006, 07: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, 07:50 PM

Try making a column named completed in your table..

Ampedhosting · 12-22-2006, 07: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, 08:07 PM

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

Ampedhosting · 12-22-2006, 08: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;

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, 08: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

Ampedhosting · 12-22-2006, 08:37 PM

Yep that fixed it. Thanks baxter, Rep added

12-22-2006, 07:49 PM	#1 (permalink)
Ampedhosting Senior Member Join Date: Jun 2006 Location: Behind You Posts: 1,165 39.71 NP$ (Donate)	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? __________________ JustHits.net - Cash Prizes given away NOW! l Alerthits.com - Cash Prizes given away NOW!

12-22-2006, 07:51 PM	#3 (permalink)
Ampedhosting Senior Member Join Date: Jun 2006 Location: Behind You Posts: 1,165 39.71 NP$ (Donate)	Err I wish I knew what you were talking about...lol Im not too good with it where would I do this? __________________ JustHits.net - Cash Prizes given away NOW! l Alerthits.com - Cash Prizes given away NOW!

12-22-2006, 08:15 PM	#5 (permalink)
Ampedhosting Senior Member Join Date: Jun 2006 Location: Behind You Posts: 1,165 39.71 NP$ (Donate)	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; 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 __________________ JustHits.net - Cash Prizes given away NOW! l Alerthits.com - Cash Prizes given away NOW!

12-22-2006, 08:23 PM	#6 (permalink)
baxter NamePros Regular Join Date: Apr 2006 Posts: 289 1,990.00 NP$ (Donate)	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 __________________ Chimps.ca - Swans.ca - Snails.ca

12-22-2006, 08:37 PM	#7 (permalink)
Ampedhosting Senior Member Join Date: Jun 2006 Location: Behind You Posts: 1,165 39.71 NP$ (Donate)	Yep that fixed it. Thanks baxter, Rep added __________________ JustHits.net - Cash Prizes given away NOW! l Alerthits.com - Cash Prizes given away NOW!

12-22-2006, 07:50 PM	#2 (permalink)
Dan Buy my domains. Join Date: Feb 2006 Posts: 2,801 56.00 NP$ (Donate)	Try making a column named completed in your table..

12-22-2006, 08:07 PM	#4 (permalink)
Dan Buy my domains. Join Date: Feb 2006 Posts: 2,801 56.00 NP$ (Donate)	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)