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

[Dmitry Dulepov [typo3]]

Hi!

Franz Koch wrote:
> 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

This will be fixed in today's maintenance release of RealURL. It will fall back to old syntax for MySQL<4.1.0. But to you should use InnoDB for realurl tables or you may get DUPLICATE KEY errors on high traffic sites.

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