[TYPO3-english] DBAL & PostgreSQL

[Rens Admiraal]

I think I found it...

The subtitle field has an empty eval configuration in
typo3/sysext/cms/ext_tables.php. When I set this to 'trim' the problem does
not occur.

It seems like an input field (string) with no eval configuration is send as
a Boolean false, which results somehow in the value 'als' in the database.
Am I correct that this is a bug in TYPO3? I would say that an empty
inputfield should post an empty string, and should not be presented as
false...



-----Original Message-----
From: typo3-english-bounces at lists.typo3.org
[mailto:typo3-english-bounces at lists.typo3.org] On Behalf Of Rens Admiraal
Sent: zaterdag 27 maart 2010 11:09
To: 'TYPO3 English'
Subject: Re: [TYPO3-english] DBAL & PostgreSQL

Hi Xavier,

I did also set those :p I just did some more testing, and for now it seems
to be only the subtitle field, I do not get this error on the navigation
title or author for example. So I think it's specific to this field...

The field type in the database is:
character varying (255), NOT NULL, default ''::character varying which is
exactly the same as the nav_title field

Just wanted to post this because I've to go now, and maybe this is of use
during testing :-)




-----Original Message-----
From: typo3-english-bounces at lists.typo3.org
[mailto:typo3-english-bounces at lists.typo3.org] On Behalf Of Xavier
Perseguers
Sent: zaterdag 27 maart 2010 7:36
To: typo3-english at lists.typo3.org
Subject: Re: [TYPO3-english] DBAL & PostgreSQL

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
_______________________________________________
TYPO3-english mailing list
TYPO3-english at lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english

_______________________________________________
TYPO3-english mailing list
TYPO3-english at lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english