- Posts: 640
- Thank you received: 16
Can't access extra address in frontend
- PeterChain
-
Topic Author
- Offline
Less
More
9 years 10 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 10 months ago #255863
by Jerome
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.
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.
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.
- PeterChain
-
Topic Author
- Offline
Less
More
- Posts: 640
- Thank you received: 16
9 years 10 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.191 seconds