Page 1 of 1

auto increment getting string val?

Posted: 2020-02-13 02:30
by D Oliveira
hi, please take a look at these two images, my prinary key “id” is an auto increment integer and works fine on local host, but when uploading the application to server look what happens, somehow the ‘Not Assigned’ value is begin pushed through, that field should be ommited in that statement, any comments? thank you

https://i.imgur.com/GJuC9m6.jpg

https://i.imgur.com/TABlpzA.jpg

*rebuild pages doesnt show any rebuilds, same database, same application

Re: auto increment getting string val?

Posted: 2020-02-13 13:02
by a.gneady
Hmm ... where does the 'Not assigned' string in the query come from? Is it specified as a default value for the field in AppGini? Please try going to the admin area > Utilities menu > Rebuild fields ... does the page report any issues in the database?

Re: auto increment getting string val?

Posted: 2020-02-13 13:21
by D Oliveira
a.gneady wrote:
2020-02-13 13:02
Hmm ... where does the 'Not assigned' string in the query come from? Is it specified as a default value for the field in AppGini? Please try going to the admin area > Utilities menu > Rebuild fields ... does the page report any issues in the database?
'not assigned' string comes from appgini standard procedure of inserting the record in the db, theres no custom code on my end, rebuild fields is clear all fields are ok, no console erros other than those images that I have shared, the `id` primary key field should be omitted in that statement, which file of appgini handles auto increment insert statements?

Re: auto increment getting string val?

Posted: 2020-02-13 13:34
by D Oliveira
UPDATE:

yes, 'Not Assigned' was a default value inside appgini application but i have never written that there, my application is in portuguese, maybe by clicking autoincrement in an appgini older version you had 'Not Assigned' to be set as default value, anyway.... removing that FIXED THE ISSUE! thank you