Charly1405241472 0 Report post Posted February 7, 2005 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
Admiral Lyoko Samus 0 Report post Posted February 7, 2005 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
miCRoSCoPiC^eaRthLinG 0 Report post Posted February 8, 2005 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
Admiral Lyoko Samus 0 Report post Posted February 9, 2005 This is true, but for some reason, versions of phpBB Fully Modded want you to fix the file too. 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. Share this post Link to post Share on other sites
Charly1405241472 0 Report post Posted March 6, 2005 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 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)*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
vhortex 1 Report post Posted April 23, 2005 This is true, but for some reason, versions of phpBB Fully Modded want you to fix the file too. 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. <{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
Disturbed1405241495 0 Report post Posted May 18, 2005 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. Share this post Link to post Share on other sites
vhortex 1 Report post Posted May 19, 2005 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