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

[ries van Twisk]

hey Ingmar,

I'll check that out...  and let you know

Ries
> 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
> _______________________________________________
> TYPO3-dev mailing list
> TYPO3-dev at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev

--
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