Permissions Problem

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
Falco1199
Registered User
Posts: 156
Joined: Fri May 17, 2002 9:11 pm
Location: New York
Contact:

Permissions Problem

Post by Falco1199 »

When I go to "Permissions" or "Pruning" in the admin CP it says:

"Couldn't obtain forum list"

What's wrong? :(
Last edited by Falco1199 on Fri May 24, 2002 12:09 am, edited 1 time in total.
:-D
Kage Musha
Registered User
Posts: 444
Joined: Sun Dec 23, 2001 10:03 pm
Location: Someone's Heart
Contact:

Post by Kage Musha »

https://www.rpggarden.com Development: Battle Mod
Released: PS2 Theme
Image Search b4 asking (less work for us :lol: )
Plz do not abuse my IM mediums or I'll have to block ya :evil:
Falco1199
Registered User
Posts: 156
Joined: Fri May 17, 2002 9:11 pm
Location: New York
Contact:

Post by Falco1199 »

No, but that link doesn't work for me. Maybe you could copy what I need to know into this post... :P
:-D
iced-pee
Registered User
Posts: 125
Joined: Sat Apr 27, 2002 9:08 pm

Post by iced-pee »

i assume you've just upgraded from 2.01. here is what is in the link:
If you're having problems with admin_forumauth.php failing to update permissions please open admin/admin_forumauth.php in a text editor, find line 112. Change this line from:

Code: Select all

$sql .= " WHERE forum_id = $forum_id"; 
to

Code: Select all

$sql = "UPDATE " . FORUMS_TABLE . " SET $sql WHERE forum_id = $forum_id"; 
and save the file.
Falco1199
Registered User
Posts: 156
Joined: Fri May 17, 2002 9:11 pm
Location: New York
Contact:

Post by Falco1199 »

Upgraded? I just installed it... I've never had phpBB before.
:-D
iced-pee
Registered User
Posts: 125
Joined: Sat Apr 27, 2002 9:08 pm

Post by iced-pee »

hmmm... you already created forums, right?
Falco1199
Registered User
Posts: 156
Joined: Fri May 17, 2002 9:11 pm
Location: New York
Contact:

Post by Falco1199 »

yeah.. I didn't upgrade though..
:-D
User avatar
psoTFX
Former Team Member
Posts: 7425
Joined: Tue Jul 03, 2001 8:50 pm

Post by psoTFX »

But you installed 2.0.1? If yes, follow the directions I've given (which are repeated above) for editing admin_forumauth.
Falco1199
Registered User
Posts: 156
Joined: Fri May 17, 2002 9:11 pm
Location: New York
Contact:

Post by Falco1199 »

I did... nothing happened. :(

8O I'm getting this message when I go to my main page:

"Could not query forums information"

:(
:-D
Falco1199
Registered User
Posts: 156
Joined: Fri May 17, 2002 9:11 pm
Location: New York
Contact:

Post by Falco1199 »

HELP!! No forums! I've even checked with my friends; they get the same message. What can I do??? :evil:
:-D
Lephnox
Registered User
Posts: 24
Joined: Sun May 19, 2002 8:34 pm

Re: Permissions Problem

Post by Lephnox »

Falco1199 wrote: When I go to "Permissions" or "Pruning" in the admin CP it says:

"Couldn't obtain forum list"

What's wrong? :(


I've got the same problem, I also edited the code like it's desribed here, but it still doesn't work...

I always get this message:

General Error
Couldn't obtain forum list

and

General Error
Could not obtain list of forums for pruning

I have the same problems for topics with polls:

General Error

Could not obtain vote data for this topic

Everything worked really fine the first 3 days untill yesterday... please help
BTW: I also just installed the newest version of phpbb i didn't upgrade.
User avatar
psoTFX
Former Team Member
Posts: 7425
Joined: Tue Jul 03, 2001 8:50 pm

Post by psoTFX »

In includes/constants.php change the line "define('DEBUG', 0);" to define('DEBUG', 1); and post here with the complete error message you get when trying to do the things you've been doing.
Lephnox
Registered User
Posts: 24
Joined: Sun May 19, 2002 8:34 pm

Post by Lephnox »

That's what i get, when I want to access FOrum Permissions:

Code: Select all

Couldn't obtain forum list

DEBUG MODE

SQL Error : 1030 Got error 28 from table handler

SELECT f.* FROM phpbb_forums f, phpbb_categories c WHERE c.cat_id = f.cat_id ORDER BY c.cat_order ASC, f.forum_order ASC

Line : 177
File : /data/members/free/tripod/de/e/i/g/ei*orius/htdocs/phpBB2/admin/admin_forumauth3.php


here for Forum Pruning:

Could not obtain list of forums for pruning

DEBUG MODE

SQL Error : 1030 Got error 28 from table handler

SELECT f.* FROM phpbb_forums f, phpbb_categories c WHERE c.cat_id = f.cat_id ORDER BY c.cat_order ASC, f.forum_order ASC

Line : 73
File : /data/members/free/tripod/de/e/i/g/ei*orius/htdocs/phpBB2/admin/admin_forum_prune.php


and finally, that's what I get when i want to access topics with Polls:

Could not obtain vote data for this topic

DEBUG MODE

SQL Error : 1030 Got error 28 from table handler

SELECT vd.vote_id, vd.vote_text, vd.vote_start, vd.vote_length, vr.vote_option_id, vr.vote_option_text, vr.vote_result FROM phpbb_vote_desc vd, phpbb_vote_results vr WHERE vd.topic_id = 20 AND vr.vote_id = vd.vote_id ORDER BY vr.vote_option_id ASC

Line : 657
File : /data/members/free/tripod/de/e/i/g/ei*orius/htdocs/phpBB2/viewtopic.php
Thx in advance!

[MOD Edit: Nested debug output in "code" tag... looks less of a mess and more readable. -SHS`]
Last edited by Lephnox on Fri Feb 28, 2003 2:51 pm, edited 1 time in total.
Lephnox
Registered User
Posts: 24
Joined: Sun May 19, 2002 8:34 pm

Post by Lephnox »

So, I also updated the Board to 2.0.1 now, but also this shows no effect... :cry:
Falco1199
Registered User
Posts: 156
Joined: Fri May 17, 2002 9:11 pm
Location: New York
Contact:

Post by Falco1199 »

I'll make the changes you said...

For me, the error only says: Couldn't obtain forum list

There isn't any non-understandable PHP stuff...
:-D
Locked

Return to “2.0.x Support Forum”