In my admin panel when i click sale>order and choose any date and click filter then i get this error:-
Fatal error: Uncaught exception 'ErrorException' with message 'Error: Unknown column 'o.date_modified' in 'where clause'<br />Error No: 1054<br />SELECT COUNT(*) AS total FROM `oc_order` WHERE order_status_id > '0' AND DATE(o.date_modified) = DATE('2017-06-27')' in /home/ebozajk3/public_html/system/database/mysqli.php:41 Stack trace: #0 /home/ebozajk3/public_html/vqmod/vqcache/vq2-system_library_db.php(32): DBMySQLi->query('SELECT COUNT(*)...') #1 /home/ebozajk3/public_html/vqmod/vqcache/vq2-admin_model_sale_order.php(651): DB->query('SELECT COUNT(*)...') #2 /home/ebozajk3/public_html/vqmod/vqcache/vq2-admin_controller_sale_order.php(395): ModelSaleOrder->getTotalOrders(Array) #3 /home/ebozajk3/public_html/vqmod/vqcache/vq2-admin_controller_sale_order.php(19): ControllerSaleOrder->getList() #4 [internal function]: ControllerSaleOrder->index() #5 /home/ebozajk3/public_html/vqmod/vqcache/vq2-system_engine_front.php(42): call_user_func_array(Array, Array) #6 /home/ebozajk3/public_html/vqmod/vqcache/vq2-system_engine_front.ph in /home/ebozajk3/public_html/system/database/mysqli.php on line 41
How can i solve this issue? Please someone help me. I want urgent help.
Fatal error: Uncaught exception 'ErrorException' with message 'Error: Unknown column 'o.date_modified' in 'where clause'<br />Error No: 1054<br />SELECT COUNT(*) AS total FROM `oc_order` WHERE order_status_id > '0' AND DATE(o.date_modified) = DATE('2017-06-27')' in /home/ebozajk3/public_html/system/database/mysqli.php:41 Stack trace: #0 /home/ebozajk3/public_html/vqmod/vqcache/vq2-system_library_db.php(32): DBMySQLi->query('SELECT COUNT(*)...') #1 /home/ebozajk3/public_html/vqmod/vqcache/vq2-admin_model_sale_order.php(651): DB->query('SELECT COUNT(*)...') #2 /home/ebozajk3/public_html/vqmod/vqcache/vq2-admin_controller_sale_order.php(395): ModelSaleOrder->getTotalOrders(Array) #3 /home/ebozajk3/public_html/vqmod/vqcache/vq2-admin_controller_sale_order.php(19): ControllerSaleOrder->getList() #4 [internal function]: ControllerSaleOrder->index() #5 /home/ebozajk3/public_html/vqmod/vqcache/vq2-system_engine_front.php(42): call_user_func_array(Array, Array) #6 /home/ebozajk3/public_html/vqmod/vqcache/vq2-system_engine_front.ph in /home/ebozajk3/public_html/system/database/mysqli.php on line 41
How can i solve this issue? Please someone help me. I want urgent help.
I want urgent help.
Well, I want a million dollars! ASAP!
It shows a:
Error: Unknown column 'o.date_modified'
but there is no such column in an OC DB by default, just a:
`date_modified`
Ernie
Well, I want a million dollars! ASAP!
It shows a:
Error: Unknown column 'o.date_modified'
but there is no such column in an OC DB by default, just a:
`date_modified`
Ernie
My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
well, it's related to some (unknown to me) extension you use,
and usually, if such an extension is installed, it has some ROUTINE
included, to add an additional table and it's columns to the database.
---
some of the VqMods, using this:
<id>vQmod - Improved Order Screen</id>
<version>1.4.x and 1.5.x</version>
<vqmver>2.4.0</vqmver>
---
<id>Dashboard Latest Tabs</id>
<version>1.2.0</version>
<vqmver>2.1.7</vqmver>
---
<id><![CDATA[Birthday Coupon]]></id>
<version><![CDATA[1]]></version>
<vqmver><![CDATA[2.16]]></vqmver>
---
But without beeing aware, wich extension(s) you use, it's not possible to tell.
Ernie
and usually, if such an extension is installed, it has some ROUTINE
included, to add an additional table and it's columns to the database.
---
some of the VqMods, using this:
<id>vQmod - Improved Order Screen</id>
<version>1.4.x and 1.5.x</version>
<vqmver>2.4.0</vqmver>
---
<id>Dashboard Latest Tabs</id>
<version>1.2.0</version>
<vqmver>2.1.7</vqmver>
---
<id><![CDATA[Birthday Coupon]]></id>
<version><![CDATA[1]]></version>
<vqmver><![CDATA[2.16]]></vqmver>
---
But without beeing aware, wich extension(s) you use, it's not possible to tell.
Ernie
My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
Sorry, I don't do any work outside of this place, and have PM
not active on reception, so, better just tell us, wich Mod's you use,
then, I could possibly be of assistance.
Ernie
not active on reception, so, better just tell us, wich Mod's you use,
then, I could possibly be of assistance.
Ernie
My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
Mod = Modification
Modification = Extension
but don't ask me now what an extention may be, because if you don't know either,
then, you'll need a Professional, to care about your Problem.
Modification = Extension
but don't ask me now what an extention may be, because if you don't know either,
then, you'll need a Professional, to care about your Problem.
My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
Who is online
Users browsing this forum: No registered users and 166 guests