HELP FURNITURE GLITCHED

Jan 16, 2017
33
0
Hello Devbest since i hopped over my cms and emu to vps i have one error, when i buy something from catalogue it only be 1 item, and in my inventory for example i have duck i buy window my duck dissapear and turn into the window, i cant have more than 1 items after hopping over from localhost to vps, someone who know how to fix this please quick response i just have my vps running 3 hrs tryng to get players onto my hotel, i need to be a bit more experienced but thanks if u can help me,



sorry i have no video or photo, if u wanna see bug http:
 
Jan 16, 2017
33
0
open the items table, verify that it is inserting the data properly.
 
Check error files-
can u come onto my hotel to see whats wrong?
 
can u come onto my hotel to see whats wrong?

 
open the items table, verify that it is inserting the data properly.
 
Check error files-
[21:56:14] Error in query caught
i get this 99x when i purchace item 100x and i only get 1 of it, and my duck dissapears when i buy something else..
 
Jan 16, 2017
33
0
Go to the fucking error file and post what the query issue is -_-
how do i find the error?
 
how do i find the error?
 
Go to the fucking error file and post what the query issue is -_-
Error in query:
UPDATE items SET room_id='' WHERE id=1994 LIMIT 1
MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect integer value: '' for column 'room_id' at row 1
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.ExecuteNonQuery()
at Database_Manager.Database.Session_Details.QueryAdapter.runQuery() in c:\Users\Daniel\Desktop\Plus Original\Silverwave Emulator\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 193


Error in query:
UPDATE items SET user_id = 29, room_id='' WHERE id = 1994
MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect integer value: '' for column 'room_id' at row 1
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.ExecuteNonQuery()
at Database_Manager.Database.Session_Details.QueryAdapter.runQuery() in c:\Users\Daniel\Desktop\Plus Original\Silverwave Emulator\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 193
 
Field 'extra_data' doesn't have a default value
 

Users who are viewing this thread

Top