OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Article Author Information

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.

Article Author Information

Postby kayiwa » Wed May 01, 2013 8:31 am

We've recently moved from OJS 2.1.1 to 2.4.2. It looks like we weren't very careful in our migration. We've encountered a problem that relates to the "article_authors" table. In 2.1.1 the table has the follow fields.

Code: Select all
"author_id","article_id","first_name","middle_name","last_name","affiliation","country","email","biography","primary_contact","seq","url"


On upgrading to 2.4.2 the affiliation (as best as I can determine) this is moved to "author_settings" with a link from "article_author_settings". The latter table has the following fields

Code: Select all
"author_id","locale","setting_name","setting_value","setting_type"


with the settings_value looking suspiciously like the "affiliation" information.

Is there a way to (we still have the back up) to import the bio and affiliation fields which broke during import or is it as simple as altering the setting_value to say "affiliation"

Cheers,
./fxk
kayiwa
 
Posts: 8
Joined: Tue Feb 19, 2013 9:18 am

Re: Article Author Information

Postby asmecher » Wed May 01, 2013 9:35 am

Hi kayiwa,

This is very closely related to the issue identified here, which is the same problem but in the "users" table instead of the "authors" table. At this point, since it's an OJS 2.1 to 2.2 migration bug that dates back many years, I suspect we're more likely to drop the 2.1 to 2.2 upgrade than we are to fix the bug -- but to recover that information with a backup of the pre-upgrade database you can adapt the instructions in the linked post.

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

Re: Article Author Information

Postby kayiwa » Wed May 01, 2013 2:40 pm

Thanks for the the response and pardon the pedantry. When you say

which is the same problem but in the "users" table instead of the "authors" table.


do you mean article_authors because I'm not otherwise seeing the authors table.

Cheers,
./fxk
kayiwa
 
Posts: 8
Joined: Tue Feb 19, 2013 9:18 am

Re: Article Author Information

Postby asmecher » Wed May 01, 2013 2:45 pm

Hi kayiwa,

Yes -- that's "article_authors" in old versions of OJS, but it was renamed to "authors" as part of the upgrade to OJS 2.3.3.

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


Return to General Discussion

Who is online

Users browsing this forum: unimechengineers and 1 guest