Catlist error

[NorbertGutscher]

After upgrading to 1.2 CP works 10 days no problems. Nothing was changed. Now since saturday there is an error at catlist (Teilnehmer).

There was an error while processing a database query.

Debug info:

Code Select Expand


While executing query "SELECT COUNT(*) from cpg11d_pictures WHERE approved = 'YES' AND aid IN (33,2,14,4,13,6,7,8,11,12,15,16,17,18,19,20,21,22,23,24,25,26,27,31,32,34,35,36,37,38,39,40,41,42,43,44) " 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


File: ..... /galerie/include/functions.inc.php - Zeile: 105



URL: http://www.menschen-foto.de
Gallery frame: http://www.menschen-foto.de/galerie/index.php

Please help

Norbert

[Joachim Müller]

did your webhost make any changes on the webserver config (PHP / mySQL)?

GauGau

[NorbertGutscher]

did your webhost make any changes on the webserver config (PHP / mySQL)?

Oh yes - now I remember. That can be the reason.
A new version of MySql 4.0.16 was installed at 29.10.2003

An now?

Gruß
Norbert

[Joachim Müller]

Norbert, I'm afraid that this strange behaviour may be caused by a corrupt mySQL table - see http://forum.coppermine-gallery.net/index.php?topic=881 for details and keep us updated.

GauGau

[NorbertGutscher]

Repair was my first action as the error occured. No positve result. :-(
All tables are also well shown with browse.

There are 21 lines in functions.inc.php with string

Code Select Expand

from {$CONFIG['TABLE_PICTURES']}

and I have no idea witch of them produce the error.  as line 105 of the debug-info is the the line with the error message.

Code Select Expand

cpg_die(CRITICAL_ERROR, $out, __FILE__, __LINE__);

Strange is also, that all other functions with pictures are OK - but how long?

In the moment I put CP again in debug mode. There are many other messages without any influence:

CP start:

Code Select Expand

Notice: Undefined index: cat_albums in .... /cm/galerie/themes/water_drop/theme.php on line 1028

click on picture:

Code Select Expand

Notice: Undefined index: user_name in .... /cm/galerie/displayimage.php on line 234

Notice: Undefined variable: header in .... /cm/galerie/themes/water_drop/theme.php on line 1349

Notice: Undefined variable: template_tab_display in .... /cm/galerie/themes/water_drop/theme.php on line 1354

Notice: Undefined variable: lang_thumb_view in .... /cm/galerie/themes/water_drop/theme.php on line 1357

Notice: Undefined index: inactive_tab in .... /cm/galerie/themes/water_drop/theme.php on line 1358


at config screen:

Code Select Expand

Notice: Undefined index: disable_flood in .... /cm/galerie/config.php on line 61

[NorbertGutscher]

Still no solution.
Now I have disabled the features producing this error, as i don't like to show my members a database error message.

(breadcrumb/catlist/alblist)

[Joachim Müller]

the notices in debug_mode aren't pretty I must admit, but they're probably no point to be concerned.
To narrow down the problem, could you make a dump of your coppermine mySQL tables, make a fresh install somewhere else on your webspace (with a different table prefix )and use the dump to populate the new install's database (remember to change the prefix in the dump files)?

GauGau

[NorbertGutscher]

To narrow down the problem, could you make a dump of your coppermine mySQL tables, make a fresh install somewhere else on your webspace (with a different table prefix )and use the dump to populate the new install's database (remember to change the prefix in the dump files)?
GauGau

Thank you for this hint, but the result of this test is the same behavoir:

http://www.ng-sw.de/filmexil/galerie

LG
Norbert

[Joachim Müller]

in the test gallery you set up there's no mySQL error for me. Of course all pics don't work because they don't exist.
Try switching the prefix of your live gallery temporarily to the prefix of the new gallery and see what happens.

GauGau

[NorbertGutscher]

klick on "Teilnehmer" there is the error also on the test-gallery

now it's going serious.
the main gallery accepts no uploads:
 

Code Select Expand

There was an error while processing a database query.

While executing query "INSERT INTO cpg11d_pictures (pid, aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, owner_name, title, caption, keywords, approved, user1, user2, user3, user4, pic_raw_ip, pic_hdr_ip) VALUES ('', '4', 'userpics/10001/', 'DSC_1256-1~1.jpg', '127381', '160979', '512', '640', '1068053006', '0', 'Norbert' , 'test', '', '', 'YES', '', '', '', '', '213.70....', '213.70....')" on 0


http://www.menschen-foto.de

[NorbertGutscher]

there are very strange things.
after deleting some unused tables, the upload works again.

perhaps that are timing problems at server side.

[NorbertGutscher]

If I define ONLY catlist in config, there is no error.
If I add anything like alblist, the database error appears.

regards
norbert

[NorbertGutscher]

As perhaps nobody has this timing problems or nobody has more as 10 users, here is the workaround:

1. dont' use catlist in config

2. Make a user list userlist.php like described here:

http://forum.coppermine-gallery.net/index.php?topic=1985


3. hack in include/functions.inc.php

Code Select Expand


                foreach ($breadcrumb_array as $category){
//                      $link = "<a href=index.php?cat={$category[0]}>{$category[1]}</a>";
                        $link = "<a href=userlist.php>{$category[1]}</a>"; // new
                        $breadcrumb .= ' > ' . $link;
                        $BREADCRUMB_TEXT .= ' > ' . $category[1];
                }
[quote][/quote]

[danmar]

What do you mean with step 1???

[NorbertGutscher]

What do you mean with step 1???

If I define content of the main page catlist only, it works. But any combination with an other function (catlist/alblist/random,2/lastup,2) this SQL error occours.

Therefore i have this work arounded and show only breadcrumb/lastup,2/lastcom,2 without "catlist" and included a link to a user list.

Regards
Norbert

PS.
The same time out error occours (sometimes) on upload pictures if i define intermediate format pictures.

[danmar]

Thank for your fast answer and help!
Oh, i understand you, yet!
I look on your Galerie, I think i have the same Problems!
But this solution is not the best, because I will have over 100 and more user! And I want special catogories for contests for example!

Is anybody here, who has an other solution?

[danmar]

Can anbody say me what is the reason of the problem!
A MYSQL update i think no!
From time to time everybody must update his Mysql database!
I think it´s a big BUG from the coppermine Gallery!

Can I save all data. Delete old Data and make a new install! And put then the old data (database and JPG) in the new installation!?
When yes, how can i do this!

[NorbertGutscher]

Can anbody say me what is the reason of the problem!

The reason is perhaps a to deep query at the users that produces a server timeout. Perhaps it is solveable by software, but I know not enough PHP (in the moment). I have also no rights by my provider to change the PHP/MySql timeout behavoir.

I have also made a database backup and installed it new. The same procedure - the same errors.


The other side is, that coppermine is perhaps designed for a singel user, not for great community.  

Is it possible to show your site?

Regards
Norbert

[danmar]

@NorbertGutscher: Danke für deine Schnellen Antworten, hast du daß mit den Single User, nicht für Communities irgendwo gelesen???
Für uns ist das eich echtes Problem, wenn die nicht angezeigt werden können!

@Developer: Is it right, that coppermine isn´t for a community?

[Casper]

I'm not one of the team, but there are clearly many galleries running with thousands of images and hundreds of users, so I think this is incorrect.

Take a look at the thread 'share your galleries' in the general forum, and you can see some of them.