Problem with PlusEMU

[IronicMaple]

So i have had bcstorm for a while, and a ''friend'' got it deleted from my vps, so i changed to plusemu. Now i have a problem with the furniture. I get error and all furniture won't be saved, so when room is unloaded the furniture is gone. Error:

Error in query:
UPDATE items SET room_id=12, x=1, y=5, z=0, rot=0 WHERE id='1067';UPDATE items SET room_id=12, x=1, y=7, z=0, rot=0 WHERE id='1065';UPDATE items SET room_id=12, x=4, y=5, z=0, rot=0 WHERE id='1064';UPDATE items SET room_id=12, x=5, y=4, z=0, rot=0 WHERE id='1063';UPDATE items SET room_id=12, x=1, y=5, z=0,5, rot=0 WHERE id='1060';UPDATE items SET room_id=12, x=6, y=1, z=0, rot=0 WHERE id='1059';UPDATE items SET room_id=12, x=1, y=9, z=0, rot=0 WHERE id='1057';UPDATE items SET room_id=12, x=10, y=1, z=0, rot=0 WHERE id='1055';UPDATE items SET room_id=12, x=2, y=5, z=0, rot=0 WHERE id='1053';UPDATE items SET room_id=12, x=1, y=10, z=1, rot=0 WHERE id='1051';UPDATE items SET room_id=12, x=1, y=10, z=2, rot=0 WHERE id='1050';UPDATE items SET room_id=12, x=8, y=1, z=0, rot=0 WHERE id='1049';UPDATE items SET room_id=12, x=11, y=1, z=0, rot=0 WHERE id='1047';UPDATE items SET room_id=12, x=3, y=5, z=0, rot=0 WHERE id='1046';UPDATE items SET room_id=12, x=1, y=10, z=3, rot=0 WHERE id='1043';UPDATE items SET room_id=12, x=5, y=3, z=0, rot=0 WHERE id='1042';UPDATE items SET room_id=12, x=5, y=5, z=0,5, rot=0 WHERE id='1026';UPDATE items SET room_id=12, x=7, y=1, z=0, rot=0 WHERE id='1038';UPDATE items SET room_id=12, x=5, y=5, z=2, rot=0 WHERE id='1025';UPDATE items SET room_id=12, x=1, y=6, z=0, rot=0 WHERE id='1036';UPDATE items SET room_id=12, x=5, y=4, z=3, rot=0 WHERE id='1024';UPDATE items SET room_id=12, x=5, y=4, z=2, rot=2 WHERE id='1034';UPDATE items SET room_id=12, x=5, y=5, z=1, rot=0 WHERE id='1033';UPDATE items SET room_id=12, x=1, y=9, z=0, rot=0 WHERE id='1121';UPDATE items SET room_id=12, x=5, y=5, z=2,5, rot=0 WHERE id='1029';UPDATE items SET room_id=12, x=2, y=5, z=2,5, rot=0 WHERE id='1030';UPDATE items SET room_id=12, x=2, y=9, z=0, rot=0 WHERE id='1118';UPDATE items SET room_id=12, x=5, y=4, z=2,5, rot=2 WHERE id='1028';UPDATE items SET room_id=12, x=1, y=7, z=0, rot=0 WHERE id='1116';UPDATE items SET room_id=12, x=1, y=5, z=2,5, rot=0 WHERE id='1019';UPDATE items SET room_id=12, x=1, y=5, z=0, rot=0 WHERE id='1114';UPDATE items SET room_id=12, x=5, y=5, z=0, rot=0 WHERE id='1113';UPDATE items SET room_id=12, x=5, y=5, z=3, rot=0 WHERE id='1023';UPDATE items SET room_id=12, x=4, y=7, z=0, rot=0 WHERE id='1111';UPDATE items SET room_id=12, x=4, y=9, z=0, rot=0 WHERE id='1110';UPDATE items SET room_id=12, x=1, y=5, z=3, rot=0 WHERE id='1020';UPDATE items SET room_id=12, x=6, y=9, z=0, rot=0 WHERE id='1108';UPDATE items SET room_id=12, x=2, y=7, z=0, rot=0 WHERE id='1107';UPDATE items SET room_id=12, x=1, y=5, z=1,5, rot=0 WHERE id='1017';UPDATE items SET room_id=12, x=1, y=5, z=1, rot=0 WHERE id='1016';UPDATE items SET room_id=12, x=1, y=7, z=3, rot=0 WHERE id='1015';UPDATE items SET room_id=12, x=1, y=6, z=3, rot=0 WHERE id='1014';UPDATE items SET room_id=12, x=1, y=8, z=3, rot=0 WHERE id='1013';UPDATE items SET room_id=12, x=1, y=9, z=3, rot=0 WHERE id='1012';UPDATE items SET room_id=12, x=6, y=5, z=0, rot=0 WHERE id='1100';UPDATE items SET room_id=12, x=2, y=5, z=0,5, rot=0 WHERE id='1022';UPDATE items SET room_id=12, x=5, y=1, z=0, rot=0 WHERE id='1021';UPDATE items SET room_id=12, x=4, y=5, z=3, rot=0 WHERE id='1027';UPDATE items SET room_id=12, x=3, y=5, z=0, rot=0 WHERE id='1090';UPDATE items SET room_id=12, x=6, y=7, z=0, rot=0 WHERE id='1089';UPDATE items SET room_id=12, x=1, y=5, z=2, rot=0 WHERE id='1018';UPDATE items SET room_id=12, x=2, y=5, z=3, rot=0 WHERE id='1031';UPDATE items SET room_id=12, x=5, y=2, z=0, rot=0 WHERE id='1080';UPDATE items SET room_id=12, x=3, y=5, z=3, rot=0 WHERE id='1073';UPDATE items SET room_id=12, x=1, y=10, z=1,5, rot=0 WHERE id='1077';UPDATE items SET room_id=12, x=9, y=1, z=0, rot=0 WHERE id='1076';UPDATE items SET room_id=12, x=1, y=10, z=0, rot=0 WHERE id='1074';UPDATE items SET room_id=12, x=5, y=5, z=1,5, rot=0 WHERE id='1032';UPDATE items SET room_id=12, x=1, y=10, z=0,5, rot=0 WHERE id='1072';UPDATE items SET room_id=12, x=1, y=8, z=0, rot=0 WHERE id='1071';UPDATE items SET room_id=12, x=5, y=5, z=0, rot=0 WHERE id='1070';UPDATE items SET room_id=12, x=1, y=10, z=2,5, rot=0 WHERE id='1068'
MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '5, rot=0 WHERE id='1060';UPDATE items SET room_id=12, x=6, y=1, z=0, rot=0 WHERE' at line 1
vid MySql.Data.MySqlClient.MySqlStream.ReadPacket()
vid MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
vid MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
vid MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
vid MySql.Data.MySqlClient.MySqlDataReader.NextResult()
vid MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
vid MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
vid Database_Manager.Database.Session_Details.QueryAdapter.runQuery() i C:\Users\lucas\Desktop\emu\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:rad 193

