Page 1 of 1

Access denied to all users except globeadmin

Posted: Fri Jun 13, 2025 1:46 am
by Lala
Help

I updated nubuilder and now access is denied to all the users except globeadmin.

The debug information says:

[0] : ===PDO MESSAGE===

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sfo_status' in 'SELECT'

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

SELECT `sfo_status` FROM `zzzzsys_form` WHERE `zzzzsys_form_id` = ?

===BACK TRACE====

/home/u150737126/domains/kiribatidb.com/public_html/lep/core/nudatabase.php - line 361 (nuRunQuery)

/home/u150737126/domains/kiribatidb.com/public_html/lep/core/nuform.php - line 1533 (db_fetch_value)

/home/u150737126/domains/kiribatidb.com/public_html/lep/core/nuform.php - line 61 (nuGetFormStatus)

/home/u150737126/domains/kiribatidb.com/public_html/lep/core/nuapi.php - line 95 (nuBeforeEdit)

I can't attach a backup because I get the following message if I try to back it up:

Image

HELP!

Re: Access denied to all users except globeadmin

Posted: Fri Jun 13, 2025 4:47 am
by kev1n
Hi,

You’ll need to run the database update as well, since it adds the sfo_status column to the zzzzsys_form table.
Also, the procedure will include '../third_party/mysqldump/Mysqldump.php', whereas your error shows a path to core/libs/, which strongly indicates that your database still needs updating.

Re: Access denied to all users except globeadmin

Posted: Fri Jun 13, 2025 5:11 am
by Lala
Far out - that's a relief! I've got a clinic full of leprosy patients whose records couldn't be seen! Thank you so much!