We are getting dreadfully frustrated in our attempt to update from 5.19 to 6.13. We have received several errors, but the one we can't resolve seems to center on the book module. FYI, this site has a lot of posts and began as a Drupal 4.3 site; we have followed very closely the steps required to update to a new version of Drupal, including making incremental steps from 5.19 to 6.0 to 6.13. The short explanation for what's happening is that the book module seems to cause problems when we run update.php, we get messages that updating sequence was aborted and/or that there are unresolved errors. CAN ANYONE HELP?

Here, in sequence and in detail, are the errors we received:

1. On our first try from Drupal 5.19 to Drupal 6.0 (all contrib modules disabled; all optional core modules left on; all drupal 5 folders removed; all drupal 6 folders moved to proper directory; admin user;) update.php function yielded these messages:

An error occurred. LOCALHOST URL HERE/update.php?id=1&op=do
Fatal error: Unsupported operand types in /LOCALHOST URL HERE/modules/book/book.install on line 218

Additional message on update page: The update process was aborted prematurely while running update #6000 in book.module. All errors have been logged. You may need to check the watchdog database table manually.

On error page:

* user warning: Duplicate entry '392-0-' for key 1 query: ALTER TABLE poll_votes ADD PRIMARY KEY (nid, uid, hostname) in /LOCALHOST URL HERE/includes/database.mysql-common.inc on line 374.
* warning: array_merge() [function.array-merge]: Argument #2 is not an array in /LOCALHOST URL HERE/modules/book/book.install on line 205.

2. Unchecked book in module list and ran update.php again, received this error:

An error occurred. LOCALHOST URL HERE/update.php?id=2&op=do
Fatal error: Unsupported operand types in /LOCALHOST URL HERE/modules/book/book.install on line 218

Additional message on update page: The update process was aborted prematurely while running update #6000 in book.module. All errors have been logged. You may need to check the watchdog database table manually.

corresponding log notes:
array_merge() [function.array-merge]: Argument #2 is not an array in /LOCALHOST URL HERE/modules/book/book.install on line 205.

Error page notes:

* user warning: Duplicate entry '392-0-' for key 1 query: ALTER TABLE poll_votes ADD PRIMARY KEY (nid, uid, hostname) in /LOCALHOST URL HERE/includes/database.mysql-common.inc on line 374.
* warning: array_merge() [function.array-merge]: Argument #2 is not an array in /LOCALHOST URL HERE/modules/book/book.install on line 205.

3. While we had gotten those update errors, we did bang on the test site pretty hard and it seemed to be working OK. We also went through many of the hundreds of book nodes that we have and they all seemed to be working OK. We also created new book nodes and, again, it seemed to be working. However, it worried us that we had this error and problem during the updating and wanted to get to the bottom of it.

A couple of forums suggested we jump to 6.13. So we did, again this would be an upgrade from 6.0. After a hiccup with the taxonomy module, (we activated the taxonomy module and tried again and that seemed to resolve what appeared to be a sequencing issue with forum module) we got this error. (FYI, the book module was enabled):

Fatal error: Unsupported operand types in /LOCALSITE URL HERE/modules/book/book.install on line 218

From error logs:
* user warning: Table 'book_temp' already exists query: CREATE TABLE book_temp ( `nid` INT unsigned NOT NULL DEFAULT 0, `parent` INT NOT NULL DEFAULT 0, `weight` TINYINT NOT NULL DEFAULT 0, PRIMARY KEY (nid), INDEX parent (parent) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /LOCALSITE URL HERE/includes/database.inc on line 517.
* user warning: Unknown column 'b.parent' in 'field list' query: INSERT INTO book_temp (nid, parent, weight) SELECT b.nid, b.parent, b.weight FROM book b INNER JOIN node n on b.vid = n.vid in /LOCALSITE URL HERE/modules/book/book.install on line 127.
* warning: array_merge() [function.array-merge]: Argument #2 is not an array in /LOCALSITE URL HERE/modules/book/book.install on line 205.

Again, can anyone help with this?

Thanks so much in advance,

Geoff Gevalt

Comments

ggevalt’s picture

Title: Problems updating to Drupal 6 from Drupal 5 » Update problems 5 to 6 with book module...

Am hoping we can get some help so am commenting to see if we can shake up some links or advice to the above problem. What concerns me is that I see a fair number of issues and forum entries about the book module that seem somewhat related but they, too, have NO responses.

I hope that someone can help out. Anyone know of issues related to book module in the updating process from Drupal 5 to Drupal 6? Solutions?

thanks

geoff

prokopton’s picture

I've spent the last 3 days with this problem. I would love to upgrade to 6.x but this is in the way.

prokopton’s picture

The book module is part of the core. Hope there a solution for it soon.

ggevalt’s picture

Seems too bad that there is no response to these queries.

I suspect that despite book.module being part of core, it is kind of ignored. Which is too bad from the point of view of the problems that we had in doing the upgrade AND in terms of the fact that there has been no development of this module which inherently has some great uses but is a bear for users to use.... Talk about not-user-friendly! I wish I knew code so that I could work on it, but alas, I am just hoping that someone sees these calls for help.

tortoise’s picture

I am having this issue as well when updating from 5.20 to 6.14. Unsupported operand types on line 218; Argument #2 is not an array on line 205. I get the same errors whether the book module is enabled or not.

tortoise’s picture

I am having this issue as well when updating from 5.20 to 6.14. Unsupported operand types on line 218; Argument #2 is not an array on line 205. I get the same errors whether the book module is enabled or not.

voipfc’s picture

+1 subscribing

HorsePunchKid’s picture

This might be a duplicate of #645214: No menu links, no books which offers some suggestions.

voipfc’s picture

Check for some custom PHP code used in blocks, pages etc.

There is a good chance that the problem lies there.

natuk’s picture

Same problem here.

noctifer’s picture

Same problem... I'm currently using the book module on a 5.22 install and need it working for 6.16 before I can upgrade. Any ideas? The suggestion on http://drupal.org/node/645214 does not help with this error.

marcorai’s picture

Same problem.

user warning: Unknown column 'b.parent' in 'field list' query: INSERT INTO book_temp (nid, parent, weight) SELECT b.nid, b.parent, b.weight FROM book b INNER JOIN node n on b.vid ...

during an upgrade from 5.22 to 6.16

Juhani’s picture

Version: 6.13 » 6.19

This doesn't fix the possible bug, but the upgraded sites that have this issue can be fixed quite easily like this http://mydrupal.com/books_lost_on_upgrade_from_drupal_5_to_6

prokopton’s picture

Sub.

Status: Active » Closed (outdated)

Automatically closed because Drupal 6 is no longer supported. If the issue verifiably applies to later versions, please reopen with details and update the version.