Support Forums › Categories › Webmaster Support › Forum Software Help
MyBB 1.4 SQL Error?

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Threaded Mode
MyBB 1.4 SQL Error?
Magiic™ Offline
Conspirator #3
***
Posts: 103
Threads: 5
Joined: Apr 2010
Reputation: 3
#1
10-28-2010, 03:08 AM
Yeah I keep getting this error when I use the Admin CP for a while. It works after a couple of refreshes, but it's irritating. I don't know where I went wrong with the MySQL.

Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1317 - Query execution was interrupted
Query:
SELECT * FROM mybb_adminsessions WHERE sid='ff578c634b388f88f8faff7b0740cdb8'
[Image: FILE.php]
First passed PL on SF.
Website Find
Reply
Sam Offline
Teacher
*****
Posts: 2,793
Threads: 251
Joined: Oct 2009
Reputation: 85
#2
10-28-2010, 03:19 AM (This post was last modified: 10-28-2010, 03:25 AM by Sam.)
It looks to me like your DB can't execute the "select" command. Make sure info is correct in inc/config.php It colud be your host though, I'm not quite sure. Contact your host.
Find
Reply
MattR Offline
MyBB Support Team Lead
***
Posts: 148
Threads: 4
Joined: Oct 2009
Reputation: 8
#3
10-28-2010, 03:22 AM (This post was last modified: 10-28-2010, 03:22 AM by MattR.)
If your config.php details were wrong you'd get a totally different error. The query is getting interrupted, you'll need to ask your host about it.
MyBB Support Team Lead
Website Find
Reply
Sam Offline
Teacher
*****
Posts: 2,793
Threads: 251
Joined: Oct 2009
Reputation: 85
#4
10-28-2010, 03:25 AM
I wasn't too far off then.
Find
Reply
Magiic™ Offline
Conspirator #3
***
Posts: 103
Threads: 5
Joined: Apr 2010
Reputation: 3
#5
10-28-2010, 03:29 AM (This post was last modified: 10-28-2010, 03:29 AM by Magiic™.)
Alright, I will do. Thanks for your help guys Thumbsup
[Image: FILE.php]
First passed PL on SF.
Website Find
Reply
Brandon Offline
Regular Member
***
Posts: 221
Threads: 15
Joined: Aug 2010
Reputation: 8
#6
10-28-2010, 08:54 AM
This occurs when you cannot connect to your database but your settings are correct. What you need to do is first, make sure that your settings are correct obviously. Usually "Localhost" and the dbname, dbpw, and dbuser are setup properly. Was this running OK before?

If that doesn't work, you'll have to ask your host. I'm pretty sure this isn't a "can't connect due to incorrect settings in the config.php file" issue though, but it's worth a shot fixing if you aren't sure they are correct.
Find
Reply
Magiic™ Offline
Conspirator #3
***
Posts: 103
Threads: 5
Joined: Apr 2010
Reputation: 3
#7
10-28-2010, 10:28 AM
(10-28-2010, 08:54 AM)Brandon Wrote: This occurs when you cannot connect to your database but your settings are correct. What you need to do is first, make sure that your settings are correct obviously. Usually "Localhost" and the dbname, dbpw, and dbuser are setup properly. Was this running OK before?

If that doesn't work, you'll have to ask your host. I'm pretty sure this isn't a "can't connect due to incorrect settings in the config.php file" issue though, but it's worth a shot fixing if you aren't sure they are correct.

Oh it works most of the time, it's just irritating Tongue I'll contact my host anyway.
[Image: FILE.php]
First passed PL on SF.
Website Find
Reply
Brandon Offline
Regular Member
***
Posts: 221
Threads: 15
Joined: Aug 2010
Reputation: 8
#8
10-29-2010, 09:56 PM
Then yea, your settings are proper it's your host.
Find
Reply
Omniscient Offline
Win By Attrition
*******
Administrators
Posts: 1,778
Threads: 163
Joined: Jun 2007
Reputation: 218
#9
10-29-2010, 11:04 PM (This post was last modified: 10-29-2010, 11:04 PM by Omniscient.)
Quote:- Query execution was interrupted

Host problem. That's what it is.
Superman I am here to rescue you.
This is Support Forums not Support PMs.  Do not PM me for support unless it's private and site related.
Website Find
Reply
Magiic™ Offline
Conspirator #3
***
Posts: 103
Threads: 5
Joined: Apr 2010
Reputation: 3
#10
10-30-2010, 01:55 AM
(10-29-2010, 11:04 PM)Omniscient Wrote: Host problem. That's what it is.
Alright then, I sent them an E-mail earlier today Smile
[Image: FILE.php]
First passed PL on SF.
Website Find
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  myBB Forum Permission Cache Error - Crippling My Forum CruciasNZ 1 1,058 04-24-2013, 12:11 AM
Last Post: Kevin Cheri
  How To Install MyBB | MyBB Installation Guide BreShiE 2 1,413 03-10-2012, 06:33 AM
Last Post: BreShiE
  Mybb problems and error, need help :) Crystal 15 4,706 09-26-2011, 03:42 AM
Last Post: Crystal
  MyBB question @OMNI or any other mybb Guru's 0xE9 13 29,577 07-28-2011, 01:29 PM
Last Post: Pompano
  How to Make your MYBB Central Plugin Compatible with new Mybb Billy Mays 3 2,130 07-12-2011, 06:40 PM
Last Post: Billy Mays

Forum Jump:


Users browsing this thread: 2 Guest(s)