[TYPO3-english] DBAL & PostgreSQL

[Xavier Perseguers]

Hi Rens,

> For example the subtitle field of the pages table. If I add a new page (with
> empty subtitle), the subtitle is set to the value 'als'. Some debugging
> learnt me that $fieldArray['subtitle'] is false in TCEMain::updateDB. This
> causes t3lib_div::fullQuoteString to return 'als'. The error TYPO3 returns
> is '102: These fields are not properly updated in database: (subtitle)
> Probably value mismatch with fieldtype.' Which is good, because the stored
> value doesn't match the given value.
>
>
>
> This is my localconf config of dbal:
>
> $TYPO3_CONF_VARS['EXTCONF']['dbal']['handlerCfg'] = array (
>                  '_DEFAULT' =>  array (
>                                 'type' =>  'adodb',
>                                 'config' =>  array (
>                                                 'driver' =>  'postgres8',
>                                                 'port' =>  5432,
>                                                 'username' =>  'user',
>                                                 'password' =>  'password',
>                                                 'host' =>  'localhost'
>                                 )
>                  )
> );

This is valid although we suggest to use the normal $typo_db_username and other variables to give credentials:

$typo_db_username = 'user';
$typo_db_password = 'password';
$typo_db_host = 'localhost';
$typo_db = 'database';

Leaving only driver (and port in your case) in the DBAL config. But that's not the point.

I don't have a clue yet but will test it, probably tomorrow. Stay tuned!

Regards

-- 
Xavier Perseguers
http://xavier.perseguers.ch/en