Mambo problem. Gallery and itemid

G'day

Got an odd one here and was hoping someone could help me out.

As part of the development of our school's Intranet, I've installed the Menalto Gallery. But I'm finding that the itemid parameter doesn't seem to be getting passed to the gallery correctly.

I got Gallery and the Mambo component hook installed OK.

However, the main menu item url for the gallery is:
jimmies.local.stjamescollege.qld.edu.au/index.php?option=com_gallery&Itemid=81

whereas the url for the individual albums within the gallery show up as (eg)
jimmies.local.stjamescollege.qld.edu.au/index.php?set_albumName=album01&option=com_gallery&Itemid=55&include=view_album.php

Unfortunately itemid=55 defines the menu item used to select one of our schools department pages. This page has a number of specialised modules and menus set to display only on this page - ie pages with itemid=55).

Anyone have any idea why the itemid value would be changing like this? How to fix it?

mambo v4.5.1a
gallery v1.4.4-pl4

I've found where the problem originates. I'm just not sure what to do to fix it.

In the file gallery/init.php there is the code:

			/* For proper Mambo breadcrumb functionality, we need
			 * to know the Item ID of the Gallery component's menu
			 * item. +2 DB calls. <sigh> */
			$db = $gallery->database{'mambo'};
			$results = $db->query('SELECT id FROM ' . $gallery->database{'user_prefix'} . "components WHERE link='option=$GALLERY_MODULENAME'");
			$row = $db->fetch_row($results);
			$componentId = $row[0];
			$results = $db->query('SELECT id FROM ' . $gallery->database{'user_prefix'} . "menu WHERE componentid='$componentId'");
			$row = $db->fetch_row($results);
			$MOS_GALLERY_PARAMS['itemid'] = $row[0]; // pick the first one

Now following through the logic, it looks up the table mos_components for a record where the field 'link' contains 'option=com_gallery' and takes the 1st field value (id) - in my case, '85'

Next it looks through the table mos_menu for a record where the field componentid is equal to the value previously retrieved - and selects the 1st instance it finds and retrieves the itemid value.

Now in my case, there are two entries in mos_menu where componentid=85 - one that defines the gallery page and one that defines the other department I mentioned. Obviously in my case, the 'wrong' one was 1st in the table and was subsequently listed.

Now I need to work out where the error lies. With mambo for duplicating the componentid value or with gallery for not selecting the 1st value (id=85) which would have been the correct value in my case.

Further research pending...

It's not conflicting with a deleted item unfortunately. It's conflicting with a valid, existing menu item.

Well, not quite (if I read the logic correctly).
It says, find the id of the com_gallery component (in mos_components), THEN find the menuitem (in mos_menu) that refers to that id value and get the itemid value.

In my case, the id value assigned to com_gallery (85) shows up in two seperate menu items. One for com_gallery, the other for com_contact. I'm trying to track down a database schema to determine if the 'fault' lies with gallery's logic, or the implementation of com_contact.

Check the following SQL dumps.

CREATE TABLE `mos_components` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `link` varchar(255) NOT NULL default '',
  `menuid` int(11) unsigned NOT NULL default '0',
  `parent` int(11) unsigned NOT NULL default '0',
  `admin_menu_link` varchar(255) NOT NULL default '',
  `admin_menu_alt` varchar(255) NOT NULL default '',
  `option` varchar(50) NOT NULL default '',
  `ordering` int(11) NOT NULL default '0',
  `admin_menu_img` varchar(255) NOT NULL default '',
  `iscore` tinyint(4) NOT NULL default '0',
  `params` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=86 ;

INSERT INTO `mos_components` VALUES (85, 'Gallery', 'option=com_gallery', 0, 0, 'option=com_gallery', 'Gallery', 'com_gallery', 0, 'js/ThemeOffice/component.png', 0, '');




CREATE TABLE `mos_menu` (
  `id` int(11) NOT NULL auto_increment,
  `menutype` varchar(25) default NULL,
  `name` varchar(100) default NULL,
  `link` text,
  `type` varchar(50) NOT NULL default '',
  `published` tinyint(1) NOT NULL default '0',
  `parent` int(11) unsigned NOT NULL default '0',
  `componentid` int(11) unsigned NOT NULL default '0',
  `sublevel` int(11) default '0',
  `ordering` int(11) default '0',
  `checked_out` int(11) unsigned NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `pollid` int(11) NOT NULL default '0',
  `browserNav` tinyint(4) default '0',
  `access` tinyint(3) unsigned NOT NULL default '0',
  `utaccess` tinyint(3) unsigned NOT NULL default '0',
  `params` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `componentid` (`componentid`,`menutype`,`published`,`access`),
  KEY `menutype` (`menutype`)
) TYPE=MyISAM AUTO_INCREMENT=86 ;

-- 
-- Dumping data for table `mos_menu`
-- 

INSERT INTO `mos_menu` VALUES (59, 'dept_demo', 'Staff list', 'index.php?option=com_contact&catid=85', 'contact_category_table', 1, 0, 85, 0, 4, 62, '2004-11-22 11:51:13', 0, 0, 0, 0, 'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nother_cat=1\ncat_description=1\ncat_items=1\nheadings=1\nposition=1\nemail=1\ntelephone=1\nfax=1');
INSERT INTO `mos_menu` VALUES (85, 'mainmenu', 'Photos', 'index.php?option=com_gallery', 'components', 1, 0, 85, 0, 22, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, '');