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: [email protected] [mailto:[email protected]] On Behalf Of Xavier Perseguers Sent: zaterdag 27 maart 2010 7:36 To: [email protected] 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 [email protected] http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english _______________________________________________ TYPO3-english mailing list [email protected] http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
