Ok, I think I have had success.
I tried to run the upgrade routine but at first was receiving a warning and wouldn't process. A debug file said
Code:
[12-Dec-2014 14:41:59 America/Chicago] PHP Fatal error: 1062:Duplicate entry 'Customers who have never completed a purchase' for key 'query_name' :: INSERT INTO zen_query_builder (query_category, query_name, query_description , query_string) VALUES ('email,newsletters', 'Customers who have never completed a purchase', 'For sending newsletter to all customers who registered but have never completed a purchase', 'SELECT DISTINCT c.customers_email_address as customers_email_address, c.customers_lastname as customers_lastname, c.customers_firstname as customers_firstname FROM TABLE_CUSTOMERS c LEFT JOIN TABLE_ORDERS o ON c.customers_id=o.customers_id WHERE o.date_purchased IS NULL'); in /home2/user/public_html/mysite.com/truesol/includes/classes/db/mysql/query_factory.php on line 120
There wasn't a double entry so I just dropped the query_builder table. The database upgrade was then able to run. I let it upgrade starting from 1.3.7 to 1.3.8 and up to 1.5.1. It skipped a bunch of things but also ran a bunch of things. One thing it did not insert though was the query_builder table. So I went to another 1.5.1 database, exported a query_builder table and imported it into the database I am working with.
The email and newsletter functions are working again. Admin looks to be ok and the storefront is loading and looks ok.
Before I put the live site in maintenance mode and do this process one last time with a fresh database copy can you see any potential problems with what I have done?
Bookmarks