- Posts: 42
- Thank you received: 1
sql problem with customer`s mail
10 years 5 months ago #235707
by marto42
sql problem with customer`s mail was created by marto42
-- 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?
-- 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?
Please Log in or Create an account to join the conversation.
10 years 5 months ago - 10 years 5 months ago #235711
by Philip
Replied by Philip on topic sql problem with customer`s mail
Last edit: 10 years 5 months ago by Philip.
Please Log in or Create an account to join the conversation.
10 years 5 months ago - 10 years 5 months ago #235752
by marto42
Replied by marto42 on topic sql problem with customer`s mail
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
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: 10 years 5 months ago by marto42.
Please Log in or Create an account to join the conversation.
10 years 5 months ago - 10 years 5 months ago #235755
by marto42
Replied by marto42 on topic sql problem with customer`s mail
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
but noting`s gonna happend too.
Tell me please how can fix my issue.
Thanks
Last edit: 10 years 5 months ago by marto42.
Please Log in or Create an account to join the conversation.
10 years 5 months ago #235779
by nicolas
Replied by nicolas on topic sql problem with customer`s mail
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.
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.
10 years 5 months ago #235786
by marto42
Replied by marto42 on topic sql problem with customer`s mail
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
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.
10 years 5 months ago #235794
by nicolas
Replied by nicolas on topic sql problem with customer`s mail
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.
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.
10 years 5 months ago #236063
by marto42
Replied by marto42 on topic sql problem with customer`s mail
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.198 seconds