[Detomah]

Ok, what happened is this, my server is hosted with 1&1 and on Thursday of last week they descided to update their version of Python and the likes. My server and subsequently Photopost had been working smoothly and without errors up until this point, directly after this point, my Photopost is now spitting out 12 individual MySQL Error Report emails to me every time someone clicks on the "all" search button on the main PhotoPost front page, together with the search results page being full of errors. The rest of my PhotoPost appears to be currently working fine and as normal, just this "all" search button and only from the main frontpage of my gallery is reporting these errors.

I've already Google'd and searched on here for possible answers as to why this may have happened, but so far have come up with a blank, besides the fact it looks like 1&1 have made a major screw up and that they've so far taken 5 days of apparent "looking at the problems" without any kind of result at all.

Anyway, i'd like you to look at a small selection of the error reports and let me know if there is any possible way at all that this could be a series of Photopost script related errors brought on by my server now using Python 2.44, Python 2.5 Ruby Version 1.85 and Perl 5.8.8 and if not, please give me your best educated reasons as to what the cause of the problems are, as o far 1&1 are proving worse than useless and are seeming claiming to have fixed the server problem, even though I can not turn off maintainance mode on my website at all at the moment, due to this.

Please see the email error reports which give a combination of the following 3 errors:

MySQL client ran out of memory

Lost connection to MySQL server during query

MySQL server has gone away

An error was encountered during execution of the query:

SELECT SUM(views) as totalviews, SUM(filesize) as diskuse, count(*) as totalphotos FROM PP_photos

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: http://www.photopost.com/members/forum/f66/index.html

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

An error was encountered during execution of the query:

SELECT c.id, c.description, c.catorder, c.photos, c.posts, c.catdepth,
p.id, p.bigimage, p.cat, p.approved, p.user, p.userid, p.date, p.width, p.height,
p2.bigimage, p2.cat, p2.storecat, p2.userid, p2.width, p2.height,
com.username, com.id, com.date, com.photo
FROM PP_categories c
LEFT JOIN PP_photos p ON c.lastphoto=p.id
LEFT JOIN PP_photos p2 ON c.thumbnail=p2.id
LEFT JOIN PP_comments com ON com.id=c.lastpost
ORDER BY c.catorder ASC

The query returned with an errorcode of:

Lost connection to MySQL server during query

If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html

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

An error was encountered during execution of the query:

SELECT id,user,userid,cat,storecat,date,title,description,ismature,keywords,bigimage,width,height,filesize,views,medwidth,medheight,medsize,approved,rating,votes,allowprint,numcom,lastposter FROM PP_photos WHERE approved < 2 ORDER BY date DESC

The query returned with an errorcode of:

MySQL client ran out of memory

If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html

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

An error was encountered during execution of the query:

SELECT date, title FROM PP_photos WHERE date >= 1204326000 AND date < 1207000800 ORDER BY date

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: http://www.photopost.com/members/forum/f66/index.html

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

An error was encountered during execution of the query:

SELECT userid,date,uid,what FROM PP_iponline ORDER BY date DESC

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: http://www.photopost.com/members/forum/f66/index.html

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

Obviously there is more, but I think this gives a pretty good example of what is happening.

This isn't a request for help as such, unless it actually turned out to be something which is caused by PhotoPost which you could actually help me fix. I believe this is more a case of wanting to prove to myself that i'm not going mad here and that this is definately a server level problem caused by something being broken and not a script level problem as 1&1 at one point tried to claim.

If possible what i'd desperately like, is if someone could let me know which direction I should be pointing 1&1 with towards looking for the issue, as at the moment it looks to me like their support and techies don't know their ar*es from their elbows.