eroare cand fac un user admin

[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.

[dorin]

Ce versiune de forum si SQL ?

[bLuEsHiFt]

phpBB 2.0.15 si MySQL 4.0.22

[dorin]

Verifica :

Cod: Selectaţi tot

Line : 200 
File : admin_ug_auth.php

E posibil sa ai o eroare acolo.

[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.

[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.