Critical Error / SQL Query

[MIL-Admin]

Waahh....
who can help me please, i am a totally newbie.

I get this error when i want to go from the
main-menu in a categorie with albums:

While executing query "SELECT COUNT(*) from cpg11d_pictures WHERE approved = 'YES' AND aid IN (2,3,4,5) " on 0

mySQL error: Die Ausführung des SELECT würde zu viele Datensätze untersuchen und wahrscheinlich sehr lange daueren. Bitte WHERE überprüfen und SET SQL_BIG_SELECTS=1 verwenden, sofern SELECT ok ist.


Debug Info:

USER:
Array
(
    [ID] => a8192656b7a940be668c708dc32c624d
    [am] => 1
    [liv] => Array
        (
           

• => 16
[1] => 1
            [2] => 2
            [3] => 3
            [4] => 4
        )

)

 
GET :
Array
(
    [cat] => 3
)

 
POST :
Array
(
)


Whats wrong

Please help me....
Greets from Austria

[Joachim Müller]

what's the size of your mysql database and how many pics do you have in it. Are you on budget hosting or "full" webhosting (or do you even run your own server)?
Please add some more details - and switch to english on your server, so you can copy-and-paste the error message in english as well, as most other supporters on this board won't understand the error message in German (it says: mySQL error: The execution of the SELECT would query too many database entries and would presumably take very long to run. Please check WHERE and use SET SQL_BIG_SELECTS=1 if SELECT is OK").
Did you try what the error message proposes and do "SET SQL_BIG_SELECTS=1"?

GauGau

[NorbertGutscher]

The same error on my site since one month without a solution.

http://forum.coppermine-gallery.net/index.php?topic=1235

And ... yes. I am on full web hosting.

Norbert

[Joachim Müller]

Have you tried what the error message itself proposes: did you modify your code accordingly (with SET SQL_BIG_SELECTS=1 )? Please refer to http://www.mysql.com/doc/en/SET_OPTION.html#IDX999 for details.

GauGau

[NorbertGutscher]

Have you tried what the error message itself proposes: did you modify your code accordingly (with SET SQL_BIG_SELECTS=1 )? Please refer to http://www.mysql.com/doc/en/SET_OPTION.html#IDX999 for details.

GauGau

OK.
My web hosting is not so "full" , that I have the rights to change this parameter. :-(

With other words. There is no solution if the count of users/pictures exeeds a limit?

Norbert

PS.
If I define ONLY catlist in config, there is no error.
If I add anything like alblist, the database error appears.

[Joachim Müller]

Hm, you could always switch of stats completely by comenting out the query and the output...

GauGau

[NorbertGutscher]

Hm, you could always switch of stats completely by comenting out the query and the output...

GauGau

sorry. i don't understand that. can you please explain in detail?

norbert