Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Critical Error / SQL Query  (Read 3935 times)

0 Members and 1 Guest are viewing this topic.

MIL-Admin

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
Critical Error / SQL Query
« on: December 04, 2003, 09:13:44 pm »
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
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Critical Error / SQL Query
« Reply #1 on: December 05, 2003, 09:27:51 am »
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
Logged

NorbertGutscher

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 49
    • http://www.menschen-foto.de
Critical Error / SQL Query
« Reply #2 on: December 05, 2003, 10:49:22 pm »
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
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Critical Error / SQL Query
« Reply #3 on: December 05, 2003, 11:08:37 pm »
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
Logged

NorbertGutscher

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 49
    • http://www.menschen-foto.de
Critical Error / SQL Query
« Reply #4 on: December 06, 2003, 01:26:25 am »
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.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Critical Error / SQL Query
« Reply #5 on: December 06, 2003, 12:19:38 pm »
Hm, you could always switch of stats completely by comenting out the query and the output...

GauGau
Logged

NorbertGutscher

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 49
    • http://www.menschen-foto.de
Critical Error / SQL Query
« Reply #6 on: December 07, 2003, 11:52:51 am »
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
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.02 seconds with 14 queries.