error with mybb1.6
1master1 Offline
Member
***
Posts: 232
Joined: Oct 2010
Post: #1
error with mybb1.6
Hello
can anyone please help me in fixing this issue?

Code:
1
2
3
4
5
6
7
8
9
10
Type: 20
File:  (Line no. 0)
Message
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 ')
                       ORDER BY p.dateline' at line 3
Query:
                       SELECT subject, message
                       FROM nstdb_posts p
                       WHERE pid IN()
                       ORDER BY p.dateline

(This post was last modified: 10-13-2010 06:13 AM by 1master1.)
10-13-2010 06:13 AM
Find all posts by this user Quote this message in a reply
RateU Offline
Administrator
*******
Posts: 2,350
Joined: Mar 2010
Post: #2
RE: error with mybb1.6
Do you get it from plugin?
At least you need a "value" inside the bracket in:

SQL Code
Where pid IN()


10-13-2010 07:11 AM
Find all posts by this user Quote this message in a reply
1master1 Offline
Member
***
Posts: 232
Joined: Oct 2010
Post: #3
RE: error with mybb1.6
yeah, i installed quite few plugins, but dont know from which plugin it occurs. Frown
10-13-2010 07:19 AM
Find all posts by this user Quote this message in a reply
RateU Offline
Administrator
*******
Posts: 2,350
Joined: Mar 2010
Post: #4
RE: error with mybb1.6
That plugin should be related for displaying post.

10-13-2010 07:23 AM
Find all posts by this user Quote this message in a reply
1master1 Offline
Member
***
Posts: 232
Joined: Oct 2010
Post: #5
RE: error with mybb1.6
I have installed these plugins related to post display

Additional Group Icons
Advanced MyCode Permissions
advancedquickreplyform
autosigremoval
BumpThread
CloseThread
Custom Forum Icons
Default Avatar 1.0
forumcleaner-2.4.4
firstpostattop
Guests Can't View Threads
Highslide
iShare_1100
limitthreadsinforums
mark_edited_as_unread_1.2
Mods Can't Edit Admin Posts
Page Manager
Popup_Reputation
rssfeedposter1.0.4.1
Select_All_Code_PhP_Blocks
SignHeightLimit
spoiler
SubscriptionCleanup
whoviewedtopic
10-13-2010 07:32 AM
Find all posts by this user Quote this message in a reply
ZiNgA BuRgA Offline
Fag
*******
Posts: 3,357
Joined: Jan 2008
Post: #6
RE: error with mybb1.6
You need to disable them one by one to see which one is causing the issue.
It might be smarter to start with ones which have some relationship with posts.

My Blog
(This post was last modified: 10-13-2010 10:24 AM by ZiNgA BuRgA.)
10-13-2010 10:24 AM
Find all posts by this user Quote this message in a reply

« Next Oldest | Next Newest »

 Standard Tools
Forum Jump: