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

Martin Kutschker Martin.Kutschker at n0spam-blackbox.net
Wed Feb 6 17:53:54 CET 2008


Dmitry Dulepov [typo3] schrieb:
> 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.

Fine. But did you consider switching to another key if tstamp is not fine 
grained enough? Depending on the application/traffic time in seconds is not 
a good choice.

Masi




More information about the TYPO3-dev mailing list