[Geoserv]

The above query wasn't the right one, here is the one I should have used:

SELECT pligg_links.link_title, pligg_links.link_title_url, COUNT( pligg_tags.tag_link_id ) AS relevance, pligg_tags.tag_link_id FROM pligg_tags, pligg_links WHERE pligg_tags.tag_words IN ( 'web', 'security', 'technology' ) AND pligg_tags.tag_link_id = pligg_links.link_id AND pligg_links.link_status != 'discard' AND NOT pligg_links.link_id = 58

and here is the error I get:

#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

Geoserv

[revenazb]

Geoserv can you attach your html1.php file, I'll take a look at it.

[diablo]

1. this mod is not working
all stories same tags, same category/ category off
notting
my test server on mysql 4.1.x

mod only works with mysql 5.x.x

any help?

thank you

[kbeeveer46]

diablo, are you testing with published stories?

[Geoserv]

Here is my html1.php file, I put in txt format for the purpose of uploading it here.

Thanks,
Geoserv.

[boardsource]

i wanted to add this mod in the sidebar, so that it would be a little easier to see. is there some sort of if statement i could add so that it only shows up in story.php, also i seem to be having the same problem as Geoserv

thanks

[diablo]

ok fixed

thank you

[revenazb]

Originally Posted by Geoserv

Here is my html1.php file, I put in txt format for the purpose of uploading it here.

Thanks,
Geoserv.

Hi Geoserv,

I tried it on my site with your html1.php file and did not get any results. I made one small cahnge and got results as before:

Try changing

link_status = 'upcoming'

to

link_status != 'discard'

If that doesn't work for you then the problem is in the templating portion of the mod.

Bert

[Geoserv]

I tried that already, so there must be something else preventing it from working.

Thanks for looking.

Geoserv.

[Andtony]

Tried this and that but still having the same problem.
Diablo, could you tell how you got this mod working?