Problem with PlusEMU

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

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

You have to put all the values between quotes.

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

Quote:

---

Originally Posted by HillBilly

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...

Find

Code:

---

UPDATE items SET

---

in your source and change what I told you.

Quote:

---

Originally Posted by HillBilly

Find

Code:

---

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

Use prepared statements.

Quote:

---

Originally Posted by HillBilly

Use prepared statements.

---

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

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

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

Quote:

---

Originally Posted by Superfun

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

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..

Quote:

---

Originally Posted by 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..

---

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

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.

And where should i put it in quotes ._.

in every value

Quote:

---

Originally Posted by Superfun

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...

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

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

No quotes?

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

Quote:

---

Originally Posted by Superfun

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

---

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

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

Quote:

---

Originally Posted by Swiglers

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.