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
Rebuild Fields utility
Re: Rebuild Fields utility
Delete setup.md5 and try again
Kind regards,
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
AppGini 24.10 Revision 1579 + all AppGini Helper tools
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
[code]...[/code]
blocks for better readabilityAppGini 24.10 Revision 1579 + all AppGini Helper tools
Re: Rebuild Fields utility
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
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
Re: Rebuild Fields utility
Just an idea:
If
Maybe you can quickly check the contents:
You could also check any logged SQL errors in Admin Area (/admin/pageQueryLogs.php?type=error)
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:
Code: Select all
SELECT DISTINCT `YOUR_COLUMN_NAME` FROM `YOUR_TABLE_NAME` ORDER BY 1
- Attachments
-
- chrome_dfhNxe09dI.png (16.59 KiB) Viewed 1120 times
Kind regards,
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
AppGini 24.10 Revision 1579 + all AppGini Helper tools
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
[code]...[/code]
blocks for better readabilityAppGini 24.10 Revision 1579 + all AppGini Helper tools
Re: Rebuild Fields utility
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
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
Re: Rebuild Fields utility
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
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
Re: Rebuild Fields utility
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
Now that I've uploaded the data again, it works. For whatever reason.
Nevertheless, many thanks for the help Mr. Setzer.
Kind regards
Joseph