[MentaL]

[Superfun]

put z in quotes (z='0'), best guess would be a problem with the decimals in the z column

[The General]

You have to put all the values between quotes.

room_id='x'
x='x'
y='x'
z='x'
rot='x'

[IronicMaple]

You have to put all the values between quotes.

room_id='x'
x='x'
y='x'
z='x'
rot='x'

The fun thing is that, i can't find where. Everything looks right to me, but still...

[The General]

Find

UPDATE items SET

in your source and change what I told you.

[IronicMaple]

Find

UPDATE items SET

in your source and change what I told you.

I changed that and it still gives me the same error? RoomItemsHandling.cs was where i found that it was no quotes, but still same error after i changed it.

standardQueries.AddQuery("UPDATE items SET room_id='0', x='0', y='0', z='0', rot='0' WHERE id = " + Item.Id + " ");

But without any quotes

[The General]

Use prepared statements.

[IronicMaple]

Use prepared statements.

Please explain more, i don't understand. English is not my first language

[IronicMaple]

Update:
I have kinda fixed it. Now the problem is that sometimes when furniture are moved, it doesn't get saved and i get error. When a furniture is placed in the room there are no error. When the furniture is moved, the error pops up. But it kinda looks the same as the error before:



Error in query:
UPDATE items SET room_id=1, x=4, y=7, z=0, rot=2 WHERE id='1219';UPDATE items SET room_id=1, x=11, y=7, z=0, rot=0 WHERE id='1239';UPDATE items SET room_id=1, x=10, y=7, z=0, rot=0 WHERE id='1244';UPDATE items SET room_id=1, x=4, y=2, z=4,00001, rot=2 WHERE id='1243';UPDATE items SET room_id=1, x=4, y=3, z=1, rot=2 WHERE id='1278';UPDATE items SET room_id=1, x=4, y=4, z=1, rot=2 WHERE id='1277';UPDATE items SET room_id=1, x=4, y=5, z=1, rot=2 WHERE id='1276';UPDATE items SET room_id=1, x=10, y=6, z=0, rot=2 WHERE id='1275';UPDATE items SET room_id=1, x=4, y=7, z=1, rot=2 WHERE id='1274';UPDATE items SET room_id=1, x=4, y=6, z=1, rot=2 WHERE id='1273';UPDATE items SET room_id=1, x=4, y=2, z=1, rot=2 WHERE id='1272';UPDATE items SET room_id=1, x=10, y=8, z=0, rot=0 WHERE id='1234';UPDATE items SET room_id=1, x=10, y=9, z=0, rot=0 WHERE id='1229';UPDATE items SET room_id=1, x=10, y=10, z=0, rot=0 WHERE id='1224'
MySql.Data.MySqlClient.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '00001, rot=2 WHERE id='1243';UPDATE items SET room_id=1, x=4, y=3, z=1, rot=2 WH' at line 1
vid MySql.Data.MySqlClient.MySqlStream.ReadPacket()
vid MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
vid MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
vid MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
vid MySql.Data.MySqlClient.MySqlDataReader.NextResult()
vid MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
vid MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
vid Database_Manager.Database.Session_Details.QueryAdapter.runQuery() i C:\Users\lucas\Desktop\emu\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:rad 193

