nuBuilder Forum

Posted: **Sun Sep 01, 2024 4:49 pm**

Hello,
I have updated from a May version to the latest Github version. Afterwards I could log in, but there were no objects available.
The table zzzzsys_objects was empty. The debug window stated that the number of columns in the zzzzsys_objects table did not match and therefore a REPLACE was not possible.

I restored a backup, added the missing column (sob_display_procedure) manually and the update went successfully.

Wouldn't it make sense to add new columns automatically during the update process if required?

Posted: **Sun Sep 01, 2024 4:57 pm**

The number of colums can be retrieved with

Code: Select all

SELECT  COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
WHERE  TABLE_SCHEMA = 'nuBuilderTableName' AND TABLE_NAME = 'zzzzsys_object';

nuBuilder Forum

Update not successful - resolved with question

Update not successful - resolved with question

Re: Update not successful - resolved with question