PLN plugin and php error

Hi Alec,

I turned off the depprecation_warnings and I’ll post tomorrow the error_log.

I haven’t made any modifications to the code. I’m not a programmer. I upgraded the installation following these instructions:

Full Package

If you have not made local code modifications to the system, upgrade by
downloading the complete package for the latest release of OJS:

- Download and decompress the package from the OJS web site
- Make a copy of the config.inc.php provided in the new package
- Move or copy the following files and directories from your current OJS
  installation:
    - config.inc.php
    - public/
    - Your uploaded files directory ("files_dir" in config.inc.php), if it
      resides within your OJS directory
- Replace the current OJS directory with the new OJS directory, moving the
  old one to a safe location as a backup
- Be sure to review the Configuration Changes section of the release notes
  in docs/release-notes/README-(version) for all versions between your
  original version and the new version. You may need to manually add
  new items to your config.inc.php file.

Upgrading the OJS database

After obtaining the latest OJS code, an additional script must be run to
complete the upgrade process by upgrading the OJS database and potentially
executing additional upgrade code.

  1. Web

If you do not have the PHP CLI installed, you can also upgrade by running a
web-based script. To do so:

- Edit config.inc.php and change "installed = On" to "installed = Off"
- Open a web browser to your OJS site; you should be redirected to the
  installation and upgrade page
- Select the "Upgrade" link and follow the on-screen instructions
- Re-edit config.inc.php and change "installed = Off" back to
   "installed = On"

After doing this, I go to MySQL Databases on the CPanel and click on “Repair it” because I can’t access previous articles if I don’t repair the database. After doing it, everything seems to work. Am I doing something wrong?

Hi @aguilera99,

Hmm, that “repair it” step is a red flag. When you clicked the “upgrade” link in the web interface, did you get confirmation of a completed upgrade?

In any case, that ought not cause the error message you described earlier. Do you have any third-party plugins installed? What part of the site are you in when that error message appears – everywhere, or just in a specific page?

Regards,
Alec Smecher
Public Knowledge Project Team

Hi Alec,

Yes, I get the confirmation of a complete upgrade. I don’t have any third-party plugins installed.

I get the error when I click on the submissions. I’m pasting the error that I’m getting (which is “fixed” when I repair the database on MySQL):

DB Error: The SELECT would examine more than MAX_JOIN_SIZE rows;
check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if
the SELECT is okayStack Trace:
File: /home9/revistj8/public_html/classes/submission/editor/EditorSubmissionDAO.inc.php line 356

Function: DAO->retrieveRange(“SELECT DISTINCT
a.*,
scf.date_completed as copyedit_comp…”, Array(21), Object(DBResultRange))

File: /home9/revistj8/public_html/classes/submission/editor/EditorSubmissionDAO.inc.php line 402

Function:
EditorSubmissionDAO->_getUnfilteredEditorSubmissions(“1”, 0, 0, Null,
Null, Null, Null, Null, Null, “a.status = 1 AND ea.edit_id IS NULL”,
Object(DBResultRange), “id”, 1)

File: /home9/revistj8/public_html/pages/editor/EditorHandler.inc.php line 263

Function:
EditorSubmissionDAO->getEditorSubmissionsUnassigned(“1”, 0, 0, Null,
Null, Null, Null, Null, Null, Object(DBResultRange), “id”, 1)

File: (unknown) line (unknown)

Function: EditorHandler->submissions(Array(1), Object(Request))

File: /home9/revistj8/public_html/lib/pkp/classes/core/PKPRouter.inc.php line 362

Function: call_user_func(Array(2), Array(1), Object(Request))

File: /home9/revistj8/public_html/lib/pkp/classes/core/PKPPageRouter.inc.php line 220

Function: PKPRouter->_authorizeInitializeAndCallRequest(Array(2), Object(Request), Array(1), False)

File: /home9/revistj8/public_html/lib/pkp/classes/core/Dispatcher.inc.php line 134

Function: PKPPageRouter->route(Object(Request))

File: /home9/revistj8/public_html/lib/pkp/classes/core/PKPApplication.inc.php line 178

Function: Dispatcher->dispatch(Object(Request))

File: /home9/revistj8/public_html/index.php line 64

Function: PKPApplication->execute()

Hi @aguilera99,

You’ll need to tweak your MySQL configuration slightly. If you send the error message to your server admin, they should be able to extend the join limit. Alternately, some users have worked around the limit another way; see https://pkp.sfu.ca/support/forum/viewtopic.php?f=8&t=2844 for details.

Regards,
Alec Smecher
Public Knowledge Project Team

Thanks Alec,

I fixed it adding $this->dbconn->Execute(“SET OPTION SQL_BIG_SELECTS=1”); to the DBConnection.inc.php file. Now, it works.

I think the SQL construction in EditorSubmissionDAO::_getUnfilteredEditorSubmissions() is potentially a bug. See also Error in "Stats & Reports" page - #6 by vleyrob and EditorSubmissionDAO::_getUnfilteredEditorSubmissions() needs a bit more filtering · Issue #888 · pkp/pkp-lib · GitHub.

Hi @ctgraham & all,

That’s possible and I can potentially help track down the problem; I know that SQL fairly well. @ctgraham, have you been able to locally show a similar problem?

If anyone experiencing this is willing to send me a database dump, please PM me details.

