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!

Viewing Issue Simple Details [ Jump to Notes ] [ Wiki ] [ Related Changesets ]

[ View Advanced ] [ Issue History ] [ Print ]

Tags

No tags attached.

Reference

http://groups.google.com/group/in-portal-bugs/browse_thread/thread/5bafcae12df7e077

Change Log Message

Fixes issue with exporting category items (ie. Links)

Estimate Points

Attached Files

Issues-with-Exporting-Category-Items-MODULES.patch [^] (6,499 bytes) 2010-11-30 11:51 [Show Content]

Index: in-bulletin/units/topics/topics_config.php
===================================================================
--- in-bulletin/units/topics/topics_config.php	(revision 14094)
+++ in-bulletin/units/topics/topics_config.php	(working copy)
@@ -390,7 +390,7 @@
 			            	'left_key_field' => 'PortalUserId',
 			            	'left_title_field' => 'Login',
 			            	'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'),
-			            	'required' => 1, 'default' => NULL,
+			            	'sample_value' => 'Guest', 'required' => 1, 'default' => NULL,
 						),
 			            'ModifiedById'			=> Array (
 			            	'type' => 'int',
Index: in-commerce/units/products/products_config.php
===================================================================
--- in-commerce/units/products/products_config.php	(revision 14094)
+++ in-commerce/units/products/products_config.php	(working copy)
@@ -493,7 +493,17 @@
 					    'Type'					=>	Array ('type' => 'int', 'not_null' => 1, 'formatter' => 'kOptionsFormatter', 'use_phrases' => 1, 'options' =>Array (1=> 'la_product_tangible',  2=> 'la_product_subscription', 4=> 'la_product_downloadable', 3=> 'la_product_service'/*, 6=> 'la_gift_certificate', 5=> 'la_product_package'*/), 'not_null' => 1, 'default' => 1 ),
 					    'Modified'				=>	Array ('type' => 'int', 'formatter' => 'kDateFormatter', 'default' => '#NOW#'),
 					    'ModifiedById'			=>	Array ('type' => 'int', 'default' => NULL),
-					    'CreatedById'			=>	Array ('type' => 'int', 'required' => 1, 'default' => NULL),
+					    'CreatedById' => Array (
+			            	'type' => 'int',
+			            	'formatter' => 'kLEFTFormatter', 
+			            	'options' => Array (USER_ROOT => 'root', USER_GUEST => 'Guest'),
+			            	'left_sql' => 'SELECT %s FROM ' . TABLE_PREFIX . 'PortalUser 
+			            					WHERE `%s` = \'%s\'',
+			            	'left_key_field' => 'PortalUserId',
+			            	'left_title_field' => 'Login',
+							'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'),
+			            	'sample_value' => 'Guest', 'required' => 1, 'default' => NULL,
+						),
 					    'ResourceId'			=>	Array ('type' => 'int', 'default' => null),
 					    'CachedReviewsQty'		=>	Array ('type' => 'int', 'formatter' => 'kFormatter', 'format' => '%d', 'not_null' => 1, 'default' => 0),
 					    'InventoryStatus' => Array ('type' => 'int', 'formatter' => 'kOptionsFormatter', 'options' => Array (0 => 'la_Disabled', 1 => 'la_by_product', 2 => 'la_by_options'), 'use_phrases' => 1, 'not_null' => 1, 'default' => 0),
Index: in-link/units/links/links_config.php
===================================================================
--- in-link/units/links/links_config.php	(revision 14094)
+++ in-link/units/links/links_config.php	(working copy)
@@ -463,7 +463,17 @@
 			            'CachedRating'		=>	Array ('type' => 'string', 'not_null' => 1, 'formatter' => 'kFormatter', 'default' => 0),
 			            'CachedVotesQty'	=>	Array ('type' => 'int', 'formatter' => 'kFormatter', 'not_null' => 1, 'default' => 0),
 			            'CachedReviewsQty'	=>	Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
