Query Logs

Got something cool to share with AppGini users? Feel free to post it here!
Post Reply
User avatar
RonP
Veteran Member
Posts:319
Joined: 2013-08-27 13:36
Location: Heiloo, The Netherlands
Contact:

Query Logs

Post by RonP » 2026-10-17 13:05

Hi,

Every now and then I check the "Query Logs" it took a while to understand the "error" message and I think that every time the application is started the Browser tries to do "something" under the "quest" account.
This results into an error by trying to create / update an index.

Is this a right assumption or do I have to make an alteration in one of the Application settings?
I don't use quest accounts.
Ron
AppGini - After login.png
AppGini - After login.png (111.95 KiB) Viewed 6605 times

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts:1757
Joined: 2018-04-01 10:12

Re: Query Logs

Post by pbottcher » 2026-10-25 08:23

Hi Ron,

that behaviour sounds very strange. Do you have any custom code that runs once the application is started via the browser? I do not see any of this type on my applications, so I would assume that there must be something different.

best
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.

User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts:1464
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Re: Query Logs

Post by onoehring » 2026-10-26 17:25

Hi,
just a quick note.
I have created a view with the name of an AG internal table. I notice the same (sometimes), when e.g. AG (or my code?) tries to create an index on that - which of course does not work for a view.
Why I have a view that's named like an AG table is easy to explain: This way I can use the contents as a lookup field in a different table. Unfortunately this is not possible directly from AG.

Olaf

User avatar
RonP
Veteran Member
Posts:319
Joined: 2013-08-27 13:36
Location: Heiloo, The Netherlands
Contact:

Re: Query Logs

Post by RonP » 2026-10-27 14:30

Hi Gents,
I'm still searching. This application started in 2012 en I've always updated the versions.
I have 2 more application and they don't cope with this issue.
Is it possible that some old coding still sucks somewhere?
Ron

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts:1757
Joined: 2018-04-01 10:12

Re: Query Logs

Post by pbottcher » 2026-10-27 20:46

Hi Ron,

as you say, the other do not have the issue, so it is most likely that some custom code is causing this.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.

User avatar
a.gneady
Site Admin
Posts:1381
Joined: 2012-09-27 14:46
Contact:

Re: Query Logs

Post by a.gneady » 2026-10-28 15:43

Having a view with the same name as an internal table could cause unpredictable conflicts. But anyway one thing to check: Admin area > Utilities menu > View/rebuild fields. From that page, scroll down the to the membership_userpermissions table and take a screenshot of what you see there. My doubt is that it could reveal some comparison bug the app is doing that could need a fix.
:geek: Build AppGini apps using Claude or other AI agents

:idea: AppGini plugins add more power to your apps -- Enjoy up to 30% off when buying 2 or more plugins.

:?: Need personalized consulting on your specific app and customizations? Book an online call with me here.

User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts:1464
Joined: 2019-05-21 22:42
Location: Germany
Contact:

Re: Query Logs

Post by onoehring » 2026-10-31 13:20

Hi Ron,

are you using any hooks?
For me it seems strange - like pbotcher said. The question remains why this happens. Does it only occur with the "guests" account?

Post Reply