To who ever can help.<br /><br />Recently My members have been complaining in large numbers that they are recieving SQL database errors. I have been submitting tickets but no one has been able to truely recreate it. I have the Invision power Board that was offered through TCH when i started version 1.3.1 final. If anyone has any ideas or reccommendations please let me know. I am a novice at this so lets try not to get to complicated in responses please. Below is the error i got today when i was refreshing the page to go to the main forum page.<br /><br /><b><!--quoteo--><div class='quotetop'>QUOTE</div><div class='quotemain'><!--quotec-->Invision Powerboard database error:<br />Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/fantasy/public_html/fantasyforums/sources/Drivers/mySQL.php on line 67<br /><br />Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/fantasy/public_html/fantasyforums/sources/Drivers/mySQL.php on line 70<br />ERROR: Cannot find database fantasy_fantasyforums<br />Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/fantasy/public_html/fantasyforums/sources/Drivers/mySQL.php on line 103<br /><br /><br /><br />There appears to be an error with the Fantasy Online Entertainment database.<br />You can try to refresh the page by clicking here (url to refersh page), if this does not fix the error, you can contact the board administrator by clicking here (url link forum admin email)<br /><br />mySQL query error: SELECT id, member_id, running_time, location FROM ibf_sessions WHERE id='276a201a51af51920baa36b416f16337' and ip_address='63.163.61.3' AND browser='Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0;'<br /><br />mySQL error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)<br />mySQL error code: <br />Date: Wednesday 02nd of March 2005 07:05:04 PM<br /><br />We apologise for any inconvenience<br /><br /><br />Here is the link to the page i was on: <a href="http://www.fantasyforums.fantasyonlineentertainment.com/index.php?showforum=8" target="_blank">http://www.fantasyforums.fantasyonlineente...php?showforum=8</a><!--QuoteEnd--></div><!--QuoteEEnd--></b><!--content-->
I'm sure if someone can help they will.<br /><br />Moving for organization.<!--content-->
Hi,<br /><br />Hmmm ... I've never had this problem before myself. But if it did happen to me this is what I would try ... which shouldn't hurt anything ...<br /><br />Try exporting your database, so that you create all the SQL to re-create the database itself. Then re-create your database by executing the SQL.<br /><br />My hunch is that the SQL file might be corrupted. Doing this might help rebuild the database and thus get rid of the corruption.<br /><br />Just a thought ...<!--content-->
BTW ...<br /><br />Keep in mind that my plan lacks the detail needed to actually accomplish this. It requires a rough working knowledge of PHPMyAdmin or other database management and that you backup your existing database before attempting this.<br /><br />There may be other things that may be missing because I'm unaware of the additional software installed to make your particular forum work!<br /><br /> <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/blink.gif" style="vertical-align:middle" emoid=":blink:" border="0" alt="blink.gif" /><!--content-->
It may be that your exceeding what we consider reasonable number of connections to the SQL server.<br /><br />Your forums are a tad on the larger side, for shared hosting that is.<br /><br />From your forums "Our members have made a total of 58,022 posts"<br /><br />With that amount of traffic that forum really should be a semi-dedicated server.<br /><br />Our forums here run on a Dual Opteron, 2GB DDR RAM and 15K RPM SCSI Drives. That's just to power our SQL not the web site. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/wink.gif" style="vertical-align:middle" emoid="
" border="0" alt="wink.gif" /><br /><br />Bill<!--content-->
Sorry I couldn't resist.<br /><br /><a href="http://www.fantasyforums.fantasyonlineentertainment.com/index.php?showtopic=3916" target="_blank">http://www.fantasyforums.fantasyonlineente...?showtopic=3916</a><br /><br />Warning: fsockopen(): unable to connect to localhost:25 in /home/fantasy/public_html/fantasyforums/sources/lib/emailer.php on line 480<br /><br />Mail Error!<br /><br />SMTP protocol failure!<br />Host: localhost<br />Return Code: <br />Return Msg: <br />Invision Power Board Error: Could not open a socket to the SMTP server<br />Check your SMTP settings from the admin control panel<br /><br />Set up your SMTP settings in your forums properly and those errors go away.<br /><br />Bill<!--content-->
<!--QuoteBegin-Head Guru+Mar 2 2005, 08:20 PM--><div class='quotetop'>QUOTE(Head Guru @ Mar 2 2005, 08:20 PM)</div><div class='quotemain'><!--QuoteEBegin-->Sorry I couldn't resist.<br /><br /><a href="http://www.fantasyforums.fantasyonlineentertainment.com/index.php?showtopic=3916" target="_blank">http://www.fantasyforums.fantasyonlineente...?showtopic=3916</a><br /><br />Warning: fsockopen(): unable to connect to localhost:25 in /home/fantasy/public_html/fantasyforums/sources/lib/emailer.php on line 480<br /><br />Mail Error!<br /><br />SMTP protocol failure!<br />Host: localhost<br />Return Code: <br />Return Msg: <br />Invision Power Board Error: Could not open a socket to the SMTP server<br />Check your SMTP settings from the admin control panel<br /><br />Set up your SMTP settings in your forums properly and those errors go away.<br /><br />Bill<br /><div align="right"><a href="http://www.totalchoicehosting.com/forums/index.php?act=findpost&pid=117520"><img src='http://www.totalchoicehosting.com/forums/style_images/1/post_snapback.gif' alt='*' border='0' /></a></div><!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />If i may ask...what are the correct settings?<!--content-->
I have my board set to use PHP mail() and not SMTP and have no problems.<!--content-->
Same here (mail() instead of SMTP - never had a problem).<br />Always use mail() instead of SMTP unless you have a good reason to do so.<!--content-->
I'm sure if someone can help they will.<br /><br />Moving for organization.<!--content-->
Hi,<br /><br />Hmmm ... I've never had this problem before myself. But if it did happen to me this is what I would try ... which shouldn't hurt anything ...<br /><br />Try exporting your database, so that you create all the SQL to re-create the database itself. Then re-create your database by executing the SQL.<br /><br />My hunch is that the SQL file might be corrupted. Doing this might help rebuild the database and thus get rid of the corruption.<br /><br />Just a thought ...<!--content-->
BTW ...<br /><br />Keep in mind that my plan lacks the detail needed to actually accomplish this. It requires a rough working knowledge of PHPMyAdmin or other database management and that you backup your existing database before attempting this.<br /><br />There may be other things that may be missing because I'm unaware of the additional software installed to make your particular forum work!<br /><br /> <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/blink.gif" style="vertical-align:middle" emoid=":blink:" border="0" alt="blink.gif" /><!--content-->
It may be that your exceeding what we consider reasonable number of connections to the SQL server.<br /><br />Your forums are a tad on the larger side, for shared hosting that is.<br /><br />From your forums "Our members have made a total of 58,022 posts"<br /><br />With that amount of traffic that forum really should be a semi-dedicated server.<br /><br />Our forums here run on a Dual Opteron, 2GB DDR RAM and 15K RPM SCSI Drives. That's just to power our SQL not the web site. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/wink.gif" style="vertical-align:middle" emoid="
" border="0" alt="wink.gif" /><br /><br />Bill<!--content-->Sorry I couldn't resist.<br /><br /><a href="http://www.fantasyforums.fantasyonlineentertainment.com/index.php?showtopic=3916" target="_blank">http://www.fantasyforums.fantasyonlineente...?showtopic=3916</a><br /><br />Warning: fsockopen(): unable to connect to localhost:25 in /home/fantasy/public_html/fantasyforums/sources/lib/emailer.php on line 480<br /><br />Mail Error!<br /><br />SMTP protocol failure!<br />Host: localhost<br />Return Code: <br />Return Msg: <br />Invision Power Board Error: Could not open a socket to the SMTP server<br />Check your SMTP settings from the admin control panel<br /><br />Set up your SMTP settings in your forums properly and those errors go away.<br /><br />Bill<!--content-->
<!--QuoteBegin-Head Guru+Mar 2 2005, 08:20 PM--><div class='quotetop'>QUOTE(Head Guru @ Mar 2 2005, 08:20 PM)</div><div class='quotemain'><!--QuoteEBegin-->Sorry I couldn't resist.<br /><br /><a href="http://www.fantasyforums.fantasyonlineentertainment.com/index.php?showtopic=3916" target="_blank">http://www.fantasyforums.fantasyonlineente...?showtopic=3916</a><br /><br />Warning: fsockopen(): unable to connect to localhost:25 in /home/fantasy/public_html/fantasyforums/sources/lib/emailer.php on line 480<br /><br />Mail Error!<br /><br />SMTP protocol failure!<br />Host: localhost<br />Return Code: <br />Return Msg: <br />Invision Power Board Error: Could not open a socket to the SMTP server<br />Check your SMTP settings from the admin control panel<br /><br />Set up your SMTP settings in your forums properly and those errors go away.<br /><br />Bill<br /><div align="right"><a href="http://www.totalchoicehosting.com/forums/index.php?act=findpost&pid=117520"><img src='http://www.totalchoicehosting.com/forums/style_images/1/post_snapback.gif' alt='*' border='0' /></a></div><!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />If i may ask...what are the correct settings?<!--content-->
I have my board set to use PHP mail() and not SMTP and have no problems.<!--content-->
Same here (mail() instead of SMTP - never had a problem).<br />Always use mail() instead of SMTP unless you have a good reason to do so.<!--content-->