Furniture stacks at one place after a x amount of time

[ringomanic]

Hi,

I have a phoenix server, after hard work. It finally runs, but when I disconnect or when I go out of the room, after an X amount of time the Phoenix server gives a error: Critical Error logged
And in the criticalexceptions.err file the following error occurs:

Error during saving furniture for room 12. Stack: MySql.Data.MySqlClient.HeaderCode (0x80004005): Data truncated for column 'z' at row 1
   at MySql.Data.Types.EntryHash.Color()
   at MySql.Data.MySqlClient.Properties.EventPrintWhere.Handle(Int32& index, Int32& target)
   at MySql.Data.Types.EntityHeader.Owns(Int32 value, Int32& type, Int32& typeOffset)
   at MySql.Data.Types.EntityHeader.CloseInfo(Int32 max, Boolean failure)
   at MySql.Data.MySqlClient.CurrencyTagRetrieve.SetGet()
   at MySql.Data.Types.AlignmentLoadView.Parameters(CommandBehavior lib)
   at MySql.Data.Types.AlignmentLoadView.Results()
   at MySql.Data.Types.BarElement.Types(String name)
   at MySql.Data.MySqlClient.Properties.InternalGrid.Bytes()
 Query: UPDATE items SET room_id = '0' WHERE id = '32' AND room_id = '12' LIMIT 1; UPDATE items SET room_id = '12', base_item = '77705', extra_data = @extra_data101, x = '5', y = '1', z = '0,1', rot = '0', wall_pos = '' WHERE id = '101' LIMIT 1; UPDATE items SET room_id = '12', base_item = '4705', extra_data = @extra_data116, x = '5', y = '5', z = '0,1', rot = '2', wall_pos = '' WHERE id = '116' LIMIT 1; UPDATE items SET room_id = '12', base_item = '77705', extra_data = @extra_data103, x = '11', y = '10', z = '0', rot = '0', wall_pos = '' WHERE id = '103' LIMIT 1; UPDATE items SET room_id = '12', base_item = '4718', extra_data = @extra_data122, x = '3', y = '5', z = '0,1', rot = '0', wall_pos = '' WHERE id = '122' LIMIT 1; UPDATE items SET room_id = '12', base_item = '4705', extra_data = @extra_data121, x = '5', y = '6', z = '0', rot = '2', wall_pos = '' WHERE id = '121' LIMIT 1; UPDATE items SET room_id = '12', base_item = '77701', extra_data = @extra_data52, x = '5', y = '7', z = '0,1', rot = '0', wall_pos = '' WHERE id = '52' LIMIT 1; UPDATE items SET x = '9', y = '3', z = '0,1', rot = '0', wall_pos = '', extra_data = @mextra_data107 WHERE id = '107' LIMIT 1;

I know that it is something with the Z table, but how can I solve it?

And another thing, when I want to close the Phoenix server, it says that user_roomvisits has a double value, it appears that something uses the room id also as user id. How to solve this

[MentaL]

[Gaby]

Run this query in your database: SET @@global.sql_mode = ''; Then restart your webserver.
Then run this query in your database: SELECT @@global.sql_mode; and see if it returns something like this: http://prntscr.com/16ci6y (this can look different in phpmyadmin)

[Kyrotix]

If that didnt work for you download this phoenix MediaFire - Online Space for your documents, photos, videos, and music.

[ringomanic]

@BaasHotel,
Unfortunately this isn't the solution

@Kyrotix,
Mediafire says this:"File Blocked for Violation.

[ringomanic]

Fixed it, regional settings.

Decimal was , but needs to be .
So I have changed it, and the bug is gone :D