Getting error

[Guest]

Orders Order ID:

Status: All OrdersPendingProcessingDelivered

 

 

Customers Order Total Date Purchased Status Action

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

[Guest]

also if you click on products

 

The Manufacturers button i get this error

 

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products p, products_description pd, manufacturers m left join specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '10'

[♥geoffreywalton]

Follow the patches link in my signature block.

 

Looks like you have a mysql4 version shop running on a server with mysql5 installed.

[Guest]

@geoffreywalton

 

can you give me the url please it save ne a lot of time

 

 

also is there a way to upgrade from php 4 to 5 without haveing to reinstall eveything ?

 

 

Also getting this error

 

Advanced Search

 

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%all%' or p.products_model like '%all%' or m.manufacturers_name like '%all%') and (pd.products_name like '%states%' or p.products_model like '%states%' or m.manufacturers_name like '%states%') )