EQEmulator Forums - Placing objects in world, MYSQL Error on save

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=598)

- - Placing objects in world, MYSQL Error on save (https://www.eqemulator.org/forums/showthread.php?t=41734)

Placing objects in world, MYSQL Error on save

Hey guys, just been doing a little work trying to customize a zone by adding a few objects here and there.

The trouble I am running into is when I create a static object and try to save it I get the MySQL error in the picture attached.

https://imgur.com/a/S2GTd

Adding the objects as a tradeskill item rather than a static seems to work but I don't want the objects openable and you lose the options for size, solidtype, incline.

Here is the error, straight out the log file.

Code:

[Sun Jan 28 11:45:45 2018] [MySQL Error] 1264: Out of range value for column 'unknown10' at row 1 

[Sun Jan 28 11:45:45 2018] ---  INSERT INTO object (id, zoneid, version, xpos, ypos, zpos, heading, objectname, type, icon, unknown08, unknown10, unknown20) VALUES (6000, 96, 0, 2385.3, -5502.4, 3.4, 478.0, 'KUSTAT1P1', 0, 0, 0, 1079574528, 0)

[Sun Jan 28 11:45:45 2018] Database Error: #1264: Out of range value for column 'unknown10' at row 1

Thanks for looking, hopefully this can be solved :smile:. I'd be super happy even if it ended up being user error!

It appears it is trying to write 1079574528 into unknown10 which only allows a 0 or 1 (unknown10 is for request_nonsolid)

I took the info from the error log and replaced 1079574528 with 0 and I was able to add the object through a query in the DB.

Really don't know where to go from here but looks like the tool isn't aligning properly with the db somehow. Also seems when I do get the items in through a query, they are clickable and open like a tradeskill item... strange things. Have it set as type 0 (static)