[support] Importing ONLY nodes from D5 into D7 - Errors!!!

[Shai Gluskin]

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/ ]