Welcome to the nuBuilder Forums!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.
[Solved] Dropdown List Items Missing Topic is solved
-
- Posts: 42
- Joined: Sat Jul 18, 2015 8:04 pm
- Has thanked: 3 times
[Solved] Dropdown List Items Missing
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.
Last edited by saultpastor on Tue Dec 14, 2021 6:15 pm, edited 1 time in total.
-
- nuBuilder Team
- Posts: 4301
- Joined: Sun Oct 14, 2018 6:43 pm
- Has thanked: 71 times
- Been thanked: 445 times
- Contact:
Re: Dropdown List Items Missing
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) ?
-
- Posts: 42
- Joined: Sat Jul 18, 2015 8:04 pm
- Has thanked: 3 times
Re: Dropdown List Items Missing
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
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
-
- nuBuilder Team
- Posts: 4301
- Joined: Sun Oct 14, 2018 6:43 pm
- Has thanked: 71 times
- Been thanked: 445 times
- Contact:
-
- Posts: 42
- Joined: Sat Jul 18, 2015 8:04 pm
- Has thanked: 3 times
Re: Dropdown List Items Missing
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
Something has changed in the system tables.
Craig
-
- Posts: 42
- Joined: Sat Jul 18, 2015 8:04 pm
- Has thanked: 3 times
-
- Posts: 42
- Joined: Sat Jul 18, 2015 8:04 pm
- Has thanked: 3 times
[Solved] Dropdown List Items Missing
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
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