|
|
|
|
![]() ![]() |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Post
#1
Mar 11 2008, 09:04 AM
Ok, my forum (phpbb3) works but sometimes it displays this message CODE General Error SQL ERROR [ mysqli ] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [2002] An sql error occurred while fetching this page. Please contact an administrator if this problem persists. This normally happens about once a week for about 2 minutes but it is really getting annoying. I installed phpbb3 fine, it didn't show any errors. But the main thing is that before this happens normally I can't connect to my website (obelisk.trap17.com) it either takes forever to load or shows the "connection has been reset" error. Then it goes to this error message. It lasts for about 2-3 minutes but 5 minutes max. Is there anyway to solve this problem? |
![]() ![]() Group: Members
Posts: 28 Joined: 27-February 08 Member No.: 58,535 |
Post
#2
Mar 12 2008, 09:44 PM
hmm i have had the same problem with phpbb2. try going to their website. phpbb.com and go to the help section. maybe they will have an answer?
|
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Post
#3
Mar 13 2008, 08:40 AM
hmm, I agree... Stopped... For now, for some reason this always happens at night, never have I seen this error in broad daylight, and also could it be because I used MySQLi instead of just MySQL? |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Group: [MODERATOR]
Posts: 4,908 Joined: 24-July 05 From: Linux, DOS and Windows…the good, the bad and the ugly Member No.: 9,787 ![]() myCENT:6.20 |
Post
#4
Mar 13 2008, 08:58 AM
I very much doubt that the cause of the problem is the use of PHP 5, which is the level of PHP on the Trap17 server. The improved MySql functions (Mysql'i' functions) were included in version 5 of PHP. Otherwise, many other members would be receiving the same errors. One likely cause of this error is a busy Mysql Server at the time you connect and process the pages. Or there could be a restricted 'pipeline' between you and the Server, at the ISP your members use, or between the multiple of the connections made between the Server and the end-users. Without further diagnosis, it is premature to suggest this is strictly a Server issue. It might be, but you do not have the data to support the claim that it is solely a Server issue. Sorry. The simple solution, until the Server is improved, or the Load Balancing gets tweaked, or the connections improve, is to simply hit the Reload button on the Browser. Pass the word amongst your visitors. Another issue is the amount of 'bloat' in the Software you are running. Phpbb3 is a feature packed Community Forum, with all the bells and whistles. How many mods have you added to the Vanilla package? All those Mods add demands (queries) on the database. Check out a less-bloated Forum Package, maybe. AEF Forums now have a convertor from Phpbb3 to AEF. Might be worth checking out??? The MySql Manual lists the following information about Error Number 2002, which you report above: QUOTE Error: 2002 (CR_CONNECTION_ERROR) Message: Can't connect to local MySQL server through socket '%s' (%d) Where %s is a string value and %d is a numeric value. It also suggest that the Error Logs may contain more information about the source of the Error. Perhaps contacting the Support department at Xisto will resolve this issue. They will be able to do the checking of the Log files and better assist you in resolving this issue for you. http://www.xistosupport.com to register a Ticket. |
![]() ![]() |
Similar Topics
| Topic Title | Replies | Topic Starter | Views | Last Action | |||
|---|---|---|---|---|---|---|---|
![]() |
3 | Shackman | 8,863 | 30th August 2004 - 06:33 PM Last post by: DataHead |
|||
![]() |
17 | stevey | 8,946 | 4th November 2009 - 01:17 AM Last post by: Soviet Rathe |
|||
![]() |
4 | The Devils Playpen | 6,031 | 9th August 2004 - 10:03 AM Last post by: LuciferStar |
|||
![]() |
6 | BlueReign | 5,195 | 18th August 2004 - 08:38 PM Last post by: Aero147 |
|||
![]() |
2 | eniranjee | 3,739 | 19th February 2009 - 12:14 PM Last post by: iG-Pradip Jadhav |
|||
![]() |
5 | MusicOnly | 1,152 | 7th February 2007 - 08:07 PM Last post by: MusicOnly |
|||
![]() |
1 | Tenshi | 230 | 29th May 2009 - 06:24 PM Last post by: jlhaslip |
|||
![]() |
2 | Dawid | 5,210 | 20th October 2004 - 07:04 PM Last post by: serverph |
|||
![]() |
3 | Danieluchis | 4,401 | 24th October 2004 - 07:15 PM Last post by: Danieluchis |
|||
![]() |
4 | guangdian | 4,452 | 26th October 2004 - 07:11 AM Last post by: Hamtaro |
|||
![]() |
2 | patrickcurl | 739 | 23rd August 2008 - 02:56 AM Last post by: OpaQue |
|||
![]() |
2 | DMA | 2,624 | 9th November 2004 - 02:08 AM Last post by: DMA |
|||
![]() |
3 | Oni_BlueEyes | 4,591 | 11th November 2004 - 05:49 PM Last post by: Oni_BlueEyes |
|||
![]() |
2 | BWiZ | 3,339 | 15th November 2004 - 07:24 AM Last post by: BWiZ |
|||
![]() |
5 | Oni_BlueEyes | 3,797 | 15th November 2004 - 08:26 AM Last post by: wassie |
|||
|
Open Discussion | Time is now: 8th November 2009 - 11:47 AM |
Web Hosting Powered by ComputingHost.com.