Hello.
After I ugraded my drupal installation from 6 to 7 the content from content_type_business_announces wasn't moved to the right location. Can someone explain to me how and where I need to move the content of that table. Bellow are the tables:
mysql> show columns from content_type_news;
+-------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------------+------+-----+---------+-------+
| vid | int(10) unsigned | NO | PRI | 0 | |
| nid | int(10) unsigned | NO | | 0 | |
+-------+------------------+------+-----+---------+-------+

mysql> show columns from content_type_business_announces;
+-------------------------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------------------+------------------+------+-----+---------+-------+
| vid | int(10) unsigned | NO | PRI | 0 | |
| nid | int(10) unsigned | NO | MUL | 0 | |
| field_picture_fid | int(11) | NO | | 0 | |
| field_picture_title | varchar(255) | NO | | | |
| field_picture_alt | varchar(255) | NO | | | |
| field_announce_content_value | longtext | YES | | NULL | |
| field_contact_value | longtext | YES | | NULL | |
| field_announce_content_format | int(10) unsigned | YES | | NULL | |
| field_contact_format | int(10) unsigned | YES | | NULL | |
| field_image_fid | int(11) | YES | | NULL | |
| field_image_list | tinyint(4) | YES | | NULL | |
| field_image_data | text | YES | | NULL | |
+-------------------------------+------------------+------+-----+---------+-------+

You can see the differnce between the content_type_news and content_type_business_announces. The problem is that the body for my content of type business announces is not displayed and the body field is missing for this content type. Before the upgrading procedure the body field was declared.
Thank you.

Comments

John_B’s picture

I do not know the answer but just checking you have used the CCK migrate module? http://drupal.org/node/1144136

Digit Professionals specialising in Drupal, WordPress & CiviCRM support for publishers in non-profit and related sectors

mos_craciun’s picture

Tried the module and it migrated some fields but I still don't see the body of the nodes.
Also it looks like the needed fields were not moved:
mysql> show columns from content_type_business_announces;
+-------------------------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------------------+------------------+------+-----+---------+-------+
| vid | int(10) unsigned | NO | PRI | 0 | |
| nid | int(10) unsigned | NO | MUL | 0 | |
| field_picture_fid | int(11) | NO | | 0 | |
| field_picture_title | varchar(255) | NO | | | |
| field_picture_alt | varchar(255) | NO | | | |
| field_announce_content_value | longtext | YES | | NULL | |
| field_contact_value | longtext | YES | | NULL | |
| field_announce_content_format | int(10) unsigned | YES | | NULL | |
| field_contact_format | int(10) unsigned | YES | | NULL | |
| field_image_fid | int(11) | YES | | NULL | |
| field_image_list | tinyint(4) | YES | | NULL | |
| field_image_data | text | YES | | NULL | |
+-------------------------------+------------------+------+-----+---------+-------+
12 rows in set (0.01 sec)

John_B’s picture

I have nothing to suggest apart from working how to migrate the content manually. It is frustrating of course and is probably an example of why experienced Drupallers usually prefer migrating content into a fresh site rather than attempting a major version upgrade. If you have not done so you might try re-running the upgrade on a local machine, in case there was just a failure of database write owing to a resource bottleneck on the server.

Digit Professionals specialising in Drupal, WordPress & CiviCRM support for publishers in non-profit and related sectors

mos_craciun’s picture

I would like to migrate manually but I don't know what and where should go.

John_B’s picture

Unfortunately there is no easy one-click method. This lack of an easy upgrade or migrate path from one major version to another is major problem with Drupal. If you have the appetite to get your hands dirty with a Drupal to Drupal data migration you might look here:
http://www.acquia.com/blog/drupal-drupal-data-migration-part-1-basics
http://drupal.org/project/migrate_d2d

Digit Professionals specialising in Drupal, WordPress & CiviCRM support for publishers in non-profit and related sectors