Hikashop down after update

  • Posts: 2
  • Thank you received: 0
10 years 8 months ago #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 AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1394183163)

Please Log in or Create an account to join the conversation.

  • Posts: 26159
  • Thank you received: 4028
  • MODERATOR
10 years 8 months ago #147236

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:

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.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 2
  • Thank you received: 0
10 years 8 months ago #147305

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 or Create an account to join the conversation.

Time to create page: 0.057 seconds
Powered by Kunena Forum