Update not successful - resolved with question

[Gnu]

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?

[Gnu]

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';