On Nov 30, 2007 12:14 PM, sander-martijn <lists@severeddreams.com> wrote:

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'll give that a try and see what happens. As to messing around with the code, I'm not a PHP or MySQL programmer so I doubt it would do much good. It's more a minor inconvenience as I rarely use the setting. I was going to submit this as an issue but can't figure out what category to put it in.

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

The only 3rd party modules that I use that I know directly messes with comments are comment-mover and Akismet.

Thanks for your time with this, I appreciate it!

Skip

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@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/ ]
>>
>
>
>
--
[ Drupal support list | http://lists.drupal.org/ ]