Metatag Generator

כאשר מתקינים את הרכיב Metataggenerator ומופיעה שגיאת דטהבייס...
"DB function failed with error number 1054"

בעיה זו נובעת מהבדלי גרסאות MySql

סביר להניח שהתקנת את הרכיב על מאגר נתונים MySql 5

תיקון:
בקובץ
/administrator/components/com_metataggenerator/functions_metataggenerator.php

יש למצוא את הקוד ולשים קומנט // כפי שמוצג.

 $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, #__categories AS cc, #__sections AS s" UPDATED TO FIX METATAGENERATOR FOR MySQL version 5.0 and above
   . "  from #__content as c inner join #__categories as cc on cc.id = c.catid inner join #__sections as s on s.id = cc.section"
   . "\n LEFT OUTER JOIN #__groups AS g ON g.id = c.access"
   . "\n LEFT OUTER JOIN #__users AS u ON u.id = c.checked_out"
   . "\n LEFT OUTER JOIN #__users AS v ON v.id = c.created_by"
   . "\n LEFT OUTER JOIN #__content_frontpage AS f ON f.content_id = c.id"
   . ( count( $where ) ? "\nWHERE " . implode( ' AND ', $where ) : '' )
   . $order
   . "\n LIMIT $pageNav->limitstart, $pageNav->limit"
   ;