View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0005840 | OXID eShop (all versions) | 4.01. Database handling | public | 2014-07-30 08:58 | 2014-08-06 08:20 |
Reporter | nerd | Assigned To | |||
Priority | high | Severity | major | Reproducibility | always |
Status | closed | Resolution | won't fix | ||
Product Version | 4.8.7 / 5.1.7 | ||||
Summary | 0005840: false dDefaultVAT vat type | ||||
Description | dDefaultVAT will not be stored in Database | ||||
Steps To Reproduce | When 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 Information | To solve the problem temporary you can execute the following mysql query. UPDATE `oxconfig` SET `oxvartype`='num' WHERE `oxvarname`='dDefaultVAT' and oxshopid = "shopidyouhavetheproblem"; | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Theme | Azure | ||||
Browser | All | ||||
PHP Version | 5.3 | ||||
Database Version | any | ||||
related to | 0003472 | resolved | aurimas.gladutis | shop calculates VAT with a komma seperated number wrong |
|
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? |
|
>>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) |
|
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. |