Only categories which are in the events_categories table are displayed. Check your event categories.

You are indeed correct, but here's the interesting part of the problem...below are the categories showing up on the Legend Display - this is an export from the Categories Table. I actually only have 5 event categories (#s 14-18).

The Events Table lists IDs 13,14,15,16,17,18, 25, 26, 30, and 31. Event Table ID 13 is the Category ID from Google Maps module. Even Table IDs 25, 26, 30, 31 are Category IDs from the News module.

id parent_id title name section published
25 0 Candidate News Candidate News 1 1
26 0 Local Party News Local Party News 1 1
30 0 County News CIty Council 1 1
31 0 Volunteer News Volunteer News 1 1
13 0 default default com_google_maps 1
14 0 MCDP Event MCDP Event com_events 1
15 0 Candidate Event Candidate Event com_events 1
16 0 Social Event Social Event com_events 1
17 0 Community Event Community Event com_events 1
18 0 Auxilliary Org Auxilliary Org com_events 1

I suppose I could delete these erroneous entries from the Event Categories table ( <!-- s:?: --><img src="{SMILIES_PATH}/icon_question.gif" alt=":?:" title="Question" /><!-- s:?: --> ), but one wonders how/why they got there to start with?

Check the main category table #__categories. All entries where the column "section" contains "com_events" are categories form JEvents.
Only those should have corresponding entries in #__events_categories.
Before you delete entries in #__events_categories please change the code in mod_events_legend.php and test again.
Change

	$sql = "SELECT cat.id, cat.name, cat.description, cat.access, evcat.color"

	. "\n FROM #__events_categories as evcat, #__categories as cat"

	. "\n WHERE  evcat.id=cat.id"

	. "\n AND cat.access <= $my->gid"

	. "\n AND cat.published = 1";

to

	$sql = "SELECT cat.id, cat.name, cat.description, cat.access, evcat.color"

	. "\n FROM #__events_categories as evcat, #__categories as cat"

	. "\n WHERE  evcat.id=cat.id"

	. "\n AND cat.access <= $my->gid"

	. "\n AND cat.section = 'com_events'"

	. "\n AND cat.published = 1";

which is more precisely to access JEvents categories.

Thanks so much, Thomas. I'll test it and advise later this week.

Regards,

Debbie