You are viewing the PKP Support Forum | PKP Home Wiki

Email Logs

General inquiries about the PKP.

Moderators: jmacgreg, btbell, michael, bdgregg, vgabler, barbarah, John

Forum rules
Feel free to post general inquiries about the PKP Here. We'll also post notes of interest from time to time. You may also want to check out the PKP blog.

Email Logs

Postby kayiwa » Tue May 21, 2013 11:14 am

Yet another migration problem. We have found that articles that have transactions between our upgrade from 2.1.1 and 2.4.2 do not show up on the web interface. We are trying to reverse engineer the fix and are doing this thus far.

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?
Posts: 8
Joined: Tue Feb 19, 2013 9:18 am

Re: Email Logs

Postby asmecher » Tue May 21, 2013 4:47 pm

Hi kayiwa,

There should be a submission_id column in the new schema; that's the same as the old article_id column (the upgrade process should rename it). This is done so that code and tables can be shared with other applications like OMP (which calls submissions "monographs").

Alec Smecher
Public Knowledge Project Team
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

Return to General Discussion

Who is online

Users browsing this forum: No registered users and 2 guests