Bug #15782
closed
multiplyDBfieldSize and datetime
0%
Description
If $TYPO3_CONF_VARS['SYS']['multiplyDBfieldSize'] is set to a value greater than 1 and you want to install "th_mailformplus" you get the following error-message:
SQL engine parse ERROR: Field type unknown in parseFieldDef()!: near "datetime default '0000-00-00 00:00:00' "
As soon as you lower multiplyDBfieldSize to 1 everything works.
After my opinion the problem lies in class.t3lib_sqlparser.php in the function parseFieldDef(). There is a regex with a lot of db-datatypes, but datetime is missing.
As soon as "datetime" is added everything work fine.
(issue imported from #M2793)
Files
Updated by Joerg Schoppet over 18 years ago
Hi,
just realised that bug 2792 is the same thing.
I've made a new patch.
Updated by Karsten Dambekalns over 18 years ago
This is not a bug in TYPO3, but a glitch in th_mailformplus. datetime is a MySQL-specific field type, and as such incompatible with the goal of at least making DBAL possible.
Besides TYPO3 never uses date or time types, but always integer to store a unix timestamp. You should submit a bug report to the author of th_mailformplus.