[TYPO3-dev] TYPO3 on PostgreSQL experiances

[Dmitry Dulepov [typo3]]

ries van Twisk wrote:
> 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;"
> 
> Since InnoDB is vendor specific, I have to remove these entries, and can 
> only be done from command line or using 'some' tool. So I remove the 
> InnoDB  declaration.

I think DBAL should handle it. But we cannot remove it from core files because it gives huge performance improvement in MySQL, which is our default database.

> After that I get this message:
> 
> Warning: Invalid argument supplied for foreach() in 
> /Users/rvt/Sites/typo3_src-4.1.6/typo3/sysext/adodb/adodb/adodb-datadict.inc.php 
> on line 266

Something ADO/DBAL related again...

> After a other reload... I don't get that message anymore, so I am not 
> sure what's the cause...

Because now you get cached copy of the page.

> Warning: Invalid argument supplied for foreach() in 
> /Users/rvt/Sites/typo3_src-4.1.6/typo3/sysext/dbal/class.ux_t3lib_db.php 
> on line 968

DBAL bug...

> 
> Warning: Cannot modify header information - headers already sent by 
> (output started at 

All "Cannot modify header..." messages can be ignored. They appear because of previous errors and will disappear with them.

> Installing tt_news brings me:
> 
> The running TYPO3 version (4.1.6) is higher than allowed (3.8.1)

I afraid you are using some ancient tt_news version.

> This is interesting because an 2.5.2 is available on TER, however 2.2.24 
> was installed..

...which confirms my statement above. Update your extension list.

-- 
Dmitry Dulepov
TYPO3 core team
Web: http://typo3bloke.net/
Skype: callto:liels_bugs
"Nothing is impossible. There are only limits to our knowledge"