ERROR in query update - items

Results 1 to 4 of 4
  1. #1
    Newbie Alex12236 is offline
    MemberRank
    May 2012 Join Date
    Barcelona, SpaiLocation
    7Posts

    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


  2. #2
    Newbie Stanleh is offline
    MemberRank
    May 2013 Join Date
    8Posts

    Re: ERROR in query update - items

    your database is bad get a new one

  3. #3
    Newbie Alex12236 is offline
    MemberRank
    May 2012 Join Date
    Barcelona, SpaiLocation
    7Posts

    Re: ERROR in query update - items

    Quote Originally Posted by Stanleh View Post
    your database is bad get a new one
    Thanks? xd

  4. #4
    Elite Member TheFlamingo is offline
    Member +Rank
    May 2013 Join Date
    123Posts

    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 :)



Advertisement