Can't access extra address in frontend

  • Posts: 634
  • Thank you received: 16
8 years 4 hours ago #255862

-- HikaShop version -- : 2.6.4
-- HikaMarket version -- : 1.7.2
-- Joomla version -- : 3.6.4
-- PHP version -- : 5.6.25
-- Browser(s) name and version -- : Any
-- Error-message(debug-mod must be tuned on) -- : Unknown column 'address_type' in 'where clause' SQL=SELECT * FROM #__hikashop_address WHERE address_published = 1 AND address_user_id = 6 AND address_type IN ('', 'billing')

Login as a vendor,

I get to edit a user order and can't select an alternative address not for shipping nor for billing.

In the dropdown more button, I can get to work "Show Default", "Show Details" and "Edit Address".

When choosing "Select Address", I get a SQL server error inside the opening iframe.

Unknown column 'address_type' in 'where clause' SQL=SELECT * FROM #__hikashop_address WHERE address_published = 1 AND address_user_id = 6 AND address_type IN ('', 'billing')

Attachments:

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
8 years 50 minutes ago #255863

Hi,

Please add the column "address_type" in the table "hikashop_address".
That column shouldn't be add in the last release but it looks like it will only be available in HikaShop 3.

ALTER TABLE `#__hikashop_address`ADD `address_type` varchar(50) NOT NULL DEFAULT '';

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.
The following user(s) said Thank You: PeterChain, mhdlabs

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

  • Posts: 634
  • Thank you received: 16
7 years 11 months ago #255890

Thanks, it works properly now.

-- Víctor

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

Moderators: Obsidev
Time to create page: 0.054 seconds
Powered by Kunena Forum