Project

General

Profile

Actions

Bug #17147

closed

Duplicate entry on cache_pagesection

Added by Nikolas Hagelstein over 17 years ago. Updated over 16 years ago.

Status:
Closed
Priority:
Should have
Category:
Communication
Target version:
-
Start date:
2007-03-23
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.1
PHP Version:
5.1
Tags:
Complexity:
Is Regression:
Sprint Focus:

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)


Related issues 2 (0 open2 closed)

Is duplicate of TYPO3 Core - Bug #16751: Duplicate entry on cache_pagesection on reloading twiceClosedMichael Stucki2006-11-29

Actions
Is duplicate of TYPO3 Core - Bug #17088: "Duplicate entry" in cache_pagesection when using framesClosedMichael Stucki2007-03-07

Actions
Actions #1

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;

Actions #2

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

Actions #3

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

Actions #4

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.

Actions #5

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

Actions #6

Updated by Michael Stucki over 17 years ago

It seems there are two bugs describing the same problem. I just close one of them...

Actions

Also available in: Atom PDF