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

[Franz Koch]

Hi list,

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.

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

lastBuiltQuery:

INSERT INTO tx_realurl_urlencodecache
(
url_hash,
origparams,
internalExtras,
content,
page_id,
tstamp
) VALUES (
'22900e36799bc1101fff8ade1185d2d3',
'id=46&tx_cal_controller[type]=tx_cal_phpicalendar&tx_cal_controller[view]=month&tx_cal_controller[uid]=11&cHash=2d1e6bcfd8',
'',
'veranstaltungen/holy-hour.html?tx_cal_controller%5Btype%5D=tx_cal_phpicalendar&tx_cal_controller%5Bview%5D=month&tx_cal_controller%5Buid%5D=11&cHash=2d1e6bcfd8',
'46',
'1201523887'
) ON DUPLICATE KEY UPDATE tstamp=1201523887
-------

This message occurs on every single view of a cal record, and I don't 
know why exactly. The db seems to be ok (no fields missing) and 
everything else is quite fine. Only this error message occurs - and also 
only if NO backend login is available.

Also strange is, that the generated url in this  error message is for a 
month view, but I don't use any month views on the whole website.

Another strange thing is, that the urldecode- and urlencode caches don't 
get filled, although they are activated in the realurl config (manually 
configures). The only table that is filled currently is pathcache.

What could be the reason? SQL version (currently 4.0.24)? PHP (which I 
don't think)? Or probably the server is a bit to slow that two 
concurrent queries get performed?

Any help is really welcome. I had to deactivate realurl for now.

--
Thanks in advance,
Franz