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

Home » General » Database discussions » Looking for some direction in solving SQL errors
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Looking for some direction in solving SQL errors [message #167578] Tue, 17 July 2012 10:17 Go to next message
pips is currently offline  pips   Ireland
Messages: 113
Registered: February 2012
Karma: 0
Senior Member
Seems we keep ketting SQL errors (FUD RC 3.04)

Quote:
(/vhosts/nomad-forum.com/httpdocs/fudforum/index.php:29
) 2003: Can't connect to MySQL server on '192.168.1.7' (4)
Query: Initiating MasterDB mysql_connect
Database version: Unknown



I appreciate SQL is a field all in itself, but i'm just wondering if you have any pointers in where i begin in solvin these problems?

Are they Host issues or is our Forum setup wrong (its a fresh set up)


After about 10 mins, the forum resets, i do a consistancy check and everything seems ok again.


(Could this be a permissions issue?)


Any help appreciated. :toppa:
Re: Looking for some direction in solving SQL errors [message #167582 is a reply to message #167578] Wed, 18 July 2012 16:14 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Is the forum and DB on the same server? If so, connect with a socket (something like :/var/run/mysqld/mysqld.sock) and add "skip-networking" to your my.cnf file.

How busy is the DB server? You may need a bigger server with more RAM / faster disks.
Re: Looking for some direction in solving SQL errors [message #167584 is a reply to message #167582] Wed, 18 July 2012 17:08 Go to previous message
pips is currently offline  pips   Ireland
Messages: 113
Registered: February 2012
Karma: 0
Senior Member
Will try this.

Thanks as ever for the support. Top notch
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Error 1045
Next Topic: Regenerate tv table without running consistency checker
Goto Forum:
  

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

Current Time: Thu Mar 28 21:55:09 GMT 2024

Total time taken to generate the page: 0.02459 seconds