Orderlist bugs !!!

[kudviss]

hello I installed the contribution New_Improved_Orderlist_v5.1_Fixed. And when i select a costumer in the on the SELECT costumer drop menu, i see this message:

 

 

Order Listing Friday 07 December, 2007

 

 

1054 - Unknown column 'o.billing_telephone' in 'field list'

 

select o.orders_id, o.customers_id, o.customers_name, o.customers_email_address, o.billing_telephone, o.delivery_telephone, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.customers_id = '3' and o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC

 

[TEP STOP]

 

 

Could anyone please tell me what does this mean ??

 

many thanks

[insomniac2]

Sorry .. I still left some custom fields I use in the code. I took the billing_telephone and delivery_telephone out.

 

You can download the 5.1b corrected version now.

 

Let me know if that works for you.

 

Link: http://www.oscommerce.com/community/contributions,1836

[kudviss]

Sorry .. I still left some custom fields I use in the code. I took the billing_telephone and delivery_telephone out.

 

You can download the 5.1b corrected version now.

 

Let me know if that works for you.

 

Link: http://www.oscommerce.com/community/contributions,1836

 

 

Hi, the bug noticed above is fixed in your update contribution, but there is still something disturbing:

1- This TEXT_MANUFACTURER_UNAVAILABLE appears in the Orders Details.

2-When we filter using SELECT CLIENT, there is no informations displayed in the Client Details.

 

Account ID:

Company:

 

Customer Name: is displayed.

Default Address:

Suburb:

Location: , ,

ZIP / Post Code:

Telephone:

 

Billing Name:

Billing Address:

Suburb:

Location: , ,

ZIP / Post Code:

Delivery Name:

Delivery Address:

Suburb:

Location: , ,

ZIP / Post Code:

FAX:

 

 

Thank you for your efforts,

[kudviss]

Hi, the bug noticed above is fixed in your update contribution, but there is still something disturbing:

1- This TEXT_MANUFACTURER_UNAVAILABLE appears in the Orders Details.

2-When we filter using SELECT CLIENT, there is no informations displayed in the Client Details.

 

Account ID:

Company:

 

Customer Name: is displayed.

Default Address:

Suburb:

Location: , ,

ZIP / Post Code:

Telephone:

 

Billing Name:

Billing Address:

Suburb:

Location: , ,

ZIP / Post Code:

Delivery Name:

Delivery Address:

Suburb:

Location: , ,

ZIP / Post Code:

FAX:

Thank you for your efforts,

 

 

There a third bug, when we use the Search Filter + submit =

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'o.payment_method like '%david%' or o.cc_number like '%david%' order by o.orders' at line 1

 

select distinct * from orders o where o.orders_id like '%david%' or o.orders_id like '%david%' or o.customers_name like '%david%' or o.customers_id like '%david%' or o.customers_id like '%david%' or o.customers_company like '%david%' or o.customers_street_address like '%david%' or o.customers_suburb like '%david%' or o.customers_city like '%david%' or o.customers_postcode like '%david%' or o.customers_state like '%david%' or o.customers_country like '%david%' or o.customers_telephone like '%david%' or o.customers_email_address like '%david%' or o.delivery_name like '%david%' or o.delivery_company like '%david%' or o.delivery_street_address like '%david%' or o.delivery_suburb like '%david%' or o.delivery_city like '%david%' or o.delivery_postcode like '%david%' or o.delivery_state like '%david%' or o.delivery_country like '%david%' or o.billing_name like '%david%' or o.billing_company like '%david%' or o.billing_street_address like '%david%' or o.billing_suburb like '%david%' or o.billing_city like '%david%' or o.billing_postcode like '%david%' or o.billing_state like '%david%' or o.billing_country like '%david%' o.payment_method like '%david%' or o.cc_number like '%david%' order by o.orders_id DESC

 

[TEP STOP]

 

PN : David is a name of a costumer i am searching.

[241]

There a third bug, when we use the Search Filter + submit =

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'o.payment_method like '%david%' or o.cc_number like '%david%' order by o.orders' at line 1

 

select distinct * from orders o where o.orders_id like '%david%' or o.orders_id like '%david%' or o.customers_name like '%david%' or o.customers_id like '%david%' or o.customers_id like '%david%' or o.customers_company like '%david%' or o.customers_street_address like '%david%' or o.customers_suburb like '%david%' or o.customers_city like '%david%' or o.customers_postcode like '%david%' or o.customers_state like '%david%' or o.customers_country like '%david%' or o.customers_telephone like '%david%' or o.customers_email_address like '%david%' or o.delivery_name like '%david%' or o.delivery_company like '%david%' or o.delivery_street_address like '%david%' or o.delivery_suburb like '%david%' or o.delivery_city like '%david%' or o.delivery_postcode like '%david%' or o.delivery_state like '%david%' or o.delivery_country like '%david%' or o.billing_name like '%david%' or o.billing_company like '%david%' or o.billing_street_address like '%david%' or o.billing_suburb like '%david%' or o.billing_city like '%david%' or o.billing_postcode like '%david%' or o.billing_state like '%david%' or o.billing_country like '%david%' o.payment_method like '%david%' or o.cc_number like '%david%' order by o.orders_id DESC

 

[TEP STOP]

 

PN : David is a name of a costumer i am searching.

 

Missing or in the query should be

or o.billing_country like '%david%' or o.payment_method like '%david%'