You are viewing the PKP Support Forum | PKP Home Wiki

Missing data - Can I recover them?

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.

Missing data - Can I recover them?

Postby mendesrocha » Fri Apr 18, 2008 11:33 am

Hello all,

One of the Journal Manager of our Portal has just complained that while he was Setting Up his Journal he update the new data and after he submited these data, the page just refreshed and after refreshing, the data that he has inserted has just vanished! So, he wrote to the techincal support and asked us to recover this data.

He was updating the Step 3 of the Setup. Precisely the item 3.2.

We have backup of the Database one month ago, and my hope is to recover that data from this backup.

So, I have two questions:

1) Why this is happening?
2) Can we recover this data?
2.1) The editor was updating an already modified data.

Posts: 178
Joined: Mon Nov 05, 2007 11:10 am
Location: Brazil

Re: Missing data - Can I recover them?

Postby asmecher » Fri Apr 18, 2008 2:05 pm

Hi Renato,

We haven't had reports of data loss on Setup page 3 -- there was an issue in OJS 2.1.1 and older that could cause data from page 5 to be lost if the "Save Settings" page was visited using the "Back" button, but this did not affect page 3. Unfortunately, without the issue being reproducible, it's difficult to find out what happened; if you're able to provide any more details, I may be able to look into it further.

As for recovering settings, you'll need to go back to a backup. To do so, I'd suggest restoring the MySQL backup to a temporary database, then selectively restoring entries from the journal_settings table. There is a list of the relevant settings in classes/manager/form/setup/JournalSetupStep3Form.inc.php in the JournalSetupStep3Form() constructor, e.g. for OJS 2.2:
Code: Select all
                                'authorGuidelines' => 'string',
                                'submissionChecklist' => 'object',
                                'copyrightNotice' => 'string',
                                'includeCreativeCommons' => 'bool',
                                'copyrightNoticeAgree' => 'bool',
                                'requireAuthorCompetingInterests' => 'bool',
                                'requireReviewerCompetingInterests' => 'bool',
                                'competingInterestGuidelines' => 'string',
                                'metaDiscipline' => 'bool',
                                'metaDisciplineExamples' => 'string',
                                'metaSubjectClass' => 'bool',
                                'metaSubjectClassTitle' => 'string',
                                'metaSubjectClassUrl' => 'string',
                                'metaSubject' => 'bool',
                                'metaSubjectExamples' => 'string',
                                'metaCoverage' => 'bool',
                                'metaCoverageGeoExamples' => 'string',
                                'metaCoverageChronExamples' => 'string',
                                'metaCoverageResearchSampleExamples' => 'string',
                                'metaType' => 'bool',
                                'metaTypeExamples' => 'string',
                                'copySubmissionAckPrimaryContact' => 'bool',
                                'copySubmissionAckSpecified' => 'bool',
                                'copySubmissionAckAddress' => 'string'
In this listing, the setting names (e.g. "metaType") will identify the values of the "setting_name" column for each entry you'll need to restore from the backup's journal_settings table.

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

Return to OJS Technical Support

Who is online

Users browsing this forum: No registered users and 1 guest