[support] Comment/Settings page error

[Skip Taylor]

I got your code and it worked. The table seems readable but numbered a
bit odd to me. Instead of 1,2,3,4,5 (I have 5 roles) it's 1,2,3,11,12
as below. I don't recall ever having that many roles, but I guess I
must have at one time.

 1 - anonymous user
 2 - authenticated user
 3 - site admin
11 - moderated auth user
12 - NoAkismet

So I changed your SQL code to this:

SELECT DISTINCT(p.perm) FROM `role` r INNER JOIN `permission` p  ON
p.rid = r.rid WHERE r.rid IN (1,2,3,11,12)

When I ran your code, it gave me these permissions:

access comments, access content, use sitemenu
edit own blog, create book pages, edit own book pa...
administer account_reminder, administer akismet se...
access comments, access content
post with no akismet checking

That seems accurate from what I could tell in the long printout version.

During this I'm logged in as Site Admin (#3 role), not the #1 account.
I just tried it with the #1 account and it gives the same 4 errors as
before.

I've tried to view the error-logs, but I'm not privileged enough. I'm
on shared hosting at Site5 (new servers)

Not sure where to go with this.  Hope you do!

Regards,
Skip

On Nov 30, 2007 8:24 AM, sander-martijn <lists at severeddreams.com> wrote:
> of course there are the 2 default roles, I'm just wondering if the table
> got messed up.  There should also be at least one admin account with
> full rights, right?  I mean the issue here is that something is not
> working properly so I'm just giving some suggestions for trouble
> shooting.  You say that code shouldn't be reached unless the user isn't
> 1, but he's obviously reaching that code since that's where the error
> lies so he's either not logged in as the primary account (perhaps the
> account he's logging in as is set to a role that didn't get transferred
> with the upgrade or something?) or something else is amiss.
>
>
>
>
>
> >
> > There are two default roles, anonymous and authenticated.
> >
> > Earnie -- http://for-my-kids.com/
> > -- http://give-me-an-offer.com/
> >
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>



-- 
Half of being smart is knowing what you're dumb at. -- David Gerrold
---
NOTICE: This email message is for the sole use of the intended
recipient(s) and may contain confidential and privileged information.
Any unauthorized review, use, disclosure or distribution is
prohibited. If you are not the intended recipient, please contact the
sender by reply email and destroy all copies of the original message.