Page 1 of 1

[Solved] Dropdown List Items Missing

Posted: Tue Dec 14, 2021 5:10 pm
by saultpastor
I have moved my nubuilder project to a hosted website from an in-house server on a raspberry pi. Everything is working except when I am logged in as a general user, all the items listed in the Select object are missing. They work properly on the globeadmin user. It sounds like a permission problem I just can't figure out which one. Hopefully, this sounds familiar to someone.

Re: Dropdown List Items Missing

Posted: Tue Dec 14, 2021 5:19 pm
by kev1n
Hi,
  • Does this happen with all select objects?
  • Do you happen to see an error message in the developer console (usually F12) ?
  • Is there an error listed in nuDebug Results (CTRL+SHIFT+D) ?

Re: Dropdown List Items Missing

Posted: Tue Dec 14, 2021 5:24 pm
by saultpastor
Yes all select objects
Not sure of the dev console output will check...
nuDebug:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'slf_form_type' in 'field list'

===SQL===========

SELECT slf_form_type FROM zzzzsys_access_form WHERE slf_zzzzsys_access_id = ? AND slf_zzzzsys_form_id = ?

===BACK TRACE====

Thanks
Craig

Re: Dropdown List Items Missing

Posted: Tue Dec 14, 2021 5:31 pm
by kev1n
Could yoo try updating to the latest nuBuilder version from Github?

Re: Dropdown List Items Missing

Posted: Tue Dec 14, 2021 5:36 pm
by saultpastor
It looks to me like I did something wrong updating the old version before moving to the new one. I should have migrated the old version over then updated to the latest version.
Something has changed in the system tables.

Craig

Re: Dropdown List Items Missing

Posted: Tue Dec 14, 2021 5:36 pm
by saultpastor
Sorry yes, will do Thanks

[Solved] Dropdown List Items Missing

Posted: Tue Dec 14, 2021 6:14 pm
by saultpastor
That worked great thanks, I should've checked nuDebug.
btw, nuBuilder update worked perfectly. I should have updated properly before migrating, but I got in a hurry and just moved the SQL backup and used a new updated copy of nuBuilder, so the data file was from the old version but the program files from the latest version. But updater just fixed it.

Thanks again

Re: [Solved] Dropdown List Items Missing

Posted: Tue Dec 14, 2021 6:24 pm
by kev1n
Great :D