Orders.php

[GoingGone]

When ever there are orders it is fine... but when the orders are finished and there are no new order then..

 

This shows up on orders.php

 

Orders

Order ID:

Status:

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 '-20, 20' at line 1

 

select o.orders_id, o.customers_name, 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.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20

 

[TEP STOP]

 

 

Also, how do I change the osCommerce title on the top of every page to my domain name? (In every file it is in the header title - I'd like to change it globally to my site name)

[selectronics4u]

there is a fix for this error in the new update that is out go to home page here and click the 051112 update at the top .your title is changed in your cat/includes/language/english file.

 

Don

[GoingGone]

My problem is that I've done a lot of editing to the base files and I don't want to lose the look of everything =/

 

I'm not having any problems with anything else right now so I'm wondering if there is a way to just fix this problem? Looking through all of the documents on the recent update, I have found nothing.

 

Or is there a way to preserve all of my changes to like the main index.php and still update everything else?

 

Thanks

[GoingGone]

Okay...

 

I did a fresh install with the files in the update having it run off the same mysql install (which I updated, I think) and it still gives me the same error =/

 

Does anyone know where I can directly fix this problem from?

[GoingGone]

I just did another clean install and... still the same problem.

 

Could it be that it is doing this because I use PowWeb?

[selectronics4u]

read thisupdate read the part for limit 20-20

that should fix your problem. if you are using mysql version 5 you may need to do the update for that .you can do the updates maually without replacing the whole file.

 

Don

[Guest]

read thisupdate read the part for limit 20-20

that should fix your problem. if you are using mysql version 5 you may need to do the update for that .you can do the updates maually without replacing the whole file.

 

Don

 

 

Hi

 

Many thanks indeed. I just tried this update on a heavily modded site and it worked a peach.

All the best

IMCDERMOTT