Jump to:
| Project: | Drupal core |
| Version: | 6.13 |
| Component: | book.module |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed (works as designed) |
Issue Summary
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.
Comments
#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
#4
I'm having the identical problem with Drupal 6.13. I've already run update.php AND deleted and re-installed the book module.
Everything else appears to be OK.
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 = 15 in /home3/xxxxxx/public_html/xxxxx/modules/book/book.module on line 657.
Edit: 8/28/09
I went back and viewed another installation of D6.13 comparing the "book" tables in each installation.
The installation that was giving me the problem listed above had two fields in the book table that were not in the other installation, so I removed them. I also added one new field to the book table as well as cleaning up the indexes by adding two new fields there.....without going into any extensive details I have been able to repair the corruption and clear the error messages. Things appear to be working ok now.
#5
don't be shy. I would like the details :)
#6
I just disabled, then uninstalled the book module. Re-enabled it, and the problems were gone.