Missing default value leads to SQL Error on saving

bihor / fp_masterquiz

TYPO3 extension to create a quiz, poll or test. The user result will be saved in the DB too and could be displayed as a chart.

GNU General Public License v3.0

5 stars 10 forks source link

Missing default value leads to SQL Error on saving #13

Closed linawolf closed 3 years ago

linawolf commented 3 years ago

I am running fp_masterquiz 1.4.4 on TYPO3 9.5.23 and ddev with MariaDB 10.2

On creating tx_fpmasterquiz_domain_model_evaluation reccord I get the following error: 2: SQL error: 'Incorrect integer value: '' for column db.tx_fpmasterquiz_domain_model_evaluation.page at row 1' (tx_fpmasterquiz_domain_model_evaluation:NEW5fc5078b8190a939405297)

Attached Patch solves the issue for me by setting 0 as default value via TCA Bugfix_Missing_Defaults.zip

bihor commented 3 years ago

Fixed in version 1.4.5