[Skip to main content](#vessel-content) # Found 2 errors (v 2.0.1) ## - **[neo191987](/forum/user/35364-neo191987 "View neo191987's Profile")** - [![neo191987's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar35364.jpg)](/forum/user/35364-neo191987 "View neo191987's Profile") Topic Author - [ Offline](/forum/user/35364-neo191987) Less More - Posts: 431 - Thank you received: 19 - - 8 years 10 months ago - 8 years 10 months ago [\#284815](#284815) by [neo191987](/forum/user/35364-neo191987 "View neo191987's Profile") *[Found 2 errors (v 2.0.1)](/forum/22-market-bug-report/893244-found-2-errors-v-2-0-1#284815 "-- HikaShop version -- : 3.2.2 -- HikaMarket version -- : 2.0.1 Hi, I found two problems. 1. Orders -> Billing address -> Edit address -> after I enter the address and click on the OK button, display the following error: Unknown column 'Array' in 'where clause' 2. Orders -> Product list -> Add new product -> If we choose a product worth about 10 euros without VAT, will be shown with an accrued Bulgarian VAT. The problem is that if I change with another VAT, the base price (the price without VAT) will be deducted and will show the value of the price with Bulgarian VAT instead of charging the indicated VAT. In my opinion, it should show the price without VAT and then charge that VAT.")* was created by *[neo191987](/forum/user/35364-neo191987 "View neo191987's Profile")* -- HikaShop version -- : 3.2.2 -- HikaMarket version -- : 2.0.1 Hi, I found two problems. 1. Orders -> Billing address -> Edit address -> after I enter the address and click on the OK button, display the following error: Unknown column 'Array' in 'where clause' 2. Orders -> Product list -> Add new product -> If we choose a product worth about 10 euros without VAT, will be shown with an accrued Bulgarian VAT. The problem is that if I change with another VAT, the base price (the price without VAT) will be deducted and will show the value of the price with Bulgarian VAT instead of charging the indicated VAT. In my opinion, it should show the price without VAT and then charge that VAT. [ ![1_2017-12-20.png](/forum/attachment/41894) ](/forum/attachment/41894 "1_2017-12-20.png") [ ![2.png](/forum/attachment/41895) ](/forum/attachment/41895 "2.png") [ ![3.png](/forum/attachment/41896) ](/forum/attachment/41896 "3.png") - [ ![1_2017-12-20.png](/forum/attachment/41894) ](/forum/attachment/41894 "1_2017-12-20.png") [ ](/forum/attachment/41894?download=1 "1_2017-12-20.png") - [ ![2.png](/forum/attachment/41895) ](/forum/attachment/41895 "2.png") [ ](/forum/attachment/41895?download=1 "2.png") - [ ![3.png](/forum/attachment/41896) ](/forum/attachment/41896 "3.png") [ ](/forum/attachment/41896?download=1 "3.png") Last edit: 8 years 10 months ago by [neo191987](/forum/user/35364-neo191987 "View neo191987's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg5MzI0NC1mb3VuZC0yLWVycm9ycy12LTItMC0xP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Away](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26400 - Thank you received: 4078 - - [](http://obsi.dev) - 8 years 10 months ago [\#284817](#284817) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Found 2 errors (v 2.0.1)](/forum/22-market-bug-report/893244-found-2-errors-v-2-0-1#284817 "-- HikaShop version -- : 3.2.2 -- HikaMarket version -- : 2.0.1 Hi, I found two problems. 1. Orders -> Billing address -> Edit address -> after I enter the address and click on the OK button, display the following error: Unknown column 'Array' in 'where clause' 2. Orders -> Product list -> Add new product -> If we choose a product worth about 10 euros without VAT, will be shown with an accrued Bulgarian VAT. The problem is that if I change with another VAT, the base price (the price without VAT) will be deducted and will show the value of the price with Bulgarian VAT instead of charging the indicated VAT. In my opinion, it should show the price without VAT and then charge that VAT.")* Hello, 1 - Thanks for the report. The problem is in the HikaShop core, for the Field class. In that file, please replace Code: public function getFilteredInput($type, &$oldData, $report = true, $varname = 'data', $force = false, $area = '') { $allCat = $this->getCategories($type, $oldData); $fields =& $this->getData($area, $type, false, $allCat); $data = $this->getInput($type, $oldData, $report, $varname, $force, $area); if(!$data) return $data; if($type== 'entry' && $area == 'frontcomp') { By Code: public function getFilteredInput($type, &$oldData, $report = true, $varname = 'data', $force = false, $area = '') { $typeName = $type; if(is_array($type)) { $typeName = $type[1]; } $allCat = $this->getCategories($typeName, $oldData); $fields =& $this->getData($area, $typeName, false, $allCat); $data = $this->getInput($type, $oldData, $report, $varname, $force, $area); if(!$data) return $data; if($typeName == 'entry' && $area == 'frontcomp') { So it will handle correctly the parameter $type when it's an array (like it is handle the in the getInput function). 2 - While in HikaShop you can modify the price, the tax value and the tax rule without any restriction ; we decided to just let you have the access to one value and let the system process the other values. So yes, we decided to let the vendor have an access to the price with tax and then deduce the price without tax and the tax value because if you change the tax rate, the price that the customer paid stay the same. Now you can still perform a view override in order to change the way that it's processed. It is purely some hidden fields and some javascript (which read the tax rate dynamically) ; there is no web-service call so all is in the view. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. The following user(s) said Thank You: [neo191987](/forum/user/35364-neo191987 "View neo191987's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg5MzI0NC1mb3VuZC0yLWVycm9ycy12LTItMC0xP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? Moderators: [Obsidev](/forum/user/7040-obsidev "View Obsidev's Profile") [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.051 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)