View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0002074||OXID eShop (all versions)||5. ------ UpdateApp / Update ------||public||2010-09-01 11:11||2011-09-05 12:20|
|Product Version||4.4.2 revision 29492|
|Target Version||Fixed in Version||4.5.3 revision 39087|
|Summary||0002074: Variants have all disappeared after Update. Only after saving the variants new in backend I can see the variants|
|Description||I've made an update from 220.127.116.11 to the 4.4.1. I used the cumulative update-version. After the update i cannot see the variants in the shop. Only when I'm saving the variants new in the shop-backend, then appears the variants in the frontend.|
|Tags||No tags attached.|
Reminder sent to: deddy
We tested the case locally, but we cannot reproduce this issue. It's possible that issue occurs because some specific circumstances.
Could you please help us to debug this case?
What would be useful - to check SQL entries of two parent-articles in oxarticles DB table:
- 1st - parent-article, which not shows the variants in frontend; and
- 2nd - parent-article which is "saved" already in admin and shows variants in frontend.
It would show the difference or data which was corrupted during upgrade.
We would appreciate your help here and feedback about the results.
||Closed as cannot reproduce.|
So sorry I've didn't reply sooner, I've had a mad week.
I've found now the difference. The oxvarcount and the oxvarminprice is null in the table oxarticles. The update didn't observed the variants.
So I need a mysql query to change this. I must count the variants and I need the min price each article.
@Developers: please check if there is a possiblity, that after upgrade from 3rd version eShop (PE 18.104.22.168) it's possible that DB fields oxvarcount and the oxvarminprice are reset to null.
I was not able to reproduce it, but it's possible, that it occurs on some specific conditions (specific product info, etc.).
Just check please, if Update is affecting these fields and how.
fixed 1.sql update script: un-commented oxminprice flied update
mail fo documentation update