[TYPO3-dev] PostgreSQL native drive for TYPO3 status update... and question about : 102: These fields are not properly

Ingmar Schlecht ingmar at typo3.org
Sat Sep 29 20:32:07 CEST 2007


Hi Ries,

here you go:
http://svn.t3.digitaldistrict.de/cgi-bin/trac.cgi/browser/typo3/TYPO3core/branches/TYPO3_4-1/t3lib/class.t3lib_tcemain.php?rev=7069#L4919

cheers
Ingmar

ries van Twisk schrieb:
> Hey Guys,
> 
> 
> yesterday and today I had some time and ideas to work on a native
> PostgreSQL driver for TYPO3.
> 
> 
> Current status is:
> 
> 1) Using a TYPO3 backend module you can transfer a MySQL database to
> PostgreSQL both Schema and data. It's quite crude and needs to get
> cleaned up a bit.
> 2) using a xlass method I replace TYPO3_DB with a postgresql version.
> 
> That means initial load needs to be done with MySQL, but then any site
> can be transfered to postgresql...
> 
> Core FE and BE works, however when I insert a content record I get this
> message:
> 
>     102: These fields are not properly updated in database:
> (CType,sectionIndex) Probably value mismatch with fieldtype.
> 
> When I compare all fields in PostgreSQL and MySQL they are exactly the
> same, yet TYPO3 complains.
> 
> How does typo3 does this comparison and where in core can I check for
> the evaluation of these fields?
> 
> 
> One other problem I have is caching.. sometimes TYPO3 returns an empty
> page, sometimes not.
> I also had caching problems with MySQL (teh duplicate entry bla bla bla
> issue) so I don't think it's a PG problem,
> but more like a TYPO3 problem. Not sure where yet...
> 
> thanks,
> Ries vanTwisk
> 
> 
> 
> 
> -- 
> Ries van Twisk
> Freelance TYPO3 Developer
> email: ries at vantwisk.nl
> web:   http://www.rvantwisk.nl/
> skype: callto://r.vantwisk
> Phone: + 1 810-476-4193
> 
> 
> 
> 
> 
> 


-- 
Ingmar Schlecht
TYPO3 Association Active Member




More information about the TYPO3-dev mailing list