OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Database Error 2.4.3

Are you an Editor, Author, or Journal Manager in need of help? Want to talk to us about workflow issues? This is your forum.

Moderators: jmacgreg, michael, vgabler, John

Forum rules
This forum is meant for general questions about the usability of OJS from an everyday user's perspective: journal managers, authors, and editors are welcome to post questions here, as are librarians and other support staff. We welcome general questions about the role of OJS and how the workflow works, as well as specific function- or user-related questions.

What to do if you have general, workflow or usability questions about OJS:

1. Read the documentation. We've written documentation to cover from OJS basics to system administration and code development, and we encourage you to read it.

2. take a look at the tutorials. We will continue to add tutorials covering OJS basics as time goes on.

3. Post a question. Questions are always welcome here, but if it's a technical question you should probably post to the OJS Technical Support subforum; if you have a development question, try the OJS Development subforum.

Database Error 2.4.3

Postby profps » Wed Mar 12, 2014 7:34 am

I've just successfully upgraded from 2.3.6.0 to 2.4.3 and as I tried to work in the system the following errors show up:
http://www.journalacademicmarketingmyst ... nsInReview

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

http://www.journalacademicmarketingmyst ... sInEditing
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

http://www.journalacademicmarketingmyst ... nsArchives
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

Can anyone help?
Thanks.
profps
 
Posts: 14
Joined: Mon Oct 24, 2011 4:22 am

Re: Database Error 2.4.3

Postby asmecher » Wed Mar 12, 2014 9:09 am

Hi profps,

That's a MySQL error message; google it for more information.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8673
Joined: Wed Aug 10, 2005 12:56 pm

Re: Database Error 2.4.3

Postby profps » Wed Mar 12, 2014 9:35 am

Thank you.
profps
 
Posts: 14
Joined: Mon Oct 24, 2011 4:22 am

Re: Database Error 2.4.3

Postby profps » Wed Mar 12, 2014 1:20 pm

I googled, but found nothing to deal with the problems for OJS. Instead, I found this for Wordpress:
Try to insert
$wpdb->query('SET OPTION SQL_BIG_SELECTS = 1');
right before the sql call

Do you have OJS solution for the problems?

Regards
profps
 
Posts: 14
Joined: Mon Oct 24, 2011 4:22 am

Re: Database Error 2.4.3

Postby asmecher » Wed Mar 12, 2014 2:11 pm

Hi all,

See http://pkp.sfu.ca/support/forum/viewtopic.php?f=8&t=2844&start=15 for a continuation of this thread.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8673
Joined: Wed Aug 10, 2005 12:56 pm


Return to OJS Editorial Support and Discussion

Who is online

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