Acysms integration

-- url of the page with the problem -- : seceretingredients.com
-- HikaShop version -- : 2.8.1
-- Joomla version -- : 3.6.4
-- PHP version -- : 5.3

lm trying to configure Acysms in hikashop but l get the following error:
1054 Unknown column 'hikaaddress.user_cms_id' in 'on clause' SQL=SELECT *, hikaaddress.address_user_id as receiver_id, hikaaddress.address_firstname as receiver_name FROM #__hikashop_address AS hikaaddress LEFT JOIN #__users AS joomUsers ON joomUsers.id = hikaaddress.user_cms_id WHERE `address_telephone2` = '1' OR REPLACE(`address_telephone2`, "-", "") LIKE '%1'

Return to Control Panel
please help.

Hi,

That SQL query does not come from HikaShop. Please contact the AcySMS support for that issue.
It looks like the component is trying to load the "user_cms_id" but that element is not in the HikaShop address table, it is in the HikaShop user table ( #__hikashop_user ) so there is a missing JOIN.

Regards,

after contacting Acysms support l was told:
Hi,

There is a missing column (user_cms_id) in your Hikashop table
"hikashop_address".
I don't have any idea about the reason but that's the reason why you
get the error..

Please take a look at this and once the column will be present the
problem will disappear.

Regards,
How ca l fix this please?

Hi,

As explained in my previous message ; we can't.
The problem is not in HikaShop and the information "user_cms_id" is in the table #__hikashop_user and not in the table #__hikashop_address.
There is no missing column ; there is a missing join in the query.

Regards,