Skip to main content

Can't access extra address in frontend

More
9 years 11 months ago #255862 by PeterChain
-- 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')

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

More
9 years 11 months ago #255863 by Jerome
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.
Code:
ALTER TABLE `#__hikashop_address`ADD `address_type` varchar(50) NOT NULL DEFAULT '';

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
The following user(s) said Thank You: PeterChain, mhdlabs

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

More
9 years 11 months ago #255890 by PeterChain
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.176 seconds
Powered by Kunena Forum