OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Problem updating from ojs 2.2.4 to 2.4.2

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.

Re: Problem updating from ojs 2.2.4 to 2.4.2

Postby alexmackr » Mon Sep 16, 2013 1:23 pm

thanks Alec, 8264 ready.

Now I get the following error when updating

-1: ERROR: el tamaño de fila de índice 3944 excede el máximo 2712 para el índice «article_settings_name_value» HINT: Valores mayores a 1/3 de la página del buffer no pueden ser indexados. Considere un índice sobre una función que genere un hash MD5 del valor, o utilice un esquema de indexación de texto completo.

ADOConnection._Execute(
CREATE INDEX article_settings_name_value ON article_settings (setting_name, setting_value);
, false) % line 864, file: adodb.inc.php
ADOConnection.Execute(
CREATE INDEX article_settings_name_value ON article_settings (setting_name, setting_value);
) % line 443, file: Installer.inc.php
Installer.executeSQL(
CREATE INDEX article_settings_name_value ON article_settings (setting_name, setting_value);
) % line 438, file: Installer.inc.php
Installer.executeSQL(Array[4]) % line 399, file: Installer.inc.php
Installer.executeAction(Array[3]) % line 268, file: Installer.inc.php


Errors occurred during installation:

A database error has occurred: ERROR: el tamaño de fila de índice 3944 excede el máximo 2712 para el índice «article_settings_name_value» HINT: Valores mayores a 1/3 de la página del buffer no pueden ser indexados. Considere un índice sobre una función que genere un hash MD5 del valor, o utilice un esquema de indexación de texto completo.
alexmackr
 
Posts: 15
Joined: Wed Aug 11, 2010 9:11 am

Re: Problem updating from ojs 2.2.4 to 2.4.2

Postby asmecher » Tue Sep 17, 2013 3:05 pm

Hi alexmackr,

Hmm, that's a new one for me. If you look at dbscripts/xml/ojs_schema.xml, you'll see...
Code: Select all
<query driver="postgres7">
    CREATE INDEX article_settings_name_value ON article_settings (setting_name, setting_value);
</query>
That's the line that's causing problems. It's creating a database index on the article_settings table, and the error message is reporting that the content is too long.

I remember having a recent conversation about this with one of the developers but can't remember the outcome -- I believe we were planning to switch to a hash for queries but haven't done so yet.

That query is only used for a few public identifier queries so you're safe to remove those three lines for now, restore from backup, and run the upgrade script again. If you encounter performance problems when using public identifiers, post here again and we'll look for solutions. Once we move to a hash implementation a subsequent upgrade will resolve it automatically when you upgrade.

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

Previous

Return to OJS Technical Support

Who is online

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