[TYPO3-dev] realurl: repeated MySQL error ''ON DUPLICATE KEY UPDATE'

[Franz Koch]

Hi Dmitry,

> Franz Koch wrote:
>> this is a cross posting in typo3.dev and typo3.projects.calendar, 
>> because I'm not sure what exactly is responsible for this error - 
>> seems to be realurl, but could be caused by cal.
> 
> This is not related to extension development, so "dev" is wrong. It 
> should go to "english" list.

sorry - next time then.

>> I have setup a fresh site (typo3 4.1.5) from scratch with realurl 
>> 1.2.1 (settings as always) and cal 0.17.0 (latest dev). I've setup 
>> many sites with realurl, but in this installation I get repeatedly the 
>> following SQL error message:
>>
>> ------
>> You have an error in your SQL syntax. Check the manual that 
>> corresponds to your MySQL server version for the right syntax to use 
>> near 'ON DUPLICATE KEY UPDATE tstamp=1201523887' at line 16
> 
> MySQL version is too old. Support for 4.0 has ended long time ago. The 
> query above assumes you have at least MySQL 4.1.
> 
> If you really cannot upgrade to newer MySQL, you have to switch to 
> previous RealURL versions.

unfortunately I cannot upgrade to newer MySQL version. The customer has 
webspace on a shared server (confixx stuff). But maybe I can bring the 
provider to upgrade their servers (php 4.3.1 is also kinda old :( ).

As for previous RealURL versions. I already tried 1.2.0 with the same 
effect - so I'll try 1.1.4 and older now. Thanks for your help Dmitry.

--
Greetings,
Franz