We are taking articles with the following query from 2.1.1
Code: Select all
INSERT INTO `ojsnew_2_4_2.email_log` (`log_id`, `article_id`, `sender_id`, `date_sent`, `ip_address`, `event_type`, `assoc_type`, `assoc_id`, `from_address`, `recipients`, `cc_recipients`, `bcc_recipients`, `subject`, `body`)
We notice that ojsnew_2_4_2.email_log does not have `article_id`
Thanks for pointing us in a direction to solve this to speed up the process. What we can best determine is the index: email_log_users that would also have to be updated with the
log_id and the related user_id.
Any other *gotcha's* to look out for?