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!
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories
  

Viewing Issue Simple Details [ Jump to Notes ] [ Wiki ]  [ Related Changesets ] [ View Advanced ] [ Issue History ] [ Print ]
ID Category Type Reproducibility Date Submitted Last Update
0000763 [In-Portal CMS] Data Management bug report always 2010-06-08 08:30 2010-06-10 13:44
Reporter alex View Status public Project Name In-Portal CMS
Assigned To alex Developer
Priority normal Resolution fixed Fixed in Version 5.0.4-B2
Status closed Product Version 5.0.4-B1 Target Version 5.0.4
Time EstimateNo estimate
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.
Additional Information
Tags No tags attached.
Reference http://groups.google.com/group/in-portal-bugs/browse_thread/thread/501431836fae1abf
Change Log Message
Estimate Points 0
Attached Files patch file icon auto_use_temp_tables_for_products.patch [^] (1,554 bytes) 2010-06-08 08:30 [Show Content]
patch file icon auto_use_temp_tables_core.patch [^] (743 bytes) 2010-06-09 07:44 [Show Content]
patch file icon auto_use_temp_tables_modules.patch [^] (10,223 bytes) 2010-06-09 07:44 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
User avatar (0002377)
Dmitry (manager)
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
User avatar (0002390)
alex (manager)
2010-06-09 07:45

 Dmitry allowed to commit this straight away.
User avatar (0002391)
alex (manager)
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
User avatar (0002400)
alex (manager)
2010-06-10 13:44

 Closing since version 5.0.4 is released.

- Related Changesets
In-Portal CMS: 5.0.x r13689
Timestamp: 2010-06-09 07:47:09
Author: alex
[ Details ] [ Diff ] 		Fixes 0000763: Incorrect join result during product editing in administrative console
mod - /in-portal/branches/5.0.x/core/units/categories/categories_config.php [ Diff ] [ File ]
Modules :: In-News: 5.0.x r13688
Timestamp: 2010-06-09 07:46:47
Author: alex
[ Details ] [ Diff ] 		Bug 0000763: Incorrect join result during product editing in administrative console
mod - /modules/in-news/branches/5.0.x/units/articles/articles_config.php [ Diff ] [ File ]
Modules :: In-Link: 5.0.x r13687
Timestamp: 2010-06-09 07:46:36
Author: alex
[ Details ] [ Diff ] 		Bug 0000763: Incorrect join result during product editing in administrative console
mod - /modules/in-link/branches/5.0.x/units/links/links_config.php [ Diff ] [ File ]
Modules :: In-Commerce: 5.0.x r13686
Timestamp: 2010-06-09 07:46:27
Author: alex
[ Details ] [ Diff ] 		Bug 0000763: Incorrect join result during product editing in administrative console
mod - /w/in-commerce/branches/5.0.x/units/products/products_config.php [ Diff ] [ File ]
Modules :: In-Bulletin: 5.0.x r13685
Timestamp: 2010-06-09 07:46:15
Author: alex
[ Details ] [ Diff ] 		Bug 0000763: Incorrect join result during product editing in administrative console
mod - /modules/in-bulletin/branches/5.0.x/units/topics/topics_config.php [ Diff ] [ File ]

- 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

Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories
  

Web Development by Intechnic
In-Portal Open Source CMS
In-Portal Open Source CMS
Copyright © 2000 - 2009 MantisBT Group

Powered by Mantis Bugtracker