There was an error while processing a database query.

[danmar]

Get this error-Message:

There was an error while processing a database query.

Debug modus!
While executing query "SELECT COUNT(*) from cpg11d_pictures WHERE approved = 'YES' AND aid IN (12,2,3,4,5,6,7,8,9,10,11,13,14,15) " on 0

mySQL error: The SELECT would examine more rows than MAX_JOIN_SIZE. Check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is ok

This error comes when I will go in the usergallery section!
Look at http://www.renderking.de
Please Help fast! If you speak german it is better!

[danmar]

Can anyboy help me? - It´s a big problem!
 :arrow: I need fast help!

[Joachim Müller]

this has been reported by another user as well, take a look at http://forum.coppermine-gallery.net/index.php?topic=1235&highlight=maxjoinsize - apart from the stuff discussed there I can't think of anything else.
You're running a nuked version of coppermine, the place to look for support should be the nuke forums (which can be found at http://coppermine.findhere.org/ ).

GauGau

[danmar]

I use only the PNCPG ! A bridge between Coppermin and MD-Pro!
But the stand-a-lone version for Coppermin runs on my server!
I don´t sure that is not the same Problem!
Because my User can upload pictures, it is only a problem to show the User Gallery site!