[TYPO3-dev] TYPO3 on PostgreSQL experiances

[Martin Kutschker]

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:]]*=)'))	{

Masi