User login

Upgrading from Drupal 7 alpha 6 to Drupal 7 beta 2

Searched words: 
mysql export schema mysql create field drupal 7 alpha5 beta2 upgrade

This isn't pretty. And i've probably left out a critical step.

Core concepts: making some changes directly in the database. Enabling head2head and alpha2alpha in the database (setting both status and schema_version). Manually commenting out the update hooks that i did in the database to make user module's updates work so that alpha2alpha's can work.

Setting the line in alpha2alpha.module to give the current version:

<?php
  $version = variable_get('alpha2alpha_version', 7);
?>

and then change the 7 to 8. Rather than the default FALSE.


PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'hash' in 'field list': INSERT INTO {registry_file} (filename, hash) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1); Array ( [:db_insert_placeholder_0] => sites/default/modules/head2head/alpha2alpha/alpha2alpha.module [:db_insert_placeholder_1] => 527b9da313a330295adc248e73a920645891ce970823a30241aef7d7d0729ef7 ) in _registry_parse_files() (line 150 of /var/local/drupal/dgd7/drupal/includes/registry.inc).

http://drupal.org/node/920344
yes i update from Alpha 6 to Alpha 7 ...and i have not know thats alpha -> alpha is not supported...hart to get the whole site back ..cry

Notice: Undefined index: hash in _registry_update() (line 70 of /var/local/drupal/dgd7/drupal/includes/registry.inc).

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'hash' in 'field list': INSERT INTO {registry_file} (filename, hash) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1); Array ( [:db_insert_placeholder_0] => sites/default/modules/head2head/alpha2alpha/alpha2alpha.module [:db_insert_placeholder_1] => 527b9da313a330295adc248e73a920645891ce970823a30241aef7d7d0729ef7 ) in _registry_parse_files() (line 150 of /var/local/drupal/dgd7/drupal/includes/registry.inc).


ALTER TABLE registry_file ADD hash VARCHAR(64) NOT NULL DEFAULT NULL;

The following updates returned messages
user module
Update #7010

* Failed: DatabaseSchemaObjectDoesNotExistException: %message in DatabaseSchema_mysql->changeField() (line 450 of /var/local/drupal/dgd7/drupal/includes/database/mysql/schema.inc).

alpha2alpha module
Update #7400

* Failed: DrupalUpdateException: %message in alpha2alpha_update_helper() (line 95 of /var/local/drupal/dgd7/drupal/sites/default/modules/head2head/alpha2alpha/alpha2alpha.install).

alter table field_config_instance drop index field_name_bundle;
describe field_config_instance;
mysql> alter table field_config_instance add index (field_name, entity_type, bundle) field_name_bundle;

mysql> select name, schema_version from system where name='alpha2alpha';
+-------------+----------------+
| name | schema_version |
+-------------+----------------+
| alpha2alpha | 7704 |
+-------------+----------------+
1 row in set (0.00 sec)

mysql> update system set schema_version=5999 where name='alpha2alpha';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select name, schema_version from system where name='alpha2alpha';
+-------------+----------------+
| name | schema_version |
+-------------+----------------+
| alpha2alpha | 5999 |
+-------------+----------------+
1 row in set (0.00 sec)

The following updates returned messages
alpha2alpha module
Update #7705

* Failed: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'disabled' in 'where clause': SELECT nt.* FROM {node_type} nt WHERE (disabled = :db_condition_placeholder_0) ORDER BY nt.type ASC; Array ( [:db_condition_placeholder_0] => 0 ) in _node_types_build() (line 698 of /var/local/drupal/dgd7/drupal/modules/node/node.module).

mysql> alter table node_type add column disabled tinyint(4) NOT NULL DEFAULT 0;

Reference

Comparing Database Schemas

Did not do, but the --no-data option for mysqldump would probably do it. See http://dev.mysql.com/doc/mysql/en/mysqldump.html

This perl utility didn't install (or, 'make'): http://adamspiers.org/computing/mysqldiff/

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.
  • You can use Markdown syntax to format and style the text. Also see Markdown Extra for tables, footnotes, and more.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img> <blockquote> <small> <h2> <h3> <h4> <h5> <h6> <sub> <sup> <p> <br> <strike> <table> <tr> <td> <thead> <th> <tbody> <tt> <output>
  • Syntax highlight code surrounded by the {syntaxhighlighter SPEC}...{/syntaxhighlighter} tags, where SPEC is a Syntaxhighlighter options string or "class="OPTIONS" title="the title".
  • Lines and paragraphs break automatically.

More information about formatting options

By submitting this form, you accept the Mollom privacy policy.