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

[ries van Twisk]

On Feb 6, 2008, at 11:22 AM, Dmitry Dulepov [typo3] wrote:

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


Hey Dmitry,

I have read/hear about t3_lock class.
Now for MySAL tables types would it be possible to use that class?  
it's an ackward solution but just an idea....

Ries