[TYPO3-core] RFC #9803: getTreeList causes duplicate entry sql error in cache_treelist
Christian Kuhn
lolli at schwarzbu.ch
Sat Oct 3 20:30:16 CEST 2009
This is an SVN patch request.
Type: bugfix
Bugtracker references:
http://bugs.typo3.org/view.php?id=9803
Branches: trunk
Problem:
With revision 3947 a new cache for getTreeList() was added to cache the
expensive operation of finding recursive pidlists. The test for an
existing cache entry fails if a page has no subpages:
The "select where identifier=" query returns one row and the field
treelist is an empty string. The check for "if
(!empty($cacheEntry[0]['treelist'])) {" fails, a new treelist is
calculated and the following insert to cache fails with an "Duplicate
entry" error.
Solution:
Check Select result set for 0 rows instead of empty string of "treelist"
field.
Greetings
Christian
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 9803_01.diff
Url: http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20091003/86ef6931/attachment.txt
More information about the TYPO3-team-core
mailing list