[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