[Phoenix] Wired doesn't save

[Adrian]

11/28/2013 2:32:07 AM: Error during saving wired items for room 147. Stack: MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect string value: '\xEF\x8F\x88\xED\x90\xB0...' for column 'extra1' at row 1
  at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
  at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
  at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& 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 ????????.????????.????????(String ????????)
  at ????????.????????.????????()
Query: DELETE FROM wired_items WHERE item_id = '14693' LIMIT 1; INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('14693',@14693Extra1,@14693Extra2,@14693Extra3,@14693Extra4,@14693Extra5);

11/28/2013 2:42:22 AM: User Zeke shut down the server 11/28/2013 2:42:22 AM

11/28/2013 2:46:44 AM: Error during saving wired items for room 13. Stack: MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect string value: '\xEF\x8F\x88\xED\x90\xB0...' for column 'extra1' at row 1
  at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
  at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
  at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& 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 ????????.????????.????????(String ????????)
  at ????????.????????.????????()
Query: DELETE FROM wired_items WHERE item_id = '15244' LIMIT 1; INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('15244',@15244Extra1,@15244Extra2,@15244Extra3,@15244Extra4,@15244Extra5);

11/28/2013 3:03:27 AM: Error during saving wired items for room 147. Stack: MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect string value: '\xEF\x8F\x88\xED\x90\xB0...' for column 'extra1' at row 1
  at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
  at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
  at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& 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 ????????.????????.????????(String ????????)
  at ????????.????????.????????()
Query: DELETE FROM wired_items WHERE item_id = '14693' LIMIT 1; INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('14693',@14693Extra1,@14693Extra2,@14693Extra3,@14693Extra4,@14693Extra5);

11/28/2013 3:19:07 AM: Error during saving wired items for room 149. Stack: MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect string value: '\xEF\x8F\x88\xED\x90\xB0...' for column 'extra1' at row 1
  at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
  at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
  at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& 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 ????????.????????.????????(String ????????)
  at ????????.????????.????????()
Query: DELETE FROM wired_items WHERE item_id = '15500' LIMIT 1; INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('15500',@15500Extra1,@15500Extra2,@15500Extra3,@15500Extra4,@15500Extra5); DELETE FROM wired_items WHERE item_id = '15505' LIMIT 1; INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('15505',@15505Extra1,@15505Extra2,@15505Extra3,@15505Extra4,@15505Extra5); DELETE FROM wired_items WHERE item_id = '15501' LIMIT 1; INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('15501',@15501Extra1,@15501Extra2,@15501Extra3,@15501Extra4,@15501Extra5); DELETE FROM wired_items WHERE item_id = '15502' LIMIT 1; INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('15502',@15502Extra1,@15502Extra2,@15502Extra3,@15502Extra4,@15502Extra5); DELETE FROM wired_items WHERE item_id = '15503' LIMIT 1; INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('15503',@15503Extra1,@15503Extra2,@15503Extra3,@15503Extra4,@15503Extra5); DELETE FROM wired_items WHERE item_id = '15504' LIMIT 1; INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('15504',@15504Extra1,@15504Extra2,@15504Extra3,@15504Extra4,@15504Extra5);

11/28/2013 3:34:20 AM: Error during saving wired items for room 135. Stack: MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect string value: '\xEF\x8F\x88\xED\x90\xB0...' for column 'extra1' at row 1
  at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
  at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
  at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& 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 ????????.????????.????????(String ????????)
  at ????????.????????.????????()
Query: DELETE FROM wired_items WHERE item_id = '15525' LIMIT 1; INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('15525',@15525Extra1,@15525Extra2,@15525Extra3,@15525Extra4,@15525Extra5); DELETE FROM wired_items WHERE item_id = '15526' LIMIT 1; INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('15526',@15526Extra1,@15526Extra2,@15526Extra3,@15526Extra4,@15526Extra5);

11/28/2013 7:05:23 AM: Error during saving wired items for room 135. Stack: MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect string value: '\xE6\xBC\xBF.\xEF\x8F...' for column 'extra2' at row 1
  at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
  at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
  at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& 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 ????????.????????.????????(String ????????)
  at ????????.????????.????????()
Query: DELETE FROM wired_items WHERE item_id = '16395' LIMIT 1; INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('16395',

 

[JayC]

Query: DELETE FROM wired_items WHERE item_id = '15525' LIMIT 1; INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('15525',@15525Extra1,@15525Extra2,@15525Extra3,@15525Extra4,@15525Extra5); DELETE FROM wired_items WHERE item_id = '15526' LIMIT 1; INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('15526',@15526Extra1,@15526Extra2,@15526Extra3,@15526Extra4,@15526Extra5);

Looks like its giving you querys to put into your database or something? Run a backup and try it , might as well.

 

[Adrian]

Query: DELETE FROM wired_items WHERE item_id = '15525' LIMIT 1; INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('15525',@15525Extra1,@15525Extra2,@15525Extra3,@15525Extra4,@15525Extra5); DELETE FROM wired_items WHERE item_id = '15526' LIMIT 1; INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('15526',@15526Extra1,@15526Extra2,@15526Extra3,@15526Extra4,@15526Extra5);

Looks like its giving you querys to put into your database or something? Run a backup and try it , might as well.

[SQL]DELETE FROM wired_items WHERE item_id = '15525' LIMIT 1;
Affected rows: 0
Time: 0.001s

[SQL] INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('15525',@15525Extra1,@15525Extra2,@15525Extra3,@15525Extra4,@15525Extra5);
[Err] 1048 - Column 'extra1' cannot be null

wot?

 

[JayC]

INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('15525','@15525Extra1','@15525Extra2','@15525Extra3','@15525Extra4','@15525Extra5');

 

[Adrian]

INSERT INTO wired_items (item_id,extra1,extra2,extra3,extra4,extra5) VALUES ('15525','@15525Extra1','@15525Extra2','@15525Extra3','@15525Extra4','@15525Extra5');

Ran that, but still the same thing.

 

[JayC]

Ahh sorry, I have never seen this error before

 

[Adrian]

Thanks anyways!

Problem solved. (had to switch emus ;l)

@Legion

 

[Legion]

Problem solved.
Thread Closed.