[Skip to main content](#vessel-content) # Error message in Hikashop dashboard ## - **[gioferrario@gmail.com](/forum/user/35746-gioferrario-gmail-com "View gioferrario@gmail.com's Profile")** - [![gioferrario@gmail.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/35746-gioferrario-gmail-com "View gioferrario@gmail.com's Profile") Topic Author - [ Offline](/forum/user/35746-gioferrario-gmail-com) Less More - Posts: 55 - Thank you received: 0 - - 11 years 6 months ago [\#199013](#199013) by [gioferrario@gmail.com](/forum/user/35746-gioferrario-gmail-com "View gioferrario@gmail.com's Profile") *[Error message in Hikashop dashboard](/forum/26-product-category-display/876447-error-message-in-hikashop-dashboard#199013 "-- url of the page with the problem -- : www.giofoto.it -- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.35 -- Browser(s) name and version -- : Crome last version -- Error-message(debug-mod must be tuned on) -- : 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT *, SUM(order_product_quantity) as Total FROM joom3_hikashop_order as a LEFT JOIN joom3_hikashop_order_product as prod ON a.order_id=prod.order_id LEFT JOIN joom3_hikashop_product AS p ON p.product_id=prod.product_id LEFT JOIN joom3_hikashop_product_category as cat ON cat.product_id=p.product_id OR cat.product_id=p.product_parent_id LEFT JOIN joom3_hikashop_category as c ON cat.category_id=c.category_id WHERE a.order_created > 1428935141 AND a.order_created Good morning, after changing the hosting service by clicking on components and Hikashop, when I should view the dashboard with statistics and different, it gives me this message. The problem seems to be a limit of db, who tell me that they can not change, there is a system to get around this limit? thanks")* was created by *[gioferrario@gmail.com](/forum/user/35746-gioferrario-gmail-com "View gioferrario@gmail.com's Profile")* -- url of the page with the problem -- : [ www.giofoto.it](http://www.giofoto.it) -- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.35 -- Browser(s) name and version -- : Crome last version -- Error-message(debug-mod must be tuned on) -- : 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT *, SUM(order_product_quantity) as Total FROM joom3_hikashop_order as a LEFT JOIN joom3_hikashop_order_product as prod ON a.order_id=prod.order_id LEFT JOIN joom3_hikashop_product AS p ON p.product_id=prod.product_id LEFT JOIN joom3_hikashop_product_category as cat ON cat.product_id=p.product_id OR cat.product_id=p.product_parent_id LEFT JOIN joom3_hikashop_category as c ON cat.category_id=c.category_id WHERE a.order_created > 1428935141 AND a.order_created Good morning, after changing the hosting service by clicking on components and Hikashop, when I should view the dashboard with statistics and different, it gives me this message. The problem seems to be a limit of db, who tell me that they can not change, there is a system to get around this limit? thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NzY0NDctZXJyb3ItbWVzc2FnZS1pbi1oaWthc2hvcC1kYXNoYm9hcmQ/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: 4080 - - [](http://obsi.dev) - 11 years 6 months ago [\#199016](#199016) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Error message in Hikashop dashboard](/forum/26-product-category-display/876447-error-message-in-hikashop-dashboard#199016 "-- url of the page with the problem -- : www.giofoto.it -- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.35 -- Browser(s) name and version -- : Crome last version -- Error-message(debug-mod must be tuned on) -- : 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT *, SUM(order_product_quantity) as Total FROM joom3_hikashop_order as a LEFT JOIN joom3_hikashop_order_product as prod ON a.order_id=prod.order_id LEFT JOIN joom3_hikashop_product AS p ON p.product_id=prod.product_id LEFT JOIN joom3_hikashop_product_category as cat ON cat.product_id=p.product_id OR cat.product_id=p.product_parent_id LEFT JOIN joom3_hikashop_category as c ON cat.category_id=c.category_id WHERE a.order_created > 1428935141 AND a.order_created Good morning, after changing the hosting service by clicking on components and Hikashop, when I should view the dashboard with statistics and different, it gives me this message. The problem seems to be a limit of db, who tell me that they can not change, there is a system to get around this limit? thanks")* Hi, > The SELECT would examine more than MAX\_JOIN\_SIZE rows; check your WHERE and use SET SQL\_BIG\_SELECTS=1 or SET MAX\_JOIN\_SIZE=# if the SELECT is okay As the message explained, the issue is related to the Database configuration which is too restrictive for needs of your widget. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NzY0NDctZXJyb3ItbWVzc2FnZS1pbi1oaWthc2hvcC1kYXNoYm9hcmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[syno](/forum/user/40370-syno "View syno's Profile")** - [![syno's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/40370-syno "View syno's Profile") - [ Offline](/forum/user/40370-syno) Less More - Posts: 30 - Thank you received: 0 - - 8 years 1 month ago [\#298226](#298226) by [syno](/forum/user/40370-syno "View syno's Profile") Replied by *[syno](/forum/user/40370-syno "View syno's Profile")* on topic *[Error message in Hikashop dashboard](/forum/26-product-category-display/876447-error-message-in-hikashop-dashboard#298226 "-- url of the page with the problem -- : www.giofoto.it -- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.35 -- Browser(s) name and version -- : Crome last version -- Error-message(debug-mod must be tuned on) -- : 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT *, SUM(order_product_quantity) as Total FROM joom3_hikashop_order as a LEFT JOIN joom3_hikashop_order_product as prod ON a.order_id=prod.order_id LEFT JOIN joom3_hikashop_product AS p ON p.product_id=prod.product_id LEFT JOIN joom3_hikashop_product_category as cat ON cat.product_id=p.product_id OR cat.product_id=p.product_parent_id LEFT JOIN joom3_hikashop_category as c ON cat.category_id=c.category_id WHERE a.order_created > 1428935141 AND a.order_created Good morning, after changing the hosting service by clicking on components and Hikashop, when I should view the dashboard with statistics and different, it gives me this message. The problem seems to be a limit of db, who tell me that they can not change, there is a system to get around this limit? thanks")* Hello, sorry for opening this old thread but is there a solution to this problem? The same problem with the search plugin could be fixed with $db->setQuery('SET SQL_BIG_SELECTS=1'); as described here: [ www.hikashop.com/forum/4-how-to/53049-co...ch-plugin.html#58420](https://www.hikashop.com/forum/4-how-to/53049-configure-the-hikashop-search-plugin.html#58420) Where do I need to put this code to fix the dashboard? Thank you for your help! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NzY0NDctZXJyb3ItbWVzc2FnZS1pbi1oaWthc2hvcC1kYXNoYm9hcmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Philip](/forum/user/34318-philip "View Philip's Profile")** - [![Philip's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34318-philip "View Philip's Profile") - [ Offline](/forum/user/34318-philip) Less More - Posts: 4820 - Thank you received: 652 - - 8 years 1 month ago - 8 years 1 month ago [\#298254](#298254) by [Philip](/forum/user/34318-philip "View Philip's Profile") Replied by *[Philip](/forum/user/34318-philip "View Philip's Profile")* on topic *[Error message in Hikashop dashboard](/forum/26-product-category-display/876447-error-message-in-hikashop-dashboard#298254 "-- url of the page with the problem -- : www.giofoto.it -- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.35 -- Browser(s) name and version -- : Crome last version -- Error-message(debug-mod must be tuned on) -- : 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT *, SUM(order_product_quantity) as Total FROM joom3_hikashop_order as a LEFT JOIN joom3_hikashop_order_product as prod ON a.order_id=prod.order_id LEFT JOIN joom3_hikashop_product AS p ON p.product_id=prod.product_id LEFT JOIN joom3_hikashop_product_category as cat ON cat.product_id=p.product_id OR cat.product_id=p.product_parent_id LEFT JOIN joom3_hikashop_category as c ON cat.category_id=c.category_id WHERE a.order_created > 1428935141 AND a.order_created Good morning, after changing the hosting service by clicking on components and Hikashop, when I should view the dashboard with statistics and different, it gives me this message. The problem seems to be a limit of db, who tell me that they can not change, there is a system to get around this limit? thanks")* Hello, You file find this in the **hikashop\_products.php** file in your folder ***YourWebsite*\\plugins\\search\\hikashop\_products** and around line **182** : [ ![[img](https://cdn.pbrd.co/images/HFlcuJf.png) ](https://cdn.pbrd.co/images/HFlcuJf.png "[img") But not really sure that can solve your issue, but you can try this, but if that don't works, we advice you to come back with more details like **HikaShop versions**, **where** do you see the error message, and any elements that can help us to better understand situation. Regards Last edit: 8 years 1 month ago by [Philip](/forum/user/34318-philip "View Philip's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NzY0NDctZXJyb3ItbWVzc2FnZS1pbi1oaWthc2hvcC1kYXNoYm9hcmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[joycehoveling](/forum/user/48862-joycehoveling "View joycehoveling's Profile")** - [![joycehoveling's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/48862-joycehoveling "View joycehoveling's Profile") - [ Offline](/forum/user/48862-joycehoveling) Less More - Posts: 115 - Thank you received: 0 - - 6 years 8 months ago [\#316285](#316285) by [joycehoveling](/forum/user/48862-joycehoveling "View joycehoveling's Profile") Replied by *[joycehoveling](/forum/user/48862-joycehoveling "View joycehoveling's Profile")* on topic *[Error message in Hikashop dashboard](/forum/26-product-category-display/876447-error-message-in-hikashop-dashboard#316285 "-- url of the page with the problem -- : www.giofoto.it -- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.35 -- Browser(s) name and version -- : Crome last version -- Error-message(debug-mod must be tuned on) -- : 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT *, SUM(order_product_quantity) as Total FROM joom3_hikashop_order as a LEFT JOIN joom3_hikashop_order_product as prod ON a.order_id=prod.order_id LEFT JOIN joom3_hikashop_product AS p ON p.product_id=prod.product_id LEFT JOIN joom3_hikashop_product_category as cat ON cat.product_id=p.product_id OR cat.product_id=p.product_parent_id LEFT JOIN joom3_hikashop_category as c ON cat.category_id=c.category_id WHERE a.order_created > 1428935141 AND a.order_created Good morning, after changing the hosting service by clicking on components and Hikashop, when I should view the dashboard with statistics and different, it gives me this message. The problem seems to be a limit of db, who tell me that they can not change, there is a system to get around this limit? thanks")* Hi, I have the same error message when accessing the hikashop dashboard: [ tweedehandjes.com/administrator/index.php?option=com\_hikashop](https://tweedehandjes.com/administrator/index.php?option=com_hikashop) *1104 The SELECT would examine more than MAX\_JOIN\_SIZE rows; check your WHERE and use SET SQL\_BIG\_SELECTS=1 or SET MAX\_JOIN\_SIZE=# if the SELECT is okay* Could you please help me to fix this? I am using HikaShop Business: 4.2.2 Kind regards, Joyce Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NzY0NDctZXJyb3ItbWVzc2FnZS1pbi1oaWthc2hvcC1kYXNoYm9hcmQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86556 - Thank you received: 14304 - - 6 years 8 months ago [\#316288](#316288) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error message in Hikashop dashboard](/forum/26-product-category-display/876447-error-message-in-hikashop-dashboard#316288 "-- url of the page with the problem -- : www.giofoto.it -- HikaShop version -- : 2.4.0 -- Joomla version -- : 3.4.1 -- PHP version -- : 5.4.35 -- Browser(s) name and version -- : Crome last version -- Error-message(debug-mod must be tuned on) -- : 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT *, SUM(order_product_quantity) as Total FROM joom3_hikashop_order as a LEFT JOIN joom3_hikashop_order_product as prod ON a.order_id=prod.order_id LEFT JOIN joom3_hikashop_product AS p ON p.product_id=prod.product_id LEFT JOIN joom3_hikashop_product_category as cat ON cat.product_id=p.product_id OR cat.product_id=p.product_parent_id LEFT JOIN joom3_hikashop_category as c ON cat.category_id=c.category_id WHERE a.order_created > 1428935141 AND a.order_created Good morning, after changing the hosting service by clicking on components and Hikashop, when I should view the dashboard with statistics and different, it gives me this message. The problem seems to be a limit of db, who tell me that they can not change, there is a system to get around this limit? thanks")* Hi, This error appears because some of the queries on that page require a lot of joins, more than your server configuration allows for. To fix this, you need to increase the value of MAX_JOIN_SIZE or set the value of SQL_BIG_SELECTS to 1 in the my.cnf file of your MySQL server. If you have your own dedicated server, your server administrator should be able to do this. If not, you should check with your hosting provider support about what to do. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NzY0NDctZXJyb3ItbWVzc2FnZS1pbi1oaWthc2hvcC1kYXNoYm9hcmQ/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.062 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)