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

[Dmitry Dulepov [typo3]]

Hi Franz!

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.

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

-- 
Dmitry Dulepov
TYPO3 core team
Web: http://typo3bloke.net/
Skype: callto:liels_bugs
"Nothing is impossible. There are only limits to our knowledge"