Rebuild Fields utility

Please report bugs and any annoyances here. Kindly include all possible details: steps to reproduce, expected result, actual result, screenshots, ... etc.
Post Reply
jfischer
Posts: 23
Joined: 2022-11-19 16:07
Location: Austria
Contact:

Rebuild Fields utility

Post by jfischer » 2023-01-10 15:16

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?
AppGini.jpg
AppGini.jpg (16.79 KiB) Viewed 1149 times
I thank you in advance for your help

Kind regards
Joseph

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: Rebuild Fields utility

Post by jsetzer » 2023-01-10 18:59

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 [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

jfischer
Posts: 23
Joined: 2022-11-19 16:07
Location: Austria
Contact:

Re: Rebuild Fields utility

Post by jfischer » 2023-01-11 08:13

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

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: Rebuild Fields utility

Post by jsetzer » 2023-01-11 09:10

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:

Code: Select all

SELECT DISTINCT `YOUR_COLUMN_NAME` FROM `YOUR_TABLE_NAME` ORDER BY 1
You could also check any logged SQL errors in Admin Area (/admin/pageQueryLogs.php?type=error)
Attachments
chrome_dfhNxe09dI.png
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 [code]...[/code] blocks for better readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

jfischer
Posts: 23
Joined: 2022-11-19 16:07
Location: Austria
Contact:

Re: Rebuild Fields utility

Post by jfischer » 2023-01-11 11:38

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

jfischer
Posts: 23
Joined: 2022-11-19 16:07
Location: Austria
Contact:

Re: Rebuild Fields utility

Post by jfischer » 2023-01-11 11:54

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
AppGini_1.jpg
AppGini_1.jpg (14.89 KiB) Viewed 1116 times
Kind regards
Joseph

jfischer
Posts: 23
Joined: 2022-11-19 16:07
Location: Austria
Contact:

Re: Rebuild Fields utility

Post by jfischer » 2023-01-11 16:16

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 ;)

Post Reply