AppGini 5.80 Build 1072
-
- Veteran Member
- Posts: 35
- Joined: 2016-02-16 22:31
AppGini 5.80 Build 1072
Hi All
Updated to AppGini 5.80 Build 1072, open existing project, add some tables => Generated new php=> Uploaded to server
After tried add new record, received error massage:
Then tried rebuild fields from admin area, and received another error massage:
Then using phpmyadmin, checked if new tables exist in database, no new app do not insert new tables, and rebuild fields utility not helps.
Could anyone can try to do the same?
Updated to AppGini 5.80 Build 1072, open existing project, add some tables => Generated new php=> Uploaded to server
After tried add new record, received error massage:
Then tried rebuild fields from admin area, and received another error massage:
Then using phpmyadmin, checked if new tables exist in database, no new app do not insert new tables, and rebuild fields utility not helps.
Could anyone can try to do the same?
Re: AppGini 5.80 Build 1072
Getting a "Run-time error 5" when exporting project.
Re: AppGini 5.80 Build 1072
Please try to regenerate the app, making sure to overwrite all existing files, then upload to your server, making sure to overwrite all files.mysh_eireannach wrote: ↑2019-10-08 10:47Hi All
Updated to AppGini 5.80 Build 1072, open existing project, add some tables => Generated new php=> Uploaded to server
After tried add new record, received error massage:
Screenshot 2019-10-08 at 11.41.14.png
Then tried rebuild fields from admin area, and received another error massage:
Screenshot 2019-10-08 at 11.38.40.png
Then using phpmyadmin, checked if new tables exist in database, no new app do not insert new tables, and rebuild fields utility not helps.
Could anyone can try to do the same?
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.
Re: AppGini 5.80 Build 1072
Please send me the AXP project file to inspect this issue. You can send it to me via https://bigprof.com/appgini/support-request
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.
Re: AppGini 5.80 Build 1072
Hi,
is it just me? I can not see any technical documentation. All it says is "No Access To Page" ...
Olaf
is it just me? I can not see any technical documentation. All it says is "No Access To Page" ...
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
Re: AppGini 5.80 Build 1072
Hi mysh_eireannach,
looking at the (too) small image of your SQL error it seems to me that it's worth trying to run that SQL using phpmyadmin. Does it work?
Did you change servers (Linux <-> Windows)? I had some troubles with that (see: viewtopic.php?f=4&t=3246 )
Also, your SQL says "GROUP=NULL ..." can those fields be NULL? If those fields are NULL by default, maybe it helps leaving these columns out?
Olaf
looking at the (too) small image of your SQL error it seems to me that it's worth trying to run that SQL using phpmyadmin. Does it work?
Did you change servers (Linux <-> Windows)? I had some troubles with that (see: viewtopic.php?f=4&t=3246 )
Also, your SQL says "GROUP=NULL ..." can those fields be NULL? If those fields are NULL by default, maybe it helps leaving these columns out?
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
-
- Veteran Member
- Posts: 35
- Joined: 2016-02-16 22:31
Re: AppGini 5.80 Build 1072
Hi a.gneady.
Yes, helps solution
Yes, helps solution
Thanks! All work now!regenerate the app, making sure to overwrite all existing files, then upload to your server, making sure to overwrite all files.
-
- Posts: 22
- Joined: 2019-03-20 13:46
Re: AppGini 5.80 Build 1072
©2019 - No rights reserved
Re: AppGini 5.80 Build 1072
a.gneady wrote: ↑2019-10-08 14:59Please send me the AXP project file to inspect this issue. You can send it to me via https://bigprof.com/appgini/support-request
Hello, send you the file, including a video-recordingw with the steps before the error.
Re: AppGini 5.80 Build 1072
Hmm ... it seems AppGini is unable to write to your temp folder ... Please try this: click the "Application theme" icon in the toolbar in AppGini (the one with a color palette), then click the button "Preview in web browser". This should open a browser window, displaying a preview of the selected theme. Does this work? It uses the same procedure of writing the preview file to the temp folder.
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.
Re: AppGini 5.80 Build 1072
Thanks .. will check it and reply to you within a few hours.
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.
-
- Veteran Member
- Posts: 35
- Joined: 2016-02-16 22:31
Re: AppGini 5.80 Build 1072
Hi Olafonoehring wrote: ↑2019-10-08 15:34Hi mysh_eireannach,
looking at the (too) small image of your SQL error it seems to me that it's worth trying to run that SQL using phpmyadmin. Does it work?
Did you change servers (Linux <-> Windows)? I had some troubles with that (see: viewtopic.php?f=4&t=3246 )
Also, your SQL says "GROUP=NULL ..." can those fields be NULL? If those fields are NULL by default, maybe it helps leaving these columns out?
Olaf
No, I not change anyting exept upgrade to AppGini 5.80 Build 1072.
I tried your solution rename all new tables to lower case, but not helps.
Error message shows:
Utilities menu : Rebuild Fields. - Not Helps!You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Group='2', Message='Test', Author='14', Attachment_1='e5ae32e9fbf11364e.pdf', At' at line 1
Query:
INSERT INTO `company_notice_board` SET Date='2019-10-9', Group='2', Message='Test', Author='14', Attachment_1='e5ae32e9fbf11364e.pdf', Attachment_2=NULL
The above info is displayed because you are currently signed in as the super admin. Other users won't see this.
You could try fixing this issue from the Admin Area : Utilities menu : Rebuild Fields.
Regenerate the app - Not Helps!
Re: AppGini 5.80 Build 1072
Hi Ahmed,
Olaf
yes, this does work. A new tab is opened in my default browser.Hmm ... it seems AppGini is unable to write to your temp folder ... Please try this: click the "Application theme" icon in the toolbar in AppGini (the one with a color palette), then click the button "Preview in web browser". This should open a browser window, displaying a preview of the selected theme. Does this work? It uses the same procedure of writing the preview file to the temp folder.
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
Re: AppGini 5.80 Build 1072
Hi mysh_eireannach,
did you try
did you try
Olaf... to run that SQL using phpmyadmin. Does it work?
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
-
- Veteran Member
- Posts: 35
- Joined: 2016-02-16 22:31
Re: AppGini 5.80 Build 1072
Hi Olaf,
You give me a good hint.
Sorted!
Problem was: I named one of my fields as 'group' and SQL query understand as syntax error.
INSERT INTO `company_notice_board` SET Date='2019-10-9', Group='2', Message='Test', Author='14', Attachment_1='e5ae32e9fbf11364e.pdf', Attachment_2=NULL
Renamed field as 'Group_w' , regenerated App, rebuild fields and problem disappear.
Conclusion:
Never name your fields as SQL commands!
Thanks for hints!
Re: AppGini 5.80 Build 1072
Hi,
you are welcome - and indeed, a good idea how (not) to name fields.
Olaf
you are welcome - and indeed, a good idea how (not) to name fields.
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
Re: AppGini 5.80 Build 1072
Hi Ahmed,
I do not change anything (just restarted Windows and AG several times) - and now the technical docs show up (did not try technical docs for pages yet). Olaf
I do not change anything (just restarted Windows and AG several times) - and now the technical docs show up (did not try technical docs for pages yet). Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
Re: AppGini 5.80 Build 1072
Actually this sounds like a bug as AppGini avoids similar errors by using back ticks around table and field names .. That is, if a field is named group, it shouldn't trigger an SQL error if it's used in queries as `group` ... So, it seems some queries are not quoting field named properly .. I'll investigate this issue and make a fix for it as soon as possible.Renamed field as 'Group_w' , regenerated App, rebuild fields and problem disappear.
Conclusion:
Never name your fields as SQL commands!
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.
Re: AppGini 5.80 Build 1072
Thanks for the update ... I'll try to investigate this issue further and see if there is a way to handle it better.
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.
Re: AppGini 5.81 Build 1094
Hi Ahmed,
well, the problem is back (was already some time ago, but did I not report it yet). I do have some information but it's not shown: AppGini 5.81 Build 1094
Olaf
well, the problem is back (was already some time ago, but did I not report it yet). I do have some information but it's not shown: AppGini 5.81 Build 1094
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
Re: AppGini 5.80 Build 1072
Hi Olaf,
Could you give me more details about your environment please? Are you using Windows 10, 8 or 7? Running as administrator or normal user?
Could you give me more details about your environment please? Are you using Windows 10, 8 or 7? Running as administrator or normal user?
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.
Re: AppGini 5.80 Build 1072
Hi Ahmed,
sure.
Windows 10 Pro (currently version 1809), 64bit. Working as admin (with UAC enabled).
I am using the Windows Firewall - but even when I disable this the information is not shown.
Also I am using Sophos Antivirus - but I seriously doubt that this matters.
Also: AppGini 5.81 Build 1094
Olaf
sure.
Windows 10 Pro (currently version 1809), 64bit. Working as admin (with UAC enabled).
I am using the Windows Firewall - but even when I disable this the information is not shown.
Also I am using Sophos Antivirus - but I seriously doubt that this matters.
Also: AppGini 5.81 Build 1094
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view