Cannot use the 7.x-2.0-alpha2 Outline Child Pages submodule [#1730488]

When browsing the non-admin portion of my site, I have encountered a near WSOD page that states that an error has occurred. It provides no information about the error.

The Drupal log lists the following:

PDOException: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined: SELECT ml.has_children FROM {book} b INNER JOIN {menu_links} ml ON b.mlid = ml.mlid WHERE b.nid = :b.nid; Array ( [:b.nid] => 1 ) in _outline_child_pages_access() (line 65 of /Users/Bob/Sites/LuthierBuilt/LuthierBuilt-SUP/docroot/sites/all/modules/contrib/outline_designer/modules/outline_child_pages/outline_child_pages.module).

On disabling Outline Child Pages, browsing returns to normal behavior.

Note that the site in question is in the final stages of being upgraded from a source D6 site, and the D6 site made frequent use of Outline Designer and nested book pages. I.e., that content is in place and accessible in the new D7 site.

Please advise and thanks for your help,

Bob

Comments

Comment #1

btopro CreditAttribution: btopro commented 14 August 2012 at 18:09

Version:	7.x-2.0-alpha2	» 7.x-2.x-dev
Priority:	Normal	» Major

patches for this and moving outline designer beyond an alpha state are always welcome, don't have a lot of time for this project at the moment with semesters starting up soon.

Comment #2

Anonymous (not verified) CreditAttribution: Anonymous commented 14 August 2012 at 18:29

I'd love to provide you a patch. Unfortunately, I am strictly a site builder, meaning I have zero PHP chops to bring to the table.

Comment #3

shaneforsythe CreditAttribution: shaneforsythe commented 29 October 2012 at 16:06

I changed

$has_children = db_query('SELECT ml.has_children FROM {book} b INNER JOIN {menu_links} ml ON b.mlid = ml.mlid WHERE b.nid = :b.nid', array(':b.nid' => $node->nid))->fetchField();

$has_children = db_query('SELECT ml.has_children FROM {book} b INNER JOIN {menu_links} ml ON b.mlid = ml.mlid WHERE b.nid = :nid', array(':nid' => $node->nid))->fetchField();

and it fixes the problem ie change :b.nid to :nid in two places
this is on line 65 of outline_designer/modules/outline_child_pages/outline_child_pages.module