[Skip to main content](#vessel-content) # Acysms integration ## - **[omys](/forum/user/45461-omys "View omys's Profile")** - [![omys's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/45461-omys "View omys's Profile") Topic Author - [ Offline](/forum/user/45461-omys) Less More - Posts: 7 - Thank you received: 0 - - 9 years 10 months ago [\#257810](#257810) by [omys](/forum/user/45461-omys "View omys's Profile") *[Acysms integration](/forum/35-orders-management/887964-acysms-integration#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.")* was created by *[omys](/forum/user/45461-omys "View omys's Profile")* -- 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4Nzk2NC1hY3lzbXMtaW50ZWdyYXRpb24/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26400 - Thank you received: 4079 - - [](http://obsi.dev) - 9 years 10 months ago [\#257811](#257811) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Acysms integration](/forum/35-orders-management/887964-acysms-integration#257811 "-- 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, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4Nzk2NC1hY3lzbXMtaW50ZWdyYXRpb24/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[omys](/forum/user/45461-omys "View omys's Profile")** - [![omys's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/45461-omys "View omys's Profile") Topic Author - [ Offline](/forum/user/45461-omys) Less More - Posts: 7 - Thank you received: 0 - - 9 years 10 months ago [\#258024](#258024) by [omys](/forum/user/45461-omys "View omys's Profile") Replied by *[omys](/forum/user/45461-omys "View omys's Profile")* on topic *[Acysms integration](/forum/35-orders-management/887964-acysms-integration#258024 "-- 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.")* 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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4Nzk2NC1hY3lzbXMtaW50ZWdyYXRpb24/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26400 - Thank you received: 4079 - - [](http://obsi.dev) - 9 years 10 months ago [\#258026](#258026) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Acysms integration](/forum/35-orders-management/887964-acysms-integration#258026 "-- 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, 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg4Nzk2NC1hY3lzbXMtaW50ZWdyYXRpb24/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.059 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)