[support] Comment/Settings page error

[sander-martijn]

Well if that sql works and in turn the database is accurate but the 
array is empty (an assumption i'm making from the error) then it looks 
like the array is likely getting lost in the php somewhere.  It could 
take quite a bit of messing around to track down exactly where this is 
happening.

What I would suggest doing at this point before trying anything else if 
you haven't modified anything in core and have put all your modules in 
/sites/all/modules/ is to backup your entire site directory, download a 
fresh copy of drupal 5.3, replacing /sites and /files with your folders 
and uploading the whole thing.  Since the site setup, themes, modules 
and uploaded files should be in those two folders that should work fine 
and shouldn't take more than about a half hr to hr (depending on ftp 
speed).  If it still doesn't work then it's one of your modules or 
something in the database.

I know you said you disabled all add-on modules, but are there any you 
suspect?

Skip Taylor wrote:
> 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/ ]
>>
> 
> 
>