In-Portal Issue Tracker - In-Portal CMS
Viewing Issue Advanced Details
ID: Category: Type: Reproducibility: Date Submitted: Last Update:
763 [In-Portal CMS] Data Management bug report always 2010-06-08 08:30 2010-06-10 13:44
Reporter: alex Platform:  
Assigned To: alex OS:  
Priority: normal OS Version:  
Status: closed Product Version: 5.0.4-B1  
Product Build: Resolution: fixed  
 
ETA: none Fixed in Version: 5.0.4-B2  
Reference: http://groups.google.com/group/in-portal-bugs/browse_thread/thread/501431836fae1abf
Change Log Message:
Estimate Points: 0
Summary: 0000763: Incorrect join result during product editing in administrative console
Description: We have LEFT JOIN to product pricing and other product-related tables in it's loading SQL. Problem is, that most of them are referring to Live tables, while actual data is being changed in temp tables.

To fix that I propose to place "%3$s" (after TABLE_PREFIX) in join clause. This will automatically add temp table name, when they are used. This should not prevent product from being displayed on front-end.
Steps To Reproduce:
Additional Information:
Relationships
Attached Files: patch auto_use_temp_tables_for_products.patch (1,554) 2010-06-08 08:30
http://tracker.in-portal.org/file_download.php?file_id=617&type=bug
patch auto_use_temp_tables_core.patch (743) 2010-06-09 07:44
http://tracker.in-portal.org/file_download.php?file_id=627&type=bug
patch auto_use_temp_tables_modules.patch (10,223) 2010-06-09 07:44
http://tracker.in-portal.org/file_download.php?file_id=628&type=bug
Issue History
Date Modified Username Field Change
2010-06-10 13:44 alex Note Added: 0002400
2010-06-10 13:44 alex Status resolved => closed
2010-06-09 07:47 alex Note Added: 0002391
2010-06-09 07:47 alex Status reviewed and tested => resolved
2010-06-09 07:47 alex Fixed in Version => 5.0.4-B2
2010-06-09 07:47 alex Resolution open => fixed
2010-06-09 07:47 alex Assigned To !COMMUNITY => alex
2010-06-09 07:47 alex Changeset attached 5.0.x r13689
2010-06-09 07:46 alex Changeset attached 5.0.x r13688
2010-06-09 07:46 alex Changeset attached 5.0.x r13687
2010-06-09 07:46 alex Changeset attached 5.0.x r13686
2010-06-09 07:46 alex Changeset attached 5.0.x r13685
2010-06-09 07:45 alex Note Added: 0002390
2010-06-09 07:45 alex Status needs testing => reviewed and tested
2010-06-09 07:45 alex Assigned To alex => !COMMUNITY
2010-06-09 07:45 alex Status needs work => needs testing
2010-06-09 07:45 alex Project In-Commerce => In-Portal CMS
2010-06-09 07:44 alex File Added: auto_use_temp_tables_modules.patch
2010-06-09 07:44 alex File Added: auto_use_temp_tables_core.patch
2010-06-08 22:31 Dmitry Note Added: 0002377
2010-06-08 22:31 Dmitry Assigned To Dmitry => alex
2010-06-08 22:31 Dmitry Status needs testing => needs work
2010-06-08 08:30 alex Assigned To => Dmitry
2010-06-08 08:30 alex Developer => alex
2010-06-08 08:30 alex Status active => needs testing
2010-06-08 08:30 alex New Issue
2010-06-08 08:30 alex File Added: auto_use_temp_tables_for_products.patch
2010-06-08 08:30 alex Reference => http://groups.google.com/group/in-portal-bugs/browse_thread/thread/501431836fae1abf

Notes
(0002377)
Dmitry   
2010-06-08 22:31   
Tested good for Products, but the same issue for Links. Please do links and check other Catalog element and commit the task.

LEFT JOIN '.TABLE_PREFIX.'Images img ON img.ResourceId = %1$s.ResourceId AND img.DefaultImg = 1
(0002390)
alex   
2010-06-09 07:45   
Dmitry allowed to commit this straight away.
(0002391)
alex   
2010-06-09 07:47   
Fix committed to 5.0.x branch. Commit Message:

Fixes 0000763: Incorrect join result during product editing in administrative console
(0002400)
alex   
2010-06-10 13:44   
Closing since version 5.0.4 is released.