phpBB.nl

Code: Selecteer alles

Couldn't delete auth access info

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'AND auth_mod = 0' at line 3

DELETE FROM phpbb_auth_access WHERE group_id = AND auth_mod = 0

Line : 180
File : /home/virtual/site16/fst/var/www/html/admin/admin_ug_auth.php

Code: Selecteer alles

	if ( !($result = $db->sql_query($sql)) )
			{
				message_die(GENERAL_ERROR, 'Could not update user level', '', __LINE__, __FILE__, $sql);
			}

			$sql = "DELETE FROM " . AUTH_ACCESS_TABLE . "
				WHERE group_id = $group_id 
					AND auth_mod = 0";
			if ( !($result = $db->sql_query($sql)) )
			{
				message_die(GENERAL_ERROR, "Couldn't delete auth access info", "", __LINE__, __FILE__, $sql);
			}

			//
			// Delete any entries in auth_access, they are not required if user is becoming an
			// admin
			//
			$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)) )

Code: Selecteer alles

Couldn't delete auth access info

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'AND auth_mod = 0' at line 3

DELETE FROM phpbb_auth_access WHERE group_id = [b]dit is leeg[/b] AND auth_mod = 0

Line : 180
File : /home/virtual/site16/fst/var/www/html/admin/admin_ug_auth.php
[code]

Zoals je ziet staat er niets bij group_id in je query, ik denk dat dat het probleem is.
Dus op naar regel 180 in admin/admin_ug_auth.php, daar moet iets staat als dit (even uit mijn eigen bestand gehaald):

[code]$sql = "DELETE FROM " . AUTH_ACCESS_TABLE . "
WHERE [b]group_id = $group_id [/b]
AND auth_mod = 0";