Ok, here goes, I'm working on a Drupal 6, multilingual site (French and English) and there are two (2) parent menu items have menu item children that point to a child menu item (a view, view_jobs).
Whenever I look a the view in Drupal, it is showing me the wrong translation for the 'parent' breadcrumb. (It always shows the french term.) I think I've tracked the problem down to a query against the menu_links table.
The following query is around line #898, menu.inc, 1.255.2.38. (this is the elaborated query)
SELECT * FROM drupal6.menu_links WHERE menu_name = 'primary-links' AND link_path IN ('view_jobs');
returns two(2) records
record #1:
'primary-links', '527', '487', 'view_jobs', 'view_jobs', 'Emplois disponibles', 'a:3:{s:10:"attributes";a:1:{s:5:"title";s:0:"";}s:8:"langcode";s:2:"fr";s:5:"alter";b:1;}', 'menu', '0', '0', '0', '0', '-49', '2', '1', '487', '527', '0', '0', '0', '0', '0', '0', '0', '0'
record #2:
'primary-links', '526', '486', 'view_jobs', 'view_jobs', 'Current Openings', 'a:3:{s:10:"attributes";a:1:{s:5:"title";s:36:"Current openings at ZZZ Consulting";}s:5:"alter";b:1;s:8:"langcode";s:2:"en";}', 'system', '0', '0', '0', '0', '-49', '2', '1', '486', '526', '0', '0', '0', '0', '0', '0', '0', '0'
...but is fetched into one result...
$parents = db_fetch_array(db_query("SELECT p1, p2, p3, p4, p5, p6, p7, p8 FROM....
SO, I'm not sure if the original query should try to use a where clause that contains a check against the language attribute OR if the query returns MORE than one record, only then, find the record with the attribute containing the correct language? (this would perform better on single language sites....)
Thoughts? Ideas? Tell me I'm in the wrong area?