If you're getting a message saying that the "Administrator" entry is a duplicate, then you've either already done the 1.3.0.2 upgrade, or you followed one of my posts in another thread to add an option to email yourself when attempting to test the admin newsletter process.
In this case, edit the zc_install/msql_zencart_1301_to_1302.sql file and put a # at the beginning of the reported statement, making it look like this:
Code:
#INSERT INTO zcart_query_builder ( query_category , query_name , query_description , query_string ) VALUES ('email,newsletters', 'Administrator', 'Just the email account of the current administrator', 'select \'ADMIN\' as customers_firstname, admin_name as customers_lastname, admin_email as customers_email_address from TABLE_ADMIN where admin_id = $SESSION:admin_id');]
Then rerun the zc_install database-upgrade option.
Bookmarks