blooberry_eq99
03-27-2019, 11:58 AM
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:
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!
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!