Regards,
Alec Smecher
Public Knowledge Project Team

I have not had a similar problem. I guess we could simulate it by getting a count on the full join product and then lowering MAX_JOIN_SIZE to that.

Dear Alec,

Now I’m having the following error.
PHP Fatal error: Call to a member function getQualifiedDAOName() on a non-object in /home9/revistj8/public_html/lib/pkp/classes/db/DAORegistry.inc.php on line 63

Everything seems to work but I don’t know what is the problem
Regards

Hi @asmecher,

Could you turn on the show_stacktrace option in config.inc.php, and when you see the error, post the complete stack trace here?

Regards,
Alec Smecher
Public Knowledge Project Team

Hi Alec,

The following is the list of errors that I’ve been getting. I have no clue about what I’m doing wrong.

[05-Dec-2015 14:41:12] PHP Fatal error: Call to a member function getQualifiedDAOName() on a non-object in /home9/revistj8/public_html/lib/pkp/classes/db/DAORegistry.inc.php on line 63
[05-Dec-2015 14:43:56] PHP Fatal error: Call to a member function getQualifiedDAOName() on a non-object in /home9/revistj8/public_html/lib/pkp/classes/db/DAORegistry.inc.php on line 63
[05-Dec-2015 17:50:51] ojs2: 404 Not Found
[06-Dec-2015 17:30:47] ojs2: 404 Not Found
[06-Dec-2015 19:31:18] ojs2: Database connection failed!
[06-Dec-2015 19:31:18] ojs2: Database connection failed!
[06-Dec-2015 19:31:18] ojs2: Database connection failed!
[07-Dec-2015 01:28:20] ojs2 has produced an error
Message: USER ERROR: Smarty error: [in file:/home9/revistj8/public_html/plugins/citationFormats/bibtex//citation.tpl line 32]: syntax error: unrecognized tag ‘/literal’ (Smarty_Compiler.class.php, line 590)
In file: /home9/revistj8/public_html/lib/pkp/lib/smarty/Smarty.class.php
At line: 1093
Stacktrace:
File: (unknown) line (unknown)
Function: PKPApplication->errorHandler(256, “Smarty error: [in file:/home9/revistj8/public_html/plugins/citationFormats/bibtex//citation.tpl line 32]: syntax error: unrecognized tag ‘/literal’ (Smarty_Compiler.class.php, line 590)”, “/home9/revistj8/public_html/lib/pkp/lib/smarty/Smarty.class.php”, 1093, Array(2))
File: /home9/revistj8/public_html/lib/pkp/lib/smarty/Smarty.class.php line 1093
Function: trigger_error(“Smarty error: [in file:/home9/revistj8/public_html/plugins/citationFormats/bibtex//citation.tpl line 32]: syntax error: unrecognized tag ‘/literal’ (Smarty_Compiler.class.php, line 590)”, 256)
File: /home9/revistj8/public_html/lib/pkp/lib/smarty/Smarty.class.php line 1815
Function: Smarty->trigger_error("[in file:/home9/revistj8/public_html/plugins/citationFormats/bibtex//citation.tpl line 32]: syntax error: unrecognized tag ‘/literal’ (Smarty_Compiler.class.php, line 590)", 256)
File: /home9/revistj8/public_html/lib/pkp/lib/smarty/Smarty_Compiler.class.php line 2256
Function: Smarty->_trigger_fatal_error(“syntax error: unrecognized tag ‘/literal’”, “file:/home9/revistj8/public_html/plugins/citationFormats/bibtex//citation.tpl”, 32, “/home9/revistj8/public_html/lib/pkp/lib/smarty/Smarty_Compiler.class.php”, 590, 256)
File: /home9/revistj8/public_html/lib/pkp/lib/smarty/Smarty_Compiler.class.php line 590
Function: Smarty_Compiler->_syntax_error(“unrecognized tag ‘/literal’”, 256, “/home9/revistj8/public_html/lib/pkp/lib/smarty/Smarty_Compiler.class.php”, 590)
File: /home9/revistj8/public_html/lib/pkp/lib/smarty/Smarty_Compiler.class.php line 312
Function: Smarty_Compiler->_compile_tag("/literal")
File: /home9/revistj8/public_html/lib/pkp/lib/smarty/Smarty.class.php line 1489
Function: Smarty_Compiler->_compile_file(“file:/home9/revistj8/public_html/plugins/citationFormats/bibtex//citation.tpl”, "{**

  • plugins/citationFormats/bibtex/citation.tpl
  • Copyright (c) 2013-2015 Simon Fraser University Library
  • Copyright (c) 2003-2015 John Willinsky
  • Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
  • Article reading tools – Capture Citation BibTeX format

}
<div class=“separator”></div>
<div id=“citation”>
{literal}
<pre style=“font-size: 1.5em; white-space: pre-wrap; white-space: -moz-pre-wrap !important; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;”>@article{{/literal}{$journal->getLocalizedInitials()|bibtex_escape}{$articleId|bibtex_escape}{literal},
author = {{/literal}{assign var=authors value=$article->getAuthors()}{foreach from=$authors item=author name=authors key=i}{assign var=firstName value=$author->getFirstName()}{assign var=authorCount value=$authors|@count}{$firstName|bibtex_escape} {$author->getLastName()|bibtex_escape}{if $i<$authorCount-1} {translate key=“common.and”} {/if}{/foreach}{literal}},
title = {{/literal}{$article->getLocalizedTitle()|strip_tags|bibtex_escape}{literal}},
journal = {{/literal}{$journal->getLocalizedTitle()|bibtex_escape}{literal}},
{/literal}{if $issue}{literal} volume = {{/literal}{$issue->getVolume()|bibtex_escape}{literal}},
number = {{/literal}{$issue->getNumber()|bibtex_escape}{literal}},{/literal}{/if}{literal}
year = {{/literal}{if $article->getDatePublished()}{$article->getDatePublished()|date_format:’%Y’}{elseif $issue->getDatePublished()}{$issue->getDatePublished()|date_format:’%Y’}{else}{$issue->getYear()|escape}{/if}{literal}},
keywords = {{/literal}{$article->getLocalizedSubject()|bibtex_escape}{literal}},
abstract = {{/literal}{$article->getLocalizedAbstract()|strip_tags:false|bibtex_escape}{literal}},
{/literal}{assign var=onlineIssn value=$journal->getSetting(‘onlineIssn’)}
{assign var=issn value=$journal->getSetting(‘issn’)}{if $issn}{literal} issn = {{/literal}{$issn|bibtex_escape}{literal}},{/literal}
{elseif $onlineIssn}{literal} issn = {{/literal}{$onlineIssn|bibtex_escape}{literal}},{/literal}{/if}
{if $article->getPages()}{if $article->getStartingPage()} pages = {literal}{{/literal}{$article->getStartingPage()}{if $article->getEndingPage()}–{$article->getEndingPage()}{/if}{literal}}{/literal}{/if}{/if}
{if $article->getPubId(‘doi’)} doi = {ldelim}{$article->getPubId(‘doi’)|escape}{rdelim},
{/if}
url = {ldelim}{url|bibtex_escape page=“article” op=“view” path=$article->getBestArticleId()}{rdelim}
{rdelim}
</pre>
{/literal}
</div>
", Null)
File: /home9/revistj8/public_html/lib/pkp/lib/smarty/Smarty.class.php line 1422
Function: Smarty->_compile_source(“file:/home9/revistj8/public_html/plugins/citationFormats/bibtex//citation.tpl”, "{
*

  • plugins/citationFormats/bibtex/citation.tpl
  • Copyright (c) 2013-2015 Simon Fraser University Library
  • Copyright (c) 2003-2015 John Willinsky
  • Distributed under the GNU GPL v2. For full terms see the file docs/COPYING.
  • Article reading tools – Capture Citation BibTeX format

*}
<div class=“separator”></div>
<div id=“citation”>
{literal}
<pre style=“font-size: 1.5em; white-space: pre-wrap; white-space: -moz-pre-wrap !important; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;”>@article{{/literal}{$journal->getLocalizedInitials()|bibtex_escape}{$articleId|bibtex_escape}{literal},
author = {{/literal}{assign var=authors value=$article->getAuthors()}{foreach from=$authors item=author name=authors key=i}{assign var=firstName value=$author->getFirstName()}{assign var=authorCount value=$authors|@count}{$firstName|bibtex_escape} {$author->getLastName()|bibtex_escape}{if $i<$authorCount-1} {translate key=“common.and”} {/if}{/foreach}{literal}},
title = {{/literal}{$article->getLocalizedTitle()|strip_tags|bibtex_escape}{literal}},
journal = {{/literal}{$journal->getLocalizedTitle()|bibtex_escape}{literal}},
{/literal}{if $issue}{literal} volume = {{/literal}{$issue->getVolume()|bibtex_escape}{literal}},
number = {{/literal}{$issue->getNumber()|bibtex_escape}{literal}},{/literal}{/if}{literal}
year = {{/literal}{if $article->getDatePublished()}{$article->getDatePublished()|date_format:’%Y’}{elseif $issue->getDatePublished()}{$issue->getDatePublished()|date_format:’%Y’}{else}{$issue->getYear()|escape}{/if}{literal}},
keywords = {{/literal}{$article->getLocalizedSubject()|bibtex_escape}{literal}},
abstract = {{/literal}{$article->getLocalizedAbstract()|strip_tags:false|bibtex_escape}{literal}},
{/literal}{assign var=onlineIssn value=$journal->getSetting(‘onlineIssn’)}
{assign var=issn value=$journal->getSetting(‘issn’)}{if $issn}{literal} issn = {{/literal}{$issn|bibtex_escape}{literal}},{/literal}
{elseif $onlineIssn}{literal} issn = {{/literal}{$onlineIssn|bibtex_escape}{literal}},{/literal}{/if}
{if $article->getPages()}{if $article->getStartingPage()} pages = {literal}{{/literal}{$article->getStartingPage()}{if $article->getEndingPage()}–{$article->getEndingPage()}{/if}{literal}}{/literal}{/if}{/if}
{if $article->getPubId(‘doi’)} doi = {ldelim}{$article->getPubId(‘doi’)|escape}{rdelim},
{/if}
url = {ldelim}{url|bibtex_escape page=“article” op=“view” path=$article->getBestArticleId()}{rdelim}
{rdelim}
</pre>
{/literal}
</div>
“, Null, “/home9/revistj8/public_html/cache/t_compile/%%95^952^952BB180%%citation.tpl.inc”)
File: /home9/revistj8/public_html/lib/pkp/lib/smarty/Smarty.class.php line 1261
Function: Smarty->_compile_resource(“file:/home9/revistj8/public_html/plugins/citationFormats/bibtex//citation.tpl”, “/home9/revistj8/public_html/cache/t_compile/%%95^952^952BB180%%citation.tpl.php”)
File: /home9/revistj8/public_html/lib/pkp/classes/template/PKPTemplateManager.inc.php line 296
Function: Smarty->fetch(“file:/home9/revistj8/public_html/plugins/citationFormats/bibtex//citation.tpl”, Null, Null, False)
File: /home9/revistj8/public_html/classes/plugins/CitationPlugin.inc.php line 67
Function: PKPTemplateManager->fetch(“file:/home9/revistj8/public_html/plugins/citationFormats/bibtex//citation.tpl”)
File: (unknown) line (unknown)
Function: CitationPlugin->displayCitationHook(“Template::RT::CaptureCite”, Array(3))
File: /home9/revistj8/public_html/lib/pkp/classes/plugins/HookRegistry.inc.php line 89
Function: call_user_func(Array(2), “Template::RT::CaptureCite”, Array(3))
File: /home9/revistj8/public_html/lib/pkp/classes/template/PKPTemplateManager.inc.php line 704
Function: HookRegistry->call(“Template::RT::CaptureCite”, Array(3))
File: /home9/revistj8/public_html/cache/t_compile/%%91^91A^91A91A9E%%captureCite.tpl.php line 38
Function: PKPTemplateManager->smartyCallHook(Array(1), Object(TemplateManager))
File: /home9/revistj8/public_html/lib/pkp/lib/smarty/Smarty.class.php line 1256
Function: include(”/home9/revistj8/public_html/cache/t_compile/%%91^91A^91A91A9E%%captureCite.tpl.php")
File: /home9/revistj8/public_html/lib/pkp/classes/template/PKPTemplateManager.inc.php line 296
Function: Smarty->fetch(“rt/captureCite.tpl”, Null, Null, True)
File: /home9/revistj8/public_html/lib/pkp/classes/template/PKPTemplateManager.inc.php line 347
Function: PKPTemplateManager->fetch(“rt/captureCite.tpl”, Null, Null, True)
File: /home9/revistj8/public_html/classes/plugins/CitationPlugin.inc.php line 85
Function: PKPTemplateManager->display(“rt/captureCite.tpl”)
File: /home9/revistj8/public_html/pages/rt/RTHandler.inc.php line 203
Function: CitationPlugin->displayCitation(Object(PublishedArticle), Object(Issue), Object(Journal))
File: (unknown) line (unknown)
Function: RTHandler->captureCite(Array(3), Object(Request))
File: /home9/revistj8/public_html/lib/pkp/classes/core/PKPRouter.inc.php line 362
Function: call_user_func(Array(2), Array(3), Object(Request))
File: /home9/revistj8/public_html/lib/pkp/classes/core/PKPPageRouter.inc.php line 220
Function: PKPRouter->_authorizeInitializeAndCallRequest(Array(2), Object(Request), Array(3), False)
File: /home9/revistj8/public_html/lib/pkp/classes/core/Dispatcher.inc.php line 134
Function: PKPPageRouter->route(Object(Request))
File: /home9/revistj8/public_html/lib/pkp/classes/core/PKPApplication.inc.php line 178
Function: Dispatcher->dispatch(Object(Request))
File: /home9/revistj8/public_html/index.php line 64
Function: PKPApplication->execute()
Server info:
OS: Linux
PHP Version: 5.2.17
Apache Version: N/A
DB Driver: mysql
DB server version: 5.5.42-37.1-log
[07-Dec-2015 01:28:22] ojs2: 404 Not Found
[07-Dec-2015 01:43:29] ojs2: 404 Not Found
[07-Dec-2015 08:08:30] ojs2 has produced an error
Message: WARNING: fsockopen() [function.fsockopen]: php_network_getaddresses: getaddrinfo failed: Nombre o servicio desconocido
In file: /home9/revistj8/public_html/lib/pkp/classes/file/wrappers/HTTPFileWrapper.inc.php
At line: 77
Stacktrace:
File: (unknown) line (unknown)
Function: PKPApplication->errorHandler(2, “fsockopen() [<a href=‘function.fsockopen’>function.fsockopen</a>]: php_network_getaddresses: getaddrinfo failed: Nombre o servicio desconocido”, “/home9/revistj8/public_html/lib/pkp/classes/file/wrappers/HTTPFileWrapper.inc.php”, 77, Array(7))
File: /home9/revistj8/public_html/lib/pkp/classes/file/wrappers/HTTPFileWrapper.inc.php line 77
Function: fsockopen(“pkp.sfu.ca”, 80, 0, “”)
File: /home9/revistj8/public_html/lib/pkp/classes/file/FileWrapper.inc.php line 53
Function: HTTPFileWrapper->open()
File: /home9/revistj8/public_html/lib/pkp/classes/xml/XMLParser.inc.php line 258
Function: FileWrapper->contents()
File: /home9/revistj8/public_html/lib/pkp/classes/db/XMLDAO.inc.php line 56
Function: XMLParser->parseStruct(“http://pkp.sfu.ca/ojs/xml/ojs-version.xml?id=53a59b077efd6&oai=http%3A%2F%2Frevistapsicologia.org%2Findex.php%2Findex%2Foai”, Array(0))
File: /home9/revistj8/public_html/lib/pkp/classes/site/VersionCheck.inc.php line 82
Function: XMLDAO->parseStruct(“http://pkp.sfu.ca/ojs/xml/ojs-version.xml?id=53a59b077efd6&oai=http%3A%2F%2Frevistapsicologia.org%2Findex.php%2Findex%2Foai”, Array(0))
File: /home9/revistj8/public_html/lib/pkp/classes/site/VersionCheck.inc.php line 47
Function: VersionCheck->parseVersionXML(“http://pkp.sfu.ca/ojs/xml/ojs-version.xml?id=53a59b077efd6&oai=http%3A%2F%2Frevistapsicologia.org%2Findex.php%2Findex%2Foai”)
File: /home9/revistj8/public_html/lib/pkp/classes/site/VersionCheck.inc.php line 205
Function: VersionCheck->getLatestVersion()
File: /home9/revistj8/public_html/pages/manager/ManagerHandler.inc.php line 42
Function: VersionCheck->checkIfNewVersionExists()
File: (unknown) line (unknown)
Function: ManagerHandler->index(Array(0), Object(Request))
File: /home9/revistj8/public_html/lib/pkp/classes/core/PKPRouter.inc.php line 362
Function: call_user_func(Array(2), Array(0), Object(Request))
File: /home9/revistj8/public_html/lib/pkp/classes/core/PKPPageRouter.inc.php line 220
Function: PKPRouter->_authorizeInitializeAndCallRequest(Array(2), Object(Request), Array(0), False)
File: /home9/revistj8/public_html/lib/pkp/classes/core/Dispatcher.inc.php line 134
Function: PKPPageRouter->route(Object(Request))
File: /home9/revistj8/public_html/lib/pkp/classes/core/PKPApplication.inc.php line 178
Function: Dispatcher->dispatch(Object(Request))
File: /home9/revistj8/public_html/index.php line 64
Function: PKPApplication->execute()
Server info:
OS: Linux
PHP Version: 5.2.17
Apache Version: N/A
DB Driver: mysql
DB server version: 5.5.42-37.1-log
[07-Dec-2015 08:08:30] ojs2 has produced an error
Message: WARNING: fsockopen() [function.fsockopen]: unable to connect to pkp.sfu.ca:80 (php_network_getaddresses: getaddrinfo failed: Nombre o servicio desconocido)
In file: /home9/revistj8/public_html/lib/pkp/classes/file/wrappers/HTTPFileWrapper.inc.php
At line: 77
Stacktrace:
File: (unknown) line (unknown)
Function: PKPApplication->errorHandler(2, “fsockopen() [<a href=‘function.fsockopen’>function.fsockopen</a>]: unable to connect to pkp.sfu.ca:80 (php_network_getaddresses: getaddrinfo failed: Nombre o servicio desconocido)”, “/home9/revistj8/public_html/lib/pkp/classes/file/wrappers/HTTPFileWrapper.inc.php”, 77, Array(7))
File: /home9/revistj8/public_html/lib/pkp/classes/file/wrappers/HTTPFileWrapper.inc.php line 77
Function: fsockopen(“pkp.sfu.ca”, 80, 0, “”)
File: /home9/revistj8/public_html/lib/pkp/classes/file/FileWrapper.inc.php line 53
Function: HTTPFileWrapper->open()
File: /home9/revistj8/public_html/lib/pkp/classes/xml/XMLParser.inc.php line 258
Function: FileWrapper->contents()
File: /home9/revistj8/public_html/lib/pkp/classes/db/XMLDAO.inc.php line 56
Function: XMLParser->parseStruct(“http://pkp.sfu.ca/ojs/xml/ojs-version.xml?id=53a59b077efd6&oai=http%3A%2F%2Frevistapsicologia.org%2Findex.php%2Findex%2Foai”, Array(0))
File: /home9/revistj8/public_html/lib/pkp/classes/site/VersionCheck.inc.php line 82
Function: XMLDAO->parseStruct(“http://pkp.sfu.ca/ojs/xml/ojs-version.xml?id=53a59b077efd6&oai=http%3A%2F%2Frevistapsicologia.org%2Findex.php%2Findex%2Foai”, Array(0))
File: /home9/revistj8/public_html/lib/pkp/classes/site/VersionCheck.inc.php line 47
Function: VersionCheck->parseVersionXML(“http://pkp.sfu.ca/ojs/xml/ojs-version.xml?id=53a59b077efd6&oai=http%3A%2F%2Frevistapsicologia.org%2Findex.php%2Findex%2Foai”)
File: /home9/revistj8/public_html/lib/pkp/classes/site/VersionCheck.inc.php line 205
Function: VersionCheck->getLatestVersion()
File: /home9/revistj8/public_html/pages/manager/ManagerHandler.inc.php line 42
Function: VersionCheck->checkIfNewVersionExists()
File: (unknown) line (unknown)
Function: ManagerHandler->index(Array(0), Object(Request))
File: /home9/revistj8/public_html/lib/pkp/classes/core/PKPRouter.inc.php line 362
Function: call_user_func(Array(2), Array(0), Object(Request))
File: /home9/revistj8/public_html/lib/pkp/classes/core/PKPPageRouter.inc.php line 220
Function: PKPRouter->_authorizeInitializeAndCallRequest(Array(2), Object(Request), Array(0), False)
File: /home9/revistj8/public_html/lib/pkp/classes/core/Dispatcher.inc.php line 134
Function: PKPPageRouter->route(Object(Request))
File: /home9/revistj8/public_html/lib/pkp/classes/core/PKPApplication.inc.php line 178
Function: Dispatcher->dispatch(Object(Request))
File: /home9/revistj8/public_html/index.php line 64
Function: PKPApplication->execute()
Server info:
OS: Linux
PHP Version: 5.2.17
Apache Version: N/A
DB Driver: mysql
DB server version: 5.5.42-37.1-log
[07-Dec-2015 08:08:35] ojs2 has produced an error
Message: WARNING: fsockopen() [function.fsockopen]: php_network_getaddresses: getaddrinfo failed: Fallo temporal en la resolución del nombre
In file: /home9/revistj8/public_html/lib/pkp/classes/file/wrappers/HTTPFileWrapper.inc.php
At line: 77
Stacktrace:
File: (unknown) line (unknown)
Function: PKPApplication->errorHandler(2, “fsockopen() [<a href=‘function.fsockopen’>function.fsockopen</a>]: php_network_getaddresses: getaddrinfo failed: Fallo temporal en la resolución del nombre”, “/home9/revistj8/public_html/lib/pkp/classes/file/wrappers/HTTPFileWrapper.inc.php”, 77, Array(7))
File: /home9/revistj8/public_html/lib/pkp/classes/file/wrappers/HTTPFileWrapper.inc.php line 77
Function: fsockopen(“pkp.sfu.ca”, 80, 0, “”)
File: /home9/revistj8/public_html/lib/pkp/classes/file/FileWrapper.inc.php line 53
Function: HTTPFileWrapper->open()
File: /home9/revistj8/public_html/lib/pkp/classes/xml/XMLParser.inc.php line 258
Function: FileWrapper->contents()
File: /home9/revistj8/public_html/lib/pkp/classes/db/XMLDAO.inc.php line 56
Function: XMLParser->parseStruct(“http://pkp.sfu.ca/ojs/xml/ojs-version.xml?id=53a59b077efd6&oai=http%3A%2F%2Frevistapsicologia.org%2Findex.php%2Findex%2Foai”, Array(0))
File: /home9/revistj8/public_html/lib/pkp/classes/site/VersionCheck.inc.php line 82
Function: XMLDAO->parseStruct(“http://pkp.sfu.ca/ojs/xml/ojs-version.xml?id=53a59b077efd6&oai=http%3A%2F%2Frevistapsicologia.org%2Findex.php%2Findex%2Foai”, Array(0))
File: /home9/revistj8/public_html/lib/pkp/classes/site/VersionCheck.inc.php line 47
Function: VersionCheck->parseVersionXML(“http://pkp.sfu.ca/ojs/xml/ojs-version.xml?id=53a59b077efd6&oai=http%3A%2F%2Frevistapsicologia.org%2Findex.php%2Findex%2Foai”)
File: /home9/revistj8/public_html/lib/pkp/classes/site/VersionCheck.inc.php line 205
Function: VersionCheck->getLatestVersion()
File: /home9/revistj8/public_html/pages/manager/ManagerHandler.inc.php line 42
Function: VersionCheck->checkIfNewVersionExists()
File: (unknown) line (unknown)
Function: ManagerHandler->index(Array(0), Object(Request))
File: /home9/revistj8/public_html/lib/pkp/classes/core/PKPRouter.inc.php line 362
Function: call_user_func(Array(2), Array(0), Object(Request))
File: /home9/revistj8/public_html/lib/pkp/classes/core/PKPPageRouter.inc.php line 220
Function: PKPRouter->_authorizeInitializeAndCallRequest(Array(2), Object(Request), Array(0), False)
File: /home9/revistj8/public_html/lib/pkp/classes/core/Dispatcher.inc.php line 134
Function: PKPPageRouter->route(Object(Request))
File: /home9/revistj8/public_html/lib/pkp/classes/core/PKPApplication.inc.php line 178
Function: Dispatcher->dispatch(Object(Request))
File: /home9/revistj8/public_html/index.php line 64
Function: PKPApplication->execute()
Server info:
OS: Linux
PHP Version: 5.2.17
Apache Version: N/A
DB Driver: mysql
DB server version: 5.5.42-37.1-log
[07-Dec-2015 08:08:35] ojs2 has produced an error
Message: WARNING: fsockopen() [function.fsockopen]: unable to connect to pkp.sfu.ca:80 (php_network_getaddresses: getaddrinfo failed: Fallo temporal en la resolución del nombre)
In file: /home9/revistj8/public_html/lib/pkp/classes/file/wrappers/HTTPFileWrapper.inc.php
At line: 77
Stacktrace:
File: (unknown) line (unknown)
Function: PKPApplication->errorHandler(2, “fsockopen() [<a href=‘function.fsockopen’>function.fsockopen</a>]: unable to connect to pkp.sfu.ca:80 (php_network_getaddresses: getaddrinfo failed: Fallo temporal en la resolución del nombre)”, “/home9/revistj8/public_html/lib/pkp/classes/file/wrappers/HTTPFileWrapper.inc.php”, 77, Array(7))
File: /home9/revistj8/public_html/lib/pkp/classes/file/wrappers/HTTPFileWrapper.inc.php line 77
Function: fsockopen(“pkp.sfu.ca”, 80, 0, “”)
File: /home9/revistj8/public_html/lib/pkp/classes/file/FileWrapper.inc.php line 53
Function: HTTPFileWrapper->open()
File: /home9/revistj8/public_html/lib/pkp/classes/xml/XMLParser.inc.php line 258
Function: FileWrapper->contents()
File: /home9/revistj8/public_html/lib/pkp/classes/db/XMLDAO.inc.php line 56
Function: XMLParser->parseStruct(“http://pkp.sfu.ca/ojs/xml/ojs-version.xml?id=53a59b077efd6&oai=http%3A%2F%2Frevistapsicologia.org%2Findex.php%2Findex%2Foai”, Array(0))
File: /home9/revistj8/public_html/lib/pkp/classes/site/VersionCheck.inc.php line 82
Function: XMLDAO->parseStruct(“http://pkp.sfu.ca/ojs/xml/ojs-version.xml?id=53a59b077efd6&oai=http%3A%2F%2Frevistapsicologia.org%2Findex.php%2Findex%2Foai”, Array(0))
File: /home9/revistj8/public_html/lib/pkp/classes/site/VersionCheck.inc.php line 47
Function: VersionCheck->parseVersionXML(“http://pkp.sfu.ca/ojs/xml/ojs-version.xml?id=53a59b077efd6&oai=http%3A%2F%2Frevistapsicologia.org%2Findex.php%2Findex%2Foai”)
File: /home9/revistj8/public_html/lib/pkp/classes/site/VersionCheck.inc.php line 205
Function: VersionCheck->getLatestVersion()
File: /home9/revistj8/public_html/pages/manager/ManagerHandler.inc.php line 42
Function: VersionCheck->checkIfNewVersionExists()
File: (unknown) line (unknown)
Function: ManagerHandler->index(Array(0), Object(Request))
File: /home9/revistj8/public_html/lib/pkp/classes/core/PKPRouter.inc.php line 362
Function: call_user_func(Array(2), Array(0), Object(Request))
File: /home9/revistj8/public_html/lib/pkp/classes/core/PKPPageRouter.inc.php line 220
Function: PKPRouter->_authorizeInitializeAndCallRequest(Array(2), Object(Request), Array(0), False)
File: /home9/revistj8/public_html/lib/pkp/classes/core/Dispatcher.inc.php line 134
Function: PKPPageRouter->route(Object(Request))
File: /home9/revistj8/public_html/lib/pkp/classes/core/PKPApplication.inc.php line 178
Function: Dispatcher->dispatch(Object(Request))
File: /home9/revistj8/public_html/index.php line 64
Function: PKPApplication->execute()
Server info:
OS: Linux
PHP Version: 5.2.17
Apache Version: N/A
DB Driver: mysql
DB server version: 5.5.42-37.1-log
[07-Dec-2015 14:46:51] PHP Fatal error: Call to a member function getQualifiedDAOName() on a non-object in /home9/revistj8/public_html/lib/pkp/classes/db/DAORegistry.inc.php on line 63
[07-Dec-2015 16:26:11] ojs2: 404 Not Found
[07-Dec-2015 20:50:43] PHP Fatal error: Call to a member function getQualifiedDAOName() on a non-object in /home9/revistj8/public_html/lib/pkp/classes/db/DAORegistry.inc.php on line 63
[07-Dec-2015 20:51:05] PHP Fatal error: Call to a member function getQualifiedDAOName() on a non-object in /home9/revistj8/public_html/lib/pkp/classes/db/DAORegistry.inc.php on line 63

There are a couple of errors reported in your log. The most likely culprit is:
Message: WARNING: fsockopen() [function.fsockopen]: unable to connect to pkp.sfu.ca:80
indicating that your server is unable to connect to PKP in order to check for available updates.

Is your server firewalled or proxied for outgoing web requests?

Try turning off show_upgrade_warning in config.inc.php to see if that resolves the error.

Hi Alec,

I turned off show_upgrade_warning. In the cpanel is enable ModSecurity Domain Manager. Should I disable it?

Regards

Mod Security is typically used to filter incoming malicious requests. I’m not sure how it would relate to this issue.

Hi ctgraham,

You asked me whether my server was firewalled or proxied for outgoing web requests. I just know that Mod Security is enabled and I don’t know whether is related to the errors because I’m not a programer.

I can give you access to the server where the ojs and sql are hosted. I just need your email to send you the login details and you can check the issues. I have a backup of everything.

The errors that I’m still getting are the following ones:

[09-Dec-2015 15:28:51] ojs2: 404 Not Found
[09-Dec-2015 20:55:21] PHP Fatal error: Call to a member function getQualifiedDAOName() on a non-object in /home9/revistj8/public_html/lib/pkp/classes/db/DAORegistry.inc.php on line 63
[10-Dec-2015 00:20:05] ojs2: 404 Not Found

I don’t know if I should worry about the getQualifiedDAOName() error.

Regards

Do the stacktraces remain the same since disabling show_upgrade_warning, or have they changed?

The stacktraces remain the same. There is no change. I just can see the ojs2:404 not found and the getQualifiedDAOName errors

Clarification: The first error has a stacktrace:

[07-Dec-2015 08:08:35] ojs2 has produced an error
Message: WARNING: fsockopen() [function.fsockopen]: unable to connect to pkp.sfu.ca:80 (php_network_getaddresses: getaddrinfo failed: Fallo temporal en la resolución del nombre)
In file: /home9/revistj8/public_html/lib/pkp/classes/file/wrappers/HTTPFileWrapper.inc.php
At line: 77
Stacktrace:
File: (unknown) line (unknown)
Function: PKPApplication->errorHandler(2, "fsockopen() [<a href='function.fsockopen'>function.fsockopen</a>]: unable to connect to pkp.sfu.ca:80 (php_network_getaddresses: getaddrinfo failed: Fallo temporal en la resolución del nombre)", "/home9/revistj8/public_html/lib/pkp/classes/file/wrappers/HTTPFileWrapper.inc.php", 77, Array(7))
File: /home9/revistj8/public_html/lib/pkp/classes/file/wrappers/HTTPFileWrapper.inc.php line 77
Function: fsockopen("pkp.sfu.ca", 80, 0, "")

The errors:

[07-Dec-2015 14:46:51] PHP Fatal error: Call to a member function getQualifiedDAOName() on a non-object in /home9/revistj8/public_html/lib/pkp/classes/db/DAORegistry.inc.php on line 63
[07-Dec-2015 16:26:11] ojs2: 404 Not Found

don’t have stacktraces attached.

To be sure I understand you, do new errors come with a stacktrace, or are you only seeing the two errors without stacktraces now?

Does this occur on every page, or only certain pages?

The following errors don’t have stacktraces
[07-Dec-2015 14:46:51] PHP Fatal error: Call to a member function getQualifiedDAOName() on a non-object in /home9/revistj8/public_html/lib/pkp/classes/db/DAORegistry.inc.php on line 63
[07-Dec-2015 16:26:11] ojs2: 404 Not Found

I did the following in order to check what I’m doing wrong:

  1. I deleted all the files except the following folders: public and files. I’m using the correct config.inc.php
  2. I download the ojs files and I unziped them in the server
  3. I did an update of the ojs, I updated the sql database with no errors reported in the website. However, I’ve got the following errors in the error log that you can find here: http://revistapsicologia.org/error_log

Everything works. However, when I click on the Unassigned submissions as the editor, I get the following error which I mentioned Alec that I fixed it adding $this->dbconn->Execute(“SET OPTION SQL_BIG_SELECTS=1”); to the DBConnection.inc.php file. I’m not going to add this line till you tell me what to do.


[11-Dec-2015 12:13:51] ojs2: DB Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
Stack Trace:
File: /home9/revistj8/public_html/classes/submission/editor/EditorSubmissionDAO.inc.php line 356
Function: DAO->retrieveRange(“SELECT DISTINCT a.*, scf.date_completed as copyedit_comp…”, Array(21), Object(DBResultRange))

File: /home9/revistj8/public_html/classes/submission/editor/EditorSubmissionDAO.inc.php line 402
Function: EditorSubmissionDAO->_getUnfilteredEditorSubmissions(“1”, 0, 0, Null, Null, Null, Null, Null, Null, “a.status = 1 AND ea.edit_id IS NULL”, Object(DBResultRange), “id”, 1)

File: /home9/revistj8/public_html/pages/editor/EditorHandler.inc.php line 263
Function: EditorSubmissionDAO->getEditorSubmissionsUnassigned(“1”, 0, 0, Null, Null, Null, Null, Null, Null, Object(DBResultRange), “id”, 1)

File: (unknown) line (unknown)
Function: EditorHandler->submissions(Array(1), Object(Request))

File: /home9/revistj8/public_html/lib/pkp/classes/core/PKPRouter.inc.php line 362
Function: call_user_func(Array(2), Array(1), Object(Request))

File: /home9/revistj8/public_html/lib/pkp/classes/core/PKPPageRouter.inc.php line 220
Function: PKPRouter->_authorizeInitializeAndCallRequest(Array(2), Object(Request), Array(1), False)

File: /home9/revistj8/public_html/lib/pkp/classes/core/Dispatcher.inc.php line 134
Function: PKPPageRouter->route(Object(Request))

File: /home9/revistj8/public_html/lib/pkp/classes/core/PKPApplication.inc.php line 178
Function: Dispatcher->dispatch(Object(Request))

File: /home9/revistj8/public_html/index.php line 64
Function: PKPApplication->execute()


Alec suggested to tweak the MySQL configuration. I don’t know how to do tweak it. What should I do?

@asmecher’s suggestion of adding $this->dbconn->Execute("SET OPTION SQL_BIG_SELECTS=1") or of increasing the max_join_size in the mysql config should resolve the problem when clicking on Unassigned Submissions.

Your error log includes a number of references to: USER WARNING: Attribute '' in element 'em' not supported or similar. This makes it appear that some user-entered HTML is being cleaned for unrecognized content, but it looks like this is actually being caused by a (corrupt?) Unicode string: “Vol. 14, Núm. 01 (2015)”. This can probably be ignored; to research it further, you would want to track down and correct that string.

I’m not immediately seeing what is raising the error: USER ERROR: Smarty error ...: syntax error: unrecognized tag '/literal' Are you seeing broken functionality around the bibtex citations?

Are you seeing any “white screen” pages that align with the error message PHP Fatal error: Call to a member function getQualifiedDAOName() on a non-object in the logs?