forum.coppermine-gallery.net
Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: NorbertGutscher on November 03, 2003, 10:28:49 am
-
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:
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
-
did your webhost make any changes on the webserver config (PHP / mySQL)?
GauGau
-
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
-
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
-
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
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.
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:
Notice: Undefined index: cat_albums in .... /cm/galerie/themes/water_drop/theme.php on line 1028
click on picture:
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:
Notice: Undefined index: disable_flood in .... /cm/galerie/config.php on line 61
-
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)
-
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
-
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
-
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
-
klick on "Teilnehmer" there is the error also on the test-gallery
now it's going serious.
the main gallery accepts no uploads:
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
-
there are very strange things.
after deleting some unused tables, the upload works again.
perhaps that are timing problems at server side.
-
If I define ONLY catlist in config, there is no error.
If I add anything like alblist, the database error appears.
regards
norbert
-
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
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]
-
What do you mean with step 1???
-
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.
-
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????
-
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!
-
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
-
@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?
-
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.
-
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.
Thousands of pictures is correct, but show me a gallery with 100 users and 100 pictures/user. Until today I have'nt see it.
It ist possible, that I am wrong. Therfore I wrote "perhaps"
Regards
Norbert
-
Norbert, I can see you have problems, and was not implying critism of you, just answering the question from danmar.
However, are you asking too much. You say when you use catlist, you have the problem.
How many categories do you have, how many albums in each category, and are you asking to show album thumbnails on front page.
If you have many of each, and are trying to show thumbs for each album on the front page, you just may be asking too much of the database.
Have you tried, in config, setting 'Show first level album thumbnails in categories' to no.
Sorry if you have already done this, I am trying to help, not criticise :wink:
-
Perhaps this is the problem, Casper. I have "only" users, no categories. They build there own albums.
The problem occoured suddenly as there where about more as 15 users. Before all works fine. As this was the same time as my provider changed the MySql-Version, it is not defined where the error comes from.
Now there are 25 users, including casper :-), and about 170 pictures. Some users have 0 and some 20 loaded. Not so much to crash a database.
Regards
Norbert
-
Ok Norbert,
I have had a good look at your site, and found the following.
To get to an album, I had to click on a thumbnail, then click on the link in the picture info.
Once in the album, I found the following strange behaviour. Look at this image;
(https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2Fwww.langportrd.f2s.com%2Fimages%2Fnorbert.jpg&hash=326fe388ce221ca5ace2a96c02c46b2208c64c2d)
Now see the breadcrumb, both the second (teilnehmer) and third (album owner) crumbs take you to the memberlist. As far as I now, this should not be happening, and maybe the cause of your database problems.
-
Casper.
This is an effect of my despairing quick and dirty hack.
But it is better than the error screens. Perhaps sometimes someone find the solution.
Thank you for the deep looking at my gallery. :-)
BTW.
Installing the gallery on a local apache (WAMP) with exact the same data, works without any problems. It must be a server side timing problem.
Regards
Norbert
-
When did you put the 'memberlist' mod on? Could it be connected to that. When you upgraded, did you change all the files, and then re-do the mod, or did you not change the modified files at all?
-
When did you put the 'memberlist' mod on? Could it be connected to that. When you upgraded, did you change all the files, and then re-do the mod, or did you not change the modified files at all?
No. This member list I have made weeks before the problem. And it works also fine after the upgrade to 1.2.
Regards Norbert
-
I spoke with my webspace-provider, he said that he don´t make any changes at the MYSQL database!
But he want analyze the scripts and the database connections!
I hope i get an answer at monday!
But show to this Gallery, it works!(But old version and phpnuke version)
http://christianfly.com/modules.php?name=coppermine
At my Gallery the problem come also with the 15. member!
I think the script is bad!
-
I think the script is bad!
my opinion as well :lol:
GauGau
-
Norbert, just a quick thought.
Have you tried with the default theme? Does this still happen then?
-
Norbert, just a quick thought.
Have you tried with the default theme? Does this still happen then?
Yes. This happens with all themes.
-
I have copy the database and the files to my locol-test-server!
There is the Problem, too!
I delete more and more User Galleries with their albums!
And see Coppermine will run fine again!
-
I have copy the database and the files to my locol-test-server!
There is the Problem, too!
I delete more and more User Galleries with their albums!
And see Coppermine will run fine again!
more and more?
where was the working limit?
-
5 User galleries with 11 Albums!
1.User Gallerie 1 Album
2.User Gallerie 1 Album
3.User Gallerie 4 Album
4.User Gallerie 2 Album
5.User Gallerie 3 Album
(That is the Point, where we get the Problem)
-
Is anybody here, that use the function user can built their own Albums?
-with more than 10 Membergallaries and much more member Albums
-with more Categories
-with over hundred users
Send me a message (PM) with your Link!
-
Ok,
I know I am asking questions that you have probably already checked, but as you said this happened after you upgraded, have you tried returning to the previous version you were using.
-
@casper: Nice idea! I want to test it this evening!
But I think it don´t help!
Then I test the postnuke version of coppermine!
When it dosen´t work again, i will convert to 4images!
@norbert: I think 4images will be a alternative also for you!
look here: http:www.4homepages.de
-
@casper: I switched to the old Coppermin 1, but i get the same error!
-
afaik oasis (http://forum.coppermine-gallery.net/profile.php?mode=viewprofile&u=59) is the one to talk to when it comes to multi-user installations of coppermine; here's a quote from his site's (http://photo.enctu.org/?lang=english) stats:
4359 users, 93827 pictures in 5112 albums with 4428 comments viewed 2174453 times
. I still think it is possible to run quite large coppermine sites... :wink:
GauGau