Download & Extend

Block's don't show up to anonymous and registered user

Project:Advanced Book Blocks
Version:6.x-2.2
Component:Miscellaneous
Category:task
Priority:critical
Assigned:Unassigned
Status:needs review

Issue Summary

I have create a new block, showing it up on sidebar.
The block doesn't show up in this form, only as a j_wuery menu form.

What am I missing?

[I can't control the functions - Enabled Books, Reset Weight, Weight - They hold still]

Comments

#1

Version:6.x-1.9» 6.x-2.2

Hello
I'm having the same problem using version 6.x-2.2 of ABB module
the block only appear for user 1 or admin , but not for a user or anonymous

#2

Title:Block's don't show up. » Block's don't show up to anonymous and registered user

Yes, me to after having update to this version.

And i have check in DB log, the error appear like this:

backtrace 19 Sep 2010 - 10:50pm Type: php Unknown column ...
php 19 Sep 2010 - 10:50pm Unknown column 'n.nid' in ...

Currently, my site installed with Workflow modules. Maybe there is a clash script between it.

#3

I am experiencing a similar issue. Having upgraded to 6.x-2-2 I now get an error message when anonymous or registered users try and access a book page with an advanced book block. The error only occurs when I have some sort of access control module enabled (I have tried it with tac_lite, taxonomy_access and nodeaccess and all give similar errors).

The following errors are an anonymous user viewing a book with tac_lite enabled -

User warning: Unknown column 'n.nid' in 'on clause' query: SELECT DISTINCT n.title, n.status, b.mlid FROM node n, book b INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'tac_lite'))) AND ( n.nid = 3 AND b.nid = n.nid) in _db_query() (line 141 of /Applications/xampp/xamppfiles/htdocs/drupal/vm/esdocs/html/includes/database.mysqli.inc).

User warning: Unknown column 'n.nid' in 'on clause' query: SELECT DISTINCT mlid, weight, link_title FROM menu_links INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'tac_lite'))) AND ( plid = 0 )ORDER by weight, link_title in _db_query() (line 141 of /Applications/xampp/xamppfiles/htdocs/drupal/vm/esdocs/html/includes/database.mysqli.inc).

Any help appreciated, thanks!

#4

The latest version (6.x-2.2) doesn't work. What I found was that though version 1.8 or higher of JQMenu is required, jquerymenu.js included in the latest version of jquerymenu module (6.x-3.3) is 1.7. I don't know where you can get jquerymenu 1.8.

jquerymenu module 6.x-2.1 works fine.

#5

yes.. thats why I down grade back to v2.1..
but its really annoying since message of security update keep appearing.

#6

This is a nice module. I wonder if the developer is still actively supporting this project. Where can I get jquerymenu 1.8? I'd like to try and test.

#7

This is exactly my problem as well. Nearly identical error messages as those reported by #3 brenv - September 20, 2010 - 23:47

#8

That was my solution as well: just to use 2.1 for now. I skimmed the source and I couldn't even immediately see where ACL-related code was, so I sort of just ran away after that. Ahem.

#9

Assigned to:amirtaiar» Anonymous

IMO, its better the developer to turn on version 2.1 since a lot of people having problem with 2.2 with no solution and patching.

cause it make my site to irritating since warning of security update appear at top of my site.

#10

Please see this bug for a patch which should solve your problems.

#11

Status:active» fixed

one word: perfect!

#12

Status:fixed» needs review

This is not fixed yet in CVS.