[Skip to main content](#vessel-content) # 1054 Unknown column 'o.order\_created' in 'where clause' when generating report ## - **[vividfish](/forum/user/18346-vividfish "View vividfish's Profile")** - [![vividfish's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/18346-vividfish "View vividfish's Profile") Topic Author - [ Offline](/forum/user/18346-vividfish) Less More - Posts: 46 - Thank you received: 1 - - 2 years 5 months ago [\#361052](#361052) by [vividfish](/forum/user/18346-vividfish "View vividfish's Profile") *[1054 Unknown column 'o.order\_created' in 'where clause' when generating report](/forum/36-reports-statistics/908180-1054-unknown-column-o-order-created-in-where-clause-when-generating-report#361052 "-- HikaShop version -- : 5.0.4 -- Joomla version -- : 4.4.2 -- PHP version -- : 8.0.30 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column 'o.order_created' in 'where clause' Call stack # Function Location 1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:141 2 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1089 3 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1900 4 Joomla\Database\DatabaseDriver->setQuery() JROOT/administrator/components/com_hikashop/classes/widget.php:1232 5 hikashopWidgetClass->data() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:52 6 dashboardViewDashboard->widget() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:17 7 dashboardViewDashboard->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:936 8 hikashop_getLayout() JROOT/administrator/components/com_hikashop/views/report/view.html.php:419 9 reportViewReport->form() JROOT/administrator/components/com_hikashop/views/report/view.html.php:28 10 reportViewReport->display() JROOT/libraries/src/MVC/Controller/BaseController.php:660 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2582 12 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2300 13 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:693 14 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2560 15 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:73 16 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71 17 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73 18 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361 19 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:143 20 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:186 21 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:293 22 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:61 23 require_once() JROOT/administrator/index.php:32 Hi, I'm trying to generate a table based report that includes the 'total customers' option, see here for details: scribehow.com/shared/Generate_a_Customer...DKl9nPTMSeTaLdlj5yuA When report is saved I get a page stating An error has occurred. 1054 Unknown column 'o.order_created' in 'where clause' Doing this with debug turned on gives me: Call stack # Function Location 1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:141 2 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1089 3 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1900 4 Joomla\Database\DatabaseDriver->setQuery() JROOT/administrator/components/com_hikashop/classes/widget.php:1232 5 hikashopWidgetClass->data() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:52 6 dashboardViewDashboard->widget() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:17 7 dashboardViewDashboard->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:936 8 hikashop_getLayout() JROOT/administrator/components/com_hikashop/views/report/view.html.php:419 9 reportViewReport->form() JROOT/administrator/components/com_hikashop/views/report/view.html.php:28 10 reportViewReport->display() JROOT/libraries/src/MVC/Controller/BaseController.php:660 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2582 12 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2300 13 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:693 14 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2560 15 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:73 16 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71 17 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73 18 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361 19 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:143 20 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:186 21 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:293 22 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:61 23 require_once() JROOT/administrator/index.php:32 Do you have any ideas how I can resolve this? Thanks in advance. KH")* was created by *[vividfish](/forum/user/18346-vividfish "View vividfish's Profile")* -- HikaShop version -- : 5.0.4 -- Joomla version -- : 4.4.2 -- PHP version -- : 8.0.30 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column 'o.order_created' in 'where clause' Call stack \# Function Location 1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:141 2 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1089 3 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1900 4 Joomla\Database\DatabaseDriver->setQuery() JROOT/administrator/components/com_hikashop/classes/widget.php:1232 5 hikashopWidgetClass->data() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:52 6 dashboardViewDashboard->widget() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:17 7 dashboardViewDashboard->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:936 8 hikashop_getLayout() JROOT/administrator/components/com_hikashop/views/report/view.html.php:419 9 reportViewReport->form() JROOT/administrator/components/com_hikashop/views/report/view.html.php:28 10 reportViewReport->display() JROOT/libraries/src/MVC/Controller/BaseController.php:660 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2582 12 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2300 13 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:693 14 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2560 15 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:73 16 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71 17 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73 18 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361 19 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:143 20 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:186 21 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:293 22 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:61 23 require_once() JROOT/administrator/index.php:32 Hi, I'm trying to generate a table based report that includes the 'total customers' option, see here for details: [ scribehow.com/shared/Generate\_a\_Customer...DKl9nPTMSeTaLdlj5yuA](https://scribehow.com/shared/Generate_a_Customers_Report_in_Hikashop_Admin_Console__PNDKl9nPTMSeTaLdlj5yuA) When report is saved I get a page stating An error has occurred. 1054 Unknown column 'o.order_created' in 'where clause' Doing this with debug turned on gives me: Call stack \# Function Location 1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:141 2 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1089 3 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1900 4 Joomla\Database\DatabaseDriver->setQuery() JROOT/administrator/components/com_hikashop/classes/widget.php:1232 5 hikashopWidgetClass->data() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:52 6 dashboardViewDashboard->widget() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:17 7 dashboardViewDashboard->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:936 8 hikashop_getLayout() JROOT/administrator/components/com_hikashop/views/report/view.html.php:419 9 reportViewReport->form() JROOT/administrator/components/com_hikashop/views/report/view.html.php:28 10 reportViewReport->display() JROOT/libraries/src/MVC/Controller/BaseController.php:660 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2582 12 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2300 13 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:693 14 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2560 15 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:73 16 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71 17 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73 18 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361 19 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:143 20 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:186 21 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:293 22 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:61 23 require_once() JROOT/administrator/index.php:32 Do you have any ideas how I can resolve this? Thanks in advance. KH Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDgxODAtMTA1NC11bmtub3duLWNvbHVtbi1vLW9yZGVyLWNyZWF0ZWQtaW4td2hlcmUtY2xhdXNlLXdoZW4tZ2VuZXJhdGluZy1yZXBvcnQ/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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86289 - Thank you received: 14265 - - 2 years 5 months ago [\#361061](#361061) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1054 Unknown column 'o.order\_created' in 'where clause' when generating report](/forum/36-reports-statistics/908180-1054-unknown-column-o-order-created-in-where-clause-when-generating-report#361061 "-- HikaShop version -- : 5.0.4 -- Joomla version -- : 4.4.2 -- PHP version -- : 8.0.30 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column 'o.order_created' in 'where clause' Call stack # Function Location 1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:141 2 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1089 3 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1900 4 Joomla\Database\DatabaseDriver->setQuery() JROOT/administrator/components/com_hikashop/classes/widget.php:1232 5 hikashopWidgetClass->data() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:52 6 dashboardViewDashboard->widget() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:17 7 dashboardViewDashboard->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:936 8 hikashop_getLayout() JROOT/administrator/components/com_hikashop/views/report/view.html.php:419 9 reportViewReport->form() JROOT/administrator/components/com_hikashop/views/report/view.html.php:28 10 reportViewReport->display() JROOT/libraries/src/MVC/Controller/BaseController.php:660 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2582 12 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2300 13 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:693 14 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2560 15 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:73 16 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71 17 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73 18 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361 19 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:143 20 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:186 21 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:293 22 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:61 23 require_once() JROOT/administrator/index.php:32 Hi, I'm trying to generate a table based report that includes the 'total customers' option, see here for details: scribehow.com/shared/Generate_a_Customer...DKl9nPTMSeTaLdlj5yuA When report is saved I get a page stating An error has occurred. 1054 Unknown column 'o.order_created' in 'where clause' Doing this with debug turned on gives me: Call stack # Function Location 1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:141 2 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1089 3 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1900 4 Joomla\Database\DatabaseDriver->setQuery() JROOT/administrator/components/com_hikashop/classes/widget.php:1232 5 hikashopWidgetClass->data() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:52 6 dashboardViewDashboard->widget() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:17 7 dashboardViewDashboard->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:936 8 hikashop_getLayout() JROOT/administrator/components/com_hikashop/views/report/view.html.php:419 9 reportViewReport->form() JROOT/administrator/components/com_hikashop/views/report/view.html.php:28 10 reportViewReport->display() JROOT/libraries/src/MVC/Controller/BaseController.php:660 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2582 12 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2300 13 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:693 14 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2560 15 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:73 16 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71 17 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73 18 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361 19 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:143 20 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:186 21 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:293 22 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:61 23 require_once() JROOT/administrator/index.php:32 Do you have any ideas how I can resolve this? Thanks in advance. KH")* Hi, Change the line: Code: $query='SELECT COUNT(name) FROM '.hikashop_table('users',false).' as u LEFT JOIN '.hikashop_table('user').' as a ON u.id=a.user_cms_id '.$filters; to: Code: $query='SELECT COUNT(name) FROM '.hikashop_table('users',false).' as u LEFT JOIN '.hikashop_table('user').' as a ON u.id=a.user_cms_id LEFT JOIN '.hikashop_table('order').' AS o ON a.user_id=o.order_user_id '.$filters; in the file /administrator/components/com_hikashop/classes/widget.php and it should fix the problem. We'll include the change for the next version of HikaShop. The following user(s) said Thank You: [vividfish](/forum/user/18346-vividfish "View vividfish's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDgxODAtMTA1NC11bmtub3duLWNvbHVtbi1vLW9yZGVyLWNyZWF0ZWQtaW4td2hlcmUtY2xhdXNlLXdoZW4tZ2VuZXJhdGluZy1yZXBvcnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[vividfish](/forum/user/18346-vividfish "View vividfish's Profile")** - [![vividfish's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/18346-vividfish "View vividfish's Profile") Topic Author - [ Offline](/forum/user/18346-vividfish) Less More - Posts: 46 - Thank you received: 1 - - 2 years 5 months ago [\#361063](#361063) by [vividfish](/forum/user/18346-vividfish "View vividfish's Profile") Replied by *[vividfish](/forum/user/18346-vividfish "View vividfish's Profile")* on topic *[1054 Unknown column 'o.order\_created' in 'where clause' when generating report](/forum/36-reports-statistics/908180-1054-unknown-column-o-order-created-in-where-clause-when-generating-report#361063 "-- HikaShop version -- : 5.0.4 -- Joomla version -- : 4.4.2 -- PHP version -- : 8.0.30 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : 1054 Unknown column 'o.order_created' in 'where clause' Call stack # Function Location 1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:141 2 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1089 3 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1900 4 Joomla\Database\DatabaseDriver->setQuery() JROOT/administrator/components/com_hikashop/classes/widget.php:1232 5 hikashopWidgetClass->data() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:52 6 dashboardViewDashboard->widget() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:17 7 dashboardViewDashboard->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:936 8 hikashop_getLayout() JROOT/administrator/components/com_hikashop/views/report/view.html.php:419 9 reportViewReport->form() JROOT/administrator/components/com_hikashop/views/report/view.html.php:28 10 reportViewReport->display() JROOT/libraries/src/MVC/Controller/BaseController.php:660 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2582 12 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2300 13 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:693 14 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2560 15 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:73 16 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71 17 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73 18 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361 19 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:143 20 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:186 21 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:293 22 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:61 23 require_once() JROOT/administrator/index.php:32 Hi, I'm trying to generate a table based report that includes the 'total customers' option, see here for details: scribehow.com/shared/Generate_a_Customer...DKl9nPTMSeTaLdlj5yuA When report is saved I get a page stating An error has occurred. 1054 Unknown column 'o.order_created' in 'where clause' Doing this with debug turned on gives me: Call stack # Function Location 1 () JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:141 2 Joomla\Database\Mysqli\MysqliStatement->__construct() JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:1089 3 Joomla\Database\Mysqli\MysqliDriver->prepareStatement() JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:1900 4 Joomla\Database\DatabaseDriver->setQuery() JROOT/administrator/components/com_hikashop/classes/widget.php:1232 5 hikashopWidgetClass->data() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:52 6 dashboardViewDashboard->widget() JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:17 7 dashboardViewDashboard->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:936 8 hikashop_getLayout() JROOT/administrator/components/com_hikashop/views/report/view.html.php:419 9 reportViewReport->form() JROOT/administrator/components/com_hikashop/views/report/view.html.php:28 10 reportViewReport->display() JROOT/libraries/src/MVC/Controller/BaseController.php:660 11 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2582 12 hikashopController->display() JROOT/administrator/components/com_hikashop/helpers/helper.php:2300 13 hikashopController->edit() JROOT/libraries/src/MVC/Controller/BaseController.php:693 14 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2560 15 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:73 16 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71 17 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73 18 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:361 19 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:143 20 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:186 21 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:293 22 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:61 23 require_once() JROOT/administrator/index.php:32 Do you have any ideas how I can resolve this? Thanks in advance. KH")* Thanks Nicolas, All working now. KH The following user(s) said Thank You: [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy85MDgxODAtMTA1NC11bmtub3duLWNvbHVtbi1vLW9yZGVyLWNyZWF0ZWQtaW4td2hlcmUtY2xhdXNlLXdoZW4tZ2VuZXJhdGluZy1yZXBvcnQ/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.143 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)