IPB

Welcome Guest ( Log In | Register )



Tags
This content has not been tagged yet
 
Reply to this topicStart new topic

Mysqli Error - Phpbb3


csp4.0
no avatar
NERVE: Interception
*********
Group: [HOSTED]
Posts: 612
Joined: 14-April 07
From: Holy Terra
Member No.: 41,610
myCENT:68.57



Post #1 post 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?
Go to the top of the page
+Quote Post
FraKture
no avatar
Newbie [Level 2]
**
Group: Members
Posts: 28
Joined: 27-February 08
Member No.: 58,535



Post #2 post 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?
Go to the top of the page
+Quote Post
csp4.0
no avatar
NERVE: Interception
*********
Group: [HOSTED]
Posts: 612
Joined: 14-April 07
From: Holy Terra
Member No.: 41,610
myCENT:68.57



Post #3 post 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?
Go to the top of the page
+Quote Post
jlhaslip
no avatar
Insert Custom Title Here
*******************
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
Spam Patrol
myCENT:6.20



Post #4 post 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.
Go to the top of the page
+Quote Post

Reply to this topicStart new topic

Collapse

> Similar Topics

    Topic Title Replies Topic Starter Views Last Action
No New Posts   3 Shackman 8,863 30th August 2004 - 06:33 PM
Last post by: DataHead
No new   17 stevey 8,946 4th November 2009 - 01:17 AM
Last post by: Soviet Rathe
No New Posts   4 The Devils Playpen 6,031 9th August 2004 - 10:03 AM
Last post by: LuciferStar
No New Posts 6 BlueReign 5,195 18th August 2004 - 08:38 PM
Last post by: Aero147
No New Posts   2 eniranjee 3,739 19th February 2009 - 12:14 PM
Last post by: iG-Pradip Jadhav
No New Posts 5 MusicOnly 1,152 7th February 2007 - 08:07 PM
Last post by: MusicOnly
No New Posts   1 Tenshi 230 29th May 2009 - 06:24 PM
Last post by: jlhaslip
No New Posts   2 Dawid 5,210 20th October 2004 - 07:04 PM
Last post by: serverph
No New Posts   3 Danieluchis 4,401 24th October 2004 - 07:15 PM
Last post by: Danieluchis
No New Posts   4 guangdian 4,452 26th October 2004 - 07:11 AM
Last post by: Hamtaro
No New Posts   2 patrickcurl 739 23rd August 2008 - 02:56 AM
Last post by: OpaQue
No New Posts   2 DMA 2,624 9th November 2004 - 02:08 AM
Last post by: DMA
No New Posts   3 Oni_BlueEyes 4,591 11th November 2004 - 05:49 PM
Last post by: Oni_BlueEyes
No New Posts   2 BWiZ 3,339 15th November 2004 - 07:24 AM
Last post by: BWiZ
No New Posts   5 Oni_BlueEyes 3,797 15th November 2004 - 08:26 AM
Last post by: wassie


 



RSS Open Discussion Time is now: 8th November 2009 - 11:47 AM

Web Hosting Powered by ComputingHost.com.