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.
Bookmarks