** Error en Administrador de contenidos Mambo con MySQL 5.x

** ERROR:
 DB function failed with error number 1054
Unknown column 'c.access' in 'on clause' SQL=SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author FROM mos_content AS c, mos_categories AS cc, mos_sections AS s LEFT JOIN mos_groups AS g ON g.id = c.access LEFT JOIN mos_users AS u ON u.id = c.checked_out LEFT JOIN mos_users AS v ON v.id = c.created_by LEFT JOIN mos_content_frontpage AS f ON f.content_id = c.id WHERE c.state >= 0 AND c.catid=cc.id AND cc.section=s.id AND s.scope='content' ORDER BY s.title, c.catid, cc.ordering, cc.title, c.ordering LIMIT 0,10

** CAUSA:
El error se debe el tipo de consulta sobre la nueva version de base de datos MySQL 5.x la cual es mas restrictiva para las uniones, porque en la version MySQL 4.x funciona OK.:


** SOLUCION:
Se debe corregir la consulta, una forma en la que funciona es: agregando dos uniones con LEF JOIN y eliminando los argumentos (c.catid=cc.id , cc.section=s.id) del condicional WHERE:

SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author
 FROM mos_content AS c LEFT JOIN mos_categories AS cc ON c.catid=cc.id 
 LEFT JOIN mos_sections AS s ON cc.section=s.id
 LEFT JOIN mos_groups AS g ON g.id = c.access
 LEFT JOIN mos_users AS u ON u.id = c.checked_out
 LEFT JOIN mos_users AS v ON v.id = c.created_by
 LEFT JOIN mos_content_frontpage AS f ON f.content_id = c.id
 WHERE c.state >= 0 AND s.scope='content' ORDER BY s.title, c.catid, cc.ordering, cc.title, c.ordering LIMIT 0,10

** CORREGIR EL PROBLEMA EN DIRECTORIO: /administrator/components/com_content
ARCHIVO:   admin.content.php

** CORRECCION PARA admin.content.php:
LINEA 149,150  COMENTARIAR
LINEA 164,165  COMENTARIAR
	if ( $sectionid == 0 ) {
		// used to show All content items
		$where = array(
		"c.state >= 0",
149://		"c.catid=cc.id",
150://		"cc.section=s.id",
		"s.scope='content'",
		);
		$order = "\n ORDER BY s.title, c.catid, cc.ordering, cc.title, c.ordering";
		$all = 1;
		//$filter = "\n , #__sections AS s WHERE s.id = c.section";
		if ($filter_sectionid > 0) {
		    $filter = "\nWHERE cc.section=$filter_sectionid";
		}
		$section->title = 'All Content Items';
		$section->id = 0;
	} else {
		$where = array(
		"c.state >= 0",
165://		"c.catid=cc.id",
166://		"cc.section=s.id",
		"s.scope='content'",
		"c.sectionid='$sectionid'"
		);
		$order = "\n ORDER BY cc.ordering, cc.title, c.ordering";
		$all = NULL;
		$filter = "\n WHERE cc.section = '$sectionid'";
		$section = new mosSection( $database );
		$section->load( $sectionid );
	}

LINEA 200  (reemplazar la consulta por:)
	$query = "SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author"
	. "\n FROM #__content AS c LEFT JOIN #__categories AS cc ON c.catid=cc.id"
	. "\n LEFT JOIN #__sections AS s ON cc.section=s.id"
	. "\n LEFT JOIN #__groups AS g ON g.id = c.access"
	. "\n LEFT JOIN #__users AS u ON u.id = c.checked_out"
	. "\n LEFT JOIN #__users AS v ON v.id = c.created_by"
	. "\n LEFT JOIN #__content_frontpage AS f ON f.content_id = c.id"
	. ( count( $where ) ? "\nWHERE " . implode( ' AND ', $where ) : '' )
	. $order
	. "\n LIMIT $pageNav->limitstart,$pageNav->limit"
	;

COMENTARIAR:
LINEAS : 268,269
LINEAS : 277,278

	if ( $sectionid == 0 ) {
		$where = array(
		"c.state = -1",
268://		"c.catid=cc.id",
269://		"cc.section=s.id",
		"s.scope='content'"
		);
		$filter = "\n , #__sections AS s WHERE s.id = c.section";
		$all = 1;
	} else {
		$where = array(
		"c.state = -1",
277://		"c.catid=cc.id",
278://		"cc.section=s.id",
		"s.scope='content'",
		"c.sectionid='$sectionid'"
		);
		$filter = "\n WHERE section = '$sectionid'";
		$all = NULL;
	}


LINEA 311   (reemplazar la consulta por:)
	$query = "SELECT c.*, g.name AS groupname, cc.name, v.name AS author"
	. "\n FROM #__content AS c LEFT JOIN #__categories AS cc ON c.catid=cc.id"
	. "\n LEFT JOIN #__sections AS s ON cc.section=s.id"
	. "\n LEFT JOIN #__groups AS g ON g.id = c.access"
	. "\n LEFT JOIN #__users AS v ON v.id = c.created_by"
	. ( count( $where ) ? "\nWHERE " . implode( ' AND ', $where ) : '' )
	. "\n ORDER BY c.catid, c.ordering"
	. "\n LIMIT $pageNav->limitstart,$pageNav->limit"
	;