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!

Relationship Graph View Issue ] Dependency Graph ]
related to child of duplicate of

Viewing Issue Simple Details
ID Category Type Reproducibility Date Submitted Last Update
0000578 [In-Portal CMS] Data Management bug report always 2010-02-11 10:40 2010-05-11 03:00
Reporter alex View Status public  
Assigned To alex
Priority normal Resolution fixed  
Status closed      
Summary 0000578: Foreign key update problem in temp handler
Description There is foreign key update problem in temp handler. When you create sub-item record in temp table, then kDBItem::setTempID() method is called and temporary (negative) ID is assigned to that item. This is done to prevent ID conflicts, when record will be copied to live table later. When that subitem has it's own sub item, then temporary ID is populated to it as well. Later, when data is copied to live table all temporary IDs in all related tables are replaced with live IDs.

product (top item) <- product option (sub item) <- product option value

Here sub-sub-item gets incorrect IDs of sub item. However there is bug during foreign key (related temporary IDs) replacement code, when in case if subitem doesn't have ForeignKey (that's product option combinations in in-commerce), then all other subitems are not processed resulting temporary ID is copied intact in live table.
Additional Information

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

Powered by Mantis Bugtracker