[TYPO3-dev] TYPO3 on PostgreSQL experiances

[Martin Kutschker]

Martin Kutschker schrieb:
>>
>> ERROR: Query could not be parsed: "SQL engine parse ERROR: Still 
>> content in clause after parsing!: near "ENGINE=InnoDB "". Query: 
>> "CREATE TABLE cache_hash ( hash varchar(32) DEFAULT '' NOT NULL, 
>> content mediumblob NOT NULL, tstamp int(11) unsigned DEFAULT '0' NOT 
>> NULL, ident varchar(20) DEFAULT '' NOT NULL, PRIMARY KEY (hash) ) 
>> ENGINE=InnoDB;"
> 
> This is IMHO an error that t3lib_sqlparser outputs. Digging into the 
> code I see that it suports TYPE=<type> but not ENGINE=<type>. Try 
> changing that in  the sql file and see if the error disappears.
> 
> Or change in line 490:
> 
> from
> if ($this->nextPart($parseString, '^(TYPE[[:space:]]*=)'))    {
> to
> if ($this->nextPart($parseString, '^((?:TYPE|ENGINE)[[:space:]]*=)'))    {

BTW, this is such a compatibility issue which could also be fixed in TYPO3 3.8.

Masi