Can't use book module
| Project: | Drupal |
| Version: | 6.12 |
| Component: | book.module |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | by design |
Jump to:
Hello.
I tried to use your book module in order to create a book. However when i try to create a new page i'm receiving the following errors:
* user warning: Unknown column 'b.mlid' in 'on clause' query: SELECT * FROM book b INNER JOIN menu_links ml ON b.mlid = ml.mlid WHERE b.nid = 524 in /home/hispa-net/drupal/drupal-6.4/modules/book/book.module on line 657.
* user warning: Unknown column 'b.mlid' in 'on clause' query: SELECT * FROM book b INNER JOIN menu_links ml ON b.mlid = ml.mlid WHERE b.nid = 524 in /home/hispa-net/drupal/drupal-6.4/modules/book/book.module on line 657.
If i go to /book URL i get:
user warning: Unknown column 'bid' in 'field list' query: SELECT DISTINCT(bid) FROM book in /home/hispa-net/drupal/drupal-6.4/modules/book/book.module on line 261.
And if i go to /admin/content/book
user warning: Unknown column 'bid' in 'field list' query: SELECT DISTINCT(bid) FROM book in /home/hispa-net/drupal/drupal-6.4/modules/book/book.module on line 261.
I'm using Drupal 6.4, and this is the first time i use this module.
#1
I am also having problems with 6.4, and maybe the problem is the same which is why I thought it was best to post here.
I'm not sure what to make of the error report (below).
When trying to create a new blog entry, I have the following warning:
user warning: Unknown column 'bid' in 'field list' query: SELECT DISTINCT(bid) FROM dr_book in /home/USER/public_html/dr/modules/book/book.module on line 261
and after creating the content:
user warning: Unknown column 'b.mlid' in 'on clause' query: SELECT * FROM dr_book b INNER JOIN dr_menu_links ml ON b.mlid = ml.mlid WHERE b.nid = 110 in /home/USER/public_html/dr/modules/book/book.module on line 657.
It seems to be with the book module, but seems to affect all blog entries.
If anyone has any ideas, I'd be very grateful.
--------------------------------
Update errors (from 5.10 to 6.4)
user warning: Duplicate entry '218-0' for key 1
query: ALTER TABLE dr_locales_target ADD PRIMARY KEY (language, lid,
plural) in
/home/USER/public_html/dr/includes/database.mysql-common.inc on line
374.
The following queries were executed
system module
Update #6043
* Failed: ALTER TABLE {locales_target} ADD PRIMARY KEY (language, lid, plural)
#2
The original error in this issue is caused by not running update.php after turning on the module. (Your database structure is not up to date)
As for the second error unfortuantly the update error you posted is unrelated to the error your having. The error your having is the database schema for the book module didn't get updated from version 5 to version 6. I would recommend trying to reinstall the book module.
#3
I just went from d6.11 to d6.12 and got the same error. I had updated and then updated again and still get this error. Any ideas how to manually fix this? FYI, the upgrade to d6.12 was for one installation but two sites. The first site worked ok. This one did not.
user warning: Unknown column 'b.mlid' in 'on clause' query: SELECT * FROM book b INNER JOIN menu_links ml ON b.mlid = ml.mlid WHERE b.nid = 99 in /home/acct/d6.website.net/html/modules/book/book.module on line 657.
thanks for any help you can offer
c