Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

update error? Topic is solved

Questions related to installing, updating, setting up and configuring
Post Reply
treed
Posts: 205
Joined: Mon May 18, 2020 12:02 am
Contact:

update error?

Unread post by treed »

Found this in the debug window after updating the database.

Code: Select all

0] : ===USER==========

globeadmin

===PDO MESSAGE===

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'WCBBQ_DB.sys_zzzzsys_config' doesn't exist

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

REPLACE INTO zzzzsys_config SELECT * FROM sys_zzzzsys_config

===BACK TRACE====

/var/www/html/db/core/nusystemupdatelibs.php - line 348 (nuRunQuery)

/var/www/html/db/core/nusystemupdate.php - line 70 (nuAppendToSystemTables)
Is this a problem or not??? This was my first system update since March.
treed
Posts: 205
Joined: Mon May 18, 2020 12:02 am
Contact:

Re: update error?

Unread post by treed »

Also when saving system settings I get the error message: zzzzsys_config is not a valid table name for a Subform
treed
Posts: 205
Joined: Mon May 18, 2020 12:02 am
Contact:

Re: update error?

Unread post by treed »

Well I'm going to put this here because it was part of the same update. It looks like an expired user was deleted from the system table during the update. Is this expected behavior? I have a bunch of employee picklists that only show non expired employees.
kev1n
nuBuilder Team
Posts: 3801
Joined: Sun Oct 14, 2018 6:43 pm
nuBuilder Version: 4.5
Has thanked: 2 times
Been thanked: 9 times
Contact:

Re: update error?

Unread post by kev1n »

treed wrote: Tue Jul 12, 2022 8:51 pm Also when saving system settings I get the error message: zzzzsys_config is not a valid table name for a Subform
This error can be ignored. The update process tried to delete records from that table which didn't exist prior to running the update.
kev1n
nuBuilder Team
Posts: 3801
Joined: Sun Oct 14, 2018 6:43 pm
nuBuilder Version: 4.5
Has thanked: 2 times
Been thanked: 9 times
Contact:

Re: update error?

Unread post by kev1n »

treed wrote: Tue Jul 12, 2022 8:54 pm Well I'm going to put this here because it was part of the same update. It looks like an expired user was deleted from the system table during the update. Is this expected behavior? I have a bunch of employee picklists that only show non expired employees.
Expired users shouldn't be deleted. I was not able to reproduce that here when updating an version form last year that also contained expired users.
Did you check zzzzsys_user table if the are really not there? Otherwise you'll have to restore them from a backup.
treed
Posts: 205
Joined: Mon May 18, 2020 12:02 am
Contact:

Re: update error?

Unread post by treed »

Yes still there in zzzzsys_user.
kev1n
nuBuilder Team
Posts: 3801
Joined: Sun Oct 14, 2018 6:43 pm
nuBuilder Version: 4.5
Has thanked: 2 times
Been thanked: 9 times
Contact:

Re: update error?

Unread post by kev1n »

Filter for the expired ones and inspect the SQL (Options menu -> form Info)

Then run the SQL in phpMyAdmin to see if you get any rows back.
kev1n
nuBuilder Team
Posts: 3801
Joined: Sun Oct 14, 2018 6:43 pm
nuBuilder Version: 4.5
Has thanked: 2 times
Been thanked: 9 times
Contact:

Re: update error?

Unread post by kev1n »

Could you check that?
treed
Posts: 205
Joined: Mon May 18, 2020 12:02 am
Contact:

Re: update error?

Unread post by treed »

In the users screen I selected expired from the drop down and there they were. No records lost. Thanks.
Post Reply