OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki

PKP Support

Support forums for the Public Knowledge Project

Skip to content


Software Hosting and Development Services available at PKP Publishing Services

As the developers of Open Journal Systems, Open Conference Systems, Open Harvester Systems, and Open Monograph Press, the PKP team are experts in helping journal managers and conference organizers make the most of their online publishing projects. PKP Publishing Services offers support for:

As a customer of PKP Publishing Services, you will not only receive direct, personalized support from the PKP Development Team, but will be contributing to the ongoing development of the PKP applications. All funds raised by PKP Publishing Services go directly toward enhancing our free, open source software. For more information, please contact us.

Manual Update error

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, michael, jheckman, barbarah, btbell, bdgregg, 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.
Post a reply

Manual Update error

Postby eruthes » Tue Oct 10, 2006 11:21 am

My configurations:
Code: Select all
OJS version    2.1.0.1
OS platform     Linux
PHP version    5.1.6-2
Apache version    Apache/2.0.55 (Debian) PHP/5.1.6-2
Database driver    postgres
Database server version    PostgreSQL 8.1.4 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.2 20060920 (prerelease) (Debian 4.1.1-14)


I downloaded the last version of the OJS, unpacked on the old codes.
I followed the instructions, clicked in the Manual Upgrade button to get the SQLs to update the database manually.

I'm getting these errors:
Code: Select all
Notice: Undefined index: url in /home/eruthes/public_html/ojsproducao/classes/article/AuthorDAO.inc.php on line 179

Notice: Undefined index: url in /home/eruthes/public_html/ojsproducao/classes/article/AuthorDAO.inc.php on line 179

Notice: Undefined index: url in /home/eruthes/public_html/ojsproducao/classes/article/AuthorDAO.inc.php on line 179

Notice: Undefined index: url in /home/eruthes/public_html/ojsproducao/classes/article/AuthorDAO.inc.php on line 179

Notice: Undefined index: url in /home/eruthes/public_html/ojsproducao/classes/article/AuthorDAO.inc.php on line 179

Notice: Undefined index: assoc_id in /home/eruthes/public_html/ojsproducao/classes/article/ArticleFileDAO.inc.php on line 234

Notice: Undefined index: url in /home/eruthes/public_html/ojsproducao/classes/article/AuthorDAO.inc.php on line 179

Notice: Undefined index: assoc_id in /home/eruthes/public_html/ojsproducao/classes/article/ArticleFileDAO.inc.php on line 234
DB Error: ERRO: coluna "assoc_id" da relação "article_files" não existe


When I comment the designateReviewVersions function on dbscripts/xml/upgrade.xml the dumb error changes to:
Code: Select all
DB Error: ERRO: relação "rt_settings" não existe


When I also comment the migrateRtSettings function on dbscripts/xml/upgrade.xml, everything seems to run normally and I car edit the SQLs to insert the corrections posted from myself on http://pkp.sfu.ca/support/forum/viewtopic.php?t=1144
eruthes
 
Posts: 26
Joined: Mon Nov 21, 2005 9:33 am
Location: Curitiba, Paraná - Brasil
Top

Postby asmecher » Tue Oct 10, 2006 11:54 am

Hi eruthes,

It looks like you still need to re-sync the OJS database against the XML file. Try running:
Code: Select all
php tools/upgrade.php upgrade
This will create the missing table and add the new columns. (NOTE: This command line has been corrected)

Regards,
Alec Smecher
Open Journal Systems Team
Last edited by asmecher on Wed Oct 11, 2006 8:31 am, edited 1 time in total.
asmecher
 
Posts: 5769
Joined: Wed Aug 10, 2005 12:56 pm
Top

Postby eruthes » Wed Oct 11, 2006 8:16 am

are you sure that the command is these?

Code: Select all
jason@~/public_html/ojsproducao$ php dbscripts/xml/upgrade.php upgrade
Could not open input file: dbscripts/xml/upgrade.php

There is no .php file on these directory, but upgrade.xml also return a parse error.

Thanks,
Eduardo Ruthes
eruthes
 
Posts: 26
Joined: Mon Nov 21, 2005 9:33 am
Location: Curitiba, Paraná - Brasil
Top

Postby asmecher » Wed Oct 11, 2006 8:30 am

Hi Eduardo,

Sorry, my mistake. The command line should be:
Code: Select all
php tools/upgrade.php upgrade
You may receive an error message regarding duplicate inserts; this is fine.

Regards,
Alec Smecher
Open Journal Systems Team
asmecher
 
Posts: 5769
Joined: Wed Aug 10, 2005 12:56 pm
Top
Post a reply

Return to OJS Technical Support

Who is online

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

Powered by phpBB® Forum Software © phpBB Group