Bug #17147
closedDuplicate entry on cache_pagesection
0%
Description
I am recieving the following error when clicking the same menu item several times.
caller t3lib_DB::exec_INSERTquery
ERROR Duplicate entry '7-222419149' for key 1
lastBuiltQuery INSERT INTO cache_pagesection
(
content,
tstamp,
page_id,
mpvar_hash
) VALUES (
'a:4:{s:3:\"all\";a:3:{s:32:\"338e394457c2db162483324451f05ded\";s:23:\"[compatVersion = 3.9.0]\";s:32:\"41428859d35690400a615c4ebfa39dc3\";s:15:\"[loginUser = *]\";s:32:\"bda496bca03246a2cfe01bea2c18e731\";s:20:\"[globalVar = GP:L=1]\";}s:6:\"rowSum\";a:12:{i:0;a:3:{i:0;s:1:\"1\";i:1;s:8:\"Defaults\";i:2;s:10:\"1174585243\";}i:1;a:3:{i:0;s:24:\"cssstyledcontent/static/\";i:1;s:30:\"EXT:css_styled_content/static/\";i:2;N;}i:2;a:3:{i:0;s:20:\"ttnews/static/tsnew/\";i:1;s:26:\"EXT:tt_news/static/ts_new/\";i:2;N;}i:3;a:3:{i:0;s:19:\"nhttnewszip/static/\";i:1;s:25:\"EXT:nh_ttnews_zip/static/\";i:2;N;}i:4;a:3:{i:0;s:17:\"nhcontswf/static/\";i:1;s:23:\"EXT:nh_cont_swf/static/\";i:2;N;}i:5;a:3:{i:0;s:10:\"lastupdate\";i:1;s:10:\"lastupdate\";i:2;N;}i:6;a:3:{i:0;s:13:\"wecdiscussion\";i:1;s:14:\"wec_discussion\";i:2;N;}i:7;a:3:{i:0;s:11:\"aahbookplus\";i:1;s:12:\"aahbook_plus\";i:2;N;}i:8;a:3:{i:0;s:9:\"srfreecap\";i:1;s:10:\"sr_freecap\";i:2;N;}i:9;a:3:{i:0;s:9:\"jmgallery\";i:1;s:10:\"jm_gallery\";i:2;N;}i:10;a:3:{i:0;s:15:\"mcgooglesitemap\";i:1;s:16:\"mc_googlesitemap\";i:2;N;}i:11;a:3:{i:0;s:9:\"ttaddress\";i:1;s:10:\"tt_address\";i:2;N;}}s:5:\"match\";a:1:{s:32:\"338e394457c2db162483324451f05ded\";s:23:\"[compatVersion = 3.9.0]\";}s:8:\"rootLine\";a:2:{i:0;a:28:{s:3:\"pid\";s:1:\"0\";s:3:\"uid\";s:1:\"1\";s:9:\"t3ver_oid\";s:1:\"0\";s:10:\"t3ver_wsid\";s:1:\"0\";s:11:\"t3ver_state\";s:1:\"0\";s:14:\"t3ver_swapmode\";s:1:\"0\";s:5:\"title\";s:17:\"www.chaosbutze.de\";s:5:\"alias\";s:0:\"\";s:9:\"nav_title\";s:0:\"\";s:5:\"media\";s:0:\"\";s:6:\"layout\";s:1:\"0\";s:6:\"hidden\";s:1:\"0\";s:9:\"starttime\";s:1:\"0\";s:7:\"endtime\";s:1:\"0\";s:8:\"fe_group\";s:0:\"\";s:16:\"extendToSubpages\";s:1:\"0\";s:7:\"doktype\";s:1:\"4\";s:8:\"TSconfig\";s:507:\"RTE.classes {\r\n codebox {\r\n name = CodeBox\r\n value=background:grey;\r\n }\r\n}\r\n\r\nRTE.default {\r\n inlineStyle.frames (\r\n p.codebox {\r\n font-size:10px;\r\n font-family:courier;\r\n border:1px solid #cccccc;\r\n background-color:#dedede;\r\n padding:10px;\r\n color:#464646; \r\n }\r\n )\r\n \r\n proc {\r\n dontHSC_rte = 1\r\n dontUndoHSC_db = 1\r\n allowedClasses=codebox \r\n } \r\n \r\n classesParagraph (\r\n codebox\r\n )\r\n ignoreMainStyleOverride=0\r\n}\r\n\r\n\";s:11:\"storage_pid\";s:1:\"8\";s:11:\"is_siteroot\";s:1:\"0\";s:9:\"mount_pid\";s:1:\"0\";s:12:\"mount_pid_ol\";s:1:\"0\";s:13:\"fe_login_mode\";s:1:\"0\";s:17:\"tx_templavoila_ds\";s:1:\"1\";s:17:\"tx_templavoila_to\";s:1:\"1\";s:22:\"tx_templavoila_next_ds\";s:1:\"1\";s:22:\"tx_templavoila_next_to\";s:1:\"1\";s:22:\"tx_realurl_pathsegment\";s:0:\"\";}i:1;a:28:{s:3:\"pid\";s:1:\"1\";s:3:\"uid\";s:1:\"7\";s:9:\"t3ver_oid\";s:1:\"0\";s:10:\"t3ver_wsid\";s:1:\"0\";s:11:\"t3ver_state\";s:1:\"0\";s:14:\"t3ver_swapmode\";s:1:\"0\";s:5:\"title\";s:4:\"Home\";s:5:\"alias\";s:0:\"\";s:9:\"nav_title\";s:0:\"\";s:5:\"media\";s:0:\"\";s:6:\"layout\";s:1:\"0\";s:6:\"hidden\";s:1:\"0\";s:9:\"starttime\";s:1:\"0\";s:7:\"endtime\";s:1:\"0\";s:8:\"fe_group\";s:1:\"0\";s:16:\"extendToSubpages\";s:1:\"0\";s:7:\"doktype\";s:1:\"1\";s:8:\"TSconfig\";s:0:\"\";s:11:\"storage_pid\";s:1:\"0\";s:11:\"is_siteroot\";s:1:\"0\";s:9:\"mount_pid\";s:1:\"0\";s:12:\"mount_pid_ol\";s:1:\"0\";s:13:\"fe_login_mode\";s:1:\"0\";s:17:\"tx_templavoila_ds\";s:0:\"\";s:17:\"tx_templavoila_to\";s:1:\"0\";s:22:\"tx_templavoila_next_ds\";s:0:\"\";s:22:\"tx_templavoila_next_to\";s:1:\"0\";s:22:\"tx_realurl_pathsegment\";s:0:\"\";}}}',
'1174641147',
'7',
'222419149'
)
debug_backtrace require // tslib_fe->getConfigArray // t3lib_TStemplate->start // t3lib_DB->exec_INSERTquery // t3lib_DB->debug
(issue imported from #M5282)
Updated by Nikolas Hagelstein over 17 years ago
This seems to happen as soon as a plugin is placed that sets $this->pi_USER_INT_obj = 0;
Updated by Michael Stucki over 17 years ago
There are related entries to that one, please search the archive (also search for closed issues). We discussed this very short before 4.1, and I thought it was fixed...?
Updated by Georg Ringer over 17 years ago
I also get it in a 4.0.3 installation, very seldom but I do get it
Updated by Nikolas Hagelstein over 17 years ago
Michael: The bugtracker says it should have been fixed in 4.1 but obviously it is not :). NOTE: i am not using frames. For a live sample see www.chaosbutze.de and hit the home menu item several times. I does not occurs on pages that do not contain any userint obj.
Updated by Jonas Felix over 17 years ago
I get the same error with 4.1.1. You can only see this if you have sql debug enabled...
Updated by Michael Stucki over 17 years ago
It seems there are two bugs describing the same problem. I just close one of them...