[Superfun]

still the same, your z value contains ',' as seperator for the decimal, which results in a error when not used in quotes

[IronicMaple]

still the same, your z value contains ',' as seperator for the decimal, which results in a error when not used in quotes

Even when i try to fix it, it gives error. And since i'm not so good at this, please help hahah
How can i fix this easily, is what i'm asking. Because this is the only error i get now, and i think i have fixed every other error

[Swiglers]

change "z" column in item table to "varchar" and not "double", then it will accept to have "," there.
do not edit anything in source though, else then whats being said up here..

[Superfun]

change "z" column in item table to "varchar" and not "double", then it will accept to have "," there.
do not edit anything in source though, else then whats being said up here..

This is a solution as well, but the values still have to be put between quotes.

[Swiglers]

yeah, he have to put it in quotes, and then edit to "varchar" in table, as it wont work with "," unless he edits that. But the sql syntax is still wrong, if he does not edit and places quotes.

[IronicMaple]

And where should i put it in quotes ._.

[Superfun]

in every value

[IronicMaple]

in every value

But i have everything in quotes, but it is still same error? I guess there are something else, or i put in wrong...

[Superfun]

I can only see quotes on the room id, there are no other quotes.

[IronicMaple]

standardQueries.AddQuery("UPDATE items SET room_id='0', x='0', y='0', z='0', rot='0' WHERE id = " + Item.Id + " ");

No quotes?

[Superfun]

99.9% sure thats not the query you need to edit.

[IronicMaple]

99.9% sure thats not the query you need to edit.

I can't find any other place, so i have no idea

[Swiglers]

It should be two or one more places.. you need to search the entire source.

[IronicMaple]

It should be two or one more places.. you need to search the entire source.

Thank you, that was what i needed to know. I found both and fixed it, now everything works.