yet another option:<div>"Direct Drupal 5 to Drupal 7 Migration in 24hrs" - <a href="http://quicksketch.org/node/5739">http://quicksketch.org/node/5739</a></div><div><br><br><div class="gmail_quote">On Tue, Apr 10, 2012 at 7:41 AM, Earnie Boyd <span dir="ltr"><<a href="mailto:earnie@users.sourceforge.net">earnie@users.sourceforge.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">On Mon, Apr 9, 2012 at 8:51 PM, Jessica Hannan - Halo Digital Design wrote:<br>
> 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.<br>
><br>
<br>
</div>Going from D5 to D7 steps:<br>
<br>
1) Upgrade all modules in D5 to most current D5 version.<br>
2) Disable but do not delete all D5 non-core modules<br>
3) Upgrade to core Drupal-6.0<br>
4) run update.php for Drupal-6<br>
5) Upgrade to Drupal-6.25<br>
6) run update.php for Drupal-6<br>
7) Upgrade all modules to their D6 most recent versions<br>
8) Enable the contrib modules to ready them for update<br>
9) run update.php for Drupal-6 contrib modules.<br>
10) Upgrade to core Drupal-7.12<br>
11) Upgrade the contrib modules to their D7 most recent versions.<br>
12) run update.php for Drupal-7 core and contrib modules.<br>
<div class="im"><br>
> 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.<br>
><br>
> "PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'language' in 'where clause'...<br>
><br>
<br>
</div>These happen because the upgrade path is lost when upgrading to higher<br>
versions of core.<br>
<div class="im"><br>
> There is no column titled "language" in the nodes. I don't have a language or translation module loaded.<br>
><br>
> 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!!<br>
><br>
<br>
</div>Yea, don't work on the live site before you have it working in a dev<br>
site. This is a rather large undertaking and you want to make sure<br>
that the site works between update.php executions so that if something<br>
breaks you know which step broke it.<br>
<br>
Ping me off list if you need more help.<br>
<font color="#888888"><br>
--<br>
Earnie<br>
-- <a href="https://sites.google.com/site/earnieboyd" target="_blank">https://sites.google.com/site/earnieboyd</a><br>
</font><div><div></div><div class="h5">--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]</div></div></blockquote></div><br></div>