Announcement

Collapse
No announcement yet.

Sql Error when creating a new record

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Sql Error when creating a new record

    Hello.

    After the recent updates to Sc I now get an error when trying to create a new record.

    When creating a new record the "OrderID" doesn't get created untill the record is saved and the mySQL creates the auto increment id #.

    This error i'm getting has something to do with the "Multi-Upload" field as its looking for the foreign key which is tied to the "OrderID" which hasn't been created yet in a new record untill its saved.

    Like I said I didn't get this error before but it kinda makes sense because its referencing an Primary key that doesn't exist for that record yet.

    How can I fix this?
Working...
X