[Skip to main content](#vessel-content)
# Profile for jonike
##
[](/forum/user/53999-jonike "View jonike's Profile")
**[ Offline](/forum/user/53999-jonike)**
- **User Type:** User
- **Register Date:** 20 Nov 2017
- **Last login:** 8 years 7 months ago
- **Time Zone:** UTC +0:00
- **Local Time:** 00:49
- **Posts:** 2
- **Profile views:** 134
- **Gender:** Unknown
- **Birthdate:** Unknown
- Posts
# jonike's recent posts (2 messages )
All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year
| [ ](#forumbottom) | Subject | Replies / Views | Last Post | [ ](#forumtop) |
|---|---|---|---|---|
| [](/forum/36-reports-statistics/893645-error-when-creating-reports#287031) | [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!") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 9 months ago, by [jonike](/forum/user/53999-jonike "View jonike's Profile") [Last Post](/forum/36-reports-statistics/893645-error-when-creating-reports#288315 "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 and check the report again. It will provide the full MySQL query.") 8 years 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:7 Views:3587 | [Last Post](/forum/36-reports-statistics/893645-error-when-creating-reports#288315 "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 and check the report again. It will provide the full MySQL query.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 8 years 8 months ago |
| [](/forum/36-reports-statistics/893645-error-when-creating-reports#286932) | [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!") Category: [Reports & Statistics](/forum/36-reports-statistics "All there is to know about reports and statisctics") Topic started 8 years 9 months ago, by [jonike](/forum/user/53999-jonike "View jonike's Profile") [Last Post](/forum/36-reports-statistics/893645-error-when-creating-reports#288315 "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 and check the report again. It will provide the full MySQL query.") 8 years 8 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:7 Views:3587 | [Last Post](/forum/36-reports-statistics/893645-error-when-creating-reports#288315 "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 and check the report again. It will provide the full MySQL query.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 8 years 8 months ago |
[](/forum/topics/feed/mode-topics?format=feed&type=rss)
Time to create page: 0.055 seconds
[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)