activating the book module in 7

Posted by mfrankel on August 24, 2012 at 6:34pm

After activation of the book module I am getting this error. The permissions were set. No other errors that I can see and logging as well as content editing and menu seems to work fine.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drupal7frameworkcom.book' doesn't exist: SELECT * FROM {book} b INNER JOIN {menu_links} ml ON b.mlid = ml.mlid WHERE b.nid IN (:nids_0, :nids_1, :nids_2); Array ( [:nids_0] => 1 [:nids_1] => 2 [:nids_2] => 3 ) in book_node_load()

Any information about setting it up will help

Thanks

Comments

=-=

Posted by VM on August 24, 2012 at 6:44pm

check the Database , is there a table labeled book?

disable and uninstall book.module and try reinstalling to have the table placed in the DB.

the table was never created.

Posted by mfrankel on August 24, 2012 at 9:01pm

The table was never created. After I created it it is now looking for the fields which are not there..
I need a way to disable the module from th database and then a way to make sure the table is created when installing the module so it will not take the site down..

I think I found what I am looking for:

http://drupal.org/node/157632

Shows how to disable the module from the database. --

I still need insight about why the table was not created to begin with

Thanks

MFR

=-=

Posted by VM on August 24, 2012 at 10:10pm

If you just added the table without adding the rows and columns as laid out in the modules .install file that's why it wouldn't work.

did you try running the uninstall routine using the uninstall tab after the module was disabled to see if the module would install properly the second time around?