Upgrade 9 y.o. OJS to OJS3

Software Support
21

Successfully upgraded to version 3.1.0.1

Now I need to test if it works properly. Will leave that for tomorrow.
Thank you again for the help!!

22

Hi @ambs,

Glad it’s un-stuck!

Regards,
Alec Smecher
Public Knowledge Project Team

1 Like
23

I know this is unrelated to OJS, and probably my fault during the database manipulation. But do you guys know any way to fix this utf8 :poop: I did? http://linguamatica.perl-hackers.net/index.php/linguamatica

Thanks

24

what do you have in config.inc.php in these values: https://github.com/pkp/ojs/blob/master/config.TEMPLATE.inc.php#L181-L198
And what is your database table encoding?

25

Hopefully the database is in utf8. I changed the collation and encoding. Just not sure if it just changed the metadata or if it really converted the entries. Regarding the config file, it is just like the template.

Probably I can go doing substitutions on the relevant fields in the database. If that seems the solution, I think I am able to do it in Perl easily…

26

Hi @ambs,

Before you dive into this too deeply, double-check the exact character set configuration in config.inc.php for your old and new installs. Watch for subtle differences like utf8 vs. utf-8.

Regards,
Alec Smecher
Public Knowledge Project Team

27

Hi
Also, I can still get the original database, and convert it again. Was being dumb one more time.
Will keep you all posted.
Thanks

28

For reference, the original database is a mess. It has correctly encoded strings, and double utf-8 encoded strings. I am fixing the original dump, trying to restore all the relevant parts. Will keep you posted of all the process. Thanks

29

Hi @ambs,

You may be able to untangle this using ftfy, by the way. I’ve heard good things about it, though I haven’t used it myself.

Regards,
Alec Smecher
Public Knowledge Project Team

30

Hi.
I got a problem with table article_keyword_search_text (and I might get similar ones with other tables, but this was the first giving trouble). So, this is an inverted index of the article keywords. Problem is that I had some keywords in Latin 1 and some other in UTF-8. After solving the issue, and saving it all in UTF-8, yeah, you guess it, I have duplicate keys in that table.

It is possible to force the regeneration of this table after migration? I mean, the easiest way to cope with this specific problem would be to delete the table contents, and then force OJS to recreate it.

Is this possible?
If not, I might need to get creative.

Thanks.

31

I think you should be able to rebuild that with this command line script: https://github.com/pkp/ojs/blob/master/tools/rebuildSearchIndex.php

1 Like
32

Thanks for pointing it. Will give it a try.

33

Removed that table contents, and did the whole process again (to 2.4, then to 3.x). Run the rebuildSearchIndex tool and it did not complain, so probably did it well. The website is much more clean now: http://linguamatica.perl-hackers.net/index.php/linguamatica

There are still a few characters that were not fixed, but hopefully they are not many, and can be hand fixed as they are found.

Need now to redesign the website.
Thanks

34

I am noticing some strings not translated (like ##manager.navigationMenus##).
Is there an easy way to help OJS with the Portuguese translation?

EDIT: Just found the translation plugin. Give me a couple of days and I will share my translated documents.

35

Another issue here. I can’t upload a PNG. It says it is an invalid type (in Portuguese, but anyway, it complains).
The best I could get in the logs is this:

94.132.14.145 - - [08/Apr/2018:16:47:16 +0000] "GET /index.php/linguamatica/manager/setup/data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8%2F9hAAAABGdBTUEAANkE3LLaAgAAAaFJREFUeJyFkb9OG0EQh781B3JzioR0Ig0SFPAEiRQ3KIpsCVkUQMEDIAoQFFGq0FDQhIoOKUqRgi5FuhTs5QFMHiA0NAdGIHH8Mzmi4DMzKWyfOXyX%2FKrdmdlvfzNjyNHG%2B3faPW9ubZu8Ogdgbf5Fufpy%2FHs3uN8YZXZhBYDb6BxAXz2rJ4%2BWt%2Fzh40bjGsAAfP6wqdMlD4CPe4fMLqxwG51zGZ4BcBQE3ISnLE9PALBXC1lc3zCJAwDnd%2FuHtaki9YNPuIDbyY2NACMD3JwcdCJeuoXHCq%2FuuPCqeS0zGn7rn8FjnXhV3ryewhkqpuK%2B71MqlajVgPqPbMDF1S%2FwwJjsobuu24a0r4NAXOgm72PJtZ0FsdY2Uw7iuJUUiQgFBdUetFKp4Pt%2BHzA9g451hfaCtZdSVcrlMsYYjDEJLBugioqiqjyViOA4vWdPttABiCAiqRa6sH8D5CEpilst0PRgVbVvQw7Al6%2B7b39OPq82Y7mbWZqZu2%2FGUhwYKoj0b0Y1u7VE1lqNouiP%2FkfWWs2YAQRBsArs5H%2BROFkH%2BAtt99BK1T3CFwAAAABJRU5ErkJggg%3D%3D HTTP/1.1" 404 52 "http://linguamatica.perl-hackers.net/index.php/linguamatica/management/settings/website" "Mozilla/5.0 (X11; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0"

And the message in the screenshot.Screenshot%20from%202018-04-08%2017-47-19

Any hint? Well, probably some issue with my nginx config. Will try to find out meanwhile.

36

Meanwhile, got a git copy as it should be easier to keep updated in the future. So, running 3.1 now.
The problem is when upgrading I get:

<h1>DB Error: Duplicate entry 'plugins.generic-acron-1-2-0-0' for key 'versions_pkey'</h1>
ojs2: DB Error: Duplicate entry 'plugins.generic-acron-1-2-0-0' for key 'versions_pkey'

I tried to get there and delete that entry from the versions table, but no joy, as it is added again.
Thanks

37

I am stupid. It did complain again, but regarding another plugin. Will keep the fight.

38

Just noticed this today, but with OJS 3.1 the sections on current submissions and website users appear as blank pages. In the log I just see PHP warnings, that seem like deprecations of some time.

Any idea what might be going on?

39

Hi @ambs,

Have you checked for sure that there are no errors amongst the warnings?

Regards,
Alec Smecher
Public Knowledge Project Team

40

I do not think so, in any case, as four eyes see better than two, I am sharing it.
I see there some errors getting js files. Can it be the culprit? I confirmed I do not have build.js in that path…