phpbb component admin edit users sql errors

Discuss the integratoin of phpbb and Joomla! here.

Moderator: General Support Moderators

Locked
toky
Joomla! Intern
Joomla! Intern
Posts: 88
Joined: Sat Sep 03, 2005 11:35 pm

phpbb component admin edit users sql errors

Post by toky » Tue Oct 25, 2005 9:05 am

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

ronpeled
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 156
Joined: Thu Oct 20, 2005 9:14 pm
Location: Los Angeles, CA
Contact:

Re: phpbb component admin edit users sql errors

Post by ronpeled » Mon Nov 14, 2005 12:35 am

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.

;)
www.Activo.com - Activo: Providing Magento development services for medium size Magento retailers.
extensions.Activo.com - Activo Extensions: Providing a growing collection of quality magento extensions.


Locked

Return to “phpbb - Joomla! Integration”