I've upgraded a d5 site to d6 and now nothing's working. When I go to the user page to log on it says '4' where the content should go, and after going back to online mode via phpmyadmin queries all I get are page not found errors. Cleared the caches from phpmyadmin.
The server error log shows nothing and the website error_log shows this a bunch of times:
[28-Nov-2010 12:33:53] PHP Warning: Unknown column 'language' in 'where clause' query: SELECT src FROM drupal_url_alias WHERE dst = 'category/image-galleries/news' AND language IN('en', '') ORDER BY language DESC, pid DESC in /home/catskill/d6/includes/database.mysql.inc on line 128
I ran update.php to update the databases after removing a bunch of unused modules /before upgrading, and the site was working well. I guess because of that the d6 db has 123 tables while the live site's db which I copied to make the d6 site has 132 - didn't notice that before.
Any help appreciated, at a loss as to how to proceed. I upgraded all the modules and the themes before my site went to never never land. Now I'm stuck big time.
Marty
Did you change the theme to a built-in standard like Garland before you brought up the new code with the old database? I always turn off non-core modules and switch the theme to one supplied with the D6 base code first.
-Don-
On 11/28/2010 12:46 PM, Marty Landman wrote:
I've upgraded a d5 site to d6 and now nothing's working. When I go to the user page to log on it says '4' where the content should go, and after going back to online mode via phpmyadmin queries all I get are page not found errors. Cleared the caches from phpmyadmin.
The server error log shows nothing and the website error_log shows this a bunch of times:
[28-Nov-2010 12:33:53] PHP Warning: Unknown column 'language' in'where clause' query: SELECT src FROM drupal_url_alias WHERE dst = 'category/image-galleries/news' AND language IN('en','') ORDER BY language DESC, pid DESC in /home/catskill/d6/includes/database.mysql.inc on line 128
I ran update.php to update the databases after removing a bunch of unused modules /before upgrading, and the site was working well. I guess because of that the d6 db has 123 tables while the live site's db which I copied to make the d6 site has 132 - didn't notice that before.
Any help appreciated, at a loss as to how to proceed. I upgraded all the modules and the themes before my site went to never never land. Now I'm stuck big time.
Marty
No Don, didn't do that.
So I reinstalled D5, set Garland as the default theme and then disabled all the contrib modules. The site was working, and then I reverted to D6 and still the site's giving page not found errors.
[28-Nov-2010 16:30:23] PHP Warning: Unknown column 'language' in 'where clause' query: SELECT src FROM drupal_url_alias WHERE dst = 'node' AND language IN('en', '') ORDER BY language DESC, pid DESC in /home/catskill/d6/includes/database.mysql.inc on line 128 [28-Nov-2010 16:31:08] PHP Warning: Unknown column 'language' in 'where clause' query: SELECT src FROM drupal_url_alias WHERE dst = 'user' AND language IN('en', '') ORDER BY language DESC, pid DESC in /home/catskill/d6/includes/database.mysql.inc on line 128
Marty
At 01:29 PM 11/28/2010, Don wrote:
Did you change the theme to a built-in standard like Garland before you brought up the new code with the old database? I always turn off non-core modules and switch the theme to one supplied with the D6 base code first.
-Don-
On 11/28/2010 12:46 PM, Marty Landman wrote:
I've upgraded a d5 site to d6 and now nothing's working. When I go to the user page to log on it says '4' where the content should go, and after going back to online mode via phpmyadmin queries all I get are page not found errors. Cleared the caches from phpmyadmin.
The server error log shows nothing and the website error_log shows this a bunch of times:
[28-Nov-2010 12:33:53] PHP Warning: Unknown column 'language' in'where clause' query: SELECT src FROM drupal_url_alias WHERE dst = 'category/image-galleries/news' AND language IN('en','') ORDER BY language DESC, pid DESC in /home/catskill/d6/includes/database.mysql.inc on line 128
I ran update.php to update the databases after removing a bunch of unused modules /before upgrading, and the site was working well. I guess because of that the d6 db has 123 tables while the live site's db which I copied to make the d6 site has 132 - didn't notice that before.
Any help appreciated, at a loss as to how to proceed. I upgraded all the modules and the themes before my site went to never never land. Now I'm stuck big time.
Marty
-- [ Drupal support list | http://lists.drupal.org/ ]
This is a common D5 -> D6 gotcha!
For general overview and details: http://drupal.org/node/132442
Your problem (or one of them at any rate for sure) is here:
http://drupal.org/node/132442#language-var
"change every instance of $language to $language->language. "
Victor Kane http://awebfactory.com.ar http://projectflowandtracker.com
On Sun, Nov 28, 2010 at 2:46 PM, Marty Landman mlandman@face2interface.comwrote:
I've upgraded a d5 site to d6 and now nothing's working. When I go to the user page to log on it says '4' where the content should go, and after going back to online mode via phpmyadmin queries all I get are page not found errors. Cleared the caches from phpmyadmin.
The server error log shows nothing and the website error_log shows this a bunch of times:
[28-Nov-2010 12:33:53] PHP Warning: Unknown column 'language' in 'where clause' query: SELECT src FROM drupal_url_alias WHERE dst = 'category/image-galleries/news' AND language IN('en', '') ORDER BY language DESC, pid DESC in /home/catskill/d6/includes/database.mysql.inc on line 128
I ran update.php to update the databases after removing a bunch of unused modules /before upgrading, and the site was working well. I guess because of that the d6 db has 123 tables while the live site's db which I copied to make the d6 site has 132 - didn't notice that before.
Any help appreciated, at a loss as to how to proceed. I upgraded all the modules and the themes before my site went to never never land. Now I'm stuck big time.
Marty
-- [ Drupal support list | http://lists.drupal.org/ ]
-
Don -
Marty Landman -
Victor Kane