Today I found a very strange mysql error and perhaps a bug.
For me it is so strange because it is not by all members only when they make a big of post.
The error is also not vissible for guest then it is normal
http://www.ikf-forum.eu/search.php?actio...user&uid=2
In this line you see a part of the error message because when I show it all there about 7000 numbers in it.
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 >= 0' at line 1
Query:
SELECT pid, tid FROM mybb_posts WHERE pid IN(1,2,4,71,6,7,10,14,16,17,135374,135376,20,21,22,23,24,25,26,27,28,29,30,31,32,33......................................................................,206446,206453,206454,206467,) AND visible >= 0
Please contact the MyBB Group for support.
I get this erro when I ask for a profile from somebody and ask for show posts.
Errors like this are usually caused by plugins, what ones do you have??
News Message (1.1.2)
Admins can log into Users' accounts (1.0)
Ads after first post (2.2)
Advanced Quick Reply Form (1.0.3)
Buddies In UserProfile (1.0)
Country Flags Of Online Users On Index (2.0)
Contact Form (3.0)
Country Flag (3.0)
Fast Menu (0.2b)
ACP Fast Drop Down Menus
Game Section (1.2 RC2.1)
Hide From Guests (1.1)
MyMood (1.0 Beta)
Multi Video Mycode For MyBB (1.7)
My Youtube (1.1)
My Question (1.3)
Show the users that has been online today (2.0)
Private Messages Admin (2.4.1)
Simple Calendar on Portal (1.1)
Portal Redirect (1.1.0)
Profile Picture (1.2)
Posting Profile Icon (2.0)
Profile Gtalk (0.1)
ProfileTube (1.0)
Quick Theme! (1.1.1)
Post On Registration (0.1)
Side Boxes! (3.0)
Trash Can Forum (2.0)
Tube Video Gallery (1.4.0)
Specific forum banning (1.0.1)
Usermap (1.1)
Username History (1.1)
I deactivate some plugins but still this error
Now my list of plugins is:
Quote:News Message (1.1.2)
Admins can log into Users' accounts (1.0)
Ads after first post (2.2)
Advanced Quick Reply Form (1.0.3)
Country Flags Of Online Users On Index (2.0)
Contact Form (3.0)
Country Flag (3.0)
Fast Menu (0.2b)
Game Section (1.2 RC2.1)
Hide From Guests (1.1)
MyMood (1.0 Beta)
Multi Video Mycode For MyBB (1.7)
My Youtube (1.1)
My Question (1.3)
Show the users that has been online today (2.0)
Private Messages Admin (2.4.1)
Simple Calendar on Portal (1.1)
Portal Redirect (1.1.0)
Posting Profile Icon (2.0)
Quick Theme! (1.1.1)
Post On Registration (0.1)
Side Boxes! (3.0)
Trash Can Forum (2.0)
Tube Video Gallery (1.4.0)
Specific forum banning (1.0.1)
Usermap (1.1)
Username History (1.1)
This is the image of the error.
I hope somebody is able to help me.
Try deactivating the trash can forum or Specific forum banning. I am just taking a guess, but they seem to do stuff with threads so I am wondering if they are screwing up the search.
Disable all your plugins, then see if it still happens. If it doesn't, enable them again one at a time testing between each one to see which one causes it. Deactive the culprit again and ask the author of it for help with it.
Well I deactivate some of the plugins, because I do not want to deactivate all of them because:
- loosing saved information in database
- after activating they do not come back on the place where I want to have them.
- loose my own settings
This is the list that still is over. Perhaps there are some of them that are 100% sure not could be the reason of the error.
Please tell it me so I can continue deactivating.
News Message (1.1.2)
Ads after first post (2.2)
Advanced Quick Reply Form (1.0.3)
Country Flags Of Online Users On Index (2.0)
Contact Form (3.0)
Country Flag (3.0)
Game Section (1.2 RC2.1)
MyMood (1.0 Beta)
Show the users that has been online today (2.0)
Simple Calendar on Portal (1.1)
Portal Redirect (1.1.0)
Posting Profile Icon (2.0)
Quick Theme! (1.1.1)
Side Boxes! (3.0)
Tube Video Gallery (1.4.0)
Usermap (1.1)
But I still call it strange till now only one person has got it.
This person has got the most post of all 12000.
And anther thing that is strange members see this error guest do not see.
http://www.ikf-forum.eu/search.php?actio...88797dc9c3
my mood mod had given me a error with another mod at 1 point so i deleted both, not saying it is the solution but it usally is 2 plugins that collide at once and do not like eachother ...