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

Home » FUDforum Development » FUDforum 3.0+ » SQL Error
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
SQL Error [message #168140] Mon, 11 February 2013 08:56 Go to next message
jm2morri is currently offline  jm2morri   
Messages: 225
Registered: January 2009
Location: Stratford, Ontario, Canad...
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
Hello,

Does anyone know what this error means and how to fix it? I get it in the http error logs.

PHP Fatal error:  SQL error has occurred, please contact the <a href="mailto:admin(at)eaglecentral(dot)ca?subject=SQL%20Error">administrator</a> of the forum and have them review the forum's SQL query log in /var/data/fudforum_data/include/core.inc on line 260


James.
Re: SQL Error [message #168141 is a reply to message #168140] Mon, 11 February 2013 09:03 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
Navigate to the ACP -> Error Log Viewer and open the SQL log.
Re: SQL Error [message #168142 is a reply to message #168141] Mon, 11 February 2013 09:03 Go to previous messageGo to next message
jm2morri is currently offline  jm2morri   
Messages: 225
Registered: January 2009
Location: Stratford, Ontario, Canad...
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
I can't. The forums don't show up at all. I suppose I should have mentioned that Smile
Re: SQL Error [message #168143 is a reply to message #168142] Mon, 11 February 2013 09:05 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
That's why I've included the link Smile
Re: SQL Error [message #168144 is a reply to message #168142] Mon, 11 February 2013 09:06 Go to previous message
jm2morri is currently offline  jm2morri   
Messages: 225
Registered: January 2009
Location: Stratford, Ontario, Canad...
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
OK, I figured it out. My SQL database was corrupted. I ran this command from the command line to fix it:

mysqlcheck -r database_name -uuserid -ppassword


If anyone runs into this in the future...

James.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Javascript gets executed if importet with NNTP
Next Topic: Reddit-like comment rating and others features
Goto Forum:
  

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

Current Time: Sun Oct 22 04:22:19 EDT 2017

Total time taken to generate the page: 0.00762 seconds