I used Migrate D2D UI migrate my content from D6 to D7. It worked pretty smoothly but I am having one issue:

Issue:

On my front page, I see all the content nodes that were "promoted to front page". However all these content nodes are out of order and are not sorted by authored date/time.

I compared the "Authoring information" of nodes in D6 and D7. It seems that the mapping of "created" field was correct and properly migrated because the date/time for authoring details are the same.

To troubleshoot this issue, I created a view that listed all my content nodes sorted by post date. The resulting view also showed content that was out of order. It seems that view is showing the content in order of the date/time the content was migrated into D7 and not based on authoring actual date/time. I also noticed that migrated content have different node ID, thus it seems migrate is creating a new node when it migrates the data from D6 to D7.

I took additional steps taken to fix but it did NOT work:

  • Run update.php
  • Run cron
  • Clear cache

It would be great if someone know how to fix this issue? I am not much of a developer, but maybe the database needs to be re-synced to the authoring date/time of each nodes instead of new creation date/time?

Here is the screenshot of the view I created: https://i.imgur.com/K498Jcn.png

Edit: Issue has be resolved: https://www.drupal.org/node/2778475#comment-11475389

Comments

yelvington’s picture

There are more than one datestamp associated with a node. When comparing source and destination, be sure you're looking at the right one. The devel module can help by displaying the actual node object structure. If it turns out that your mapping is wrong, just roll back the migration, fix the mapping, and re-migrate.

Zythyr’s picture

yelvington Thanks for the suggestion. I looked at the timestamp for the following values using Devel in both D6 and D7:
created
changed
revision_timestamp

The values are the same in both my orignal D6 site and the migrated D7 site.

Would you have any other suggestions on what is causing the issue?

Zythyr’s picture

Issue fixed:

I figured out my issue. This might sound embarrassing but the problem was related to Promoted to front page option for nodes on my D6.

Many nodes didn't have Promoted to front page enabled in my D6 site but were still showing up on the front page. Thus I assumed this would be the case for D7. I later figured out that the original site architect of D6 created a custom view for the front page, thus nodes were showing up on front page even though Promoted to front page was not enabled.