Server error 500 due to missing database field "invisible
herrrilke opened this issue · 0 comments
herrrilke commented
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_produkteADD
invisibleCHAR(1) NOT NULL AFTER
id`;
ALTER TABLE ctl_produkte
ADD INDEX( invisible
);`