Page 1 of 1

phpbb component admin edit users sql errors

Posted: Tue Oct 25, 2005 9:05 am
by toky
Need some help with using phpbb admin. Getting SQL errors when editing user permissions.

Joomla 1.03
phpbb_com 1.2.4RC3
up2date yummy server.

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 : 196
File : admin_ug_auth.php

and

Couldn't update private forum permissions
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax near ' 1, 1, 1, 1, 1, 1, 1, 1, 1, 0)' at line 2
INSERT INTO phpbb_auth_access (forum_id, group_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_vote, auth_pollcreate, auth_mod) VALUES (9, , 1, 1, 1, 1, 1, 1, 1, 1, 1, 0)
Line : 406
File : admin_ug_auth.php
Kiss

http://mgamers.org

Re: phpbb component admin edit users sql errors

Posted: Mon Nov 14, 2005 12:35 am
by ronpeled
The issue seems to be the missing or empty variable for 'group_id' in the code. I beleive I have seen this in a few more places in the phpBB admin panel.

Adam seems to be working on the next version of the phpBB component - it might be worth the wait.

;)