Mutiple Category Problem Fix/Solution (recommend changing)

Report bugs and errors in this forum.

Mutiple Category Problem Fix/Solution (recommend changing)

Postby azn_romeo_4u » Mon Feb 02, 2009 10:10 am

1. Open the file inc/show.news.php
2. Find the line 86 which looks like:
$where[] = 'category =~ %'.$single_cat.'%';

3. Replace the line with below line.
$where[] = "category REGEXP ^$single_cat\$|^$single_cat,|,$single_cat,|,$single_cat\$";


If you have the problem, I recommend making the changes. Or you can use ramon's solution. http://forums.cutenewsru.com/multiple-c ... t2614.html I have 115+ categories as of today and i had stuff going into other categories like crazy but with the fix, it's all good.

I had a coder look into the problem for me. So credits to him.
azn_romeo_4u
 
Posts: 123
Joined: Thu Sep 18, 2008 5:06 am

Postby nolikewise » Sun Jul 26, 2009 5:44 pm

thanks i applied it
nolikewise
 
Posts: 177
Joined: Mon Dec 17, 2007 8:47 am
Location: Turkiye

Postby samiro » Thu Feb 18, 2010 7:40 pm

after the modification - do we need to use it like this
'34|42|43';

of like before
'34,42,43';
????????
User avatar
samiro
 
Posts: 103
Joined: Sun Apr 20, 2008 1:52 pm
Location: IL

Postby Torstein » Fri Feb 19, 2010 3:16 pm

no
Torstein
 
Posts: 292
Joined: Thu Aug 03, 2006 11:19 pm

Postby samiro » Fri Feb 19, 2010 3:52 pm

what "no"

this :'34|42|43';
or '34,42,43'; ?
User avatar
samiro
 
Posts: 103
Joined: Sun Apr 20, 2008 1:52 pm
Location: IL

Postby Torstein » Fri Feb 19, 2010 4:58 pm

No, you do not have to use '34|42|43'; syntax.

You just use the normal syntax '34,42,43';
Torstein
 
Posts: 292
Joined: Thu Aug 03, 2006 11:19 pm

Postby samiro » Fri Feb 19, 2010 5:03 pm

thank you
i change this
its not make any difference but i will leave it like you said
thank you
User avatar
samiro
 
Posts: 103
Joined: Sun Apr 20, 2008 1:52 pm
Location: IL

Re: Mutiple Category Problem Fix/Solution (recommend changin

Postby alex » Sun Feb 20, 2011 12:57 am

thanks for the fix, this solved my crazy categories
alex
 
Posts: 24
Joined: Thu Aug 21, 2008 5:05 pm


Return to Bugs and errors



Who is online

Users browsing this forum: No registered users and 0 guests

cron