Permissions Problem

[Falco1199]

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

"Couldn't obtain forum list"

What's wrong?

[Kage Musha]

Did you read: http://www.phpbb.com/phpBB/viewtopic.php?t=19579 ?

[Falco1199]

No, but that link doesn't work for me. Maybe you could copy what I need to know into this post...

[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]

Upgraded? I just installed it... I've never had phpBB before.

[iced-pee]

hmmm... you already created forums, right?

[Falco1199]

yeah.. I didn't upgrade though..

[psoTFX]

But you installed 2.0.1? If yes, follow the directions I've given (which are repeated above) for editing admin_forumauth.

[Falco1199]

I did... nothing happened.

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

"Could not query forums information"

[Falco1199]

HELP!! No forums! I've even checked with my friends; they get the same message. What can I do???

[Lephnox]

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.

[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]

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`]

[Lephnox]

So, I also updated the Board to 2.0.1 now, but also this shows no effect...

[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...