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

[ries van Twisk]

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