In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

Index: products_config.php
===================================================================
--- products_config.php	(revision 13156)
+++ products_config.php	(working copy)
@@ -366,6 +366,7 @@
 							'ParentPath'	=> TABLE_PREFIX.'Category.ParentPath',
 							'Manufacturer'	=> TABLE_PREFIX.'Manufacturers.Name',
 							'Filename' => TABLE_PREFIX.'%3$sCategoryItems.Filename',
+							'CategoryFilename' => TABLE_PREFIX.'Category.NamedParentPath',
 							'FileSize'		=>	'files.Size',
 							'FilePath'		=>	'files.FilePath',
 							'FileVersion'	=>	'files.Version',
@@ -380,6 +381,7 @@
 							'FilePath'		=>	'files.FilePath',
 							'FileVersion'	=>	'files.Version',
 							'Filename' 		=>	TABLE_PREFIX.'%3$sCategoryItems.Filename',
+							'CategoryFilename' => TABLE_PREFIX.'Category.NamedParentPath',
 						),
 					),

Index: units/products/products_config.php
===================================================================
--- units/products/products_config.php	(revision 13400)
+++ units/products/products_config.php	(working copy)
@@ -398,7 +398,8 @@
 							'CategoryId'	=> TABLE_PREFIX.'%3$sCategoryItems.CategoryId',
 							'ParentPath'	=> TABLE_PREFIX.'Category.ParentPath',
 							'Manufacturer'	=> TABLE_PREFIX.'Manufacturers.Name',
-							'Filename' => TABLE_PREFIX.'%3$sCategoryItems.Filename',
+							'Filename'		=> TABLE_PREFIX.'%3$sCategoryItems.Filename',
+							'CategoryFilename' => TABLE_PREFIX.'Category.NamedParentPath',
 							'FileSize'		=>	'files.Size',
 							'FilePath'		=>	'files.FilePath',
 							'FileVersion'	=>	'files.Version',
@@ -413,9 +414,12 @@
 							'FilePath'		=>	'files.FilePath',
 							'FileVersion'	=>	'files.Version',
 							'Filename' 		=>	TABLE_PREFIX.'%3$sCategoryItems.Filename',
+							'CategoryFilename' => TABLE_PREFIX.'Category.NamedParentPath',
 						),
 					),
 
+					'CacheModRewrite' => true,
+
 					'ListSQLs'			=>	Array (
 													''	=>	'	SELECT %1$s.* %2$s
 																FROM %1$s

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

0000585

closed (5.0.4)

alex

In-Bulletin

Calculated field "CategoryFilename" is missing for topics resulting additional database queries on topic list

Notes
(0001745) alex (manager) 2010-03-25 10:30	Won't work if we don't add 'CacheModRewrite' => true, to produts_config.php

(0001784) Dmitry (manager) 2010-04-04 22:08	Patch reviewed and tested okay.

(0002189) alex (manager) 2010-05-11 04:34	Fix committed to 5.0.x branch. Commit Message: Fixes 0000586: Calculated field "CategoryFilename" is missing for products resulting additional database queries on product list

(0002424) alex (manager) 2010-06-10 13:44	Closing since version 5.0.4 is released.

Related Changesets
Modules :: In-Commerce: 5.0.x r13538 Timestamp: 2010-05-11 04:34:20 Author: alex [ Details ] [ Diff ]	Fixes 0000586: Calculated field "CategoryFilename" is missing for products resulting additional database queries on product list
	mod - /w/in-commerce/branches/5.0.x/units/products/products_config.php	[ Diff ] [ File ]

Issue History
Date Modified	Username	Field	Change
2010-06-10 13:44	alex	Note Added: 0002424
2010-06-10 13:44	alex	Status	resolved => closed
2010-05-11 04:34	alex	Note Added: 0002189
2010-05-11 04:34	alex	Status	reviewed and tested => resolved
2010-05-11 04:34	alex	Fixed in Version	=> 5.0.4-B1
2010-05-11 04:34	alex	Resolution	open => fixed
2010-05-11 04:34	alex	Changeset attached	5.0.x r13538
2010-05-11 04:33	alex	File Added: missing_category_filename_products_v2.patch
2010-04-04 22:08	Dmitry	Note Added: 0001784
2010-04-04 22:08	Dmitry	Assigned To	Dmitry => alex
2010-04-04 22:08	Dmitry	Status	needs testing => reviewed and tested
2010-03-25 10:30	alex	Note Added: 0001745
2010-02-27 04:44	alex	Developer	=> alex
2010-02-24 05:48	alex	Relationship added	related to 0000585
2010-02-24 05:43	alex	Assigned To	=> Dmitry
2010-02-24 05:43	alex	Status	active => needs testing
2010-02-24 05:42	alex	Reference	=> http://groups.google.com/group/in-portal-bugs/browse_thread/thread/f0ec3830c440dc63
2010-02-24 05:42	alex	Target Version	=> 5.0.4
2010-02-24 05:40	alex	New Issue
2010-02-24 05:40	alex	File Added: missing_category_filename_products.patch