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
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
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
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
Quote from: "gaugau"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.
Hm, you could always switch of stats completely by comenting out the query and the output...
GauGau
Quote from: "gaugau"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