Fieldtype, Module

Developer
Supported

VZ Buyers

ExpressionEngine 2

Back to this add-on's main page
View Other Add-ons From Eli Van Zoeren

     

You must be logged in to post.

[FIX] Bug in ft.vz_buyers.php & Store 1.6.5

General

Abe
Abe

So just installed this addon and there is a small error (I think caused by a change to Store)

You would get an error similar to this appearing on the edit entry page:

A Database Error Occurred
Error Number
1054

Unknown column 
'exp_store_order_items.order_completed_date' in 'where clause'

SELECT `exp_store_order_items`.`order_id`, `exp_store_order_items`.`item_qty`, `exp_store_orders`.`order_date`, `exp_store_orders`.`order_email`, `exp_store_orders`.`billing_nameFROM (`exp_store_order_items`) JOIN `exp_store_ordersON `exp_store_orders`.`order_id` = `exp_store_order_items`.`order_idWHERE `exp_store_order_items`.`entry_id` = '283' AND `exp_store_order_items`.`order_completed_date` > 0

Filename
third_party/vz_buyers/ft.vz_buyers.php

Line Number
57 

To fix it simply open up ‘ft.vz_buyers.php’ and change line 55 from:

->where('store_order_items.order_completed_date >'0

To:

->where('store_orders.order_completed_date >'0

(change the ‘store_order_items’ table reference)

Hope this helps some people