4.7.2 - Issue copying orders

  • Posts: 130
  • Thank you received: 2
  • Hikashop Business
1 year 8 months ago #350318

-- 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


Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
1 year 8 months ago #350321

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.

Please Log in or Create an account to join the conversation.

  • Posts: 130
  • Thank you received: 2
  • Hikashop Business
1 year 8 months ago #350324

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

Please Log in or Create an account to join the conversation.

Time to create page: 0.065 seconds
Powered by Kunena Forum