I upgraded to the new release of this module today. Things have been going well till now. I use the module to grant edit permissions on a by-book basis for members depending on their roles. As of now, no one has any access to edit any of the books where there roles are assigned. I have looked in my error logs and now see 69 pages of this entry:

Table 'mydatabasename_drpl1.book_access' doesn't exist query: SELECT * FROM book_access WHERE nid = 45 in /home/mountain/public_html/modules/book_access/book_access.module on line 172.

I have uninstalled the module, reinstalled it...I have checked and rechecked permissions, rebuilt permissions.

In need of serious help here…thanks

[Edited by kiamlaluno]

Comments

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Title: Books are no longer accessible » Table 'book_access' doesn't exist
Status: Active » Fixed

A query was using the previous table name. I fixed the code, and committed it in CVS.

Thanks for your report.

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Component: Miscellaneous » Code

I have marked #671862: book_access table doesn't exist? as duplicate of this report.

paragon77’s picture

paragon77 commented

Do you know when a new release that fixes the table issue will come out? I downloaded the last one that I thought had the correction and the same error messages appeared.

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented

The development snapshot code has been already fixed. I didn't create any official release from that development snapshot, yet.

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented

I right created version 6.x-1.0-rc4.

paragon77’s picture

paragon77 commented

Received this message during the update.php process after installing the new module:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'real = 'book_access'' at line 1 query: UPDATE node_access SET realm = 'book_access_role' WHERE real = 'book_access' in /home/mountain/public_html/modules/book_access/book_access.install on line 192.

Now, I don't know if that's because I had rolled back my version of the module from rc3 to rc2 when then original error occurred or not, but I wanted to let you know in case you needed to look into something.

This was after installing rc4, btw.

[Edited by kiamlaluno]

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented

It has been reported in #676106: Problem with book_access.install . It is a typo; where you read real, it should be realm.
I will fix it ASAP.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.