restoring old .sql file

[dazza05]

hi can anybody help me please?

 

i have just installed Os commerce on the server and the installation went fine and it completed successfully

 

problem comes when i go to www.myserver.com/catalog/admin/ the admin page loads but the errors come if i visit products or orders. i get an error like this one.

 

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 p.products_id, p.products_ordered, pd.products_name from products p, products_description pd where pd.products_id = p.products_id and pd.language_id = '1' and p.products_ordered > 0 group by pd.products_id order by p.products_ordered DESC, pd.products_name limit -20, 20

 

 

its because there is no database file in my backup folder

 

as the main problem arises when i try to restore my sql databse file. i browse to the location of the file, load it but it doesnt restore it. there for there are no products etc.

 

i have been informed it my be permissions problem but i have folled th pre/post installation file permission changing.

 

any help will be useful

cheers