EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   EQEmu Operations Center (https://www.eqemulator.org/forums/forumdisplay.php?f=679)
-   -   Error when adding zone objects (https://www.eqemulator.org/forums/showthread.php?t=42371)

blooberry_eq99 03-27-2019 11:58 AM

Error when adding zone objects
 
I think there is an issue with the SQL builder behind the object addition portion of EOC. When I filled out all the fields and hit 'Add Object', I end up with this error on the page:

Code:

INSERT INTO object SET id="", zoneid="484", objectname="IT10864_ACTORDEF", xpos="481", ypos="1052", zpos="320", heading="493", itemid="0", charges="0", type="17", icon="0", version="0" - Incorrect integer value: '' for column 'id' at row 1
My guess is that the SQL builder is not picking up the ID field from the page, and thus passing null for that column, causing the SQL error. I can manually add the items in the DB, but prefer using EOC when possible.

Is this something that can be looked at?

Thanks in advance!

joligario 03-27-2019 09:34 PM

Looks like your db doesn’t autoincrement. Next time EOC is updated, this should be fixed.


All times are GMT -4. The time now is 01:55 PM.

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.