Importing ONLY nodes from D5 into D7 - Errors!!!
I have a client that wanted to upgrade from D% to D7. Fortunately, they were ok with starting all over... but now that the website is ready, I need to move the nodes in. I exported the nodes into a sql file, imported them into the new database and although they show up in the new database, when I go back to the new website, it's giving me the following error. "PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'language' in 'where clause'... There is no column titled "language" in the nodes. I don't have a language or translation module loaded. I rolled the database back to get the website functional again, but I'd like to try to make this work as there are 207 nodes that I'd rather not add by hand!! Thanks! Jessica Hannan 815-545-5541 http://www.HaloDigitalDesign.com Join us on Facebook!! http://www.facebook.com/halodigitaldesign
Jessica and all, On the D5 site set up an RSS feed which aggregates the nodes you want to export from the old site. Now on the Drupal 7 site, use the Feeds module to import the nodes. Both sites have to be up and running separately for this to work. There is a bit of a learning curve on the Feeds module, but it is a good way to go for your use-case. Shai On Apr 9, 2012, at 8:51 PM EDT, Jessica Hannan - Halo Digital Design wrote:
I have a client that wanted to upgrade from D% to D7. Fortunately, they were ok with starting all over... but now that the website is ready, I need to move the nodes in.
I exported the nodes into a sql file, imported them into the new database and although they show up in the new database, when I go back to the new website, it's giving me the following error.
"PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'language' in 'where clause'...
There is no column titled "language" in the nodes. I don't have a language or translation module loaded.
I rolled the database back to get the website functional again, but I'd like to try to make this work as there are 207 nodes that I'd rather not add by hand!!
Thanks!
Jessica Hannan 815-545-5541 http://www.HaloDigitalDesign.com Join us on Facebook!! http://www.facebook.com/halodigitaldesign
-- [ Drupal support list | http://lists.drupal.org/ ]
On Mon, Apr 9, 2012 at 8:51 PM, Jessica Hannan - Halo Digital Design wrote:
I have a client that wanted to upgrade from D% to D7. Fortunately, they were ok with starting all over... but now that the website is ready, I need to move the nodes in.
Going from D5 to D7 steps: 1) Upgrade all modules in D5 to most current D5 version. 2) Disable but do not delete all D5 non-core modules 3) Upgrade to core Drupal-6.0 4) run update.php for Drupal-6 5) Upgrade to Drupal-6.25 6) run update.php for Drupal-6 7) Upgrade all modules to their D6 most recent versions 8) Enable the contrib modules to ready them for update 9) run update.php for Drupal-6 contrib modules. 10) Upgrade to core Drupal-7.12 11) Upgrade the contrib modules to their D7 most recent versions. 12) run update.php for Drupal-7 core and contrib modules.
I exported the nodes into a sql file, imported them into the new database and although they show up in the new database, when I go back to the new website, it's giving me the following error.
"PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'language' in 'where clause'...
These happen because the upgrade path is lost when upgrading to higher versions of core.
There is no column titled "language" in the nodes. I don't have a language or translation module loaded.
I rolled the database back to get the website functional again, but I'd like to try to make this work as there are 207 nodes that I'd rather not add by hand!!
Yea, don't work on the live site before you have it working in a dev site. This is a rather large undertaking and you want to make sure that the site works between update.php executions so that if something breaks you know which step broke it. Ping me off list if you need more help. -- Earnie -- https://sites.google.com/site/earnieboyd
yet another option: "Direct Drupal 5 to Drupal 7 Migration in 24hrs" - http://quicksketch.org/node/5739 On Tue, Apr 10, 2012 at 7:41 AM, Earnie Boyd <earnie@users.sourceforge.net>wrote:
On Mon, Apr 9, 2012 at 8:51 PM, Jessica Hannan - Halo Digital Design wrote:
I have a client that wanted to upgrade from D% to D7. Fortunately, they were ok with starting all over... but now that the website is ready, I need to move the nodes in.
Going from D5 to D7 steps:
1) Upgrade all modules in D5 to most current D5 version. 2) Disable but do not delete all D5 non-core modules 3) Upgrade to core Drupal-6.0 4) run update.php for Drupal-6 5) Upgrade to Drupal-6.25 6) run update.php for Drupal-6 7) Upgrade all modules to their D6 most recent versions 8) Enable the contrib modules to ready them for update 9) run update.php for Drupal-6 contrib modules. 10) Upgrade to core Drupal-7.12 11) Upgrade the contrib modules to their D7 most recent versions. 12) run update.php for Drupal-7 core and contrib modules.
I exported the nodes into a sql file, imported them into the new database and although they show up in the new database, when I go back to the new website, it's giving me the following error.
"PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'language' in 'where clause'...
These happen because the upgrade path is lost when upgrading to higher versions of core.
There is no column titled "language" in the nodes. I don't have a language or translation module loaded.
I rolled the database back to get the website functional again, but I'd like to try to make this work as there are 207 nodes that I'd rather not add by hand!!
Yea, don't work on the live site before you have it working in a dev site. This is a rather large undertaking and you want to make sure that the site works between update.php executions so that if something breaks you know which step broke it.
Ping me off list if you need more help.
-- Earnie -- https://sites.google.com/site/earnieboyd -- [ Drupal support list | http://lists.drupal.org/ ]
participants (4)
-
Benj Fredrick -
Earnie Boyd -
Jessica Hannan - Halo Digital Design -
Shai Gluskin