Even though they're not needed, you will constantly be prompted for:
book_access module :
7201 - Update the existing tables.
7202 - Remove spurious entries in the node access tables that cause users to see books they should not see.
7203 - Update the value of some Drupal variables used by the module.

Need to clean this up (though it's not breaking anything currently).

Comments

ippy’s picture

Hi

Thanks for taking on maintaining this project :)

I have the same issue. And (as I'm sure you know), Drush says...

The following updates are pending:

book_access module :
7201 - Update the existing tables.
7202 - Remove spurious entries in the node access tables that cause users to see books they should not see.
7203 - Update the value of some Drupal variables used by the module.

Do you wish to run all pending updates? (y/n): y
SQLSTATE[42000]: Syntax error or access violation: 1072 Key column [error]
'uid' doesn't exist in table
Performed update: book_access_update_7201 [ok]
Finished performing updates. [ok]

If you would like any further info or help testing, we'd be very happy to.

Ippy

thelee’s picture

Yes, sometimes I get uid constraint and sometimes I don't. I haven't had time to look at this yet, but as far as I can tell (we use it on several sites here), regardless of what happens it should be A-OK.

thelee’s picture

Yes - as a confirmation, now that I'm looking at this issue, this is only a major issue for people upgrading from earlier branches of book_access. Fortunately the fix is easy.

thelee’s picture

Here's the patch I'm applying to the dev branch.

thelee’s picture

Status: Active » Fixed

Should be in -dev soon, will combine with another potential fix for another stable release.

Status: Fixed » Closed (fixed)

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