Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

[Solved] Dropdown List Items Missing Topic is solved

Questions related to using nuBuilder Forte.
Post Reply
saultpastor
Posts: 42
Joined: Sat Jul 18, 2015 8:04 pm
Has thanked: 3 times

[Solved] Dropdown List Items Missing

Unread post 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.
Last edited by saultpastor on Tue Dec 14, 2021 6:15 pm, edited 1 time in total.
kev1n
nuBuilder Team
Posts: 4302
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 71 times
Been thanked: 445 times
Contact:

Re: Dropdown List Items Missing

Unread post 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) ?
saultpastor
Posts: 42
Joined: Sat Jul 18, 2015 8:04 pm
Has thanked: 3 times

Re: Dropdown List Items Missing

Unread post 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
kev1n
nuBuilder Team
Posts: 4302
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 71 times
Been thanked: 445 times
Contact:

Re: Dropdown List Items Missing

Unread post by kev1n »

Could yoo try updating to the latest nuBuilder version from Github?
saultpastor
Posts: 42
Joined: Sat Jul 18, 2015 8:04 pm
Has thanked: 3 times

Re: Dropdown List Items Missing

Unread post 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
saultpastor
Posts: 42
Joined: Sat Jul 18, 2015 8:04 pm
Has thanked: 3 times

Re: Dropdown List Items Missing

Unread post by saultpastor »

Sorry yes, will do Thanks
saultpastor
Posts: 42
Joined: Sat Jul 18, 2015 8:04 pm
Has thanked: 3 times

[Solved] Dropdown List Items Missing

Unread post 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
kev1n
nuBuilder Team
Posts: 4302
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 71 times
Been thanked: 445 times
Contact:

Re: [Solved] Dropdown List Items Missing

Unread post by kev1n »

Great :D
Post Reply