EZorb:
I will try to explain better. Fresh install of 1.3.9f and demo-database and 1.3.9f with all mods installed works great no problems. Now I need to have 1.3.8a database to work with new install 1.3.9f.
After changing configure.php files to match 1.3.8a database I installed all SQL patches on 1.3.8a database the ones that were already installed installer said so. Next ran UpDate database and patch level now says 1.3.9f. Now everything work except FEC. It has defaulted to orginal. So that is why I said it has to be something to do with the database. So the only thing I can think of is JS is not working with the updated database.
Problem Found
When you run the uninstaller I found even though it shows FEC has been removed only parts have been removed. I found the following was left installed, [INSERT INTO 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');] When you try to install SQL patch it does not install any part of the patch because it think the patch is installed.
Remendy
I loaded the SQL patch into an editor and found the above to be line 6. I removed this line, and installed the SQL patch. This time the SQL installer installed 14 Statements and said the following was also installed.
Error ERROR: Cannot ADD column dropdown because it already exists.
Error ERROR: Cannot ADD column gift_message because it already exists.
Error ERROR: Cannot ADD column checkbox because it already exists.
Error ERROR: Cannot ADD column COWOA_account because it already exists.
Error ERROR: Cannot ADD column COWOA_order because it already exists.
Error ERROR: Cannot ADD column COWOA_order because it already exists.
Error ERROR: Cannot ADD column COWOA_order because it already exists.
Error ERROR: Cannot ADD column COWOA_order because it already exists.
Error ERROR: Cannot ADD column COWOA_order because it already exists.
Error ERROR: Cannot ADD column COWOA_order because it already exists.
Error ERROR: Cannot ADD column COWOA_order because it already exists.
Error ERROR: Cannot ADD column COWOA_order because it already exists.
Error ERROR: Cannot insert configuration_key "ACCOUNT_TELEPHONE" because it already exists
Tested
All works fine now – this is a great mod that I would rate as a must have #1
Need to know
Why is code being left behind? Is it due to not included in unstaller or is there something wrong on the database server and my host need to fix.