sql problem with customer`s mail

  • Posts: 31
  • Thank you received: 1
8 years 7 months ago #235707

-- HikaShop version -- : 2.6.1
-- Joomla version -- : 3.5.1
-- PHP version -- : 5.5.14
-- Browser(s) name and version -- : chrome 50.0.2661.26 beta-m (64-bit)
-- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column 'Array' in 'where clause' SQL=SELECT category_id FROM #__hikashop_product_category WHERE product_id = Array;

Hello, I`ve got a problem with the link who customers received from my online shop. I`ve tested to purchased some produkt and received mail. On the link to see my bought product I`ve saw an error:
1054 Unknown column 'Array' in 'where clause' SQL=SELECT category_id FROM #__hikashop_product_category WHERE product_id = Array;
What I can do?

Attachments:

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

  • Posts: 4747
  • Thank you received: 644
  • MODERATOR
8 years 7 months ago #235711

Hello,

Can you try to Check your database, for this go to Components => HikaShop => Configuration and click on the Check database button.



Awaiting news from you.

Regards,

Attachments:
Last edit: 8 years 7 months ago by Philip.

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

  • Posts: 31
  • Thank you received: 1
8 years 7 months ago #235752

I made it. Everything is ok.
OK Table "hikashop_address" checked
OK Table "hikashop_badge" checked
OK Table "hikashop_banner" checked
OK Table "hikashop_cart" checked
OK Table "hikashop_cart_product" checked
OK Table "hikashop_category" checked
OK Table "hikashop_characteristic" checked
OK Table "hikashop_click" checked
OK Table "hikashop_config" checked
OK Table "hikashop_currency" checked
OK Table "hikashop_discount" checked
OK Table "hikashop_download" checked
OK Table "hikashop_entry" checked
OK Table "hikashop_field" checked
OK Table "hikashop_file" checked
OK Table "hikashop_filter" checked
OK Table "hikashop_geolocation" checked
OK Table "hikashop_history" checked
OK Table "hikashop_limit" checked
OK Table "hikashop_massaction" checked
OK Table "hikashop_order" checked
OK Table "hikashop_order_product" checked
OK Table "hikashop_payment" checked
OK Table "hikashop_price" checked
OK Table "hikashop_product" checked
OK Table "hikashop_product_category" checked
OK Table "hikashop_product_related" checked
OK Table "hikashop_plugin" checked
OK Table "hikashop_shipping" checked
OK Table "hikashop_shipping_price" checked
OK Table "hikashop_tax" checked
OK Table "hikashop_taxation" checked
OK Table "hikashop_user" checked
OK Table "hikashop_variant" checked
OK Table "hikashop_vote" checked
OK Table "hikashop_vote_user" checked
OK Table "hikashop_waitlist" checked
OK Table "hikashop_widget" checked
OK Table "hikashop_zone" checked
OK Table "hikashop_zone_link" checked
OK Table "hikashop_warehouse" checked
OK Table "hikashop_email_log" checked
OK Product categories checked
OK Variants orphan links cleaned

Last edit: 8 years 7 months ago by marto42.

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

  • Posts: 31
  • Thank you received: 1
8 years 7 months ago #235755

the same problem. the same message after checking customer`s mail link. I`ve put this code - www.hikashop.com/forum/checkout/883603-4...heckout-process.html
but noting`s gonna happend too.
Tell me please how can fix my issue.
Thanks

Last edit: 8 years 7 months ago by marto42.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
8 years 7 months ago #235779

Hi,

Could you turn on the "debug mode" setting of the Joomla configuration and try again ?
It should then display more information about the error on the page of the error which would allow us to better understand where that issue is coming from.

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

  • Posts: 31
  • Thank you received: 1
8 years 7 months ago #235786

I turn on debug mode. Here are the message:
1054 Unknown column 'Array' in 'where clause' SQL=SELECT category_id FROM ixks1_hikashop_product_category WHERE product_id = Array;
Call stack
# Function Location
1 JApplicationCms->execute() /home/elecir5i/public_html/shop.advanciumbg.com/index.php:49
2 JApplicationSite->render() /home/elecir5i/public_html/shop.advanciumbg.com/libraries/cms/application/cms.php:263
3 JApplicationCms->render() /home/elecir5i/public_html/shop.advanciumbg.com/libraries/cms/application/site.php:745
4 JDocumentHtml->render() /home/elecir5i/public_html/shop.advanciumbg.com/libraries/cms/application/cms.php:1068
5 JDocumentHtml->_renderTemplate() /home/elecir5i/public_html/shop.advanciumbg.com/libraries/joomla/document/html.php:477
6 JDocumentHtml->getBuffer() /home/elecir5i/public_html/shop.advanciumbg.com/libraries/joomla/document/html.php:697
7 JDocumentRendererHtmlModules->render() /home/elecir5i/public_html/shop.advanciumbg.com/libraries/joomla/document/html.php:411
8 JDocumentRendererHtmlModule->render() /home/elecir5i/public_html/shop.advanciumbg.com/libraries/joomla/document/renderer/html/modules.php:42
9 JModuleHelper::renderModule() /home/elecir5i/public_html/shop.advanciumbg.com/libraries/joomla/document/renderer/html/module.php:93
10 include() /home/elecir5i/public_html/shop.advanciumbg.com/libraries/cms/module/helper.php:190
11 modAccordeonckhikashopHelper::getItems() /home/elecir5i/public_html/shop.advanciumbg.com/modules/mod_accordeonck/mod_accordeonck.php:37
12 modAccordeonckhikashopHelper::getActiveCategory() /home/elecir5i/public_html/shop.advanciumbg.com/modules/mod_accordeonck/helper_hikashop.php:61
13 JDatabase->query() /home/elecir5i/public_html/shop.advanciumbg.com/modules/mod_accordeonck/helper_hikashop.php:340
14 JDatabaseDriverMysqli->execute() /home/elecir5i/public_html/shop.advanciumbg.com/libraries/joomla/database/database.php:33

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
8 years 7 months ago #235794

Hi,

Thank you. That's why we had a hard time finding where the problem is coming from :)
As per the debug data, the error comes from a MySQL query in the Accordeon CK module you're using on your website, which apparently has a bug.
Please contact the developer of the extension so that they can provide a solution for it.

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

  • Posts: 31
  • Thank you received: 1
8 years 7 months ago #236063

Thank you, so much. I just dissabled Accordion CK module and customers link work perfect. Thanks

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

Time to create page: 0.067 seconds
Powered by Kunena Forum