View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
13459Bug reportsCentral participant databasepublic2018-03-08 15:392018-03-09 16:33
ReporterBen2017 Assigned Toc_schmitz  
PrioritynoneSeverityblock 
Status closedResolutionreopened 
Product Version3.1.x 
Summary13459: SQLSTATE[42000]: .... SET SQL_BIG_SELECTS=1
Description

Interner Serverfehler
CDbCommand konnte das SQL-Statement nicht ausführen:
SQLSTATE[42000]: Syntax error or access violation: 1104 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

Muss dann die configsys.php ergänzt werden und wie?

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)Version 2.73.1+171220
I will donate to the project if issue is resolvedYes
BrowserFirefox Version 2.73.1+171220
Database type & versionMySQL-Client-Version: 5.5.59
Server OS (if known)Server Version: 5.6.37-82.2-log
Webserver software & version (if known)Server Version: 5.6.37-82.2-log
PHP Version 5.6 (Langzeitversion)

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2018-03-09 13:14

administrator   ~46962

You need to set up your MySQL server properly and set SET SQL_BIG_SELECTS=1 in the MySQL server configuration.
Ben2017

Ben2017

2018-03-09 15:43

reporter   ~46973

i add in application/config/config.php:

mysql_query("SET OPTION SQL_BIG_SELECTS=1");
mysql_query("SET MAX_JOIN_SIZE=#");

but still same error...
c_schmitz

c_schmitz

2018-03-09 16:33

administrator   ~46976

Please read again: MySQL server configuration.
Don't reopen the issue as this is not a bug - if you have further questions use the forums, instead.

Issue History

Date Modified Username Field Change
2018-03-08 15:39 Ben2017 New Issue
2018-03-09 13:14 c_schmitz Assigned To => c_schmitz
2018-03-09 13:14 c_schmitz Status new => closed
2018-03-09 13:14 c_schmitz Resolution open => no change required
2018-03-09 13:14 c_schmitz Note Added: 46962
2018-03-09 15:43 Ben2017 Status closed => feedback
2018-03-09 15:43 Ben2017 Resolution no change required => reopened
2018-03-09 15:43 Ben2017 Note Added: 46973
2018-03-09 16:33 c_schmitz Status feedback => closed
2018-03-09 16:33 c_schmitz Note Added: 46976