OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Email log empty

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
What to do if you have a technical problem with OJS:

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a development question, try the OJS Development subforum.

Re: Email log empty

Postby raickonen » Tue Sep 10, 2013 8:34 am

Hi piotreba,

Thaks allot! Your sugestion worked fine. I apologize because I didn't understand first time. Your update fix all problems!



Dear OJS,

Could you provide any fix on this? My problelm was solved but many journals coming from 2.3.5 or above will have this problem and would be very goo to have a permanent solution. Maybe a patch or bugfix?

Tks
raickonen
 
Posts: 34
Joined: Tue Nov 16, 2010 10:39 am

Re: Email log empty

Postby asmecher » Tue Sep 10, 2013 9:47 am

Hi raickonen,

Do you have a database dump prior to the upgrade that you would be willing to share with us for testing?

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

Re: Email log empty

Postby raickonen » Tue Sep 10, 2013 10:26 am

Alec,

Sent you PM.

raickonen
raickonen
 
Posts: 34
Joined: Tue Nov 16, 2010 10:39 am

Re: Email log empty

Postby asmecher » Tue Sep 10, 2013 2:40 pm

Hi raickonen,

Thanks, I've tracked it down -- I'll post a patch to http://pkp.sfu.ca/bugzilla/show_bug.cgi?id=8420 shortly.

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

Re: Email log empty

Postby lskibinski » Tue Oct 01, 2013 8:21 am

I just wanted to say a huge THANKYOU to piotreba for posting this:

piotreba wrote:Ok, the case is not so serious...
Just simple UPDATE SQL statement was needed, maybe will be helpful for others:
UPDATE `pre_ojs_update_db`.`article_email_log`, `post_ojs_update_db`.`email_log` SET `post_ojs_update_db`.`email_log`.`assoc_id` = `pre_ojs_update_db`.`article_email_log`.`article_id` WHERE `post_ojs_update_db`.`email_log`.`log_id` = `pre_ojs_update_db`.`article_email_log`.`log_id`


I didn't realize you could query across databases in MySQL and thought I was done for when I encountered this problem this afternoon.

For what it's worth, it looks like the assoc_id field in my pre_update db had plenty of nulls and these were transferred as-is to the new db, ignoring the article_id field and resulting in very strange behaviour.

This was supposedly patched so If you're interested in the migration script I used and the databases let me know.

Regards,

Luke Skibinski
Ubiquity Press
lskibinski
 
Posts: 11
Joined: Mon Mar 11, 2013 10:15 am

Previous

Return to OJS Technical Support

Who is online

Users browsing this forum: Bing [Bot], Yahoo [Bot] and 2 guests