-			            'CreatedById'		=>	Array ('type' => 'int', 'formatter' => 'kLEFTFormatter', 'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'), 'options' => Array (USER_ROOT => 'root', USER_GUEST => 'Guest'), 'left_sql' => 'SELECT %s FROM '.TABLE_PREFIX.'PortalUser WHERE `%s` = \'%s\'', 'left_key_field' => 'PortalUserId', 'left_title_field' => 'Login', 'required' => 1, 'default' => NULL),
+			            'CreatedById' => Array (
+			            	'type' => 'int',
+			            	'formatter' => 'kLEFTFormatter', 
+			            	'options' => Array (USER_ROOT => 'root', USER_GUEST => 'Guest'),
+			            	'left_sql' => 'SELECT %s FROM ' . TABLE_PREFIX . 'PortalUser 
+			            					WHERE `%s` = \'%s\'',
+			            	'left_key_field' => 'PortalUserId',
+			            	'left_title_field' => 'Login',
+							'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'),
+			            	'sample_value' => 'Guest', 'required' => 1, 'default' => NULL,
+						),			
 			            'ModifiedById'		=>	Array ('type' => 'int', 'formatter' => 'kLEFTFormatter', 'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'), 'options' => Array (USER_ROOT => 'root', USER_GUEST => 'Guest'), 'left_sql' => 'SELECT %s FROM '.TABLE_PREFIX.'PortalUser WHERE `%s` = \'%s\'', 'left_key_field' => 'PortalUserId', 'left_title_field' => 'Login', 'default' => NULL),
 			            'Priority'			=>	Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
 			            'Status'			=>	Array (
Index: in-news/units/articles/articles_config.php
===================================================================
--- in-news/units/articles/articles_config.php	(revision 14094)
+++ in-news/units/articles/articles_config.php	(working copy)
@@ -395,7 +395,17 @@
 			            'Hits'				=>	Array ('type' => 'double', 'formatter' => 'kFormatter', 'format' => '%d', 'not_null' => 1, 'default' => 0),
 			            'CachedRating'		=>	Array ('type' => 'string', 'default' => 0),
 			            'CachedVotesQty'	=>	Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
-			            'CreatedById' 		=>	Array ('type' => 'int', 'formatter' => 'kLEFTFormatter', 'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'), 'options' => Array (USER_ROOT => 'root', USER_GUEST => 'Guest'), 'left_sql' => 'SELECT %s FROM '.TABLE_PREFIX.'PortalUser WHERE `%s` = \'%s\'', 'left_key_field' => 'PortalUserId', 'left_title_field' => 'Login', 'required' => 1, 'default' => NULL),
+			            'CreatedById' => Array (
+			            	'type' => 'int',
+			            	'formatter' => 'kLEFTFormatter', 
+			            	'options' => Array (USER_ROOT => 'root', USER_GUEST => 'Guest'),
+			            	'left_sql' => 'SELECT %s FROM ' . TABLE_PREFIX . 'PortalUser 
+			            					WHERE `%s` = \'%s\'',
+			            	'left_key_field' => 'PortalUserId',
+			            	'left_title_field' => 'Login',
+							'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'),
+			            	'sample_value' => 'Guest', 'required' => 1, 'default' => NULL,
+						),
 			            'Priority'			=>	Array ('type' => 'int', 'not_null' => 1, 'default' => 0),
 			            'Status'			=>	Array (
 			            	'type' => 'int',

Relationships [ Relation Graph ] [ Dependency Graph ]

child of

0000845

closed (5.1.1)

Dmitry

Revising usage of NULL columns

Notes
(0003162) alex (manager) 2011-01-05 06:08	ok

(0003163) alex (manager) 2011-01-05 06:10	Fix committed to 5.1.x branch. Commit Message: Fixes 0000937: Issues with Exporting Category Items Commit on behalf of Dmitry

(0003357) Dmitry (manager) 2011-03-30 09:53	Closing, since 5.1.2 release has been released.

Related Changesets
Modules :: In-News: 5.1.x r14123 Timestamp: 2011-01-05 06:10:21 Author: alex [ Details ] [ Diff ]	Fixes 0000937: Issues with Exporting Category Items Commit on behalf of Dmitry
	mod - /modules/in-news/branches/5.1.x/units/articles/articles_config.php	[ Diff ] [ File ]

Modules :: In-Link: 5.1.x r14122 Timestamp: 2011-01-05 06:10:06 Author: alex [ Details ] [ Diff ]	Bug 0000937: Issues with Exporting Category Items Commit on behalf of Dmitry
	mod - /modules/in-link/branches/5.1.x/units/links/links_config.php	[ Diff ] [ File ]

Modules :: In-Commerce: 5.1.x r14121 Timestamp: 2011-01-05 06:09:50 Author: alex [ Details ] [ Diff ]	Bug 0000937: Issues with Exporting Category Items Commit on behalf of Dmitry
	mod - /w/in-commerce/branches/5.1.x/units/products/products_config.php	[ Diff ] [ File ]

Modules :: In-Bulletin: 5.1.x r14120 Timestamp: 2011-01-05 06:09:30 Author: alex [ Details ] [ Diff ]	Bug 0000937: Issues with Exporting Category Items Commit on behalf of Dmitry
	mod - /modules/in-bulletin/branches/5.1.x/units/topics/topics_config.php	[ Diff ] [ File ]

Issue History
Date Modified	Username	Field	Change
2011-03-30 09:53	Dmitry	Note Added: 0003357
2011-03-30 09:53	Dmitry	Status	resolved => closed
2011-01-05 06:10	alex	Note Added: 0003163
2011-01-05 06:10	alex	Status	reviewed and tested => resolved
2011-01-05 06:10	alex	Fixed in Version	=> 5.1.2-B1
2011-01-05 06:10	alex	Resolution	open => fixed
2011-01-05 06:10	alex	Assigned To	!COMMUNITY => alex
2011-01-05 06:10	alex	Changeset attached	5.1.x r14123
2011-01-05 06:10	alex	Changeset attached	5.1.x r14122
2011-01-05 06:09	alex	Changeset attached	5.1.x r14121
2011-01-05 06:09	alex	Changeset attached	5.1.x r14120
2011-01-05 06:08	alex	Note Added: 0003162
2011-01-05 06:08	alex	Status	needs testing => reviewed and tested
2010-11-30 11:54	Dmitry	Relationship added	child of 0000845
2010-11-30 11:51	Dmitry	Assigned To	=> !COMMUNITY
2010-11-30 11:51	Dmitry	Developer	=> Dmitry
2010-11-30 11:51	Dmitry	Status	active => needs testing
2010-11-30 11:51	Dmitry	New Issue
2010-11-30 11:51	Dmitry	File Added: Issues-with-Exporting-Category-Items-MODULES.patch
2010-11-30 11:51	Dmitry	Reference	=> http://groups.google.com/group/in-portal-bugs/browse_thread/thread/5bafcae12df7e077
2010-11-30 11:51	Dmitry	Change Log Message	=> Fixes issue with exporting category items (ie. Links)

Web Development by Intechnic

In-Portal Open Source CMS