Update #7003 and Update #7055 Failed - Can these be MySQL issues be repaired?

Posted by mouse77e on June 8, 2012 at 10:37am

The following updates returned messages

user module

Update #7000
User passwords rehashed to improve security
Update #7002
Migrated user time zones
filter module

Update #7003
Failed: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0-php_code' for key 'PRIMARY': INSERT INTO {filter} (format, module, name, weight, settings, status) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => 0 [:db_insert_placeholder_1] => php [:db_insert_placeholder_2] => php_code [:db_insert_placeholder_3] => 2 [:db_insert_placeholder_4] => a:0:{} [:db_insert_placeholder_5] => 1 ) in filter_update_7003() (line 334 of /Applications/MAMP/htdocs/june2012/modules/filter/filter.install).
system module

Update #7007
Inserted into {role_permission} the permissions for role ID 1, Inserted into {role_permission} the permissions for role ID 2, Inserted into {role_permission} the permissions for role ID 4
Update #7055
Failed: PDOException: SQLSTATE[HY000]: General error: 1283 Column 'value' cannot be part of FULLTEXT index: ALTER TABLE {variable} CHANGE `value` `value` LONGBLOB NOT NULL COMMENT 'The value of the variable.'; Array ( ) in db_change_field() (line 2985 of /Applications/MAMP/htdocs/june2012/includes/database/database.inc).

Hello.

I am upgrading a production site from Drupal 6 to 7 - (it started life as a Drupal 5 site) - and I am getting the above errors.

There are discussions on the forumas about the cause of these errors - sadly with no conclusions - but can I fix the errors? Sadly I am not a MySQL expert, can anyone pick through these errors and tell me how to do the necessary please?

Many thanks

Tim

Comments

Before you start the possibly

Posted by John_B on June 8, 2012 at 3:43pm

Before you start the possibly large problem of debugging a D6>D7 upgrade, it is always best to sit down and consider whether there is any way you could rebuild the site in D7 from scratch rather than running the troublesome upgrade.

If you must upgrade, on the first problem you might open the filter table in phpmyadmin and go looking for a duplicate entry for php filter and delete it if you find one. This is the kind of thing one has to do to resolve those problems. Always back up db before following my suggestions!

Digit Professionals

Starting Over

Posted by mouse77e on October 22, 2012 at 7:26pm

I am now looking at staring over.
I have seen patches - which didn't work for me... http://drupal.org/node/1072450 - I am going to have to find a way of extracting 1000+ users, along with attached files, photos and relationships, plus 700+ strong taxonomies.
Does anyone have a plan, a road map for starting over?

I WILL learn this Drupal stuff! [My Dyslexia be damned!]

This module

Posted by John_B on October 23, 2012 at 8:34am

This module http://drupal.org/project/migrate is there to help you.

Digit Professionals

Migrate Module - makes me panic a little!

Posted by mouse77e on October 24, 2012 at 9:29pm

Having read http://www.gizra.com/content/data-migration-part-1 it seems to be a possible solution but to be honest it intimidates the hell out of me - dyslexia is a cruel mistress!
The production site has 1000+ users, a huge range of taxonomy fields and desperately needs updating to D7... I am even thinking about finding an experienced user to give me a hand.