[SOLVED] Where are my currencies?

[MartyW]

Hello,

 

I am new to Prestashop please bare with me

 

At the back end under /psadmin > Localiation > Currencies I am getting the following message

 

Bad SQL query

Column 'conversion_rate' in order clause is ambiguous

 

I have attached a screenshot

 

Any help with this would be great i seen another post that said to clear the smarty cache but I have had no joy with this

 

Thanks for reading

Edited July 17, 2013 by MartyW (see edit history)

[MartyW]

Replied to the spam last time, I followed the instructions here

 

http://www.prestashop.com/forums/topic/249966-currencies-error/

 

but it is filled with folders and following a youtube video here it didnt show the guy deleting folders

 

 

Any thoughts?

Edited July 17, 2013 by MartyW (see edit history)

[vekia]

Ive tried that but it didnt work, thanks anyway

 

can you please explain what you mean? what you tried?

[MartyW]

I have deleted all the data from the smarty Cache apart from the folders should I delete the folders and leave the index file?

 

I have attached ascreen shot of the folders I mean

[vekia]

have you tried to regenerate the currency rates/

[MartyW]

Thanks for the response can I delete the folders that I mentioned in the last post without adversly affecting the site?

 

by regenerate the currency rates do you mean

 

Update Currency Rates

 

If not How dod you regenerate the currency rates?