Pagina 1 din 1
eroare cand fac un user admin
Scris: 24-Mai-2005, 23:38:23
de bLuEsHiFt
Cod: Selectaţi tot
Couldn't update auth access
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'group_id = 80' at line 3
UPDATE phpbb_auth_access SET auth_view = 0, auth_read = 0, auth_post = 0, auth_reply = 0, auth_edit = 0, auth_delete = 0, auth_sticky = 0, auth_announce = 0 , auth_ban = 0, auth_greencard = 0, auth_bluecard = 0WHERE group_id = 80
Line : 200
File : admin_ug_auth.php
Asta imi arata cand fac un utilizator, admin. Sugerez ca am instalat mod-ul Yellow Card, cu ajutorul EasyMOD si am updatat baza de date cu fisierul yellow card de updatat database-ul.
Scris: 26-Mai-2005, 15:13:56
de dorin
Ce versiune de forum si SQL ?
Scris: 26-Mai-2005, 17:25:14
de bLuEsHiFt
phpBB 2.0.15 si MySQL 4.0.22
Scris: 26-Mai-2005, 18:00:33
de dorin
Verifica :
E posibil sa ai o eroare acolo.
Scris: 30-Iun-2005, 10:04:54
de bLuEsHiFt
Cod: Selectaţi tot
Could not update auth access
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'group_id = 23' at line 3
UPDATE phpbb_auth_access SET auth_view = 0, auth_read = 0, auth_post = 0, auth_reply = 0, auth_edit = 0, auth_delete = 0, auth_sticky = 0, auth_announce = 0 , auth_globalannounce = 0WHERE group_id = 23
Line : 232
File : admin_ug_auth.php
Ma ajuta si pe cineva?
Nu pot sa mai scot permisiuni de admin de la useri.
Scris: 30-Iun-2005, 11:20:38
de dorin
Deschide fisierul admin_ug_auth.php.
Cauta:
Cod: Selectaţi tot
//
// Make admin a user (if already admin) ... ignore if you're trying
// to change yourself from an admin to user!
//
Verifica codul care urmeaza si care trebuie sa fie astfel:
Cod: Selectaţi tot
{
$sql = "UPDATE " . AUTH_ACCESS_TABLE . "
SET auth_view = 0, auth_read = 0, auth_post = 0, auth_reply = 0, auth_edit = 0, auth_delete = 0, auth_sticky = 0, auth_announce = 0
WHERE group_id = $group_id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not update auth access', '', __LINE__, __FILE__, $sql);
}
Atentie, cred ca iti lipseste conditia WHERE.
Revino cu detalii.