coppermine-gallery.com/forum

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: danmar on January 08, 2004, 11:42:35 PM

Title: There was an error while processing a database query.
Post by: danmar on January 08, 2004, 11:42:35 PM
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!
Title: There was an error while processing a database query.
Post by: danmar on January 09, 2004, 07:31:57 AM
Can anyboy help me? - It´s a big problem!
 :arrow: I need fast help!
Title: There was an error while processing a database query.
Post by: Joachim Müller on January 09, 2004, 09:41:22 AM
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
Title: There was an error while processing a database query.
Post by: danmar on January 09, 2004, 09:52:51 AM
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!