watman10 Posted March 5, 2011 Share Posted March 5, 2011 Details: - Upgrading to Prestashop V1.3 from older version using an existing databaseProblem Statement:- In the back-end, navigating to Payment > Vouchers returns an error "Bad SQL Query"Resolution Statement:- There have been changes to the database infrastructure in V1.3 (AFAIK). This causes the php sql query to fail as it has an expectancy for a table which does not exist in the old database.Resolution Fix:- Launch preferred DB editor (Recommended: Heidi SQL 6.0 EXPERIENCED USERS ONLY http://www.heidisql.com/)- Navigate to table "PS_DISCOUNT"- At position 4 add column "id_currency" of types "INT 10" and default value 0- Save changes to database- Refresh the vouchers page in your browser and the issue should be resolvedSCREENSHOT ATTACHED 1 Link to comment Share on other sites More sharing options...
leelee23 Posted September 13, 2011 Share Posted September 13, 2011 Excellent - thanks Watman10, saved me some time that did Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now