[Answd] I'm screwed!

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Slim~keith
Registered User
Posts: 59
Joined: Tue Oct 15, 2002 3:10 pm
Contact:

[Answd] I'm screwed!

Post by Slim~keith »

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
Registered User
Posts: 59
Joined: Tue Oct 15, 2002 3:10 pm
Contact:

Post by Slim~keith »

humm... :roll:
User avatar
primedomain
Former Team Member
Posts: 25944
Joined: Sat Dec 15, 2001 10:23 am

Post by primedomain »

Have you modified admin_ug_auth.php in any way?
Slim~keith
Registered User
Posts: 59
Joined: Tue Oct 15, 2002 3:10 pm
Contact:

Post by Slim~keith »

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.
User avatar
primedomain
Former Team Member
Posts: 25944
Joined: Sat Dec 15, 2001 10:23 am

Post by primedomain »

so the error persists even after you have deleted this file and re-uploaded it in ASCII?
Slim~keith
Registered User
Posts: 59
Joined: Tue Oct 15, 2002 3:10 pm
Contact:

Post by Slim~keith »

Well all i did was overwrite the file. i had it on auto but i will try your way!
Slim~keith
Registered User
Posts: 59
Joined: Tue Oct 15, 2002 3:10 pm
Contact:

Post by Slim~keith »

OK, i just did that and No luck :roll:. Do you have more ideas?
issue9mm
Registered User
Posts: 22
Joined: Mon Dec 24, 2001 5:11 am

Post by issue9mm »

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
Registered User
Posts: 59
Joined: Tue Oct 15, 2002 3:10 pm
Contact:

Post by Slim~keith »

I'm hopeing this is what you want!
Last edited by Slim~keith on Wed Nov 27, 2002 6:36 am, edited 1 time in total.
Slim~keith
Registered User
Posts: 59
Joined: Tue Oct 15, 2002 3:10 pm
Contact:

Post by Slim~keith »

bump :?
Slim~keith
Registered User
Posts: 59
Joined: Tue Oct 15, 2002 3:10 pm
Contact:

Post by Slim~keith »

i will not give up! i need an Answer.....
R. U. Serious
Registered User
Posts: 830
Joined: Mon Feb 11, 2002 2:07 pm

Post by R. U. Serious »

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
Registered User
Posts: 59
Joined: Tue Oct 15, 2002 3:10 pm
Contact:

Post by Slim~keith »

R. U. Serious, you are the man! "THANK YOU" so much that worked the first time! :wink:
User avatar
gussie
Registered User
Posts: 92
Joined: Wed Nov 27, 2002 1:26 am

Many thanks from Taiwan, too

Post by gussie »

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 :oops:
danb00
Registered User
Posts: 1025
Joined: Sun Dec 15, 2002 9:41 pm
Location: Inside Mod:Extreme PHPBB
Contact:

Post by danb00 »

You saved my life!!

Is this a know bug then?

Cos that script worked.

works on phpbb 2.0.4
Locked

Return to “2.0.x Support Forum”