[Skip to main content](#vessel-content) # Report show errorss ## - **[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")** - [![ler@singmuiheng.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Topic Author - [ Offline](/forum/user/3330-ler-singmuiheng-com) Less More - Posts: 575 - Thank you received: 11 - - 4 years 4 months ago [\#342994](#342994) by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") *[Report show errorss](/forum/36-reports-statistics/904682-report-show-errorss#342994 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.21 -- PHP version -- : 7.2 -- Browser(s) name and version -- : google chrome -- Error-message(debug-mod must be tuned on) -- : 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_ AS a' at line 1 Hi, can you help to check why error shows out in the report")* was created by *[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")* -- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.21 -- PHP version -- : 7.2 -- Browser(s) name and version -- : google chrome -- Error-message(debug-mod must be tuned on) -- : 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_ AS a' at line 1 Hi, can you help to check why error shows out in the report This message contains confidential information - [ ![Capture-happinessreport.JPG](/forum/attachment/55162) ](/forum/attachment/55162 "...nessreport.JPG") [ ](/forum/attachment/55162?download=1 "...nessreport.JPG") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDQ2ODItcmVwb3J0LXNob3ctZXJyb3Jzcz90bXBsPW1hcmtkb3du) 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 - - 4 years 4 months ago [\#343002](#343002) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Report show errorss](/forum/36-reports-statistics/904682-report-show-errorss#343002 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.21 -- PHP version -- : 7.2 -- Browser(s) name and version -- : google chrome -- Error-message(debug-mod must be tuned on) -- : 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_ AS a' at line 1 Hi, can you help to check why error shows out in the report")* Hi, That's hard to say like that. Even with the backend access I can't say. It looks like a bug appearing in a specific situation based on how the report is configured. Are you able to reproduce the issue with a new report ? If so, could you do a screenshot of the settings just before you save and get the error ? Also, it would be great if you could do that modification ( [ www.hikashop.com/support/forum/install-u...ror-1064.html#326783](https://www.hikashop.com/support/forum/install-update/901387-i-can-t-access-hikashop-having-error-1064.html#326783) ) so that the error message would include the MySQL query leading to the error. With the settings and the MySQL query that would help. Also, if you could provide a FTP access to add debug to the code it would be great. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDQ2ODItcmVwb3J0LXNob3ctZXJyb3Jzcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")** - [![ler@singmuiheng.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Topic Author - [ Offline](/forum/user/3330-ler-singmuiheng-com) Less More - Posts: 575 - Thank you received: 11 - - 4 years 4 months ago [\#343013](#343013) by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Replied by *[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")* on topic *[Report show errorss](/forum/36-reports-statistics/904682-report-show-errorss#343013 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.21 -- PHP version -- : 7.2 -- Browser(s) name and version -- : google chrome -- Error-message(debug-mod must be tuned on) -- : 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_ AS a' at line 1 Hi, can you help to check why error shows out in the report")* Unfortunately, I cannot reproduce the same setting, I already change the code to parent::__construct($message.' '.$query, $code, $previous); This message contains confidential information Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDQ2ODItcmVwb3J0LXNob3ctZXJyb3Jzcz90bXBsPW1hcmtkb3du) 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 - - 4 years 4 months ago [\#343023](#343023) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Report show errorss](/forum/36-reports-statistics/904682-report-show-errorss#343023 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.21 -- PHP version -- : 7.2 -- Browser(s) name and version -- : google chrome -- Error-message(debug-mod must be tuned on) -- : 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_ AS a' at line 1 Hi, can you help to check why error shows out in the report")* Hi, Thanks. I was able to investigate the issue. The problem was the data of the report itself which wasn't initialized properly. So the fact that it wasn't displaying was only a byproduct. I've added some code to add failsafes so that if the report has invalid data, it will still be able to load properly. The patch seems to work fine on your website. We'll add that for the next version of HikaShop in September. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDQ2ODItcmVwb3J0LXNob3ctZXJyb3Jzcz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")** - [![ler@singmuiheng.com's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Topic Author - [ Offline](/forum/user/3330-ler-singmuiheng-com) Less More - Posts: 575 - Thank you received: 11 - - 4 years 4 months ago [\#343026](#343026) by [ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile") Replied by *[ler@singmuiheng.com](/forum/user/3330-ler-singmuiheng-com "View ler@singmuiheng.com's Profile")* on topic *[Report show errorss](/forum/36-reports-statistics/904682-report-show-errorss#343026 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.21 -- PHP version -- : 7.2 -- Browser(s) name and version -- : google chrome -- Error-message(debug-mod must be tuned on) -- : 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_ AS a' at line 1 Hi, can you help to check why error shows out in the report")* Thank you, nicholas. Btw can you show where you had change the code, so that I can patch on the other website also? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDQ2ODItcmVwb3J0LXNob3ctZXJyb3Jzcz90bXBsPW1hcmtkb3du) 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 - - 4 years 4 months ago [\#343027](#343027) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Report show errorss](/forum/36-reports-statistics/904682-report-show-errorss#343027 "-- HikaShop version -- : 4.3.0 -- Joomla version -- : 3.9.21 -- PHP version -- : 7.2 -- Browser(s) name and version -- : google chrome -- Error-message(debug-mod must be tuned on) -- : 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_ AS a' at line 1 Hi, can you help to check why error shows out in the report")* Hi, I changed code in several different places so it will be hard to patch manually. It will be easier to just wait for the next release to update. But you can ignore the error. Just delete the report and recreate a new one and you should not have the problem. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDQ2ODItcmVwb3J0LXNob3ctZXJyb3Jzcz90bXBsPW1hcmtkb3du) 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.071 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)