- Posts: 640
- Thank you received: 16
Can't access extra address in frontend
- PeterChain
-
Topic Author
- Offline
Less
More
9 years 11 months ago #255862
by PeterChain
Can't access extra address in frontend was created 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')
-- 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.
9 years 11 months ago #255863
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Replied by Jerome on topic Can't access extra address in frontend
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.
Regards,
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.
- PeterChain
-
Topic Author
- Offline
Less
More
- Posts: 640
- Thank you received: 16
9 years 11 months ago #255890
by PeterChain
Replied by PeterChain on topic Can't access extra address in frontend
Thanks, it works properly now.
-- Víctor
-- Víctor
Please Log in or Create an account to join the conversation.
Moderators: Obsidev
Time to create page: 0.145 seconds