Post by coolhaka » Tue Jun 27, 2017 9:17 pm

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.

New member

Posts

Joined
Fri Mar 28, 2014 4:21 am

Post by IP_CAM » Thu Jun 29, 2017 10:28 am

I want urgent help.
Well, I want a million dollars! ASAP! :D
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.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by coolhaka » Thu Jun 29, 2017 2:20 pm

Please help me, how can I solve this error?

New member

Posts

Joined
Fri Mar 28, 2014 4:21 am

Post by IP_CAM » Thu Jun 29, 2017 6:25 pm

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

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.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by coolhaka » Thu Jun 29, 2017 10:05 pm

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

New member

Posts

Joined
Fri Mar 28, 2014 4:21 am

Post by IP_CAM » Thu Jun 29, 2017 10:58 pm

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

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.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by coolhaka » Fri Jun 30, 2017 2:35 am

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

New member

Posts

Joined
Fri Mar 28, 2014 4:21 am

Post by IP_CAM » Fri Jun 30, 2017 8:36 am

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.

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.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by coolhaka » Mon Jul 03, 2017 6:35 pm

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

New member

Posts

Joined
Fri Mar 28, 2014 4:21 am
Who is online

Users browsing this forum: No registered users and 166 guests