AppGini Community Forums

Hi
In the AppGini definition of the model field it says "INT UNSIGNED NULL" but it should be VARCHAR (100). I have already regenerated and uploaded the files. But it doesn't change. Where can I look for the error? I thank you in advance for your help

Kind regards
Joseph

Delete setup.md5 and try again

Hello Mr. Setzer

Unfortunately it is not successful. AppGini wants the field as "INT UNSIGNED NULL" and the database is VARCHAR (100). It's actually not a blemish anymore, but it bothers me a bit. Data can still be entered and displayed correctly.
Deleted the Setup.md5 and reinstalled the tables (templates, hooks and in the root directory of Appgini. No success.

Thanks for your help.
Kind regards

Joseph

Just an idea:
If updateDB.php cannot migrate that field from VARCHAR to INT automatically, perhaps there are values inside which are not convertable to int, eg alphanumerics "ABC" or values like "1.99".

Maybe you can quickly check the contents:
You could also check any logged SQL errors in Admin Area (/admin/pageQueryLogs.php?type=error)

Hello Mr. Setzer

From the definition in AppGini I would like to change the "Model" field from "INT UNSIGNED NULL" to Varchar (100) - as in the database.
Data is currently not available on the list. (Csv saved) Unfortunately, the field in the definition of AppGini is retained as such. Even rewriting the Setup.md5 is unsuccessful.

Kind regards
Joseph

Hello Mr. Setzer

In my Xampp environment it works like in the picture, but unfortunately not on the productive application on the Internet server. See image
Kind regards
Joseph

Hello Mr. Setzer

Now that I've uploaded the data again, it works. For whatever reason.
Nevertheless, many thanks for the help Mr. Setzer.

Kind regards
Joseph