Quote Originally Posted by need_help View Post
I installed the new version of fast and easy checkout on a site today.

I then decided to upgrade my old site.

Rather foolishly i decided to uninstall using the uninstall.sql file thinking i could easily use the install.sql file to get the new version up and running without using the update sql files as i was unsure if i needed to run just the latest update sql file or the last two as the version i was running was at least three updates old.

Now i have all the files in the correct folders but i cannot get the install sql to work and fast and easy checkout has gone from the admin section and i get this.

1062 Duplicate entry 'Permanent Account Holders Only' for key 2
in:
[INSERT INTO zen_query_builder ( query_id , query_category , query_name , query_description , query_string ) VALUES ( '', 'email,newsletters', 'Permanent Account Holders Only', 'Send email only to permanent account holders ', 'select customers_email_address, customers_firstname, customers_lastname from TABLE_CUSTOMERS where COWOA_account != 1 order by customers_lastname, customers_firstname, customers_email_address');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I tried looking in MyPHPAdmin but i'm unsure what search terms to use to get rid of all the old data so i can run the install sql again.

Can you help please.
I fixed this by simply running my backup file. Then i upgraded to the latest SQL update and everything is now fine.

Good tip for everyone is always backup before making changes to your site. It can save your store much time and heartache.