[Skip to main content](#vessel-content) # Error when creating reports ## - **[jonike](/forum/user/53999-jonike "View jonike's Profile")** - [![jonike's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/53999-jonike "View jonike's Profile") Topic Author - [ Offline](/forum/user/53999-jonike) Less More - Posts: 2 - Thank you received: 0 - - 8 years 9 months ago [\#286932](#286932) by [jonike](/forum/user/53999-jonike "View jonike's Profile") *[Error when creating reports](/forum/36-reports-statistics/893645-error-when-creating-reports#286932 "-- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.0.26 -- Browser(s) name and version -- : 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 ----- Notice: unserialize(): Error at offset 280 of 862 bytes in /home/friendsvinp/public_html/administrator/components/com_hikashop/helpers/helper.php on line 1570 Warning: Creating default object from empty value in /home/friendsvinp/public_html/administrator/components/com_hikashop/classes/widget.php on line 467 Notice: Undefined property: stdClass::$display in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 151 Notice: Undefined property: stdClass::$display in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 ----- Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:650 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 3 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/widget.php:1253 4 hikashopWidgetClass->data() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:56 5 dashboardViewDashboard->widget() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:17 6 dashboardViewDashboard->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:820 7 hikashop_getLayout() JROOT/administrator/components/com_hikashop/views/report/view.html.php:417 8 reportViewReport->form() JROOT/administrator/components/com_hikashop/views/report/view.html.php:32 9 reportViewReport->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1880 11 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1658 12 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:710 13 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1858 14 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:71 15 require_once() JROOT/libraries/src/Component/ComponentHelper.php:381 16 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 17 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 18 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 19 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 20 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Return to Control Panel Everything works fantastic except when trying to create reports. I've searched through the forum and while having found similar syntax errors haven't found this one listed anywhere. This occurs only when creating Reports through the Orders Menu. Any help would be greatly appreciated. Switched from VM to Hikashop since September and haven't had any issues. Just want to see if these reports would be a quick option for our accountant. Thanks in advance and have a great day!")* was created by *[jonike](/forum/user/53999-jonike "View jonike's Profile")* -- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.0.26 -- Browser(s) name and version -- : 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 --- Notice: unserialize(): Error at offset 280 of 862 bytes in /home/friendsvinp/public_html/administrator/components/com_hikashop/helpers/helper.php on line 1570 Warning: Creating default object from empty value in /home/friendsvinp/public_html/administrator/components/com_hikashop/classes/widget.php on line 467 Notice: Undefined property: stdClass::$display in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 151 Notice: Undefined property: stdClass::$display in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 --- Call stack \# Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:650 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 3 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/widget.php:1253 4 hikashopWidgetClass->data() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:56 5 dashboardViewDashboard->widget() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:17 6 dashboardViewDashboard->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:820 7 hikashop_getLayout() JROOT/administrator/components/com_hikashop/views/report/view.html.php:417 8 reportViewReport->form() JROOT/administrator/components/com_hikashop/views/report/view.html.php:32 9 reportViewReport->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1880 11 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1658 12 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:710 13 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1858 14 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:71 15 require_once() JROOT/libraries/src/Component/ComponentHelper.php:381 16 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 17 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 18 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 19 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 20 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Return to Control Panel Everything works fantastic except when trying to create reports. Code: 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 I've searched through the forum and while having found similar syntax errors haven't found this one listed anywhere. This occurs only when creating Reports through the Orders Menu. Any help would be greatly appreciated. Switched from VM to Hikashop since September and haven't had any issues. Just want to see if these reports would be a quick option for our accountant. Thanks in advance and have a great day! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTM2NDUtZXJyb3Itd2hlbi1jcmVhdGluZy1yZXBvcnRzP3RtcGw9bWFya2Rvd24=) 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 - - 8 years 9 months ago [\#287020](#287020) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error when creating reports](/forum/36-reports-statistics/893645-error-when-creating-reports#287020 "-- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.0.26 -- Browser(s) name and version -- : 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 ----- Notice: unserialize(): Error at offset 280 of 862 bytes in /home/friendsvinp/public_html/administrator/components/com_hikashop/helpers/helper.php on line 1570 Warning: Creating default object from empty value in /home/friendsvinp/public_html/administrator/components/com_hikashop/classes/widget.php on line 467 Notice: Undefined property: stdClass::$display in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 151 Notice: Undefined property: stdClass::$display in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 ----- Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:650 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 3 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/widget.php:1253 4 hikashopWidgetClass->data() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:56 5 dashboardViewDashboard->widget() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:17 6 dashboardViewDashboard->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:820 7 hikashop_getLayout() JROOT/administrator/components/com_hikashop/views/report/view.html.php:417 8 reportViewReport->form() JROOT/administrator/components/com_hikashop/views/report/view.html.php:32 9 reportViewReport->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1880 11 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1658 12 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:710 13 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1858 14 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:71 15 require_once() JROOT/libraries/src/Component/ComponentHelper.php:381 16 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 17 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 18 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 19 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 20 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Return to Control Panel Everything works fantastic except when trying to create reports. I've searched through the forum and while having found similar syntax errors haven't found this one listed anywhere. This occurs only when creating Reports through the Orders Menu. Any help would be greatly appreciated. Switched from VM to Hikashop since September and haven't had any issues. Just want to see if these reports would be a quick option for our accountant. Thanks in advance and have a great day!")* Hi, We would need more information to help as we aren't able to reproduce the issue. What are the steps you take to arrive to these errors ? How did you configure the report ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTM2NDUtZXJyb3Itd2hlbi1jcmVhdGluZy1yZXBvcnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jonike](/forum/user/53999-jonike "View jonike's Profile")** - [![jonike's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/53999-jonike "View jonike's Profile") Topic Author - [ Offline](/forum/user/53999-jonike) Less More - Posts: 2 - Thank you received: 0 - - 8 years 9 months ago [\#287031](#287031) by [jonike](/forum/user/53999-jonike "View jonike's Profile") Replied by *[jonike](/forum/user/53999-jonike "View jonike's Profile")* on topic *[Error when creating reports](/forum/36-reports-statistics/893645-error-when-creating-reports#287031 "-- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.0.26 -- Browser(s) name and version -- : 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 ----- Notice: unserialize(): Error at offset 280 of 862 bytes in /home/friendsvinp/public_html/administrator/components/com_hikashop/helpers/helper.php on line 1570 Warning: Creating default object from empty value in /home/friendsvinp/public_html/administrator/components/com_hikashop/classes/widget.php on line 467 Notice: Undefined property: stdClass::$display in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 151 Notice: Undefined property: stdClass::$display in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 ----- Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:650 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 3 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/widget.php:1253 4 hikashopWidgetClass->data() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:56 5 dashboardViewDashboard->widget() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:17 6 dashboardViewDashboard->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:820 7 hikashop_getLayout() JROOT/administrator/components/com_hikashop/views/report/view.html.php:417 8 reportViewReport->form() JROOT/administrator/components/com_hikashop/views/report/view.html.php:32 9 reportViewReport->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1880 11 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1658 12 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:710 13 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1858 14 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:71 15 require_once() JROOT/libraries/src/Component/ComponentHelper.php:381 16 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 17 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 18 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 19 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 20 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Return to Control Panel Everything works fantastic except when trying to create reports. I've searched through the forum and while having found similar syntax errors haven't found this one listed anywhere. This occurs only when creating Reports through the Orders Menu. Any help would be greatly appreciated. Switched from VM to Hikashop since September and haven't had any issues. Just want to see if these reports would be a quick option for our accountant. Thanks in advance and have a great day!")* Hi, This happens whenever I use any of the pre-configured reports listed under Orders > Reports > Sales This Month When I configure a new report everything seems to work except the tables which I get an error with widgets.php Tried going through a few of the the other pre configured reports like Order to ship I get the following errors in addition to the 1064 Notice: unserialize(): Error at offset 279 of 869 bytes in /home/friendsvinp/public_html/administrator/components/com_hikashop/helpers/helper.php on line 1570 Warning: Creating default object from empty value in /home/friendsvinp/public_html/administrator/components/com_hikashop/classes/widget.php on line 467 Notice: Undefined property: stdClass::$display in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 151 Notice: Undefined property: stdClass::$display in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTM2NDUtZXJyb3Itd2hlbi1jcmVhdGluZy1yZXBvcnRzP3RtcGw9bWFya2Rvd24=) 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 - - 8 years 9 months ago [\#287052](#287052) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error when creating reports](/forum/36-reports-statistics/893645-error-when-creating-reports#287052 "-- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.0.26 -- Browser(s) name and version -- : 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 ----- Notice: unserialize(): Error at offset 280 of 862 bytes in /home/friendsvinp/public_html/administrator/components/com_hikashop/helpers/helper.php on line 1570 Warning: Creating default object from empty value in /home/friendsvinp/public_html/administrator/components/com_hikashop/classes/widget.php on line 467 Notice: Undefined property: stdClass::$display in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 151 Notice: Undefined property: stdClass::$display in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 ----- Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:650 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 3 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/widget.php:1253 4 hikashopWidgetClass->data() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:56 5 dashboardViewDashboard->widget() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:17 6 dashboardViewDashboard->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:820 7 hikashop_getLayout() JROOT/administrator/components/com_hikashop/views/report/view.html.php:417 8 reportViewReport->form() JROOT/administrator/components/com_hikashop/views/report/view.html.php:32 9 reportViewReport->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1880 11 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1658 12 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:710 13 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1858 14 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:71 15 require_once() JROOT/libraries/src/Component/ComponentHelper.php:381 16 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 17 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 18 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 19 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 20 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Return to Control Panel Everything works fantastic except when trying to create reports. I've searched through the forum and while having found similar syntax errors haven't found this one listed anywhere. This occurs only when creating Reports through the Orders Menu. Any help would be greatly appreciated. Switched from VM to Hikashop since September and haven't had any issues. Just want to see if these reports would be a quick option for our accountant. Thanks in advance and have a great day!")* Hi, That's really strange as I'm not able to reproduce the problem on my end. Well, you can always create new reports and configure them the same way. You can check the configuration of each report on our demo website : [ demo.hikashop.com/administrator](https://demo.hikashop.com/administrator) with the user access demo / demo Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTM2NDUtZXJyb3Itd2hlbi1jcmVhdGluZy1yZXBvcnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[rufusr](/forum/user/14271-rufusr "View rufusr's Profile")** - [![rufusr's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/butterfly_orange.png)](/forum/user/14271-rufusr "View rufusr's Profile") - [ Offline](/forum/user/14271-rufusr) Less More - Posts: 9 - Thank you received: 0 - - 8 years 8 months ago [\#288197](#288197) by [rufusr](/forum/user/14271-rufusr "View rufusr's Profile") Replied by *[rufusr](/forum/user/14271-rufusr "View rufusr's Profile")* on topic *[Error 1064](/forum/36-reports-statistics/893645-error-when-creating-reports#288197 "-- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.0.26 -- Browser(s) name and version -- : 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 ----- Notice: unserialize(): Error at offset 280 of 862 bytes in /home/friendsvinp/public_html/administrator/components/com_hikashop/helpers/helper.php on line 1570 Warning: Creating default object from empty value in /home/friendsvinp/public_html/administrator/components/com_hikashop/classes/widget.php on line 467 Notice: Undefined property: stdClass::$display in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 151 Notice: Undefined property: stdClass::$display in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 ----- Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:650 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 3 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/widget.php:1253 4 hikashopWidgetClass->data() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:56 5 dashboardViewDashboard->widget() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:17 6 dashboardViewDashboard->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:820 7 hikashop_getLayout() JROOT/administrator/components/com_hikashop/views/report/view.html.php:417 8 reportViewReport->form() JROOT/administrator/components/com_hikashop/views/report/view.html.php:32 9 reportViewReport->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1880 11 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1658 12 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:710 13 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1858 14 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:71 15 require_once() JROOT/libraries/src/Component/ComponentHelper.php:381 16 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 17 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 18 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 19 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 20 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Return to Control Panel Everything works fantastic except when trying to create reports. I've searched through the forum and while having found similar syntax errors haven't found this one listed anywhere. This occurs only when creating Reports through the Orders Menu. Any help would be greatly appreciated. Switched from VM to Hikashop since September and haven't had any issues. Just want to see if these reports would be a quick option for our accountant. Thanks in advance and have a great day!")* Before I contact . support directly I would like to ask this question. Is there a know issue with HikaShop producing this error - 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 '*, SUM(a.order_full_price) AS total,a.order_currency_id AS currency_id FROM sf20' at line 1? I get this error when trying to access the HikaShop dashboard. HikaShop version 3.3.0 Joomla version 3.8.5 PHP version 5.6.33 Thanks in advance for any assistance with this issue... Blessings! Rufus Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTM2NDUtZXJyb3Itd2hlbi1jcmVhdGluZy1yZXBvcnRzP3RtcGw9bWFya2Rvd24=) 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 - - 8 years 8 months ago [\#288212](#288212) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error 1064](/forum/36-reports-statistics/893645-error-when-creating-reports#288212 "-- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.0.26 -- Browser(s) name and version -- : 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 ----- Notice: unserialize(): Error at offset 280 of 862 bytes in /home/friendsvinp/public_html/administrator/components/com_hikashop/helpers/helper.php on line 1570 Warning: Creating default object from empty value in /home/friendsvinp/public_html/administrator/components/com_hikashop/classes/widget.php on line 467 Notice: Undefined property: stdClass::$display in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 151 Notice: Undefined property: stdClass::$display in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 ----- Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:650 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 3 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/widget.php:1253 4 hikashopWidgetClass->data() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:56 5 dashboardViewDashboard->widget() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:17 6 dashboardViewDashboard->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:820 7 hikashop_getLayout() JROOT/administrator/components/com_hikashop/views/report/view.html.php:417 8 reportViewReport->form() JROOT/administrator/components/com_hikashop/views/report/view.html.php:32 9 reportViewReport->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1880 11 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1658 12 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:710 13 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1858 14 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:71 15 require_once() JROOT/libraries/src/Component/ComponentHelper.php:381 16 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 17 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 18 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 19 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 20 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Return to Control Panel Everything works fantastic except when trying to create reports. I've searched through the forum and while having found similar syntax errors haven't found this one listed anywhere. This occurs only when creating Reports through the Orders Menu. Any help would be greatly appreciated. Switched from VM to Hikashop since September and haven't had any issues. Just want to see if these reports would be a quick option for our accountant. Thanks in advance and have a great day!")* Hi, You're apparently using the legacy dashboard and this error comes apparently from a bug due to the way one of your reports is configured. So first, to remove the error on your HikaShop dashboard, you have two easy solution: - you can turn off the "dashboard legacy" setting of the Hikashop configuration to use the new dashboard system. - you can turn off one by one the reports displayed on the legacy dashboard via the menu Orders>Reports in order to find the report causing the issue. Once you find the report with the issue, please provide a screenshot of its settings. Also, if you could do that change and try again to access the dashboard with the error : [ www.hikashop.com/support/forum/install-u...mbiguous.html#287405](https://www.hikashop.com/support/forum/install-update/893519-1052-column-product-id-in-where-clause-is-ambiguous.html#287405) and provide the full MySQL query, that would help us understand the problem so that we can write a patch for it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTM2NDUtZXJyb3Itd2hlbi1jcmVhdGluZy1yZXBvcnRzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[rufusr](/forum/user/14271-rufusr "View rufusr's Profile")** - [![rufusr's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/butterfly_orange.png)](/forum/user/14271-rufusr "View rufusr's Profile") - [ Offline](/forum/user/14271-rufusr) Less More - Posts: 9 - Thank you received: 0 - - 8 years 8 months ago [\#288310](#288310) by [rufusr](/forum/user/14271-rufusr "View rufusr's Profile") Replied by *[rufusr](/forum/user/14271-rufusr "View rufusr's Profile")* on topic *[Error 1064](/forum/36-reports-statistics/893645-error-when-creating-reports#288310 "-- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.0.26 -- Browser(s) name and version -- : 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 ----- Notice: unserialize(): Error at offset 280 of 862 bytes in /home/friendsvinp/public_html/administrator/components/com_hikashop/helpers/helper.php on line 1570 Warning: Creating default object from empty value in /home/friendsvinp/public_html/administrator/components/com_hikashop/classes/widget.php on line 467 Notice: Undefined property: stdClass::$display in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 151 Notice: Undefined property: stdClass::$display in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 ----- Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:650 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 3 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/widget.php:1253 4 hikashopWidgetClass->data() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:56 5 dashboardViewDashboard->widget() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:17 6 dashboardViewDashboard->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:820 7 hikashop_getLayout() JROOT/administrator/components/com_hikashop/views/report/view.html.php:417 8 reportViewReport->form() JROOT/administrator/components/com_hikashop/views/report/view.html.php:32 9 reportViewReport->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1880 11 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1658 12 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:710 13 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1858 14 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:71 15 require_once() JROOT/libraries/src/Component/ComponentHelper.php:381 16 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 17 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 18 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 19 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 20 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Return to Control Panel Everything works fantastic except when trying to create reports. I've searched through the forum and while having found similar syntax errors haven't found this one listed anywhere. This occurs only when creating Reports through the Orders Menu. Any help would be greatly appreciated. Switched from VM to Hikashop since September and haven't had any issues. Just want to see if these reports would be a quick option for our accountant. Thanks in advance and have a great day!")* Thanks Nicolas, unpublishing the sales location report fixed the issue and we don't need that particular report any longer. I'm not sure where to look to get you the full sql query. Tell me where to look and I would be more than happy to get you the information. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTM2NDUtZXJyb3Itd2hlbi1jcmVhdGluZy1yZXBvcnRzP3RtcGw9bWFya2Rvd24=) 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 - - 8 years 8 months ago [\#288315](#288315) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error 1064](/forum/36-reports-statistics/893645-error-when-creating-reports#288315 "-- HikaShop version -- : 3.2.2 -- Joomla version -- : 3.8.3 -- PHP version -- : 7.0.26 -- Browser(s) name and version -- : 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 ----- Notice: unserialize(): Error at offset 280 of 862 bytes in /home/friendsvinp/public_html/administrator/components/com_hikashop/helpers/helper.php on line 1570 Warning: Creating default object from empty value in /home/friendsvinp/public_html/administrator/components/com_hikashop/classes/widget.php on line 467 Notice: Undefined property: stdClass::$display in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 151 Notice: Undefined property: stdClass::$display in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 Notice: Undefined property: stdClass::$content in /home/friendsvinp/public_html/administrator/components/com_hikashop/views/report/view.html.php on line 152 ----- Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:650 2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 3 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_hikashop/classes/widget.php:1253 4 hikashopWidgetClass->data() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:56 5 dashboardViewDashboard->widget() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:17 6 dashboardViewDashboard->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:820 7 hikashop_getLayout() JROOT/administrator/components/com_hikashop/views/report/view.html.php:417 8 reportViewReport->form() JROOT/administrator/components/com_hikashop/views/report/view.html.php:32 9 reportViewReport->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1880 11 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:1658 12 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:710 13 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:1858 14 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:71 15 require_once() JROOT/libraries/src/Component/ComponentHelper.php:381 16 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:356 17 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101 18 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159 19 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:267 20 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51 Return to Control Panel Everything works fantastic except when trying to create reports. I've searched through the forum and while having found similar syntax errors haven't found this one listed anywhere. This occurs only when creating Reports through the Orders Menu. Any help would be greatly appreciated. Switched from VM to Hikashop since September and haven't had any issues. Just want to see if these reports would be a quick option for our accountant. Thanks in advance and have a great day!")* Hi, If you go in the menu Orders>Reports and open the report of the same name, you should get the error again. In that case, do the modification as explained in [ www.hikashop.com/support/forum/install-u...mbiguous.html#287405](https://www.hikashop.com/support/forum/install-update/893519-1052-column-product-id-in-where-clause-is-ambiguous.html#287405) and check the report again. It will provide the full MySQL query. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84OTM2NDUtZXJyb3Itd2hlbi1jcmVhdGluZy1yZXBvcnRzP3RtcGw9bWFya2Rvd24=) 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.069 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)