Related category

[aladdin1]

The related category does not seem to works in my idrectory, any guidance?

[ezykiwi]

Have you checked in the other catagory... I found it was kinda around the wrong way..... but that was probibly just me..

[aladdin1]

What is the tag name?

[pip]

Guys, did any of you manage to get it working? I can't seem to assign related category.

[canmmail]

i have this problem too.
and i tried everything.

[esm]

the problem is probably the data type. it is currently set at SMALLINT which means is maximum value is 32767. So if your category id is larger then you will have a problem

change the data type to INT with Length of 10

or run the following command

ALTER TABLE idx_category CHANGE related related INT(10) DEFAULT '0' NOT NULL

[esm]

also, I am not sure that this line is correct in the Display function in the category.class.php file

    $query = "select * from $this->table_name where (related = $this->parent and visible = 1 and related<>0)";

seems like it should be

    $query = "select * from $this->table_name where (category_id= $this->parent and visible = 1 and related<>0)";

you could try the above change
but let me know if the original works.

[pip]

Originally posted by esm
the problem is probably the data type. it is currently set at SMALLINT which means is maximum value is 32767. So if your category id is larger then you will have a problem

change the data type to INT with Length of 10

or run the following command

ALTER TABLE idx_category CHANGE related related INT(10) DEFAULT '0' NOT NULL

I only have 20 categories and I don't think any of those exceeded the max value of SMALLINT. I believe it is more of a coding error and I will try what you suggested on category.class.php

But of course, they above should apply to those having more categories than the max value.

[esm]

use

 $query = "select * from $this->table_name where (category_id= $this->parent and visible = 1 and related<>0)";

[pip]

Hi ESM,

Your code doesn't make a difference. I still can't create a RELATED category. When I do that, the whole category goes under another directory instead of a symlink-like category appears on that other directory.

AND WHERE IS THE IDEAL SUPPORT FROM DODY???? He has NEVER responded to any of my PM or emails to him. What kind of developer who wouldn't support his clients? We pay for the software, remember????

If not for ESM and many others like him who are supportive in this forum, I don't think Dody's little software would come this far.

[aladdin1]

Originally posted by pip

What kind of developer who wouldn't support his clients?

Doby would!!

He has been very busy speaking about Indexu 4.0 (13 month) and about Indexu 3.2 (Several months), BTW, Indexu 3.2 is going to alleviate and fix all the known bugs......... someday

[ezykiwi]

If your wanting to look at a working example of Related Cat, send me a pm.

Cheers Ezy

[pip]

An example of a working code would be appreciated, Ezykiwi. I have also PM you.

[pip]

Aladdin1, did you manage to get your Related Category working?

Am I supposed to fill in these in my category.class?

// internal use only

var $db_server = "mysql";
var $db_hostname = "localhost";
var $db_username = "";
var $db_password = "";
var $db_name = "";
var $db_connect = "";

Mine is not filled yet. Let me know if this is the cause. By the way, what should I fill in for $db_connect?

[canmmail]

hey everybody,
everyones related category feature works correctly except "pip" and me ??????

Strange isn't it ?
Is there anyone using related category feauture in here ????????
I think that. this is really really big problem a very big problem.