Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::General Support

Support::General Support Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself.

Reply
 
Thread Tools Display Modes
  #1  
Old 01-28-2018, 02:43 PM
caddie23
Fire Beetle
 
Join Date: Sep 2008
Location: red deer
Posts: 5
Exclamation 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 . I'd be super happy even if it ended up being user error!
Reply With Quote
  #2  
Old 01-28-2018, 03:46 PM
caddie23
Fire Beetle
 
Join Date: Sep 2008
Location: red deer
Posts: 5
Default

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)

Last edited by caddie23; 01-28-2018 at 04:07 PM.. Reason: Help please
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 09:08 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3