Acysms integration

  • Posts: 7
  • Thank you received: 0
7 years 11 months ago #257810

-- 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.

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
7 years 11 months ago #257811

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,

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.

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

  • Posts: 7
  • Thank you received: 0
7 years 11 months ago #258024

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?

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
7 years 11 months ago #258026

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,

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.

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

Time to create page: 0.055 seconds
Powered by Kunena Forum