[Answd] I'm screwed!

Slim~keith · Post by **Slim~keith** » Thu Nov 21, 2002 6:01 pm

i have installed most all of the MODs on my 2.0.3 version board. everything seem to run smooth but. i have added some "moderators"in the past but i was trying to add one more and i got an error!First thing i did was go search. i found a few thingts that may help but NO real answer.
--------------------------------------------------------
Couldn't update private forum permissions

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ' 1)' at line 2

INSERT INTO phpbb_auth_access (forum_id, group_id, auth_mod) VALUES (1, , 1)

Line : 385
File : d:\www\stranke\***********.com\forum\admin\admin_ug_auth.php
--------------------------------------------------------------------

Can someone help me with this?

Slim~keith · Post by **Slim~keith** » Fri Nov 22, 2002 3:26 am

humm...

primedomain · Post by **primedomain** » Fri Nov 22, 2002 9:20 am

Have you modified admin_ug_auth.php in any way?

Slim~keith · Post by **Slim~keith** » Sat Nov 23, 2002 5:56 pm

I didn't think so. but the first thing i did was replace that file with the original file! please tell me that the error is not telling me the table's are not screwed up.

primedomain · Post by **primedomain** » Sat Nov 23, 2002 6:01 pm

so the error persists even after you have deleted this file and re-uploaded it in ASCII?

Slim~keith · Post by **Slim~keith** » Sat Nov 23, 2002 6:15 pm

Well all i did was overwrite the file. i had it on auto but i will try your way!

Slim~keith · Post by **Slim~keith** » Sun Nov 24, 2002 3:35 am

OK, i just did that and No luck

. Do you have more ideas?

issue9mm · Post by **issue9mm** » Sun Nov 24, 2002 4:11 am

Well, by reading the error message, it indicates that there is no value for the "group_id". For whatever reason, it's not populating the query with that value , as evidenced by the (1, , 1) portion of the INSERT statement. That's causing a syntax error, and mySQL isn't able to do an insert.

Post a copy of your admin_ug_auth.php file and that should give us more insight as to why that field isn't being populated.

-9mm-

Slim~keith · Post by **Slim~keith** » Mon Nov 25, 2002 3:43 am

I'm hopeing this is what you want!

Slim~keith · Post by **Slim~keith** » Mon Nov 25, 2002 5:29 pm

bump

Slim~keith · Post by **Slim~keith** » Tue Nov 26, 2002 4:41 pm

i will not give up! i need an Answer.....

R. U. Serious · Post by **R. U. Serious** » Tue Nov 26, 2002 5:33 pm

Save the following script as .php in your phpbb folder and run it from your browser:
http://www.phpbb.com/phpBB/viewtopic.ph ... highlight=

Slim~keith · Post by **Slim~keith** » Wed Nov 27, 2002 6:37 am

R. U. Serious, you are the man! "THANK YOU" so much that worked the first time!

gussie · Post by **gussie** » Tue Dec 03, 2002 4:24 am

Thank you from me, too! 8)

I was stumped by the Delete (personal) Group problem I encountered after I installed Niels' Delete Inactive Users mod (http://mods.db9.dk/viewtopic.php?t=460)

I'm unsure this is related to his mod per se. He requested that we try deleting someone using the regular ACP Members Management form. I got the same problem -- suggesting it is a problem with the underlying database.

Tommy's (dkklein) solution assigns Personal Group IDs to inactive accounts -- then allowing Niels mod to do its thing.

Whew! Blew 2 hours trying to figure this out

danb00 · Post by **danb00** » Sun Feb 09, 2003 1:59 pm

You saved my life!!

Is this a know bug then?

Cos that script worked.

works on phpbb 2.0.4

advertisements