Latest UI [Field 'extra_data' doesn't have a default value]

Results 1 to 3 of 3
  1. #1
    Valued Member Flowy Otaku is offline
    MemberRank
    Feb 2013 Join Date
    113Posts

    Latest UI [Field 'extra_data' doesn't have a default value]

    While buying stuff in the shop it replaces my other furniture in the inventory, so i can only have 1 item in the inventory the other items just disappear and i get this error:

    Error in query:

    INSERT INTO items (base_item, user_id) VALUES (1773, 1)
    MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'extra_data' doesn't have a default value
    at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
    at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, 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() in c:\Users\Robin\Desktop\Program\Flip filer 2014\new ui database,emu,cms\changeui\Silverwave Emulator\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 164


    Best Wishes
    Flowy


  2. #2
    Wanheda Funsolit is offline
    MemberRank
    Feb 2012 Join Date
    SwedenLocation
    259Posts

    Re: Latest UI [Field 'extra_data' doesn't have a default value]

    Find in your emu: INSERT INTO items (base_item, user_id) VALUES

    I dont know the base item and userid variables but you will see it after you searched the code.
    Just add: extradata in it and a value with nothing in it.

    Like:
    INSERT INTO items (base_item, user_id, extra_data) VALUES (BASEITEMID, USERID, ' ')

  3. #3
    Valued Member Flowy Otaku is offline
    MemberRank
    Feb 2013 Join Date
    113Posts

    Re: Latest UI [Field 'extra_data' doesn't have a default value]

    fixed it.



Advertisement