[Skip to main content](#vessel-content) # modifications to reports are giving SQL errors, dashboard not available now ## - **[ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile")** - [![ianspeed's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1602-ianspeed "View ianspeed's Profile") Topic Author - [ Offline](/forum/user/1602-ianspeed) Less More - Posts: 173 - Thank you received: 8 - - 7 years 1 month ago [\#311620](#311620) by [ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile") *[modifications to reports are giving SQL errors, dashboard not available now](/forum/36-reports-statistics/898412-modifications-to-reports-are-giving-sql-errors-dashboard-not-available-now#311620 "-- HikaShop version -- : 4.2.1 -- Joomla version -- : 3.9.11 -- PHP version -- : 7.0.33 -- Browser(s) name and version -- : chrome -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM #__hikashop_order AS a WHERE a.order_type='sale' AND a.order_status IN (' at line 1 Return to Control Panel Can't access the dashboard after making a change to the comparison sales data, get sql syntax error. Any ideas?")* was created by *[ianspeed](/forum/user/1602-ianspeed "View ianspeed's Profile")* -- HikaShop version -- : 4.2.1 -- Joomla version -- : 3.9.11 -- PHP version -- : 7.0.33 -- Browser(s) name and version -- : chrome -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM #__hikashop_order AS a WHERE a.order_type='sale' AND a.order_status IN (' at line 1 Return to Control Panel Can't access the dashboard after making a change to the comparison sales data, get sql syntax error. Any ideas? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTg0MTItbW9kaWZpY2F0aW9ucy10by1yZXBvcnRzLWFyZS1naXZpbmctc3FsLWVycm9ycy1kYXNoYm9hcmQtbm90LWF2YWlsYWJsZS1ub3c/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: 86555 - Thank you received: 14304 - - 7 years 1 month ago [\#311622](#311622) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[modifications to reports are giving SQL errors, dashboard not available now](/forum/36-reports-statistics/898412-modifications-to-reports-are-giving-sql-errors-dashboard-not-available-now#311622 "-- HikaShop version -- : 4.2.1 -- Joomla version -- : 3.9.11 -- PHP version -- : 7.0.33 -- Browser(s) name and version -- : chrome -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM #__hikashop_order AS a WHERE a.order_type='sale' AND a.order_status IN (' at line 1 Return to Control Panel Can't access the dashboard after making a change to the comparison sales data, get sql syntax error. Any ideas?")* Hi, First, you can disable the report via the Orders>Reports menu. That way, it won't appear as a widget on the dashboard and thus won't crash the dashboard. Then, you can create a new report and publish it once it's working like you want. Also, you might want to try to reproduce the issue and provide a screenshot of the settings of the report just before you save it (after you save it, the report edition page will crash as it will also run the report so you won't be able to do a screenshot of the settings once you have the issue with the report. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTg0MTItbW9kaWZpY2F0aW9ucy10by1yZXBvcnRzLWFyZS1naXZpbmctc3FsLWVycm9ycy1kYXNoYm9hcmQtbm90LWF2YWlsYWJsZS1ub3c/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.048 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)