Hello,
I was updating ojs from 3.0.2.0 to the latest version and managed to update to 3.1.1.4 with no issue, and then to 3.1.2.0 with your help (the problem there was to change driver to sqli)
After I tried to update further but got different type of error related to database fields, so I stopped to check the journal and noticed that it’s not functioning as before: titles of articles (including the links to the articles’ individual pages) have disappeared from the pages showing each published edition. It’s also not possible to access the individual submissions relative to each article (error message: DB Error: Unknown column ‘a.primary_contact’ in ‘where clause’).
Is it something to do with sqli driver? is it possible to fix it? If I backup ojs to previous version it won’t work as my hosting was updated to php7 and it’s not supported by previous ojs versions.
ojs address: https://revista.ibdh.org.br/
Hi @Mila_Simakova
Have you tested your journal with a different theme to check whether it shows the titles? It seems that the current theme you are using is not fully compatible with your OJS version.
I’ve checked the Issue page and the value for titles is not coming to the code.
Best,
Israel
Hi, Thank you for the advice. I’ve managed to change to default Manuscript but the issue remains, titles are not shown…
Hi @Mila_Simakova
Could you please double check whether you have the following locale file on your default Manuscript theme folder?
defaultManuscript/locale.po at master · pkp/defaultManuscript · GitHub
Best,
Israel
Also, could you please confirm which version (tag) of theme your are using?
GitHub - pkp/defaultManuscript at 1.0.0
Hi,
I’ve tried to upload1.0.0 didn’t see any changes, now I’ve installed :
<release>1.0.2.0</release>
<!-- The date of the latest version -->
<date>2018-04-10</date>
Also uploaded all languages to “locale”:

Do not see any changes still… website doesn’t switch between languages. AI believe due to same issue.
Last version when website was working was 3.0.2.0 but i had to update due to switch to php7. I can restore that version from back up, but how do I proceed to make sure the theme gets updates aswell?
Hi @Mila_Simakova
Default Manuscript is a child theme from Default Theme. Could you please test Immersion or Pragma theme on your installation to ensure that titles are not being displayed at all?
Last version when website was working was 3.0.2.0 but i had to update due to switch to php7. I can restore that version from back up, but how do I proceed to make sure the theme gets updates aswell?
I recommend you to restore locally and test before to put it back in production. The best approach to ensure your themes are updated along your OJS version is using git to deploy them , i.e.: git clone, and checking out the version compatible to your OJS, i.e. git checkout .
For example, to git clone/checkout the Classic Theme and keep it compatible to OJS 3.1.2 you need to check out the tag 1.0.1:
git clone https://github.com/pkp/classic.git plugins/themes/classic
cd plugins/themes/classic
git checkout -b local_repo_theme_name tags/1.0.1
If you want to use the theme with a newer version of OJS (3.2 or 3.2.1), you need to use a different tag (1.0.4):
git clone https://github.com/pkp/classic.git plugins/themes/classic
cd plugins/themes/classic
git checkout -b local_repo_theme_name tags/1.0.4
See all versions compatibility to this theme from its repo README file:
Best,
Israel
Hi,
Thank you for more details. Pragma is not available in my plugin lis, and Immersion looks completely broken and descriptions of options look off.
I’ve been updating ojs by uploading files to FTP directly, didn’t use git and won’t be able to replicate action to compare theme tags due to my limited skills in github…
I tried to upload default theme folder from newer and older versions ojs packages, older would not make difference and newer would break the website.
Can it be for example database issue?
I was updating ojs: 3.0.2 → 3.1.1.2 → 3.1.1.4 → 3.1.2
Maybe the update should have been done more gradually?
Hi @Mila_Simakova
This translations are showing the locale keys due to the missing locale files to the Brazilian Portuguese on Pragma theme.
You may add download the locale file and add it to your theme folder from the github repo:
pragma/locale at 1.1.0 · pkp/pragma · GitHub
Please. note that only from tag release 1.1.0 the Brazilian Portuguese has been added. Any previous version of this theme will not have it.
I assume that the issue you are troubleshooting might be related to a missing locale file only, isn’t?
Best,
Israel
Hi,
Thank you for more details.
Is it possible to find tag in FTP files?
Since the beginning I use Default theme, I checked the locale file - it has pt_BR. Maybe I should try to replace it by the one from newer version?(sorry, can’t find in on github).
I tried Pragma, it has pt_BR, but breaks the website (error 500). I believe because it’s not compatible with ojs 3.1.2.
I tried Classic 1.0.1 and Immersion 1.0.3 with locale folder from newer version, themes work with same issue.
I also installed Default Translation plugin and added pt_BR to Manuscript theme, and it worked. Without Default Translation plugin this theme was breaking the website. But again issue is still there: titles are not shown and languages not switching.
As I mentioned, language switch doesn’t work as well. May be there is a way to force switch the language? Then if it would work with English I’d probably be able to go ahead and update ojs and hopefully it would resolve BR language troubles… Because when I try to update ojs to next version it gives errors.
I am not sure if I understood your question, but you can find tag releases from here:
Given that the issues started with the upgrade, I would recommend you restart the process from your backup. There are issues in your DB related to missing fields or columns, e.g.:
https://revista.ibdh.org.br/index.php/ibdh/article/view/468
These errors are not related to Theme issues but rely on the structure and data on your DB though.
Best,
Israel
Hi,
I recovered backup and updated untill 3.2.1 locally. Title issue is solved but languages still do not switch. Doesn’t look like it’s same problem of theme compatibility. Any idea what can be the root cause?
Hi @Mila_Simakova
When you attempt to switch languages and it does not work, is there any message on your server error log file or your broser console log?
Israel