View Issue Details

IDProjectCategoryView StatusLast Update
0000319OXID eShop (all versions)4.07. Source code, Testpublic2012-12-10 13:45
Reportersarunas_valaskevicius Assigned To 
PriorityurgentSeveritycrashReproducibilityalways
Status resolvedResolutionfixed 
Fixed in Version4.0.0.0 revision 13895 
Summary0000319: update possibly wrong
DescriptionALTER TABLE `oxorderarticles` ADD COLUMN `OXVATPRICE` double NOT NULL DEFAULT '0' AFTER `OXBRUTPRICE`;
...
ALTER TABLE `oxorderarticles` DROP COLUMN `OXTOTALVAT`;

and there is no filling of newly created OXVATPRICE, and after droping OXTOTALVAT we loose info. check if this is correct:

OXVATPRICE = OXTOTALVAT / artcnt;

(if yes, then fix update.sql)
TagsNo tags attached.
Theme
BrowserAll
PHP Version5.2.6
Database Version5.0.33

Activities

vilma_liorensaityte

2008-10-22 11:42

reporter   ~0000191

At the moment oxvatprice is without discounts, so teh solution is:

`OXVATPRICE`=`OXBRUTPRICE`-`OXNETPRICE`