[Skip to main content](#vessel-content) # Hikashop down after update ## - **[altitude](/forum/user/26150-altitude "View altitude's Profile")** - [![altitude's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/26150-altitude "View altitude's Profile") Topic Author - [ Offline](/forum/user/26150-altitude) Less More - Posts: 2 - Thank you received: 0 - - 12 years 7 months ago [\#147234](#147234) by [altitude](/forum/user/26150-altitude "View altitude's Profile") *[Hikashop down after update](/forum/25-install-update/866447-hikashop-down-after-update#147234 "-- url of the page with the problem -- : altitude-imageworx.ch/index.php/en/be-steady/online-shop-en -- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.2.3 -- PHP version -- : 5.4.24 -- Browser(s) name and version -- : Safari and or Firefox newest -- Error-message(debug-mod must be tuned on) -- : During update the update process stopped, and i now get the following message. Does anyone have a tip to help me her? Thanks Error_message: 1054 - Unknown column 'b.taxation_date_start' in 'where clause' SQL=SELECT b.*,c.* FROM j30ai_hikashop_category AS a LEFT JOIN j30ai_hikashop_taxation AS b ON a.category_namekey=b.category_namekey LEFT JOIN j30ai_hikashop_tax AS c ON b.tax_namekey=c.tax_namekey WHERE a.category_id = 12 AND b.taxation_published=1 AND ( taxation_type = '' OR taxation_type = 'company_with_vat_number' ) AND b.taxation_date_start 1394183163)")* was created by *[altitude](/forum/user/26150-altitude "View altitude's Profile")* -- url of the page with the problem -- : [ altitude-imageworx.ch/index.php/en/be-steady/online-shop-en](http://altitude-imageworx.ch/index.php/en/be-steady/online-shop-en) -- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.2.3 -- PHP version -- : 5.4.24 -- Browser(s) name and version -- : Safari and or Firefox newest -- Error-message(debug-mod must be tuned on) -- : During update the update process stopped, and i now get the following message. Does anyone have a tip to help me her? Thanks Error_message: 1054 - Unknown column 'b.taxation_date_start' in 'where clause' SQL=SELECT b.*,c.* FROM j30ai_hikashop_category AS a LEFT JOIN j30ai_hikashop_taxation AS b ON a.category_namekey=b.category_namekey LEFT JOIN j30ai_hikashop_tax AS c ON b.tax_namekey=c.tax_namekey WHERE a.category_id = 12 AND b.taxation_published=1 AND ( taxation_type = '' OR taxation_type = 'company_with_vat_number' ) AND b.taxation_date_start <= 1394183163 AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1394183163) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NjQ0Ny1oaWthc2hvcC1kb3duLWFmdGVyLXVwZGF0ZT90bXBsPW1hcmtkb3du) 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") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 12 years 7 months ago [\#147236](#147236) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Hikashop down after update](/forum/25-install-update/866447-hikashop-down-after-update#147236 "-- url of the page with the problem -- : altitude-imageworx.ch/index.php/en/be-steady/online-shop-en -- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.2.3 -- PHP version -- : 5.4.24 -- Browser(s) name and version -- : Safari and or Firefox newest -- Error-message(debug-mod must be tuned on) -- : During update the update process stopped, and i now get the following message. Does anyone have a tip to help me her? Thanks Error_message: 1054 - Unknown column 'b.taxation_date_start' in 'where clause' SQL=SELECT b.*,c.* FROM j30ai_hikashop_category AS a LEFT JOIN j30ai_hikashop_taxation AS b ON a.category_namekey=b.category_namekey LEFT JOIN j30ai_hikashop_tax AS c ON b.tax_namekey=c.tax_namekey WHERE a.category_id = 12 AND b.taxation_published=1 AND ( taxation_type = '' OR taxation_type = 'company_with_vat_number' ) AND b.taxation_date_start 1394183163)")* Hi, HikaShop process some SQL queries during the update and I think that it add some troubles (maybe not the right to alter tables ?). I don't know from which version you have updated but you can find the different SQL queries for the updates in the "install.hikashop.php" file. For the update from HikaShop 2.2.3 to HikaShop 2.3.0, theses queries are processed: Code: ALTER TABLE `#__hikashop_taxation` ADD `taxation_date_start` int(10) unsigned NOT NULL DEFAULT '0', ADD `taxation_date_end` int(10) unsigned NOT NULL DEFAULT '0'; CREATE TABLE IF NOT EXISTS `#__hikashop_warehouse` ( `warehouse_id` INT(10) NOT NULL AUTO_INCREMENT, `warehouse_name` VARCHAR(255) NOT NULL DEFAULT '', `warehouse_published` tinyint(4) NOT NULL DEFAULT '1', `warehouse_description` TEXT NOT NULL, `warehouse_ordering` INT(10) NOT NULL DEFAULT 0, `warehouse_created` int(10) DEFAULT NULL, `warehouse_modified` int(10) DEFAULT NULL, PRIMARY KEY (`warehouse_id`) ) ENGINE=MyISAM; ALTER TABLE `#__hikashop_product` ADD `product_warehouse_id` int(10) unsigned NOT NULL DEFAULT '0'; Where you have to replace "#_" by your database prefix. Example: if your database joomla prefix is "jos", the table "#__hikashop_taxation" will become "jos_hikashop_taxation". Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NjQ0Ny1oaWthc2hvcC1kb3duLWFmdGVyLXVwZGF0ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[altitude](/forum/user/26150-altitude "View altitude's Profile")** - [![altitude's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/26150-altitude "View altitude's Profile") Topic Author - [ Offline](/forum/user/26150-altitude) Less More - Posts: 2 - Thank you received: 0 - - 12 years 7 months ago [\#147305](#147305) by [altitude](/forum/user/26150-altitude "View altitude's Profile") Replied by *[altitude](/forum/user/26150-altitude "View altitude's Profile")* on topic *[Hikashop down after update](/forum/25-install-update/866447-hikashop-down-after-update#147305 "-- url of the page with the problem -- : altitude-imageworx.ch/index.php/en/be-steady/online-shop-en -- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.2.3 -- PHP version -- : 5.4.24 -- Browser(s) name and version -- : Safari and or Firefox newest -- Error-message(debug-mod must be tuned on) -- : During update the update process stopped, and i now get the following message. Does anyone have a tip to help me her? Thanks Error_message: 1054 - Unknown column 'b.taxation_date_start' in 'where clause' SQL=SELECT b.*,c.* FROM j30ai_hikashop_category AS a LEFT JOIN j30ai_hikashop_taxation AS b ON a.category_namekey=b.category_namekey LEFT JOIN j30ai_hikashop_tax AS c ON b.tax_namekey=c.tax_namekey WHERE a.category_id = 12 AND b.taxation_published=1 AND ( taxation_type = '' OR taxation_type = 'company_with_vat_number' ) AND b.taxation_date_start 1394183163)")* Hello, Thanks for the quick solution. will work on it and if I do have more questions I will let you know. THX Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NjQ0Ny1oaWthc2hvcC1kb3duLWFmdGVyLXVwZGF0ZT90bXBsPW1hcmtkb3du) 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? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.085 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)