Navigation Block has vanished
Hello, For some reason, the navigation block has vanished from my website. But when you login (with any account) the block appears again. This just happened today, and I haven't touched Drupal in the last 3 days, so it is not obviously something I did. In addition, all other blocks look just fine. It is only the navigation block that is acting up. Is there a setting somewhere that might make a block appear only for authenticated users? I have Drupal 4.7 btw. Earlier today I also got a note from a user about what looks like a MySQL-related error. I don't know if this is at all related, but I include it below just in case. --------- * user warning: Got error 28 from storage engine query: SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN (1) in /home/theingot/public_html/community/includes/database.mysqli.inc on line 124. * user warning: Got error 28 from storage engine query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE (t.tid IN ('3','4','9','10','11','12','13')) AND r.nid = 1 ORDER BY v.weight, t.weight, t.name in /home/theingot/public_html/community/includes/database.mysqli.inc on line 124 --------- Line 124 is inside function _db_query() and the relevant lines are: if (!mysqli_errno($active_db)) { return $result; } else { trigger_error(check_plain(mysqli_error($active_db) ."\nquery: ". $query), E_USER_WARNING); return FALSE; } So I guess all we know is that there was some MySQL error. I don't see how this could be connected to the navigation block disappearing, but I thought I'd include it for completeness. I would be grateful for any assistance you may offer. Daniel.
I also can't see some pages unless I am logged in. For example, you can't see the blogs. It says "Access Denied" which is ridiculous. Here, see for yourself: http://theingots.org/community/blog Does anyone know why permissions would go berzerk like that? More importantly, where can I reset them so that regular visitors can see the bogs again? I've tested other pages and those can be accessed fine. It looks like it's only blogs that are somehow access-denied. And of course, the navigation bar doesn't appear. These look like a weird sort of permission problem. Because the site works fine when you login. Daniel. Daniel Carrera wrote:
Hello,
For some reason, the navigation block has vanished from my website. But when you login (with any account) the block appears again. This just happened today, and I haven't touched Drupal in the last 3 days, so it is not obviously something I did. In addition, all other blocks look just fine. It is only the navigation block that is acting up.
Is there a setting somewhere that might make a block appear only for authenticated users? I have Drupal 4.7 btw.
Earlier today I also got a note from a user about what looks like a MySQL-related error. I don't know if this is at all related, but I include it below just in case.
--------- * user warning: Got error 28 from storage engine query: SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN (1) in /home/theingot/public_html/community/includes/database.mysqli.inc on line 124. * user warning: Got error 28 from storage engine query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE (t.tid IN ('3','4','9','10','11','12','13')) AND r.nid = 1 ORDER BY v.weight, t.weight, t.name in /home/theingot/public_html/community/includes/database.mysqli.inc on line 124 ---------
Line 124 is inside function _db_query() and the relevant lines are:
if (!mysqli_errno($active_db)) { return $result; } else { trigger_error(check_plain(mysqli_error($active_db) ."\nquery: ". $query), E_USER_WARNING); return FALSE; }
So I guess all we know is that there was some MySQL error.
I don't see how this could be connected to the navigation block disappearing, but I thought I'd include it for completeness.
I would be grateful for any assistance you may offer.
Daniel.
Have you been using an access control module, and then turned it off? If so, sometimes the access table isn't updated correctly, it happened to me. Under the Admin > Content > Posts page (/admin/content/node-settings) there is a 'Rebuild Permissions' button. This will force a complete rebuild of the access tables. Greg -----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Daniel Carrera Sent: Saturday, June 28, 2008 10:22 AM To: support@drupal.org Subject: Re: [support] Navigation Block has vanished I also can't see some pages unless I am logged in. For example, you can't see the blogs. It says "Access Denied" which is ridiculous. Here, see for yourself: http://theingots.org/community/blog Does anyone know why permissions would go berzerk like that? More importantly, where can I reset them so that regular visitors can see the bogs again? I've tested other pages and those can be accessed fine. It looks like it's only blogs that are somehow access-denied. And of course, the navigation bar doesn't appear. These look like a weird sort of permission problem. Because the site works fine when you login. Daniel. Daniel Carrera wrote:
Hello,
For some reason, the navigation block has vanished from my website. But when you login (with any account) the block appears again. This just happened today, and I haven't touched Drupal in the last 3 days, so it is not obviously something I did. In addition, all other blocks look just fine. It is only the navigation block that is acting up.
Is there a setting somewhere that might make a block appear only for authenticated users? I have Drupal 4.7 btw.
Earlier today I also got a note from a user about what looks like a MySQL-related error. I don't know if this is at all related, but I include it below just in case.
--------- * user warning: Got error 28 from storage engine query: SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN (1) in /home/theingot/public_html/community/includes/database.mysqli.inc on line 124. * user warning: Got error 28 from storage engine query: SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE (t.tid IN ('3','4','9','10','11','12','13')) AND r.nid = 1 ORDER BY v.weight, t.weight, t.name in /home/theingot/public_html/community/includes/database.mysqli.inc on line 124 ---------
Line 124 is inside function _db_query() and the relevant lines are:
if (!mysqli_errno($active_db)) { return $result; } else { trigger_error(check_plain(mysqli_error($active_db) ."\nquery: ". $query), E_USER_WARNING); return FALSE; }
So I guess all we know is that there was some MySQL error.
I don't see how this could be connected to the navigation block disappearing, but I thought I'd include it for completeness.
I would be grateful for any assistance you may offer.
Daniel.
-- [ Drupal support list | http://lists.drupal.org/ ]
Greg Holsclaw wrote:
Have you been using an access control module, and then turned it off? If so, sometimes the access table isn't updated correctly, it happened to me.
I am indeed using the access control module, but I am not aware of doing anything that might have turned it off.
Under the Admin > Content > Posts page (/admin/content/node-settings) there is a 'Rebuild Permissions' button. This will force a complete rebuild of the access tables.
I go to Admin > Content and I see a list of posts. But I don't see any additional link that says Posts or a button that says "Rebuild Permissions". I go to the URL /admin/content/node-settings and I only get the admin front page (that shows a log of recent activity). I have Drupal 4.7. Is it possible that my version does not have this rebuild-permissions feature? Daniel.
More information: Actually, you can see the individual blog posts on their own, but you cannot see the "blog" URL that aggregates all the blogs. See here: http://theingots.org/community/node/5194 http://theingots.org/community/blog For some reason, an anonymous user cannot see the '/blog' URL but can see the actual blog post 'node/5194'. Any ideas? Daniel. Daniel Carrera wrote:
Greg Holsclaw wrote:
Have you been using an access control module, and then turned it off? If so, sometimes the access table isn't updated correctly, it happened to me.
I am indeed using the access control module, but I am not aware of doing anything that might have turned it off.
Under the Admin > Content > Posts page (/admin/content/node-settings) there is a 'Rebuild Permissions' button. This will force a complete rebuild of the access tables.
I go to Admin > Content and I see a list of posts. But I don't see any additional link that says Posts or a button that says "Rebuild Permissions".
I go to the URL /admin/content/node-settings and I only get the admin front page (that shows a log of recent activity).
I have Drupal 4.7. Is it possible that my version does not have this rebuild-permissions feature?
Daniel.
Sorry for all the posts. I'm just trying to figure out how to make my site work again. It looks like pages that list nodes are the ones giving "access denied" errors. For example: http://theingots.org/community/node http://theingots.org/community/blog http://theingots.org/community/blog/4 All of these pages are supposed to give you a list of other pages with a summary and a link. But if you are not logged in you get an "access denied" error. I went to "Access Control" > "category permissions" and set "anonymous user"s to be able to "list" all nodes, but that didn't help. Any ideas? I don't know what to do. Daniel. Daniel Carrera wrote:
More information: Actually, you can see the individual blog posts on their own, but you cannot see the "blog" URL that aggregates all the blogs.
See here:
http://theingots.org/community/node/5194 http://theingots.org/community/blog
For some reason, an anonymous user cannot see the '/blog' URL but can see the actual blog post 'node/5194'.
Any ideas?
Daniel.
Daniel Carrera wrote:
Greg Holsclaw wrote:
Have you been using an access control module, and then turned it off? If so, sometimes the access table isn't updated correctly, it happened to me. I am indeed using the access control module, but I am not aware of doing anything that might have turned it off.
Under the Admin > Content > Posts page (/admin/content/node-settings) there is a 'Rebuild Permissions' button. This will force a complete rebuild of the access tables.
I go to Admin > Content and I see a list of posts. But I don't see any additional link that says Posts or a button that says "Rebuild Permissions".
I go to the URL /admin/content/node-settings and I only get the admin front page (that shows a log of recent activity).
I have Drupal 4.7. Is it possible that my version does not have this rebuild-permissions feature?
Daniel.
On Sat, Jun 28, 2008 at 11:19 PM, Daniel Carrera <daniel.carrera@zmsl.com> wrote:
I go to Admin > Content and I see a list of posts. But I don't see any additional link that says Posts or a button that says "Rebuild Permissions".
What you are looking for is Admin > Content Management > Post Settings
Rebuild Permissions. -- -- B
I don't understand. Magically the website started working again. I swear I didn't do anything. It wasn't working when I went to bed, and now it is working again. To reply to Bakwas' post: My Drupal 4.7 Admin menu doesn't have a content management option, just Content. And Content doesn't have post settings. There is Admin > Settings > Posts, but that's an unrelated page. It has things like the number of characters in a trimmed post, but nothing about permissions. Anyways, thanks for trying to help. I'll start planning to move to Drupal 5 in the future. Cheers, Daniel. bakwas bakwas wrote:
On Sat, Jun 28, 2008 at 11:19 PM, Daniel Carrera <daniel.carrera@zmsl.com> wrote:
I go to Admin > Content and I see a list of posts. But I don't see any additional link that says Posts or a button that says "Rebuild Permissions".
What you are looking for is Admin > Content Management > Post Settings
Rebuild Permissions.
Quoting Daniel Carrera <daniel.carrera@zmsl.com>:
Anyways, thanks for trying to help. I'll start planning to move to Drupal 5 in the future.
You should do that ASAP. Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/
participants (4)
-
bakwas bakwas -
Daniel Carrera -
Earnie Boyd -
Greg Holsclaw