View Issue Details

IDProjectCategoryView StatusLast Update
0005840OXID eShop (all versions)4.01. Database handlingpublic2014-08-06 08:20
Reporternerd Assigned To 
PriorityhighSeveritymajorReproducibilityalways
Status closedResolutionwon't fix 
Product Version4.8.7 / 5.1.7 
Summary0005840: false dDefaultVAT vat type
DescriptiondDefaultVAT will not be stored in Database
Steps To ReproduceWhen creating new shops and set the VAT it will not be stored. I think the Problem is the wrong oxvartype (str) if you change this to num the vat is able to getting saved again.
Additional InformationTo solve the problem temporary you can execute the following mysql query.
UPDATE `oxconfig` SET `oxvartype`='num' WHERE `oxvarname`='dDefaultVAT' and oxshopid = "shopidyouhavetheproblem";
TagsNo tags attached.
Attached Files
notvat.png (9,294 bytes)   
notvat.png (9,294 bytes)   
ThemeAzure
BrowserAll
PHP Version5.3
Database Versionany

Relationships

related to 0003472 resolvedaurimas.gladutis shop calculates VAT with a komma seperated number wrong 

Activities

cesnauskast

2014-07-30 13:53

reporter   ~0010052

Reminder sent to: nerd

Hi,

Cannot reproduce this behavior - when I create new shop, the oxvartype of "dDefaultVAT" is (num), not (str).
The only thing that came up to my mind for now and could make this situation appear is that maybe database.sql file has been changed before setup process of the shop.

If you provide more information about your case, that would help a lot:
- Was database.sql file changed before setup of the shop?
- Does your main shop has any value in the field [Default VAT for all Products] in "Master Settings->Core Settings->Settings->VAT"?
- What exactly steps you are doing, when creating new shop?

nerd

2014-07-30 14:23

reporter   ~0010053

Last edited: 2014-07-30 14:24

>>Was database.sql file changed before setup of the shop?
No (if then not deliberately altered)

>>Does your main shop has any value in the field [Default VAT for all Products]
No, because typ is str and vat could not be safed but i could change and enter if needed.

>>What exactly steps you are doing, when creating new shop?
Master Settings --> Core Settings--> Create New Shop --> enter values like attached --> set shop active --> enter url under mall

if i try to enter the vat under settings --> VAT and clicking on save the field getting cleaned

Hope screenshot in german is okay (just to see the marked/filled fields)

cesnauskast

2014-07-31 15:45

reporter   ~0010057

It looks like that you are using old database, aren't you?
Because oxvartype from "str" to "num" for "dDefaultVAT" was changed with 4.8_5.1 release, because of 0003472 bug.