Database Error on the Gallery - No comments visible

[Jonas1975]

I'm having a database error on the Gallery where no comments and the quick comment are visible. This is the error I'm having:

http://themobilephotographyblog.com/index.php?pretty;action=gallery&sa=view;id=144
Database Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
File: /home/sites/themobilephotographyblog.com/public_html/Sources/Load.php(2269) : eval()'d code
Line: 2671

I have no idea what originated this and I don't have also no idea on how to fix it.

You can see the error here: http://themobilephotographyblog.com/gallery/?sa=view;id=492

Edit: I added my Load.php file.

[Jonas1975]

Seems like this is on hosting server side.

Found out this: http://drupal.org/node/359702 but I haven't enough php language knowledge to understand it completely.

[Jonas1975]

Not sure why but the error is gone (I didn't do anything). Since I didn't do anything, I think it might appear again. So any help on how to deal with this would be great.

[SMFHacks]

The error would probably be in Sources/Gallery.php around line 2671  or in themes/default/gallery.template.php on the same line.

[Jonas1975]

The error would probably be in Sources/Gallery.php around line 2671  or in themes/default/gallery.template.php on the same line.

Thanks for looking at it. Since I didn't do anything, I'm afraid that it will appear again. I read that usually is on the server side. What's your opinion on what I have to do if it happens again?

[SMFHacks]

Attach those two files and can take a look.
Your gallery does not look like it has enough files to run into those limits.

[Jonas1975]

Attach those two files and can take a look.
Your gallery does not look like it has enough files to run into those limits.

Ok, here they are. There are some simple customizations on the files from the "standard" ones that I made.
Thanks.

[SMFHacks]

Looks like this query but do not seee how it would excceed max join size.

Code: [Select]

$dbresult = $smcFunc['db_query']('', "
SELECT
c.id_picture, c.id_comment, c.date, c.comment, c.id_member, c.lastmodified,
c.modified_id_member, m.posts, m.real_name, c.approved, r.value
FROM ({db_prefix}gallery_comment as c)
LEFT JOIN {db_prefix}members AS m ON (c.id_member = m.id_member)
LEFT JOIN {db_prefix}gallery_rating AS r ON (r.id_member = c.id_member AND r.id_picture = " . $context['gallery_pic']['id_picture'] . ")
WHERE c.id_picture = " . $context['gallery_pic']['id_picture'] . " AND c.approved = 1 ORDER BY c.id_comment $commentorder");

You could try to run this query before it

Code: [Select]

mysql_query("SET SQL_BIG_SELECTS=1");


[Jonas1975]

Ok, I will try it if the error appears again.

That part of the code is on what file and how should I place the new code on it?

[SMFHacks]

Gallery2.template.php Around line 2663
Before

Code: [Select]

// Display all user comments


[Jonas1975]

The error appeared again and that line of code seems to have fixed the issue.

Thanks!