<div class="gmail_quote">On Nov 30, 2007 12:14 PM, sander-martijn <<a href="mailto:lists@severeddreams.com">lists@severeddreams.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Well if that sql works and in turn the database is accurate but the<br>array is empty (an assumption i'm making from the error) then it looks
<br>like the array is likely getting lost in the php somewhere. It could<br>take quite a bit of messing around to track down exactly where this is<br>happening.<br><br>What I would suggest doing at this point before trying anything else if
<br>you haven't modified anything in core and have put all your modules in<br>/sites/all/modules/ is to backup your entire site directory, download a<br>fresh copy of drupal 5.3, replacing /sites and /files with your folders
<br>and uploading the whole thing. Since the site setup, themes, modules<br>and uploaded files should be in those two folders that should work fine<br>and shouldn't take more than about a half hr to hr (depending on ftp
<br>speed). If it still doesn't work then it's one of your modules or<br>something in the database.<br></blockquote>
<div> </div>
<div>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.
</div>
<div> </div>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><span id=""></span><br>I know you said you disabled all add-on modules, but are there any you<br>suspect?<br>
<div>
<div></div>
<div class="Wj3C7c"></div></div></blockquote>
<div> </div>
<div> </div>
<div>The only 3rd party modules that I use that I know directly messes with comments are comment-mover and Akismet.</div>
<div> </div>
<div>Thanks for your time with this, I appreciate it!</div>
<div>Skip</div>
<div> </div>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div class="Wj3C7c"><span id=""></span><br>Skip Taylor wrote:<br>> I got your code and it worked. The table seems readable but numbered a<br>> bit odd to me. Instead of 1,2,3,4,5 (I have 5 roles) it's 1,2,3,11,12
<br>> as below. I don't recall ever having that many roles, but I guess I<br>> must have at one time.<br>><br>> 1 - anonymous user<br>> 2 - authenticated user<br>> 3 - site admin<br>> 11 - moderated auth user
<br>> 12 - NoAkismet<br>><br>> So I changed your SQL code to this:<br>><br>> SELECT DISTINCT(p.perm) FROM `role` r INNER JOIN `permission` p ON<br>> p.rid = r.rid WHERE r.rid IN (1,2,3,11,12)<br>><br>
> When I ran your code, it gave me these permissions:<br>><br>> access comments, access content, use sitemenu<br>> edit own blog, create book pages, edit own book pa...<br>> administer account_reminder, administer akismet se...
<br>> access comments, access content<br>> post with no akismet checking<br>><br>> That seems accurate from what I could tell in the long printout version.<br>><br>> During this I'm logged in as Site Admin (#3 role), not the #1 account.
<br>> I just tried it with the #1 account and it gives the same 4 errors as<br>> before.<br>><br>> I've tried to view the error-logs, but I'm not privileged enough. I'm<br>> on shared hosting at Site5 (new servers)
<br>><br>> Not sure where to go with this. Hope you do!<br>><br>> Regards,<br>> Skip<br>><br>> On Nov 30, 2007 8:24 AM, sander-martijn <<a href="mailto:lists@severeddreams.com">lists@severeddreams.com
</a>> wrote:<br>>> of course there are the 2 default roles, I'm just wondering if the table<br>>> got messed up. There should also be at least one admin account with<br>>> full rights, right? I mean the issue here is that something is not
<br>>> working properly so I'm just giving some suggestions for trouble<br>>> shooting. You say that code shouldn't be reached unless the user isn't<br>>> 1, but he's obviously reaching that code since that's where the error
<br>>> lies so he's either not logged in as the primary account (perhaps the<br>>> account he's logging in as is set to a role that didn't get transferred<br>>> with the upgrade or something?) or something else is amiss.
<br>>><br>>><br>>><br>>><br>>><br>>>> There are two default roles, anonymous and authenticated.<br>>>><br>>>> Earnie -- <a href="http://for-my-kids.com/" target="_blank">
http://for-my-kids.com/</a><br>>>> -- <a href="http://give-me-an-offer.com/" target="_blank">http://give-me-an-offer.com/</a><br>>>><br>>> --<br>>> [ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">
http://lists.drupal.org/</a> ]<br>>><br>><br>><br>><br>--<br>[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></div></div></blockquote></div><br><br clear="all">
<br>-- <br>Half of being smart is knowing what you're dumb at. -- David Gerrold<br>---<br>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.