Back to top

Autore Topic: Bug in com_users  (Letto 948 volte)

Offline Astrolinux

  • Nuovo arrivato
  • *
  • Post: 14
  • Sesso: Maschio
    • Mostra profilo
Bug in com_users
« il: 25 Ago 2008, 10:20:03 »
Salve.
In seguito all'aggiornamento alla versione 1.5.6 (prima non so se vi fosse tale errore) viene riportato nel backend alla pagina /administrator/index.php?option=com_users l'errore DB function failed with error number 1054
Unknown column 'aro.aro_id' in 'on clause' SQL=SELECT a.*, g.name AS groupname FROM jos_users AS a INNER JOIN jos_core_acl_aro AS aro ON aro.value = a.id INNER JOIN jos_core_acl_groups_aro_map AS gm ON gm.aro_id = aro.aro_id INNER JOIN jos_core_acl_aro_groups AS g ON g.group_id = gm.group_id GROUP BY a.id LIMIT 0, 100

Ho risolto tale problematica variando il file /administrator/com_users/admin.users.php alla riga 163 così come segue:

   $query = "SELECT a.*, g.name AS groupname"
   . "\n FROM #__users AS a"
   . "\n INNER JOIN #__core_acl_aro AS aro ON aro.value = a.id"   // map user to aro
   . "\n INNER JOIN #__core_acl_groups_aro_map AS gm ON gm.aro_id = aro.id"   // map aro to group
   . "\n INNER JOIN #__core_acl_aro_groups AS g ON g.id = gm.group_id";


 



Web Design Bolzano Kreatif