[Skip to main content](#vessel-content)

#   error in checkout after update to 4.7.4

##

- **[comyoo](/forum/user/1145-comyoo "View comyoo's Profile")**
- [![comyoo's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1145.png)](/forum/user/1145-comyoo "View comyoo's Profile") Topic Author
- [ Offline](/forum/user/1145-comyoo)

Less More

- Posts: 97
- Thank you received: 0
-
-

3 years 4 months ago [\#352923](#352923) by [comyoo](/forum/user/1145-comyoo "View comyoo's Profile")  *[error in checkout after update to 4.7.4](/forum/25-install-update/906643-error-in-checkout-after-update-to-4-7-4#352923 "-- url of the page with the problem -- :   www.geertswarenhui  -- HikaShop version -- : 4.7.4 -- Joomla version -- : 3.10.11 -- PHP version -- : 8.1.18 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Unknown column 'total&#95;number&#95;of&#95;products' in 'field list'  Startpagina Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:610 2 mysqli&#95;query() JROOT/libraries/joomla/database/driver/mysqli.php:610 3 JDatabaseDriverMysqli-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2515 4 hikashopClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:208 5 hikashopOrderClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:913 6 hikashopOrderClass-&gt;createFromCart() JROOT/components/com&#95;hikashop/controllers/checkout.php:678 7 checkoutController-&gt;confirm() JROOT/libraries/src/MVC/Controller/BaseController.php:702 8 Joomla&#92;CMS&#92;MVC&#92;Controller&#92;BaseController-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2441 9 hikashopController-&gt;execute() JROOT/components/com&#95;hikashop/hikashop.php:88 10 require&#95;once() JROOT/libraries/src/Component/ComponentHelper.php:402 11 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 12 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 13 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 14 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 15 Joomla&#92;CMS&#92;Application&#92;CMSApplication-&gt;execute() JROOT/index.php:49  Hi,  Very serious problem: my customers can't order right now: Unknown column 'total&#95;number&#95;of&#95;products' in 'field list'  Startpagina Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:610 2 mysqli&#95;query() JROOT/libraries/joomla/database/driver/mysqli.php:610 3 JDatabaseDriverMysqli-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2515 4 hikashopClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:208 5 hikashopOrderClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:913 6 hikashopOrderClass-&gt;createFromCart() JROOT/components/com&#95;hikashop/controllers/checkout.php:678 7 checkoutController-&gt;confirm() JROOT/libraries/src/MVC/Controller/BaseController.php:702 8 Joomla&#92;CMS&#92;MVC&#92;Controller&#92;BaseController-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2441 9 hikashopController-&gt;execute() JROOT/components/com&#95;hikashop/hikashop.php:88 10 require&#95;once() JROOT/libraries/src/Component/ComponentHelper.php:402 11 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 12 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 13 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 14 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 15 Joomla&#92;CMS&#92;Application&#92;CMSApplication-&gt;execute() JROOT/index.php:49  What to do?")* was created by *[comyoo](/forum/user/1145-comyoo "View comyoo's Profile")*

-- url of the page with the problem -- : [ www.geertswarenhui](https://www.geertswarenhui)
-- HikaShop version -- : 4.7.4
-- Joomla version -- : 3.10.11
-- PHP version -- : 8.1.18
-- Browser(s) name and version -- : Chrome
-- Error-message(debug-mod must be tuned on) -- : Unknown column 'total_number_of_products' in 'field list'

Startpagina
Call stack
\# Function Location
1 () JROOT/libraries/joomla/database/driver/mysqli.php:610
2 mysqli_query() JROOT/libraries/joomla/database/driver/mysqli.php:610
3 JDatabaseDriverMysqli-&gt;execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2515
4 hikashopClass-&gt;save() JROOT/administrator/components/com_hikashop/classes/order.php:208
5 hikashopOrderClass-&gt;save() JROOT/administrator/components/com_hikashop/classes/order.php:913
6 hikashopOrderClass-&gt;createFromCart() JROOT/components/com_hikashop/controllers/checkout.php:678
7 checkoutController-&gt;confirm() JROOT/libraries/src/MVC/Controller/BaseController.php:702
8 Joomla\CMS\MVC\Controller\BaseController-&gt;execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2441
9 hikashopController-&gt;execute() JROOT/components/com_hikashop/hikashop.php:88
10 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402
11 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
12 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
13 Joomla\CMS\Application\SiteApplication-&gt;dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
14 Joomla\CMS\Application\SiteApplication-&gt;doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
15 Joomla\CMS\Application\CMSApplication-&gt;execute() JROOT/index.php:49

Hi,

Very serious problem: my customers can't order right now:
Unknown column 'total_number_of_products' in 'field list'

Startpagina
Call stack
\# Function Location
1 () JROOT/libraries/joomla/database/driver/mysqli.php:610
2 mysqli_query() JROOT/libraries/joomla/database/driver/mysqli.php:610
3 JDatabaseDriverMysqli-&gt;execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2515
4 hikashopClass-&gt;save() JROOT/administrator/components/com_hikashop/classes/order.php:208
5 hikashopOrderClass-&gt;save() JROOT/administrator/components/com_hikashop/classes/order.php:913
6 hikashopOrderClass-&gt;createFromCart() JROOT/components/com_hikashop/controllers/checkout.php:678
7 checkoutController-&gt;confirm() JROOT/libraries/src/MVC/Controller/BaseController.php:702
8 Joomla\CMS\MVC\Controller\BaseController-&gt;execute() JROOT/administrator/components/com_hikashop/helpers/helper.php:2441
9 hikashopController-&gt;execute() JROOT/components/com_hikashop/hikashop.php:88
10 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402
11 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
12 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
13 Joomla\CMS\Application\SiteApplication-&gt;dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
14 Joomla\CMS\Application\SiteApplication-&gt;doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
15 Joomla\CMS\Application\CMSApplication-&gt;execute() JROOT/index.php:49

What to do?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNjY0My1lcnJvci1pbi1jaGVja291dC1hZnRlci11cGRhdGUtdG8tNC03LTQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26400
- Thank you received: 4080
-
- [](http://obsi.dev)
-

3 years 4 months ago [\#352925](#352925) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[error in checkout after update to 4.7.4](/forum/25-install-update/906643-error-in-checkout-after-update-to-4-7-4#352925 "-- url of the page with the problem -- :   www.geertswarenhui  -- HikaShop version -- : 4.7.4 -- Joomla version -- : 3.10.11 -- PHP version -- : 8.1.18 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Unknown column 'total&#95;number&#95;of&#95;products' in 'field list'  Startpagina Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:610 2 mysqli&#95;query() JROOT/libraries/joomla/database/driver/mysqli.php:610 3 JDatabaseDriverMysqli-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2515 4 hikashopClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:208 5 hikashopOrderClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:913 6 hikashopOrderClass-&gt;createFromCart() JROOT/components/com&#95;hikashop/controllers/checkout.php:678 7 checkoutController-&gt;confirm() JROOT/libraries/src/MVC/Controller/BaseController.php:702 8 Joomla&#92;CMS&#92;MVC&#92;Controller&#92;BaseController-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2441 9 hikashopController-&gt;execute() JROOT/components/com&#95;hikashop/hikashop.php:88 10 require&#95;once() JROOT/libraries/src/Component/ComponentHelper.php:402 11 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 12 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 13 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 14 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 15 Joomla&#92;CMS&#92;Application&#92;CMSApplication-&gt;execute() JROOT/index.php:49  Hi,  Very serious problem: my customers can't order right now: Unknown column 'total&#95;number&#95;of&#95;products' in 'field list'  Startpagina Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:610 2 mysqli&#95;query() JROOT/libraries/joomla/database/driver/mysqli.php:610 3 JDatabaseDriverMysqli-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2515 4 hikashopClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:208 5 hikashopOrderClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:913 6 hikashopOrderClass-&gt;createFromCart() JROOT/components/com&#95;hikashop/controllers/checkout.php:678 7 checkoutController-&gt;confirm() JROOT/libraries/src/MVC/Controller/BaseController.php:702 8 Joomla&#92;CMS&#92;MVC&#92;Controller&#92;BaseController-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2441 9 hikashopController-&gt;execute() JROOT/components/com&#95;hikashop/hikashop.php:88 10 require&#95;once() JROOT/libraries/src/Component/ComponentHelper.php:402 11 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 12 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 13 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 14 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 15 Joomla&#92;CMS&#92;Application&#92;CMSApplication-&gt;execute() JROOT/index.php:49  What to do?")*

Hello,

Please use "check database" in your HikaShop configuration toolbar.
[ www.hikashop.com/support/documentation/5...-config.html#toolbar](https://www.hikashop.com/support/documentation/54-hikashop-config.html#toolbar)

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNjY0My1lcnJvci1pbi1jaGVja291dC1hZnRlci11cGRhdGUtdG8tNC03LTQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[comyoo](/forum/user/1145-comyoo "View comyoo's Profile")**
- [![comyoo's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1145.png)](/forum/user/1145-comyoo "View comyoo's Profile") Topic Author
- [ Offline](/forum/user/1145-comyoo)

Less More

- Posts: 97
- Thank you received: 0
-
-

3 years 4 months ago [\#353000](#353000) by [comyoo](/forum/user/1145-comyoo "View comyoo's Profile")  Replied by *[comyoo](/forum/user/1145-comyoo "View comyoo's Profile")* on topic *[error in checkout after update to 4.7.4](/forum/25-install-update/906643-error-in-checkout-after-update-to-4-7-4#353000 "-- url of the page with the problem -- :   www.geertswarenhui  -- HikaShop version -- : 4.7.4 -- Joomla version -- : 3.10.11 -- PHP version -- : 8.1.18 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Unknown column 'total&#95;number&#95;of&#95;products' in 'field list'  Startpagina Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:610 2 mysqli&#95;query() JROOT/libraries/joomla/database/driver/mysqli.php:610 3 JDatabaseDriverMysqli-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2515 4 hikashopClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:208 5 hikashopOrderClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:913 6 hikashopOrderClass-&gt;createFromCart() JROOT/components/com&#95;hikashop/controllers/checkout.php:678 7 checkoutController-&gt;confirm() JROOT/libraries/src/MVC/Controller/BaseController.php:702 8 Joomla&#92;CMS&#92;MVC&#92;Controller&#92;BaseController-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2441 9 hikashopController-&gt;execute() JROOT/components/com&#95;hikashop/hikashop.php:88 10 require&#95;once() JROOT/libraries/src/Component/ComponentHelper.php:402 11 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 12 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 13 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 14 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 15 Joomla&#92;CMS&#92;Application&#92;CMSApplication-&gt;execute() JROOT/index.php:49  Hi,  Very serious problem: my customers can't order right now: Unknown column 'total&#95;number&#95;of&#95;products' in 'field list'  Startpagina Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:610 2 mysqli&#95;query() JROOT/libraries/joomla/database/driver/mysqli.php:610 3 JDatabaseDriverMysqli-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2515 4 hikashopClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:208 5 hikashopOrderClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:913 6 hikashopOrderClass-&gt;createFromCart() JROOT/components/com&#95;hikashop/controllers/checkout.php:678 7 checkoutController-&gt;confirm() JROOT/libraries/src/MVC/Controller/BaseController.php:702 8 Joomla&#92;CMS&#92;MVC&#92;Controller&#92;BaseController-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2441 9 hikashopController-&gt;execute() JROOT/components/com&#95;hikashop/hikashop.php:88 10 require&#95;once() JROOT/libraries/src/Component/ComponentHelper.php:402 11 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 12 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 13 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 14 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 15 Joomla&#92;CMS&#92;Application&#92;CMSApplication-&gt;execute() JROOT/index.php:49  What to do?")*

HI Jerome,

That was also my first thought, but I already did that and all the tables were ok / green.

I set my website back to the backup of the day before update and every is working again.
Very strange.

Do you have any other idea?
So the latest version did not work, backup before the update is working, but is says that is has version: You have the latest stable version of HikaShop Business: 4.7.4

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNjY0My1lcnJvci1pbi1jaGVja291dC1hZnRlci11cGRhdGUtdG8tNC03LTQ/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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

3 years 4 months ago [\#353003](#353003) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[error in checkout after update to 4.7.4](/forum/25-install-update/906643-error-in-checkout-after-update-to-4-7-4#353003 "-- url of the page with the problem -- :   www.geertswarenhui  -- HikaShop version -- : 4.7.4 -- Joomla version -- : 3.10.11 -- PHP version -- : 8.1.18 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Unknown column 'total&#95;number&#95;of&#95;products' in 'field list'  Startpagina Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:610 2 mysqli&#95;query() JROOT/libraries/joomla/database/driver/mysqli.php:610 3 JDatabaseDriverMysqli-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2515 4 hikashopClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:208 5 hikashopOrderClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:913 6 hikashopOrderClass-&gt;createFromCart() JROOT/components/com&#95;hikashop/controllers/checkout.php:678 7 checkoutController-&gt;confirm() JROOT/libraries/src/MVC/Controller/BaseController.php:702 8 Joomla&#92;CMS&#92;MVC&#92;Controller&#92;BaseController-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2441 9 hikashopController-&gt;execute() JROOT/components/com&#95;hikashop/hikashop.php:88 10 require&#95;once() JROOT/libraries/src/Component/ComponentHelper.php:402 11 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 12 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 13 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 14 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 15 Joomla&#92;CMS&#92;Application&#92;CMSApplication-&gt;execute() JROOT/index.php:49  Hi,  Very serious problem: my customers can't order right now: Unknown column 'total&#95;number&#95;of&#95;products' in 'field list'  Startpagina Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:610 2 mysqli&#95;query() JROOT/libraries/joomla/database/driver/mysqli.php:610 3 JDatabaseDriverMysqli-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2515 4 hikashopClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:208 5 hikashopOrderClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:913 6 hikashopOrderClass-&gt;createFromCart() JROOT/components/com&#95;hikashop/controllers/checkout.php:678 7 checkoutController-&gt;confirm() JROOT/libraries/src/MVC/Controller/BaseController.php:702 8 Joomla&#92;CMS&#92;MVC&#92;Controller&#92;BaseController-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2441 9 hikashopController-&gt;execute() JROOT/components/com&#95;hikashop/hikashop.php:88 10 require&#95;once() JROOT/libraries/src/Component/ComponentHelper.php:402 11 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 12 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 13 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 14 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 15 Joomla&#92;CMS&#92;Application&#92;CMSApplication-&gt;execute() JROOT/index.php:49  What to do?")*

Hi,

This error indicates that the total_number_of_products column in the table hikashop_order is missing.
This column is supposed to be added to the database during the update.
And the "check database" button is also supposed to add it there.
Without that column, it's normal you're getting that error.
If both the update and the check database processes are not able to add it, you can always go in your PHPMyAdmin and add that column to the hikashop_order table:
[ www.pair.com/support/kb/adding-a-column-...abase-in-phpmyadmin/](https://www.pair.com/support/kb/adding-a-column-to-a-database-in-phpmyadmin/)
The type "int" will be ok.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNjY0My1lcnJvci1pbi1jaGVja291dC1hZnRlci11cGRhdGUtdG8tNC03LTQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[comyoo](/forum/user/1145-comyoo "View comyoo's Profile")**
- [![comyoo's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1145.png)](/forum/user/1145-comyoo "View comyoo's Profile") Topic Author
- [ Offline](/forum/user/1145-comyoo)

Less More

- Posts: 97
- Thank you received: 0
-
-

3 years 4 months ago [\#353042](#353042) by [comyoo](/forum/user/1145-comyoo "View comyoo's Profile")  Replied by *[comyoo](/forum/user/1145-comyoo "View comyoo's Profile")* on topic *[error in checkout after update to 4.7.4](/forum/25-install-update/906643-error-in-checkout-after-update-to-4-7-4#353042 "-- url of the page with the problem -- :   www.geertswarenhui  -- HikaShop version -- : 4.7.4 -- Joomla version -- : 3.10.11 -- PHP version -- : 8.1.18 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Unknown column 'total&#95;number&#95;of&#95;products' in 'field list'  Startpagina Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:610 2 mysqli&#95;query() JROOT/libraries/joomla/database/driver/mysqli.php:610 3 JDatabaseDriverMysqli-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2515 4 hikashopClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:208 5 hikashopOrderClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:913 6 hikashopOrderClass-&gt;createFromCart() JROOT/components/com&#95;hikashop/controllers/checkout.php:678 7 checkoutController-&gt;confirm() JROOT/libraries/src/MVC/Controller/BaseController.php:702 8 Joomla&#92;CMS&#92;MVC&#92;Controller&#92;BaseController-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2441 9 hikashopController-&gt;execute() JROOT/components/com&#95;hikashop/hikashop.php:88 10 require&#95;once() JROOT/libraries/src/Component/ComponentHelper.php:402 11 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 12 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 13 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 14 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 15 Joomla&#92;CMS&#92;Application&#92;CMSApplication-&gt;execute() JROOT/index.php:49  Hi,  Very serious problem: my customers can't order right now: Unknown column 'total&#95;number&#95;of&#95;products' in 'field list'  Startpagina Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:610 2 mysqli&#95;query() JROOT/libraries/joomla/database/driver/mysqli.php:610 3 JDatabaseDriverMysqli-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2515 4 hikashopClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:208 5 hikashopOrderClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:913 6 hikashopOrderClass-&gt;createFromCart() JROOT/components/com&#95;hikashop/controllers/checkout.php:678 7 checkoutController-&gt;confirm() JROOT/libraries/src/MVC/Controller/BaseController.php:702 8 Joomla&#92;CMS&#92;MVC&#92;Controller&#92;BaseController-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2441 9 hikashopController-&gt;execute() JROOT/components/com&#95;hikashop/hikashop.php:88 10 require&#95;once() JROOT/libraries/src/Component/ComponentHelper.php:402 11 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 12 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 13 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 14 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 15 Joomla&#92;CMS&#92;Application&#92;CMSApplication-&gt;execute() JROOT/index.php:49  What to do?")*

It is indeed missing in the databse, but...
In the SQL file of installation it is also missing... Or do I look over it? When I download the package, browse to back &gt; tables.sql
Is the name 'total_number_of_products or order_total_numer_of_products?
Code:

CREATE TABLE IF NOT EXISTS &#96;#__hikashop_order&#96; ( &#96;order_id&#96; int(10) unsigned NOT NULL AUTO_INCREMENT, &#96;order_billing_address_id&#96; int(10) unsigned NOT NULL DEFAULT '0', &#96;order_shipping_address_id&#96; int(10) unsigned NOT NULL DEFAULT '0', &#96;order_user_id&#96; int(10) unsigned NOT NULL DEFAULT '0', &#96;order_parent_id&#96; int(10) unsigned NOT NULL DEFAULT '0', &#96;order_status&#96; varchar(255) NOT NULL DEFAULT '', &#96;order_type&#96; varchar(255) NOT NULL DEFAULT 'sale', &#96;order_number&#96; varchar(255) NOT NULL DEFAULT '', &#96;order_created&#96; int(10) unsigned NOT NULL DEFAULT '0', &#96;order_modified&#96; int(10) unsigned NOT NULL DEFAULT '0', &#96;order_invoice_id&#96; int(10) unsigned NOT NULL DEFAULT '0', &#96;order_invoice_number&#96; varchar(255) NOT NULL DEFAULT '', &#96;order_invoice_created&#96; int(10) unsigned NOT NULL DEFAULT '0', &#96;order_currency_id&#96; int(10) unsigned NOT NULL DEFAULT '0', &#96;order_currency_info&#96; TEXT NULL, &#96;order_full_price&#96; decimal(17,5) NOT NULL DEFAULT '0.00000', &#96;order_tax_info&#96; TEXT NULL, &#96;order_discount_code&#96; varchar(255) NOT NULL DEFAULT '', &#96;order_discount_price&#96; decimal(17,5) NOT NULL DEFAULT '0.00000', &#96;order_discount_tax&#96; decimal(17,5) NOT NULL DEFAULT '0.00000', &#96;order_payment_id&#96; varchar(255) NOT NULL DEFAULT '', &#96;order_payment_method&#96; varchar(255) NOT NULL DEFAULT '', &#96;order_payment_price&#96; decimal(17,5) NOT NULL DEFAULT '0.00000', &#96;order_payment_tax&#96; decimal(17,5) NOT NULL DEFAULT '0.00000', &#96;order_payment_params&#96; TEXT NULL, &#96;order_shipping_id&#96; varchar(255) NOT NULL DEFAULT '', &#96;order_shipping_method&#96; varchar(255) NOT NULL DEFAULT '', &#96;order_shipping_price&#96; decimal(17,5) NOT NULL DEFAULT '0.00000', &#96;order_shipping_tax&#96; decimal(17,5) NOT NULL DEFAULT '0.00000', &#96;order_shipping_params&#96; TEXT NULL, &#96;order_partner_id&#96; int(10) unsigned NOT NULL DEFAULT '0', &#96;order_partner_price&#96; decimal(17,5) NOT NULL DEFAULT '0.00000', &#96;order_partner_paid&#96; int(11) NOT NULL DEFAULT '0', &#96;order_partner_currency_id&#96; int(10) unsigned NOT NULL DEFAULT '0', &#96;order_ip&#96; varchar(255) NOT NULL DEFAULT '', &#96;order_site_id&#96; varchar(255) NULL DEFAULT '', &#96;order_lang&#96; varchar(255) NULL DEFAULT '', &#96;order_token&#96; varchar(255) NULL DEFAULT '', &#96;order_weight&#96; decimal(12,3) unsigned NULL, &#96;order_weight_unit&#96; varchar(255) NULL, &#96;order_volume&#96; decimal(12,3) unsigned NULL, &#96;order_dimension_unit&#96; varchar(255) NULL, PRIMARY KEY (&#96;order_id&#96;), KEY &#96;order_user_id&#96; (&#96;order_user_id&#96;) ) ENGINE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNjY0My1lcnJvci1pbi1jaGVja291dC1hZnRlci11cGRhdGUtdG8tNC03LTQ/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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86561
- Thank you received: 14307
-
-

3 years 4 months ago [\#353047](#353047) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[error in checkout after update to 4.7.4](/forum/25-install-update/906643-error-in-checkout-after-update-to-4-7-4#353047 "-- url of the page with the problem -- :   www.geertswarenhui  -- HikaShop version -- : 4.7.4 -- Joomla version -- : 3.10.11 -- PHP version -- : 8.1.18 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : Unknown column 'total&#95;number&#95;of&#95;products' in 'field list'  Startpagina Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:610 2 mysqli&#95;query() JROOT/libraries/joomla/database/driver/mysqli.php:610 3 JDatabaseDriverMysqli-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2515 4 hikashopClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:208 5 hikashopOrderClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:913 6 hikashopOrderClass-&gt;createFromCart() JROOT/components/com&#95;hikashop/controllers/checkout.php:678 7 checkoutController-&gt;confirm() JROOT/libraries/src/MVC/Controller/BaseController.php:702 8 Joomla&#92;CMS&#92;MVC&#92;Controller&#92;BaseController-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2441 9 hikashopController-&gt;execute() JROOT/components/com&#95;hikashop/hikashop.php:88 10 require&#95;once() JROOT/libraries/src/Component/ComponentHelper.php:402 11 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 12 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 13 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 14 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 15 Joomla&#92;CMS&#92;Application&#92;CMSApplication-&gt;execute() JROOT/index.php:49  Hi,  Very serious problem: my customers can't order right now: Unknown column 'total&#95;number&#95;of&#95;products' in 'field list'  Startpagina Call stack # Function Location 1 () JROOT/libraries/joomla/database/driver/mysqli.php:610 2 mysqli&#95;query() JROOT/libraries/joomla/database/driver/mysqli.php:610 3 JDatabaseDriverMysqli-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2515 4 hikashopClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:208 5 hikashopOrderClass-&gt;save() JROOT/administrator/components/com&#95;hikashop/classes/order.php:913 6 hikashopOrderClass-&gt;createFromCart() JROOT/components/com&#95;hikashop/controllers/checkout.php:678 7 checkoutController-&gt;confirm() JROOT/libraries/src/MVC/Controller/BaseController.php:702 8 Joomla&#92;CMS&#92;MVC&#92;Controller&#92;BaseController-&gt;execute() JROOT/administrator/components/com&#95;hikashop/helpers/helper.php:2441 9 hikashopController-&gt;execute() JROOT/components/com&#95;hikashop/hikashop.php:88 10 require&#95;once() JROOT/libraries/src/Component/ComponentHelper.php:402 11 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 12 Joomla&#92;CMS&#92;Component&#92;ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 13 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 14 Joomla&#92;CMS&#92;Application&#92;SiteApplication-&gt;doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 15 Joomla&#92;CMS&#92;Application&#92;CMSApplication-&gt;execute() JROOT/index.php:49  What to do?")*

Hi,

Indeed. The message from Jerome actually missled me to a wrong conclusion.
There is no such column and it's normal.
You can always create it and it will solve the problem. But it should not be necessary.
I suppose you must be using some 3rd party plugin implementing the onBeforeOrderCreate event and messing with the order object before it is saved.
I've made some modifications in the way HikaShop deals with that total_number_of_products value so that it can't create an error in such cases.
Download the HikaShop install package on our website and install it on yours to get the patch and you should not get the error anymore, even without the column in the database.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzkwNjY0My1lcnJvci1pbi1jaGVja291dC1hZnRlci11cGRhdGUtdG8tNC03LTQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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.058 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
