alnv/catalog-manager

Server error 500 due to missing database field "invisible

herrrilke opened this issue · 0 comments

in an existing installation after updating to Contao 4.13 with
alnv/catalog-manager 1.32.35
alnv/catalog-manager-importer 1.4.0
alnv/catalog-manager-wishlist 2.3.0

PHP 8.1

when querying a CM-generated table the error 500 was thrown with the following message in error.log
"Column not found: 1054 Unknown column 'invisible' in 'where clause'".

the following fields were missing in the table in question, which seem to be created automatically in other tables(?)
invisible, CHAR (1)
start, VARCHAR (16)
stop, VARCHAR (16)

after i added 'invisible', the application works again.

ALTER TABLE ctl_produkteADDinvisibleCHAR(1) NOT NULL AFTERid`;

ALTER TABLE ctl_produkte ADD INDEX( invisible);`