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

hicham7’s picture

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

parasolx’s picture

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.

brenv’s picture

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!

WinstonC’s picture

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.

parasolx’s picture

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

WinstonC’s picture

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.

woodhome’s picture

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

CatherineOmega’s picture

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.

parasolx’s picture

Assigned: amirtaiar » Unassigned

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.

Frodo Looijaard’s picture

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

parasolx’s picture

Status: Active » Fixed

one word: perfect!

Frodo Looijaard’s picture

Status: Fixed » Needs review

This is not fixed yet in CVS.