FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » mySQL forum errors
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
mySQL forum errors [message #5695] Sat, 14 September 2002 19:33 Go to next message
Mezzers is currently offline  Mezzers   United Kingdom
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 Please help, I don't understand why it suddenly crashed!

Thank you, Mez
Re: mySQL forum errors [message #5697 is a reply to message #5695] Sat, 14 September 2002 20:05 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
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
Re: mySQL forum errors [message #5698 is a reply to message #5697] Sat, 14 September 2002 22:03 Go to previous messageGo to next message
Mezzers is currently offline  Mezzers   United Kingdom
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
Re: mySQL forum errors [message #5699 is a reply to message #5698] Sat, 14 September 2002 22:10 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
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
Re: AH HA [message #5700 is a reply to message #5698] Sat, 14 September 2002 22:17 Go to previous messageGo to next message
Mezzers is currently offline  Mezzers   United Kingdom
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

Mez
Re: mySQL forum errors [message #5701 is a reply to message #5699] Sat, 14 September 2002 22:21 Go to previous messageGo to next message
Mezzers is currently offline  Mezzers   United Kingdom
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
Re: mySQL forum errors [message #5702 is a reply to message #5701] Sat, 14 September 2002 22:38 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
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
Re: mySQL forum errors [message #5703 is a reply to message #5702] Sat, 14 September 2002 22:47 Go to previous messageGo to next message
Mezzers is currently offline  Mezzers   United Kingdom
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
Re: mySQL forum errors [message #5704 is a reply to message #5703] Sat, 14 September 2002 22:57 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
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
Re: mySQL forum errors [message #5706 is a reply to message #5703] Sat, 14 September 2002 23:06 Go to previous messageGo to next message
Mezzers is currently offline  Mezzers   United Kingdom
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
Re: mySQL forum errors [message #5709 is a reply to message #5706] Sun, 15 September 2002 00:08 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
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
Re: mySQL forum errors [message #5710 is a reply to message #5709] Sun, 15 September 2002 00:08 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
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
Re: mySQL forum errors [message #5713 is a reply to message #5710] Sun, 15 September 2002 00:55 Go to previous messageGo to next message
Mezzers is currently offline  Mezzers   United Kingdom
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

Mez
Re: mySQL forum errors - Follow-up [message #5716 is a reply to message #5713] Sun, 15 September 2002 16:04 Go to previous messageGo to next message
Mezzers is currently offline  Mezzers   United Kingdom
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

Thanks again for all your help. Smile

Mez
Re: mySQL forum errors - Follow-up [message #6442 is a reply to message #5716] Fri, 11 October 2002 07:49 Go to previous message
ctbk is currently offline  ctbk   Italy
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

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: trouble with update.php and PHP safe mode
Next Topic: Error
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 06 16:22:29 GMT 2024

Total time taken to generate the page: 0.02707 seconds