Filter News Module by Thread Prefix

[lukem]

I am having problems with this. In the news module, I replaced:

PHP Code:

WHERE thread.threadid IN(" . implode(',', $newstids) . ") 


with

PHP Code:

WHERE thread.threadid IN(" . implode(',', $newstids) . ") AND thread.prefixid = 'NEWS' 


The problem is that it isn't showing any threads with the NEWS prefix other than threads posted today. I've tried setting the cutoff to 0 or 120 and neither seem to make a difference.

Can anyone here help me with this?

[lukem]

I posted a couple of news threads today and they are showing up on the homepage. There's no one that can help me with this problem? I'm willing to pay for it!

[Alfa1]

Why not move each thread to a forum dedicated to the prefix topic?

[lukem]

Originally Posted by Alfa1

Why not move each thread to a forum dedicated to the prefix topic?

That is how I had it before but basically I have news broken down by state. I also had a forum where people from that state could talk. Most people go to the latter forum and not the news. I merged them and now just post the NEWS prefix in front of any news threads. I've posted a few other places to see if I can pay someone to look into this problem since it doesn't seem like I'm getting any fixes from here.

[lukem]

bump for support

[Zexsi]

Submit a query to your sqlserver first, (my forum has a base prefix of vb, yours will probably have something different, change as needed)

select prefixid from vb_thread group by prefixid;

Now, what do you see? is it just 1 row of nothing?

[lukem]

select NEWS from thread group by prefixid;

Error

SQL query: Documentation

SELECT NEWS
FROM thread
GROUP BY prefixid
LIMIT 0 , 30;

MySQL said: Documentation
#1054 - Unknown column 'NEWS' in 'field list'

Does that help at all or did I do something wrong?

[Zexsi]

Try this instead (exactly as I show it, copy/paste)

SELECT prefixid from thread group by prefixid;

[lukem]

Sorry, I'm not sure why I changed it. I get a list of all my prefixes:

Edit Delete
Edit Delete Group_Buy
Edit Delete NEWS
Edit Delete SOLD
Edit Delete TRADED
Edit Delete WTB
Edit Delete WTS
Edit Delete WTS_WTT
Edit Delete WTT

[Zexsi]

based on what I'm seeing from your results,

AND thread.prefixid = 'NEWS'

should have worked. I am starting to think the problem might be elsewhere, such as time limit ranges or something else.

Just one last thing to try would be to use this instead, if this doesnt work, then you'll know for sure its something else:

AND thread.prefixid like '%NEWS%'

[lukem]

I don't think this worked as there's no more showing than before. Only today's NEWS threads are showing up but no breadcrumbs or past days.

Cutoff is set to 0.

As soon as I remove:

AND thread.prefixid like '%NEWS%'

All other threads show up, the news archive shows up, and the breadcrumbs show up. I don't get it at all.

[Zexsi]

How about instead of 0, use 90 or 180 and see if that affects the results. You could be on to a bug when using zero maybe.

[lukem]

Nope, just tried that. It still just shows only the ones I've posted today. I did notice that the news archive shows up because I posted more than 5 news threads today. But with 0, 90, 180, etc, the breadcrumbs should be showing up with ones before today.

[tavenger5]

I'm trying to do something similar. Have you found the solution?

[alt3rnate]

I have exactly the same issue :/ bump for support