search

madeyourday / contao-rocksolid-slider

RockSolid Slider Contao Extension
http://rocksolidthemes.com/de/contao/plugins/responsive-slider
Other
9 stars 7 forks source link

Error if database is in strict mode #79

Closed operatorone closed 1 year ago

operatorone commented 2 years ago

After an Update to 4.9.21 I got the message in the install tool to set the database to strict mode. So I did. Afterwards I couldn't create any content element and got the following error message:

An exception occurred while executing 'INSERT INTO tl_content (floating, perRow, rsts_content_type, rsts_template, pid, sorting, ptable, tstamp) VALUES ('left', '', 'rsts_default', 'rsts_default', 10, 28, 'tl_article', 0)': SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column xb1_db.tl_content.perRow at row 1

I deactivated the strict mode again and the error was gone.

ausi commented 2 years ago

This doesn’t seem to be related to the Slider extension.

Do you have a custom DCA setting for perRow that changes the default value?

Maybe related to https://github.com/contao/contao/pull/3909