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 :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
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 06:17 Go to next message
pips is currently offline  pips   Ireland
Messages: 113
Registered: February 2012
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
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 12:14 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
remove from buddy list
ignore all messages by this user
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 13:08 Go to previous message
pips is currently offline  pips   Ireland
Messages: 113
Registered: February 2012
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Will try this.

Thanks as ever for the support. Top notch
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Fri Oct 20 17:44:02 EDT 2017

Total time taken to generate the page: 0.00810 seconds