Imported from: http://groups.google.com/group/in-portal-bugs/browse_thread/thread/f2de5b5b5c9fbebb#
There is foreign key update problem in temp handler. When you create
subcreate sub-item record in temp table, then kDBItem::setTempID() method is called
and called and temporary (negative) ID is assigned to that item. This is done to
prevent to prevent ID conflicts, when record will be copied to live table later. When
that When that subitem has it's own sub item, then temporary ID is populated to it as
wellas well. Later, when data is copied to live table all temporary IDs in all
related all related tables are replaced with live IDs.
| No Format |
|---|
...
product (top item) <- product option (sub item) <- product option value |
...
(sub-sub-item) |
...
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.
--
Best Regards,
http://www.in-portal.com
http://www.alex-time.com
foreign_key_update_problem.patch
Related Tasks
| Jira Legacy | ||||||
|---|---|---|---|---|---|---|
|