Title not shown after failed upgrade from 3.1 to 3.2 , possibly locale problem

After failed upgrade, I try to restore database manually to its original structure.
Now the problem is the title of each article / submission not shown.
for example
https://online-journal.unja.ac.id/biospecies

In administration page there some unusual printed string :
a:4:{s:10:“uploadName”;s:30:“pageHeaderTitleImage_en_US.png”;s:5:“width”;i:1000;s:6:“height”;i:125;s:12:“dateUploaded”;s:19:“2012-12-09 09:03:14”;}

I trace to this file

lib/pkp/classes/submission/Submission.inc.php
with this method
function getLocalizedTitle($preferredLocale = null, $includePrefix = true) {
$title = $this->getLocalizedData(‘title’, $preferredLocale);
if ($includePrefix) {
$prefix = $this->getLocalizedPrefix();
if (!empty($prefix)) $prefix .= ’ ';
$title = $prefix . $title;
}
return $title;
}
I think the function is calling

lib/pkp/classes/oai/OAIStruct.inc.php
function getLocalizedData($data, $locale) {
foreach ($data as $element) {
if (isset($data[$locale])) return $data[$locale];
}
return ‘’;
}
But I can not find the sql query or any hint.
Please help me how to fix this problem…

  • Application Version - OJS 3.1.2.1

You can post in any language, but please note there is a Spanish OJS forum and a German category on this forum.

Hi @Moh_Ilhami,

Manually downgrading your database from 3.2.x to 3.1.x could be quite complicated… Do you have a backup from before the upgrade was made? Do you know where during the upgrade process the upgrade failed?

Regards,
Alec Smecher
Public Knowledge Project Team

Sorry, I dont have backup :frowning:
The most recent backup is on April 4th.

Hi @Moh_Ilhami,

Do you know where during the upgrade process the upgrade failed?

Regards,
Alec Smecher
Public Knowledge Project Team

Hi Amecher,

I can restore the title using this command:
insert into submission_settings SELECT * FROM onlinejo_ojs20200416.submission_settings where setting_name like 'title'

I was able to recover 7500 records and lost several records

I also recover “setting_type” column in “site_settings” table.

My initial problem, when I was upgrading from 3.1 to 3.2

ERROR: Upgrade failed: DB: Duplicate entry '0-1' for key 'citations_publication_seq'

or something similar. I can not continue the upgrade process.

I was advised to delete all records from citations from Indonesian forum: forum.relawanjurnal.id