I've just done somthing stupid= deleted all currencys

[rossshep]

It was all going so well then. I noticed that prices wern't showing up by products and in an superb flash of inspired thinking I decied to delete all the currencies and start again (I know it was a stupid thing to do but you live and learn) now when I go to currencys in the admin section all I get is:

 

Currencies

 

Currency Code Value 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 currencies_id, title, code, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, last_updated, value from currencies order by title limit -20, 20

 

[TEP STOP]

 

 

But there is no option to reinstate the currencys I deleted. Is the any thing i can do, I had just backed up my site prior to this can I just reload it on to the server and hav it working straight away or is life not that simple.

 

Ross

[Guest]

yeah just reload your backup you should be fine, happens to me too b4 when i delete all customers or specials.. i dont know why this happen though.. maybe sombody can lecture us about thsi