Topic: There was an error while processing a database query. (Read 3213 times)

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!

danmar · « **Reply #1 on:** January 09, 2004, 07:31:57 am »

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

Joachim Müller · « **Reply #2 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

danmar · « **Reply #3 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!

News:

Author Topic: There was an error while processing a database query. (Read 3213 times)

danmar

There was an error while processing a database query.

danmar

There was an error while processing a database query.

Joachim Müller

There was an error while processing a database query.

danmar

There was an error while processing a database query.