[In-Commerce] Incorrect join result during product editing in administrative console

[Alexander Obuhovich]

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.

--
Best Regards,

http://www.in-portal.com
http://www.alex-time.com

[Alexander Obuhovich]

Here is the task: http://tracker.in-portal.org/view.php?id=763

[Dmitry Andrejev]

Just to add that we have fixed some other places for Catalog items in this task too.

DA.

--
You received this message because you are subscribed to the Google Groups "In-Portal Bugs Team" group.
To post to this group, send email to in-port...@googlegroups.com.
To unsubscribe from this group, send email to in-portal-bug...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/in-portal-bugs?hl=en.