Page 1 of 1
update error?
Posted: Tue Jul 12, 2022 8:40 pm
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.
Re: update error?
Posted: Tue Jul 12, 2022 8:51 pm
by treed
Also when saving system settings I get the error message: zzzzsys_config is not a valid table name for a Subform
Re: update error?
Posted: Tue Jul 12, 2022 8:54 pm
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.
Re: update error?
Posted: Wed Jul 13, 2022 12:42 am
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.
Re: update error?
Posted: Wed Jul 13, 2022 12:44 am
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.
Re: update error?
Posted: Wed Jul 13, 2022 5:55 pm
by treed
Yes still there in zzzzsys_user.
Re: update error?
Posted: Wed Jul 13, 2022 6:21 pm
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.
Re: update error?
Posted: Mon Jul 18, 2022 8:44 pm
by kev1n
Could you check that?
Re: update error?
Posted: Tue Jul 19, 2022 12:45 am
by treed
In the users screen I selected expired from the drop down and there they were. No records lost. Thanks.