MyBB Community Forums

Full Version: DB Error
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
i am getting below error on my website http://pakbestgamers.com/

Quote:MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND visible='1' AND closed NOT LIKE 'moved|%'' at line 1
Query:
SELECT COUNT(*) AS annnum FROM mybb_threads WHERE fid IN (2,11,12,13,14,15,17,) AND visible='1' AND closed NOT LIKE 'moved|%'
That's not a default MyBB query. What plugins do you have installed?
but site home page works fine yesterday and my forum works fine http://pakbestgamers.com/forums/
In inc/init.php, add the following a new line after the line that says "<?php"
define("NO_PLUGINS",1);
So top looks like this:
<?php 
define("NO_PLUGINS",1);
/**

This will temporarily disable all plugins so some features will be missing from your forum but if you remove that line afterwards, everything will be fine again.

Do you still get that error with all plugins disabled?
If it was working yesterday but not today, something must have changed. Either by you, another admin or your host.
i did still same you can also check your self
I also made another test forum where i everything works fine
http://pakbestgamers.com/mybb/index.php
What plugins you have installed ?
below are installed
Auto Media (1.1.9)
Image Resizer & Optimizer with GD (1.1.1)
MyVids by MyBBSource.com (1.0)
myxbl (3.1)
Page Manager (1.5.2)
Sure you've got no others...?? As it doesn't look like that query is coming from any of those.