add product to cart error

hello

i face this problem recently whenever i try to add product to the cart
i use opencart 3.0.3.2 and journal theme v 3
the store was working fine until this error happened

Fatal error: Uncaught Exception: Error: Table 'arabarcc_oc.oc_order_cart' doesn't exist<br />Error No: 1146<br />SELECT * FROM oc_order_cart WHERE product_id = '573' in /home/arabarcc/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /home/arabarcc/storage/modification/system/library/db.php(58): DB\MySQLi->query('SELECT * FROM o...') #1 /home/arabarcc/storage/modification/system/library/cart/cart.php(220): DB->query('SELECT * FROM o...') #2 /home/arabarcc/storage/modification/system/library/cart/cart.php(340): Cart\Cart->getProducts() #3 /home/arabarcc/storage/modification/catalog/controller/common/cart.php(10): Cart\Cart->getTaxes() #4 /home/arabarcc/storage/modification/system/engine/action.php(79): ControllerCommonCart->index(Array) #5 /home/arabarcc/storage/modification/system/engine/loader.php(51): Action->execute(Object(Registry), Array) #6 /home/arabarcc/storage/modification/catalog/controller/common/header.php(252): Loader->controller('common/cart') #7 /home/arabarcc/storage/modification/system/engine/ac in /home/arabarcc/public_html/system/library/db/mysqli.php on line 40

please help me

thank you

Hi

Well your error says

Table 'arabarcc_oc.oc_order_cart' doesn't exist

This means the table does not exist in the database


To resolve you will need to find the modification and either remove it or ask the developer to fix it
You could try to add the table yourself manually, but you will need to know which fields and what conditions.

It is also possible that you have uninstalled the modification (which has deleted the table) and not refreshed your cache

thanks @by mona

i wondered what cause that because i didn't add anything related to cart

i added the table oc_order_cart then i added product_id inside it and voila

arabarc wrote: ↑

Sun Dec 08, 2019 11:35 pm

i wondered what cause that because i didn't add anything related to cart

100% that table was created by an ocmod extension, vqmod extension or module.
Because on a clean install there is no oc_order_cart table

xxvirusxx wrote: ↑

Mon Dec 09, 2019 1:01 am

100% that table was created by an ocmod extension, vqmod extension or module.

I think the problem is that it was NOT created by the modification .. or that the modification has been uninstalled and cache not refreshed .. either way it could not ‘just have happened’ without a change somewhere ..

xxvirusxx is quite correct order_cart is not Opencart installation

thanks @by mona

i wondered what cause that because i didn't add anything related to cart

i added the table oc_order_cart then i added product_id inside it and voila

I am glad this is “voila” .. and you are welcome ... but you still probably need to find the modification .. or clean out your cache ...
It may be that it is not actually fixed, but you have resolved an element of it ...

by mona wrote: ↑

Mon Dec 09, 2019 1:58 am

xxvirusxx wrote: ↑

Mon Dec 09, 2019 1:01 am

100% that table was created by an ocmod extension, vqmod extension or module.

I think the problem is that it was NOT created by the modification .. or that the modification has been uninstalled and cache not refreshed .. either way it could not ‘just have happened’ without a change somewhere ..

xxvirusxx is quite correct order_cart is not Opencart installation

thanks @by mona

i wondered what cause that because i didn't add anything related to cart

i added the table oc_order_cart then i added product_id inside it and voila

I am glad this is “voila” .. and you are welcome ... but you still probably need to find the modification .. or clean out your cache ...
It may be that it is not actually fixed, but you have resolved an element of it ...

true i did little dig it was from this extension called Update Product Prices in Order and i get rid of it because it wasn't work with oc 3.0.2.3

i have another issue if you knew the solution my cart do not refresh unless i hit refresh button v.v

Now, contact Journal team

For that extension maybe @thekrotek can help you
https://www.opencart.com/index.php?rout ... n_id=36677