[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