Error 1064 when searching customers orders

[edvon]

Hi all,
my first post... using 1.3.8, I use stock by attributes and a sidebox addon. I recently altered orders.php because I couldn't search for a product id in all orders, that's been fixed, but now when I look for a customers orders I get:

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 'select o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.shippi' at line 1
in:
[select count(*) as total select o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.shipping_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total, o.customers_company, o.customers_email_address, o.customers_street_address, o.delivery_company, o.delivery_name, o.delivery_street_address, o.billing_company, o.billing_name, o.billing_street_address, o.payment_module_code, o.shipping_module_code, o.ip_address from (zen_orders_status s, zen_orders o ) left join zen_orders_total ot on (o.orders_id = ot.orders_id) where o.customers_id = '8' and o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

did a search but havnen't found nothing in the forums. how would I go about searching for the file that could have the error?

thanks, Edvon

[edvon]

here is the changes I made to the orders.php file:

before:
$new_fields . "
from (" . TABLE_ORDERS_STATUS . " s, " .
TABLE_ORDERS . " o " .

after:

$new_fields . "
from (" . TABLE_ORDERS . " o, " .
TABLE_ORDERS_STATUS . " s " .


before:
$new_fields . "
from (" . TABLE_ORDERS_STATUS . " s, " .
TABLE_ORDERS . " o " .

after:
$new_fields . "
from (" . TABLE_ORDERS . " o, " .
TABLE_ORDERS_STATUS . " s " .



before:
$new_fields . "
from (" . TABLE_ORDERS_STATUS . " s, " .
TABLE_ORDERS . " o " .


after:

$new_fields . "
from (" . TABLE_ORDERS . " o, " .
TABLE_ORDERS_STATUS . " s " .



Hope this might help to fix?

Edvon

[DrByte]

Better would be to upgrade to the latest version where all known bugs are fixed.

[edvon]

Thanks Dr. Byte,

yes, about upgrading I am a little apprehensive, but I suppose it makes sense. Any pointers to threads about upgrading and what to look out for when doing so? Will all my mods (stock by attributes, sideboxes) be "remembered" after the upgrade?

Edvon