Help with error saddles

Results 1 to 3 of 3
  1. #1
    Member jales is offline
    MemberRank
    Sep 2011 Join Date
    55Posts

    Help with error saddles

    I am in error in saddles, and probably a lot of people too, and the old error BcStorm not been updated with the emulator already fixed. Vo let the error log anyone who can help I am grateful.

    Error in query:
    INSERT INTO items (base_id, rareid, group_data, placedBy) VALUES (2804,0,'',1)
    MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'placedBy' in 'field list'
    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.ExecuteScalar()
    at Database_Manager.Database.Session_Details.QueryAdapter.insertQuery()


    Error in query:
    INSERT INTO items (base_id, rareid, group_data, placedBy) VALUES (2804,0,'',1)
    MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'placedBy' in 'field list'
    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.ExecuteScalar()
    at Database_Manager.Database.Session_Details.QueryAdapter.insertQuery()


  2. #2
    Gaby is offline
    MemberRank
    Apr 2013 Join Date
    Viva HollandiaLocation
    1,607Posts

    Re: Help with error saddles

    Add a column called​ PlacedBy in your items table.

  3. #3
    Hakuna Matata Matata is offline
    MemberRank
    Sep 2012 Join Date
    DenmarkLocation
    807Posts

    Re: Help with error saddles

    Run this SQL query:
    ALTER TABLE items
    ADD placedBy int(11)



Advertisement