Upgrade multisite installation from Drupal 6.20 to Drupal 7.0-r3 [#1009552]

Comment	File	Size	Author
#10	contact.1009552.10.patch	340 bytes	hershel

Comment #1

Branjawn commented 29 December 2010 at 05:56

I was getting this error:
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drp01.drup_blocked_ips' doesn't exist: SELECT 1 FROM {blocked_ips} WHERE ip = :ip; Array ( [:ip] => 65.87.166.200 ) in drupal_is_denied() (line 1779 of /home5/public_html/includes/bootstrap.inc).

Now I am stuck with this:
Fatal error: Call to undefined function decode_entities() in /home5/public_html/includes/common.inc on line 1552

Any help is welcome!

Log in or register to post comments

Comment #2

Branjawn commented 29 December 2010 at 16:06

Just to let someone know, I'm still working on this.

Log in or register to post comments

Comment #3

Branjawn commented 29 December 2010 at 17:14

Title:

Upgrade multisite from 6 to 7

» Upgrade multisite installation from Drupal 6.20 to Drupal 7.0-r3

Log in or register to post comments

Comment #4

Branjawn commented 29 December 2010 at 17:27

It may be fixed. I worked with Hostmonster support (very helpful!) and got a fresh php.ini file, removed added themes and modules, nothing was changing.
Well, I went to mysite.com/install.php and used the update link from that page (as opposed to me entering manually in browser url bar) and it worked! I did get a few db errors, but overall it worked and I'm not getting WSOD or Fatal Errors.

Log in or register to post comments

Comment #5

Branjawn commented 29 December 2010 at 17:43

Problems:

Still exists on non-update pages:
Fatal error: Call to undefined function decode_entities() in /home5/public_html/includes/common.inc on line 1552

On mysite.com/update.php?op=results I get the following:

    * Notice: Undefined index: update_success in update_results_page() (line 162 of /home5/aredlion/public_html/update.php).
    * Warning: array_pop() [function.array-pop]: The argument should be an array in update_results_page() (line 166 of /home5/public_html/update.php).

The update process was aborted prematurely while running update # in .module. All errors have been logged.

When I ran the update, I got this result on that page:

system module
Update #7002
Failed: DatabaseSchemaObjectExistsException: Table <em class="placeholder">blocked_ips</em> already exists. in DatabaseSchema->createTable() (line 623 of /home5/public_html/includes/database/schema.inc).
contact module
Update #7002
Failed: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'module' in 'where clause': SELECT 1 AS expression FROM {role_permission} role_permission WHERE ( (rid = :db_condition_placeholder_0) AND (permission = :db_condition_placeholder_1) AND (module = :db_condition_placeholder_2) ) FOR UPDATE; Array ( [:db_condition_placeholder_0] => 2 [:db_condition_placeholder_1] => access user contact forms [:db_condition_placeholder_2] => contact ) in contact_update_7002() (line 128 of /home5/public_html/modules/contact/contact.install).

Log in or register to post comments

Comment #6

Branjawn commented 29 December 2010 at 17:43

Deleted blocked_ips table, ran update.pgp again, new error:

The following updates returned messages
system module
Update #7004

    * Failed: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'garland-node-syndicate' for key 'tmd': UPDATE {block} SET delta=:db_update_placeholder_0 WHERE (module = :db_condition_placeholder_0) AND (delta = :db_condition_placeholder_1) ; Array ( [:db_update_placeholder_0] => syndicate [:db_condition_placeholder_0] => node [:db_condition_placeholder_1] => 0 ) in update_fix_d7_block_deltas() (line 349 of /home5/public_html/includes/update.inc).

contact module
Update #7002

    * Failed: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'module' in 'where clause': SELECT 1 AS expression FROM {role_permission} role_permission WHERE ( (rid = :db_condition_placeholder_0) AND (permission = :db_condition_placeholder_1) AND (module = :db_condition_placeholder_2) ) FOR UPDATE; Array ( [:db_condition_placeholder_0] => 2 [:db_condition_placeholder_1] => access user contact forms [:db_condition_placeholder_2] => contact ) in contact_update_7002() (line 128 of /home5/public_html/modules/contact/contact.install).

Log in or register to post comments

Comment #7

Branjawn commented 29 December 2010 at 21:22

16 hours, no help. discouraging.

Log in or register to post comments

Comment #8

Remon commented 12 March 2011 at 17:09

Still apparent? could you test with D7.0?

Log in or register to post comments

Comment #9

hershel commented 15 March 2011 at 15:25

Version:	7.0-rc3	» 7.0
Component:	other	» contact.module

I am starting work on upgrading a large site from D6-D7 and first time I ran the update (offline of course!) I also get this same error:

 * Failed: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown
    column 'module' in 'where clause': SELECT 1 AS expression FROM
    {role_permission} role_permission WHERE ( (rid =
    :db_condition_placeholder_0) AND (permission = :db_condition_placeholder_1)
    AND (module = :db_condition_placeholder_2) ) FOR UPDATE; Array (
    [:db_condition_placeholder_0] => 2 [:db_condition_placeholder_1] => access
    user contact forms [:db_condition_placeholder_2] => contact ) in
    contact_update_7002() (line 128 of
    /srv/http/D.7/modules/contact/contact.install).

I disabled all non-core modules before the upgrade. Aside from that it worked fine.