OpenCart Community

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.

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

Please help me, how can I solve this error?

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

Give me your email or Private message details, i will send my ftp details.

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

I don't understand the mod. Please tell me what you want.

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.

Last time i installed in my store, these extension:- Ship2Pay, X-Shipping Pro and Zipcode Pincode Postcode Checker.