OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



upgrading issues

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.

upgrading issues

Postby tkalfaoglu » Wed Feb 27, 2013 11:01 am

Hi there. I am trying to update,and the upgrade tool shows:
Code version: 2.2.3.0
Database version: 2.2.3.0
Latest version: 2.4.1.0

I start the upgrade process..

After dozens of " Deprecated: Function set_magic_quotes_runtime() is deprecated in ..."
messages,I finally get:
ERROR: Upgrade failed: DB: Duplicate entry 'ba�\009Flı' for key 'article_search_keyword_text'

Using phpmyadmin, I exported and looked at the database and there are hundreds of keywords that contain strange characters (either Turkish or Arabic I'm guessing), but also english keywords that look normal.
I was afraid to delete keywords, as I believe there is another table that uses their ID number..
Any ideas how I should fix this so I can upgrade?

Update: I searched and replaced many letters that I recognised. For example, I did a search and replace of every "�\009" for "ç" or whatever.

However, it now complains about regular keywords, such as: "duplicate entry 'students' for key..." Wasn't there a unique requirement in the previous version of OJS? How could duplicates happen in this table, and get rejected when it tries to upgrade?

Thanks!
-turgut
tkalfaoglu
 
Posts: 12
Joined: Wed Feb 27, 2013 10:54 am

Re: upgrading issues

Postby asmecher » Wed Feb 27, 2013 11:10 am

Hi tkalfaoglu,

I'd suggest:
  • Revert your database to its state before you started the upgrade script
  • Run the following SQL queries:
    Code: Select all
    DELETE FROM article_search_keyword_list;
    DELETE FROM article_search_object_keywords;
    DELETE FROM article_search_objects;
  • Try the upgrade again
  • Re-generate the search index by running tools/rebuildSearchIndex.php
Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 7746
Joined: Wed Aug 10, 2005 12:56 pm

Re: upgrading issues

Postby tkalfaoglu » Thu Feb 28, 2013 2:27 am

It worked -- many thanks!
tkalfaoglu
 
Posts: 12
Joined: Wed Feb 27, 2013 10:54 am

Re: upgrading issues

Postby tkalfaoglu » Sat Mar 02, 2013 4:56 am

Hi there. I'm trying to enclose my transcript of my update attempt. I hope it accepts it as a zip file.
The upgrade script has been stuck for an hour now. What shall I do?

error.zip
(50.44 KiB) Downloaded 25 times


I spoke too soon: It now just outputted a few more lines:

[data: dbscripts/xml/upgrade/2.3.3_update.xml]
[note: docs/release-notes/README-2.3.3]
[data: dbscripts/xml/upgrade/2.3.4_update.xml]
[note: docs/release-notes/README-2.3.4]
[data: dbscripts/xml/upgrade/2.3.5_update.xml]
[note: docs/release-notes/README-2.3.5]
[note: docs/release-notes/README-2.3.6]
[code: Installer Installer::migrateReviewingInterests2]

:)
tkalfaoglu
 
Posts: 12
Joined: Wed Feb 27, 2013 10:54 am

Re: upgrading issues

Postby asmecher » Sat Mar 02, 2013 7:44 pm

Hi tkalfaoglu,

If you have an enormous number of users (along with their reviewing interests), those functions may well take a long time. It's likely that spammers have been auto-registering for your journal in the hopes that it'll help with their SEO (it won't). I'd suggest checking your users table for volume and considering enabling CAPTCHA testing for registration. Did the upgrade complete, and if not, do you have a full error log?

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

Re: upgrading issues

Postby tkalfaoglu » Sat Mar 02, 2013 10:41 pm

Thank you very much - the migration never completed, giving many patch errors, so I finally downloaded the entire set and replaced it altogether. Its working well now.. thank you..
tkalfaoglu
 
Posts: 12
Joined: Wed Feb 27, 2013 10:54 am


Return to OJS Technical Support

Who is online

Users browsing this forum: Google [Bot] and 2 guests