[SOLVED] Bad SQL Query

[tdr170]

I just did my first test order using the Paypal sandbox and under orders/ statuses I am getting a Bad SQL Query notice.

Everything seemed to work OK, order went through emails were sent and the order shows in other areas of BO.

I also Get this message when trying to create a new status.

An error occurred while creating object.

order_state (Unknown column 'deleted' in 'field list')

Has anyone experienced this and if so how do I fix it.

 

 

Edited May 16, 2012 by tdr170 (see edit history)

[tdr170]

This seems to be an issue with the Order files in Classes and Admin/ tabs, I replaces all files having to do with order in these two folders and all is fine now.

The Prestashop version is 1.4.7 and I replaced the files from a 1.4.6 version and that fixed it.

[ralphstirrat]

HI I've just installed 1.4.8.2 and I've got this error, I've replaced all the files from 1.4.7.3 (admin/tabs/adminorder* and classes/order*)

and it still doesn't work? anyone any ideas?

[tdr170]

Try downloading the SVN files (http://www.prestashop.com/en/developers-versions) this is info on how to use SVN.

At the bottom you will also see a place to download older versions in case the SVN does not work try the files from 1.4.6.2

You will need a SVN program I use this (http://tortoisesvn.net/downloads.html)

 

The SVN contains all the latest updated Files. (if you download the complete SVN version and install it is 1.4.9)

[ralphstirrat]

Thanks for the info, I'll try what you've suggested.

[ralphstirrat]

I've had a look at this but I don't think it's what I'm after as I'm not a developer, I'm only know some html and css so I think it's beyond me. I'll try and replace the files and see if that helps otherwise I'll just do a fresh re-install.

[the_raven]

thanks tdr170 for your nice idea. i had same problem with this title :

 

Bad SQL query Column 'conversion_rate' in order clause is ambiguousdf

 

i use PS ver 1.5.4 . this error msg occure when i had trying to open >> Localization >> Currencies .

 

i changed >> classes\controllerAdminController.php with same file from a fresh version of PS 1.5.4 and problem solved.

 

thank you .