Jump to content
xisto Community
Charly1405241472

Problem With Permission

Recommended Posts

When I try to give one of my user a permission to access a secret forum, I get following error:

Couldn't update private forum permissionsDEBUG MODESQL Error : 1064 You have an error in your SQL syntax near ' 1, 1, 1, 1, 1, 1, 1, 1, 1, 0)' at line 2INSERT 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 (13, , 1, 1, 1, 1, 1, 1, 1, 1, 1, 0)Line : 390File : /.../admin/admin_ug_auth.php

I have worked it out by creating a group which is given access to that forum, but I would still like to know a solution for this problem.

Share this post


Link to post
Share on other sites

When I try to give one of my user a permission to access a secret forum, I get following error:

 

Couldn't update private forum permissionsDEBUG MODESQL Error : 1064 You have an error in your SQL syntax near ' 1, 1, 1, 1, 1, 1, 1, 1, 1, 0)' at line 2INSERT 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 (13, , 1, 1, 1, 1, 1, 1, 1, 1, 1, 0)Line : 390File : /.../admin/admin_ug_auth.php

I have worked it out by creating a group which is given access to that forum, but I would still like to know a solution for this problem.

<{POST_SNAPBACK}>

Ok, you are obviously using a version of phpBB. I'm pretty sure I can see what the problem is, but I'd still like to know what version you are using. Just to be safe. ;)

Share this post


Link to post
Share on other sites

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 (13, , 1, 1, 1, 1, 1, 1, 1, 1, 1, 0)

 

<{POST_SNAPBACK}>


If you look carefully at the syntax, you'll notice that the value that was to be inserted in place of group_id is missing...

see after VALUES (13, * , 1 .....).

 

MySQL syntax doesn't permit you to pass blank values (see *). Either the group_id has to be omitted and the syntax changed to phpbb_auth_access ( forum_id, auth_view,....) or else you have to pass some value ( at least a zero ) inside the VALUES () statement for group_id.. Your problem lies right there.. maybe you need to create a separate group number for your restricted forum users and somehow use that value over here..

Share this post


Link to post
Share on other sites

QUOTE(Charly @ Feb 7 2005, 08:42 PM)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 (13, , 1, 1, 1, 1, 1, 1, 1, 1, 1, 0)

*



If you look carefully at the syntax, you'll notice that the value that was to be inserted in place of group_id is missing...
see after VALUES (13, * , 1 .....).

MySQL syntax doesn't permit you to pass blank values (see *). Either the group_id has to be omitted and the syntax changed to phpbb_auth_access ( forum_id, auth_view,....) or else you have to pass some value ( at least a zero ) inside the VALUES () statement for group_id.. Your problem lies right there.. maybe you need to create a separate group number for your restricted forum users and somehow use that value over here..


thanks for the help!

Share this post


Link to post
Share on other sites

This is true, but for some reason, versions of phpBB Fully Modded want you to fix the file too.  :P I'm not sure why, but all I can say is that they might want to rethink their releases.  The one I got was majorly bugged.  I had to fix a lot of SQL syntax errors like that. :P

<{POST_SNAPBACK}>


Well I think, fully modded means that the original code that was tested lotsa times was now "hacked" or changed by the modder. And it also suggest base on the name that that version have undergone tons of modification from the stable phpBB release.

 

It is a common problem regarding modders lack of standardization on the mod solutions.

 

It also a common knowledge that not all mods fit together flawlessly.

Share this post


Link to post
Share on other sites

The reason why it says that is because you eather have a file missing to phpbb or one or more of your files has a bug.  Just reinstall the forums with new files and it should work.

<{POST_SNAPBACK}>


Im sorry bout that pal but i do believe you read the previous lines wrong, the problem is in the SQL itself..

 

if the error is a missing file then there will be an error output of I/O related and it will nagged you that somefile is missing or not linked..

 

surely that there is a bug and it is already commented at the post above.. reinstalling the forum board wont also work since as Admiral Lyoko Samus said, he also have a majorly bugged version..

 

so much for fully modded stuffs..

 

stable program + mod = unstable modded program

 

more mod = more errors

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.