4.7.2 - Issue copying orders

-- HikaShop version -- : 4.7.2
-- Joomla version -- : 4.2.9
-- PHP version -- : 8.0
-- Browser(s) name and version -- : All
-- Error-message(debug-mod must be tuned on) -- : Er heeft zich een fout voorgedaan.
1054 Unknown column 'total_number_of_products' in 'field list'
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:1048
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/helpers/helper.php:2510
5 hikashopClass->save() JROOT/administrator/components/com_hikashop/classes/order.php:207
6 hikashopOrderClass->save() JROOT/administrator/components/com_hikashop/classes/order.php:2199
7 hikashopOrderClass->copyOrder() JROOT/administrator/components/com_hikashop/controllers/order.php:576
8 OrderController->copy() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2437
10 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:73
11 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
12 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
13 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:355
14 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:143
15 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:186
16 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:294
17 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:61
18 require_once() JROOT/administrator/index.php:32

Directly after upgrading to 4.7.2 a bug was introduced:

When I select an order in the orders-overview and click the Copy button, an error occurrs, and the order is not copied to a new one. The error is:

1054 Unknown column 'total_number_of_products' in 'field list'

With maximum error reporting and debog on, the following errors are shown:

========================================================

Er heeft zich een fout voorgedaan.
1054 Unknown column 'total_number_of_products' in 'field list'
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:1048
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/helpers/helper.php:2510
5 hikashopClass->save() JROOT/administrator/components/com_hikashop/classes/order.php:207
6 hikashopOrderClass->save() JROOT/administrator/components/com_hikashop/classes/order.php:2199
7 hikashopOrderClass->copyOrder() JROOT/administrator/components/com_hikashop/controllers/order.php:576
8 OrderController->copy() JROOT/libraries/src/MVC/Controller/BaseController.php:672
9 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2437
10 hikashopController->execute() JROOT/administrator/components/com_hikashop/hikashop.php:73
11 require_once() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
12 Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}() JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
13 Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT/libraries/src/Component/ComponentHelper.php:355
14 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:143
15 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:186
16 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:294
17 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/includes/app.php:61
18 require_once() JROOT/administrator/index.php:32

Hi,

Thank you for your feedback. We've made a patch for that issue.
Download again the install package of HikaShop 4.7.2 on our website and install it on yours and you'll get the patch.

Hi Nicolas, this indeed fixed the issue, thank you for your swift response