OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



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
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.

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()
madriano
 
Posts: 52
Joined: Wed Nov 25, 2009 12:23 pm

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
asmecher
 
Posts: 8479
Joined: Wed Aug 10, 2005 12:56 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: 52
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()
madriano
 
Posts: 52
Joined: Wed Nov 25, 2009 12:23 pm

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
asmecher
 
Posts: 8479
Joined: Wed Aug 10, 2005 12:56 pm


Return to OJS Technical Support

Who is online

Users browsing this forum: No registered users and 2 guests