# POST to mysql error: user\_id\_on\_create always 3

**URL:** <https://community.dreamfactory.com/t/post-to-mysql-error-user-id-on-create-always-3/3974>\
**Category:** Schema & Data\
**Created:** [July 28, 2017, 2:14pm UTC](https://community.dreamfactory.com/t/post-to-mysql-error-user-id-on-create-always-3/3974 "2017-07-28T14:14:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![EM\_FLK](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/em_flk/32/953_2.png) [@EM\_FLK](https://community.dreamfactory.com/u/EM_FLK)\
**Post date:** [July 28, 2017, 2:14pm UTC](https://community.dreamfactory.com/t/post-to-mysql-error-user-id-on-create-always-3/3974/1 "2017-07-28T14:14:30Z")

</div>

For some reason when I create a new record for my database table I am met with the following error:

> ```
> "code": "23000",
> "message": "SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3' for key 'ID' (SQL: insert into `bitnami_df`.`mobileusers` (`Email`, `ID`, `Pass`, `NiftyID`, `CRMid`, `BooksID`, `Confirmed`) values (redacted@redacted.org, 3, 5456, 444, 444, 566, 1))",
> 
> ```

Has anyone had this issue or know a resolution?

---

<div class="post-metadata">

**Author:** ![leehicks](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/leehicks/32/55_2.png) [@leehicks](https://community.dreamfactory.com/u/leehicks)\
**Post date:** [August 1, 2017, 1:01pm UTC](https://community.dreamfactory.com/t/post-to-mysql-error-user-id-on-create-always-3/3974/2 "2017-08-01T13:01:23Z")

</div>

Can you please post the schema of the table mobileusers using \_schema/mobileusers endpoint? Are there any constraints on the ID field?