ERROR in query update - items
I don't understand this error. Help me please xD
Error in query:
UPDATE items,items_users SET placedBy = 2640, user_id = 2640 WHERE item_id = 19123
MySql.Data.MySqlClient.MySqlException (0x80004005): Column 'item_id' in where clause is ambiguous
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at Database_Manager.Database.Session_Details.QueryAdapter.runQuery()
Thanks xD
Re: ERROR in query update - items
your database is bad get a new one
Re: ERROR in query update - items
Quote:
Originally Posted by
Stanleh
your database is bad get a new one
Thanks? xd
Re: ERROR in query update - items
Column 'item_id' in where clause is ambiguous. Something wrong i column "item_id". Change your items_users table from another database :)