Error in attach file in edition in a specific journal

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
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.
madriano
Posts: 55
Joined: Wed Nov 25, 2009 12:23 pm

Error in attach file in edition in a specific journal

Postby madriano » Fri Feb 07, 2014 5:34 am

Hi.

We have a new problem, maybe yet because of the last upgrade (viewtopic.php?f=8&t=10079).

- Logging as Editor, in submissions "in editing", inside in a document;
- "Layout" section, "Upload file to" ==> "Galley" (or other options of upload file), occurs the error below in this specific journal:


Code: Select all

DB Error: ERROR: duplicate key value violates unique constraint "article_galleys_pkey1" DETALHE: Key (galley_id)=(117) already exists.

Stack Trace:

File: /var/www/revistas/classes/article/ArticleGalleyDAO.inc.php line 321
Function: DAO->update("INSERT INTO article_galleys (article_id, file_id, label, loc...", Array(8))

File: /var/www/revistas/classes/submission/form/ArticleGalleyForm.inc.php line 275
Function: ArticleGalleyDAO->insertGalley(Object(ArticleGalley))

File: /var/www/revistas/pages/sectionEditor/SubmissionEditHandler.inc.php line 1794
Function: ArticleGalleyForm->execute("layoutFile", Null)

File: /var/www/revistas/pages/sectionEditor/SubmissionEditHandler.inc.php line 1643
Function: SubmissionEditHandler->_uploadGalley("layoutFile", Object(Request))

File: (unknown) line (unknown)
Function: SubmissionEditHandler->uploadLayoutFile(Array(0), Object(Request))

File: /var/www/revistas/lib/pkp/classes/core/PKPRouter.inc.php line 370
Function: call_user_func(Array(2), Array(0), Object(Request))

File: /var/www/revistas/lib/pkp/classes/core/PKPPageRouter.inc.php line 266
Function: PKPRouter->_authorizeInitializeAndCallRequest(Array(2), Object(Request), Array(0), False)

File: /var/www/revistas/lib/pkp/classes/core/Dispatcher.inc.php line 133
Function: PKPPageRouter->route(Object(Request))

File: /var/www/revistas/lib/pkp/classes/core/PKPApplication.inc.php line 189
Function: Dispatcher->dispatch(Object(Request))

File: /var/www/revistas/index.php line 63
Function: PKPApplication->execute()

asmecher
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm
Contact:

Re: Error in attach file in edition in a specific journal

Postby asmecher » Fri Feb 07, 2014 9:30 am

Hi madriano,

It sounds to me like your database sequence has gotten reset on the article_galleys table. See the first answer at [url]http://stackoverflow.com/questions/8923114/how-to-reset-auto-increment-in-mysql[url] -- note that you'll want to start with the highest ID value in that table, plus one.

Regards,
Alec Smecher
Public Knowledge Project Team

madriano
Posts: 55
Joined: Wed Nov 25, 2009 12:23 pm

Re: Error in attach file in edition in a specific journal

Postby madriano » Mon Feb 10, 2014 4:22 am

Hi Alec, thanks again!

Updated the sequence "article_galleys_galley_id_seq1" for the higher value of the galley_id field of the article_galleys table. Upload ok!

madriano
Posts: 55
Joined: Wed Nov 25, 2009 12:23 pm

Re: Error in attach file in edition in a specific journal

Postby madriano » Tue Apr 15, 2014 12:09 pm

Hi Alec, I again...

The following error is occurring, I think it´s related to the previous problem in this topic, but I don´t know which structures of the database (tables, sequences) it´s working:

Code: Select all

DB Error: ERROR: duplicate key value violates unique constraint "custom_issue_orders_pkey" DETALHE: Key (issue_id)=(5) already exists.

Stack Trace:

File: /var/www/revistas/classes/issue/IssueDAO.inc.php line 764
Function: DAO->update("INSERT INTO custom_issue_orders (issue_id, journal_id, seq) VALU...", Array(3))

File: /var/www/revistas/classes/issue/IssueDAO.inc.php line 684
Function: IssueDAO->insertCustomIssueOrder("28", "5", 1)

File: /var/www/revistas/classes/issue/IssueDAO.inc.php line 450
Function: IssueDAO->resequenceCustomIssueOrders("28")

File: /var/www/revistas/classes/issue/form/IssueForm.inc.php line 368
Function: IssueDAO->updateIssue(Object(Issue))

File: /var/www/revistas/pages/editor/IssueManagementHandler.inc.php line 258
Function: IssueForm->execute(192)

File: (unknown) line (unknown)
Function: IssueManagementHandler->editIssue(Array(1), Object(Request))

File: /var/www/revistas/lib/pkp/classes/core/PKPRouter.inc.php line 370
Function: call_user_func(Array(2), Array(1), Object(Request))

File: /var/www/revistas/lib/pkp/classes/core/PKPPageRouter.inc.php line 266
Function: PKPRouter->_authorizeInitializeAndCallRequest(Array(2), Object(Request), Array(1), False)

File: /var/www/revistas/lib/pkp/classes/core/Dispatcher.inc.php line 133
Function: PKPPageRouter->route(Object(Request))

File: /var/www/revistas/lib/pkp/classes/core/PKPApplication.inc.php line 189
Function: Dispatcher->dispatch(Object(Request))

File: /var/www/revistas/index.php line 63
Function: PKPApplication->execute()

asmecher
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm
Contact:

Re: Error in attach file in edition in a specific journal

Postby asmecher » Tue Apr 15, 2014 1:23 pm

Hi madriano,

See viewtopic.php?f=8&t=11482 for information on this.

Regards,
Alec Smecher
Public Knowledge Project Team


Return to “OJS Technical Support”

Who is online

Users browsing this forum: Google [Bot] and 1 guest