[TYPO3-dev] TYPO3 on PostgreSQL experiances

[Martin Kutschker]

Martin Kutschker schrieb:
> ries van Twisk schrieb:
>> As promised my experience to installed TYPO3 on PostgreSQL.
>>
>> Basically I follow the installation manual on these site:
>>
>> http://typo3.org/documentation/document-library/extension-manuals/dbal/0.9.9/view/1/4/ 
>>
>>
>> Modifying the localconf.php is relative painless and it connects to 
>> PostgreSQL (8.2) right away:
>>
>> I will in my username/password and select my (already created) 
>> database (UTF-8)
>>
>> First I hit this error:
>>
>> 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:]]*=)'))    {

Ries, did this help?

Masi