[ic] UI item delete

[Chen Naor]

Mike Heins wrote:
> Quoting Chen Naor (chen at lilux.co.il):
>>> Hi,
>>> IC 5.0 + Pg 7.4.1
>>>
>>> It seems that delete item delete then items from: products, pricing,
>>> inventory, merchandising, options,
>>> but if there is a matrix options using variants (variants table) it
>>> is left undeleted.
>>> Is it a feature problem, configuration problem or a bug?
>>
>> OK , I did some research.
>> I addede to variable table the following:
>> UI_ITEM_TABLES  products pricing inventory merchandising options:sku
>> variants:sku When deleteing a product I get the following error:
>>
>> Deleted GAIL from products
>> Deleted GAIL from merchandising
>> deleted 2 records from options where sku = 'GAIL'
>> db_maintenance:
>> No records in variants where sku = '''GAIL'''
>>
>>
>> If I change the order of the tables in UI_ITEM_TABLES  the error is
>>
>> db_maintenance:
>> No records in options where sku = '''GAIL'''
>>
>> Any ideas?
>
> It's a bug. Try this patch to lib/UI/profiles/db_maintenance:
>
> --- /DU/profiles/db_maintenance 2003-01-13 17:31:12.000000000 -0500
> +++ /du/profiles/db_maintenance 2004-03-14 10:24:28.000000000 -0500
> @@ -137,15 +137,15 @@
>   }
>   if($col) {
>   next unless length ($key);
> - $key = $db->quote($key, $col);
> - my $num = $db->query("delete from $t where $col = $key");
> + my $k = $db->quote($key, $col);
> + my $num = $db->query("delete from $t where $col = $k");
>   if($num > 0) {
>   push @out, errmsg(
>   "deleted %s records from %s where %s = %s",
>   $num,
>   $t,
>   $col,
> - $key,
> + $k,
>   );
>   }
>   else {
> @@ -153,7 +153,7 @@
>   "No records in %s where %s = %s",
>   $t,
>   $col,
> - $key,
> + $k,
>   );
>   }
>   }

Hi Mike,
I added the patch but it has no effect.
But I think it is something with the files in the lib/UI/profiles directory.
It looks like the changes I made did not take effect.
I few weeks ago I changed the file lib/UI/profiles/recompute_transaction to make some extra
calculations & had the same results -> no effect.
Were & when those file are activated?
Maybe it is something with the compilation?
I made the changes in 2 servers one installed from RPM and the other one from TGZ (IC5.0).
After the changes I restart IC.
In both is the same results -> no effect.
Have a look if you can :-),
thanks
Chen Naor