|
כאשר מתקינים את הרכיב 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" ;
|