| Niranjan Soni 2005-11-01, 6:23 pm |
| Hi All
I am currently carrying out DB migration from a 5.1 to 5.6. I ran the db
migration script with precheck option and i got a error which is as follows.
[2005.11.01 17:19:00] Info : select count(*) from catentry where
(catenttype_id = 'ItemBean' or catenttype_id = 'PackageBean') and ((select
count(catentry_id_parent) from catentrel where catreltype_id='PRODUCT_ITEM'
and catentry_id_child = catentry_id) > 1)
[2005.11.01 17:19:00] Error: [404] You have some items with more than one
parent products. Each item can have only one parent product. You need to
delete all others.
I understand the reason for this error our 5.1 catalogue is unstructured (in
5.6 terms). What i like do now is to find out the items that have more than
one parent product. Does anybody know a sql that i can run to find out these
items, i tried working through the above sql but cann't understand it
completly (not good at sql  ).
Any help or ideas are welcome.
Thanks
Niranjan
|