Ibara updated 4 Februari 2020 kwa 4 h 31 me

 

Jinsi ya kurekebisha user usimamizi kituo piwigo .

Piwigo walikutana na baadhi ya matatizo siku za hivi karibuni na si kwa kuongeza au kubadilisha user taarifa ya akaunti.
ujumbe popup inaonekana wakati wa ufunguzi wa watumiaji ukurasa usimamizi wa akaunti.
Tatizo ni kwamba Mysql 8 inatumia meza aitwaye GROUPS.
Moja ya nambari hizi kwenye ufungaji aliteuliwa kwa njia na unaleta migogoro hiyo.
Hapa ni ufumbuzi.

Katika usakinishaji wako Piwigo:

/admin/user_list_backend.php

hariri mistari 204 (line 3 mfano wetu) na 213 (line 12 mfano wetu) chini


SELECT
    user_id,
    GROUP_CONCAT(name ORDER BY name SEPARATOR ", ") AS groups
  FROM '.USER_GROUP_TABLE.'
    JOIN `'.GROUPS_TABLE.'` ON id = group_id
  WHERE user_id IN ('.implode(',', $user_ids).')
  GROUP BY user_id
;';
  $result = pwg_query($query);
  while ($row = pwg_db_fetch_assoc($result))
  {
    $groups_of_user[ $row['user_id'] ] = $row['groups'];
  }

et remplacer GROUPS par GRPS

SELECT
    user_id,
    GROUP_CONCAT(name ORDER BY name SEPARATOR ", ") AS grps
  FROM '.USER_GROUP_TABLE.'
    JOIN `'.GROUPS_TABLE.'` ON id = group_id
  WHERE user_id IN ('.implode(',', $user_ids).')
  GROUP BY user_id
;';
  $result = pwg_query($query);
  while ($row = pwg_db_fetch_assoc($result))
  {
    $groups_of_user[ $row['user_id'] ] = $row['grps'];
  }

Enregistrez vos modifications.

Vider le cache de votre navigateur.

Rechargez la page Web de piwigo na Admin -> Utilisateurs -> Gérer


0
0.0 rating
0 nje ya 5 nyota (kulingana na 0 Maoni)
Mufti0%
Vizuri sana0%
Wastani0%
Maskini0%
kutisha0%
kufuta
Kiwango cha makala hii

kuondoka na Jibu

Anwani yako si kuchapishwa. Mashamba required ni alama *