[TYPO3-mvc] Problems with property "order"
Martin Ernst
ernst at alto.de
Wed Nov 30 13:27:31 CET 2011
Hello,
I am using extbase 1.4 with TYPO3 4.6.0.
I have one model "order". It works fine.
Additionally, I have a 1:n relation to a different table "orderedproduct".
Thus, the new model "orderedproduct" needs the property "order". And
this is the problem. The SQL statements throw errors, because "order" is
a reserved word in MySQL. I have changed the ext_tables.sql so that
"orders" now is written with quotes:
`order` int(11) unsigned DEFAULT '0' NOT NULL,
The table can be created now. But each SQL statement built by extbase
uses "order" (if needed) without quotes:
UPDATE tx_altowws_domain_model_orderedproduct SET order='1',
tstamp='1322655028', sys_language_uid=NULL WHERE uid='1'
Can I make extbase quote all table and column names so that I can work
with my model?
Thanks
Martin
More information about the TYPO3-project-typo3v4mvc
mailing list