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:
- I deleted all the files except the following folders: public and files. I’m using the correct config.inc.php
- I download the ojs files and I unziped them in the server
- 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?