This is a common D5 -> D6 gotcha!<br><br>For general overview and details: <a href="http://drupal.org/node/132442">http://drupal.org/node/132442</a><br><br>Your problem (or one of them at any rate for sure) is here:<br>
<br><a href="http://drupal.org/node/132442#language-var">http://drupal.org/node/132442#language-var</a><br><br>"change every instance of <code>$language</code> to <code>$language->language</code>.
"<br><br>Victor Kane<br><a href="http://awebfactory.com.ar">http://awebfactory.com.ar</a><br><a href="http://projectflowandtracker.com">http://projectflowandtracker.com</a><br><br><div class="gmail_quote">On Sun, Nov 28, 2010 at 2:46 PM, Marty Landman <span dir="ltr"><<a href="mailto:mlandman@face2interface.com">mlandman@face2interface.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">I've upgraded a d5 site to d6 and now nothing's working. When I go to<br>
the user page to log on it says '4' where the content should go, and<br>
after going back to online mode via phpmyadmin queries all I get are<br>
page not found errors. Cleared the caches from phpmyadmin.<br>
<br>
The server error log shows nothing and the website error_log shows<br>
this a bunch of times:<br>
<br>
[28-Nov-2010 12:33:53] PHP Warning: Unknown column<br>
&#039;language&#039; in &#039;where clause&#039;<br>
query: SELECT src FROM drupal_url_alias WHERE dst =<br>
&#039;category/image-galleries/news&#039; AND language<br>
IN(&#039;en&#039;, &#039;&#039;) ORDER BY language DESC, pid DESC in<br>
/home/catskill/d6/includes/database.mysql.inc on line 128<br>
<br>
I ran update.php to update the databases after removing a bunch of<br>
unused modules /before upgrading, and the site was working well. I<br>
guess because of that the d6 db has 123 tables while the live site's<br>
db which I copied to make the d6 site has 132 - didn't notice that before.<br>
<br>
Any help appreciated, at a loss as to how to proceed. I upgraded all<br>
the modules and the themes before my site went to never never land.<br>
Now I'm stuck big time.<br>
<br>
Marty<br>
<font color="#888888"><br>
--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</font></blockquote></div><br>