Error related to PP query

Alfa1 · May 17th, 2011, 12:34 PM

I am encountering a weird issue. Since a long time I am getting error emails like this:

Quote:

An error was encountered during execution of the query:

SELECT id,user,userid,cat,storecat,title,ismature,bigimage,height,width FROM
pp_photos WHERE approved=1 AND storecat=0 ORDER BY date DESC LIMIT 37

The query returned with an errorcode of:

MySQL server has gone away

If you need assistence or feel this is a 'bug'; please report it to our support
forums at: Photopost Pro Bug Reports - PhotoPost Community

To turn off these emails, set $debug=0 in your config-inc.php file.

On first glance you would expect that this email means that the server has gone offline. But, I get these almost daily and its always the exact same query.
Do you have an idea what is happening?

Chuck S · May 17th, 2011, 12:43 PM

The query is sound. You can issue that same query in phpmyadmin in your hosting control panel and see if will return 37 results. No issue with that query. MYSQL HAS GONE AWAY means your mysql has shut down. As to why mysql has shut down I can not say maybe your host and server logs would have more info to assist in regards to that.

Alfa1 · May 17th, 2011, 07:07 PM

What function / event causes that query?

I run a highly active board. If the mysql server goes away then that means that a large volume of users experience problems and I would expect other error mails as well. But I am not getting other error mails. Just one of these almost every day.

I will try to find out if I can find anything in the logs.

Chuck S · May 17th, 2011, 07:56 PM

That query can be from 3 different files its a generic query either for featured photos or previews on the showphoto page.

mysql has gone away is pretty absolute that error is what is coming back from mysql on your server. That is not a message from our software.

Alfa1 · May 20th, 2011, 05:48 PM

The logs have been reviewed for every time the error occurred. At none of these times there were MySQL restarts. No high server loads and no full memory either. Meanwhile the same error keeps coming in. So something is going wrong with that query. Its quite a mystery.
The only thing we can think of is upgrade MySQL to 5.5 and hope its gone then.
Please let me know if you or Michael have any ideas / suggestions.

Chuck S · May 21st, 2011, 11:15 AM

Well as I said that query is sound nothing special about it.

Code:

Content visible to verified customers only.

That will return the latest 37 photos uploaded to your site. I will see if we have any ideas but as stated it is hard to think of anything when the error reported is a mysql server level error message.

Alfa1 · May 22nd, 2011, 07:48 PM

Do you know why on earth is looking for exactly 37 photos? The number is always the same.

Chuck S · May 22nd, 2011, 08:20 PM

Yes that is easy. Your electing to show 12 photos on the featured photo blocks. We grab the number you want plus 25 to be able to get enough results after viewing permissions etc are applied to fill the blocks. Therefore your limit is 37.