FUDforum: FUDforum Installation Issues » mySQL forum errors

Home » FUDforum » FUDforum Installation Issues » mySQL forum errors

Show: Today's Messages :: Polls :: Message Navigator

mySQL forum errors [message #5695]

Sat, 14 September 2002 19:33

Mezzers

Messages: 12
Registered: September 2002
Location: UK

Karma: 0

Junior Member

Got through the install process okay, then posted a couple of test messages. The first came up fine, but when I posted my second message and went to view it, I got a mySQL error similar to this:

Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /home/charlesdanuk/public_html/forum/index.php on line 27

Warning: Supplied argument is not a valid MySQL-Link resource in /home/charlesdanuk/public_html/forum/index.php on line 28

Warning: Supplied argument is not a valid MySQL-Link resource in /home/charlesdanuk/public_html/forum/index.php on line 28

Fatal error: SQL Error has occured, please contact the administrator of the forum and have them review the forum's SQL query log in /home/charlesdanuk/public_html/forum/data/include/theme/default/err.inc on line 102

(I say 'similar' because I didn't copy the first error message I got before flying off to see what was up in the err.inc file.)

Unfortunately I can't geto the err.inc because the forum files are locked, and it won't let me chmod them to gain access. I can't get back into the administration area either.... Sad

Sad

Please help, I don't understand why it suddenly crashed!

Thank you, Mez

Report message to a moderator

Re: mySQL forum errors [message #5697 is a reply to message #5695]

Sat, 14 September 2002 20:05

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Which forum version are you using? Also, make sure that MySQL server is running and is accessible.

FUDforum Core Developer

Report message to a moderator

Re: mySQL forum errors [message #5698 is a reply to message #5697]

Sat, 14 September 2002 22:03

Mezzers

Messages: 12
Registered: September 2002
Location: UK

Karma: 0

Junior Member

FUDforum version 2.3.1, and sorry, I'm not sure how to tell if my database is up and running. I just accessed it via phpMyAdmin on my server, if that means anything.

Also, I remember now that when I went to view the second message I'd posted, the first line of the error message had to do with a lost link to the database and an inability to reconnect.

I've done broke it good, ain't I? Drats, and I really really like FUDforum, too. Thanks for your help, Prottoss.

Mez

Report message to a moderator

Re: mySQL forum errors [message #5699 is a reply to message #5698]

Sat, 14 September 2002 22:10

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

If you've installed 2.3.1 I believe you still should be able to modify certain files unless you 'locked' the forum.
Here is what you need to do, open GLOBALS.php file and make sure the MySQL settings inside that file are correct. I see no reason why would forum fail working in phpMyAdmin is wokring fine with the same MySQL database.

FUDforum Core Developer

Report message to a moderator

Re: AH HA [message #5700 is a reply to message #5698]

Sat, 14 September 2002 22:17

Mezzers

Messages: 12
Registered: September 2002
Location: UK

Karma: 0

Junior Member

It just let me back into the forum and administration area, where I was able to unlock the files. Disappointingly, err.inc line 102 just shows the code behind the message triggered by an SQL error, not the particulars of what caused the error.

I'm now going to attempt to recreate the error. I've got something of a talent for finding trouble, so no doubt I'll be back soon. Wink

Wink

Mez

Report message to a moderator

Re: mySQL forum errors [message #5701 is a reply to message #5699]

Sat, 14 September 2002 22:21

Mezzers

Messages: 12
Registered: September 2002
Location: UK

Karma: 0

Junior Member

Fascinating. I have a GLOBALS.php directory taking up 61 bytes under my forum directory, but there's nothing in it. Is that right?

Mez

Report message to a moderator

Re: mySQL forum errors [message #5702 is a reply to message #5701]

Sat, 14 September 2002 22:38

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

That's right, because the file you are looking it as a 'symlink' to the actual file located inside the include/ directory.

If you use 'Error Log Viewer' you'll see the actual error message that occured.

I am wondering, if you were able to login, then your forum is able to connect to MySQL...

FUDforum Core Developer

Report message to a moderator

Re: mySQL forum errors [message #5703 is a reply to message #5702]

Sat, 14 September 2002 22:47

Mezzers

Messages: 12
Registered: September 2002
Location: UK

Karma: 0

Junior Member

Yes, I'm logged in now and am taking a look at things. I have a sense that something I did inadvertently bumped my database, because I couldn't access it via phpMyAdmin for a while after the first error occurred. Which, btw, I just found in my error log. It's Greek to me. Maybe it will shed some light?

Sat Sep 14 18:59:39 GMT 2002
(t=threadt&frm_id=1&rid=1&S=a129a7a49ad8354f728852e16fb1b8da) :
Query: Initiating mysql_pconnect
Server Version: Unknown
[Referring Page] http://www.charlesdance.co.uk/forum/index.php?
t=thread&frm_id=1&rid=1&S=a129a7a49ad8354f728852e16fb1b8da

This was the first error; there are more that follow if you want/need to see them. Just ask. I really appreciate your time!

Mez

Report message to a moderator

Re: mySQL forum errors [message #5704 is a reply to message #5703]

Sat, 14 September 2002 22:57

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Well, from what I could gather from the 1st error you showed to me, something was not quite right with the MySQL server. Not a problem with the forum itself, the fact phpMyAdmin was unable to access the MySQL only re-affirms this conclusion.

FUDforum Core Developer

Report message to a moderator

Re: mySQL forum errors [message #5706 is a reply to message #5703]

Sat, 14 September 2002 23:06

Mezzers

Messages: 12
Registered: September 2002
Location: UK

Karma: 0

Junior Member

Just did it again. I clicked on 'Test Category' to view the messages and got this:

Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /home/charlesdanuk/public_html/forum/data/include/theme/default/db.inc on line 23

Warning: Supplied argument is not a valid MySQL-Link resource in /home/charlesdanuk/public_html/forum/data/include/theme/default/db.inc on line 24

Warning: Supplied argument is not a valid MySQL-Link resource in /home/charlesdanuk/public_html/forum/data/include/theme/default/db.inc on line 24

Fatal error: SQL Error has occured, please contact the administrator of the forum and have them review the forum's SQL query log in /home/charlesdanuk/public_html/forum/data/include/theme/default/err.inc on line 102

Can't get into anything again, altho this time I was wise and left my files unlocked! My database link in globals.php is right...I think. In truth I originally input it as:

:var/lib/mysql/mysql.sock

After I was able to login to admin again, I took another look at the manual and modified it to:

:/var/lib/mysql/mysql.sock

But both times I was able to get into the forum, and neither time did it throw an error at me until I tried to go into 'Test Category'.

Mez

Report message to a moderator

Re: mySQL forum errors [message #5709 is a reply to message #5706]

Sun, 15 September 2002 00:08

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

What is the version of the MySQL you are using?

FUDforum Core Developer

Report message to a moderator

Re: mySQL forum errors [message #5710 is a reply to message #5709]

Sun, 15 September 2002 00:08

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Also, can you try switching from persistant connections to regular ones (option of the admin control panel) and see if the problem goes away.

FUDforum Core Developer

Report message to a moderator

Re: mySQL forum errors [message #5713 is a reply to message #5710]

Sun, 15 September 2002 00:55

Mezzers

Messages: 12
Registered: September 2002
Location: UK

Karma: 0

Junior Member

mySQL version 3.23.45. I've also posted a query to my host's database support forum, but so far they aren't as attentive as you.

prottoss wrote on Sun, 15 September 2002 01:08

Also, can you try switching from persistant connections to regular ones (option of the admin control panel) and see if the problem goes away.

Will do, as soon as my database bounces back! I'll let you know what happens. Thanks for the pointers, Prottoss, you've been very kind to this newbie. Smile

Smile

Mez

Report message to a moderator

Re: mySQL forum errors - Follow-up [message #5716 is a reply to message #5713]

Sun, 15 September 2002 16:04

Mezzers

Messages: 12
Registered: September 2002
Location: UK

Karma: 0

Junior Member

Prottoss, you were right, this is a mySQL issue with my host -- nothing to do with FUD. Everyone who's asked about it on their support forum (including me) is being yelled at to ALWAYS ring the fault line when something like this happens. Unfortunately it started just as I got my forum up and running, so I assumed it was something I had done.

Geez Loweez, I've got enough problems as a webmistress...now I'm supposed to become a techie for my host? Only if they pay me! Twisted Evil

Twisted Evil

Thanks again for all your help. Smile

Smile

Mez

Report message to a moderator

Re: mySQL forum errors - Follow-up [message #6442 is a reply to message #5716]

Fri, 11 October 2002 07:49

ctbk

Messages: 142
Registered: April 2002
Location: Milan, Italy

Karma: 0

Senior Member

I have the same problem you had and I didn't understand how did you resolve it.

Sometimes when I browse the forum I get a blank page.
If I try to reload it, sometimes it works, sometimes I get the blank page again.

Looking in ControlPanel, Error Log viewer, I got a page serveral MB big, full of MySql Errors like:

Query: Initiating mysql_pconnect
Server Version: Unknown
[etc etc]

I've just upgraded mysql-server to version 3.23.52, but the problem persists.

Now I tried disabling persistant connections and the board is working fine... but I'd like to solve the problem.

What did you do?

Thanx,
Ste

~
~
:wq

[Updated on: Fri, 11 October 2002 07:57]

Report message to a moderator

Previous Topic:	trouble with update.php and PHP safe mode
Next Topic:	Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 05:50:03 GMT 2024

Total time taken to generate the page: 0.02561 seconds