Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 Error when using filterxt links for thread prefixes, after updating to MyBB 1.8.6
Shane777 Offline
Junior Member
**
Posts: 3
Joined: Sep 2015
Post: #1
Error when using filterxt links for thread prefixes, after updating to MyBB 1.8.6
I recently upgraded my board to MyBB 1.8.6.  Everything with XThreads seems to work fine except for some prefix filter links I have on one of my forums.  Here is the error I get when clicking those links:

SQL Error:
1054 - Unknown column 'prefix' in 'where clause'
Query:
SELECT DISTINCT tid,uid FROM mybb_posts WHERE uid='1' AND tid IN (21896,21883,21747,21742,21719,21673,21672,21630,21614,21587,21556,21429,21425,21373,21362,21332,212​88,21284,21059,20997,20842,20840,20744,20357,20241,15365,13707) AND visible IN (-1,0,1) AND `prefix` IN (5)


An example of one of the links that causes that error to appear is this link:
/forumdisplay.php?fid=18&filterxt_prefix=5

The error only happens while logged in.  For some reason, if I'm viewing as a guest, the links work correctly.

Before updating to MyBB 1.8.6, they all worked perfectly.  After I upgraded to MyBB 1.8.6, I also made sure to upgrade XThreads yesterday just to see if that would help.  The error remained even after updating XThreads. Frown

How can I fix this?  I am comfortable editing core files if you have some find/replace instructions I can follow.  Thanks.
(This post was last modified: 09-18-2015 07:28 PM by Shane777.)
09-18-2015 07:17 PM
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 when using filterxt links for thread prefixes, after updating to MyBB 1.8.6
For 1.8, instead of using filterxt_prefix=5, use prefix=5

09-19-2015 01:35 AM
Find all posts by this user Quote this message in a reply
Shane777 Offline
Junior Member
**
Posts: 3
Joined: Sep 2015
Post: #3
RE: Error when using filterxt links for thread prefixes, after updating to MyBB 1.8.6
Thank you.  When I try that, it works for a single prefix URL.

But for the multiple prefix URLs it still doesn't work how it used to.  For example:

forumdisplay.php?fid=18&prefix[]=5&prefix[]=7

^That doesn't filter 5 and 7 like it should.

What is the new way to write the URL for multiple prefixes?
(This post was last modified: 09-19-2015 02:22 AM by Shane777.)
09-19-2015 02:20 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 when using filterxt links for thread prefixes, after updating to MyBB 1.8.6
Are you using the default MyBB thread prefix?
If so, for temporary solutions, try to set the Use 'dot' Icons setting in Forum Display Options settings group to Off

(This post was last modified: 09-19-2015 04:56 AM by RateU.)
09-19-2015 02:39 AM
Find all posts by this user Quote this message in a reply
Shane777 Offline
Junior Member
**
Posts: 3
Joined: Sep 2015
Post: #5
RE: Error when using filterxt links for thread prefixes, after updating to MyBB 1.8.6
That worked.  The single prefix URLs and the multiple prefix URLs all function perfectly again using filterxt_prefix=.  Thank you for the quick help.
(This post was last modified: 09-19-2015 07:36 AM by Shane777.)
09-19-2015 07:34 AM
Find all posts by this user Quote this message in a reply

« Next Oldest | Next Newest »

 Standard Tools
Forum Jump: