upgrade problem from 5.x to 6.1 plz help ASAP !!!!!!!!!!!!!!!!!!!!!!
i am getting the following message
Warning: Unknown column 'serialized' in 'field list' query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'variables' in /home/desitcom/public_html/agrineer.org/includes/database.mysql.inc on line 128
Warning: Unknown column 'serialized' in 'field list' query: UPDATE cache SET data = 'a:127:{s:13:\"filter_html_1\";i:1;s:18:\"node_options_forum\";a:1:{i:0;s:6:\"status\";}s:15:\"install_profile\";s:7:\"default\";s:17:\"node_options_page\";a:1:{i:0;s:6:\"status\";}s:12:\"comment_page\";i:0;s:14:\"theme_settings\";a:1:{s:21:\"toggle_node_info_page\";b:0;}s:18:\"drupal_private_key\";s:64:\"0b3a220f93537d4240eea254e4b3a6d8675056fdd9bf529bc76d4150dbc6a961\";s:19:\"file_directory_temp\";s:4:\"/tmp\";s:19:\"file_directory_path\";s:5:\"files\";s:14:\"file_downloads\";s:1:\"1\";s:9:\"cron_last\";i:0;s:22:\"theme_ability_settings\";a:16:{s:11:\"toggle_logo\";i:1;s:11:\"toggle_name\";i:0;s:13:\"toggle_slogan\";i:0;s:14:\"toggle_mission\";i:0;s:24:\"toggle_node_us in /home/desitcom/public_html/agrineer.org/includes/database.mysql.inc on line 128
Home
Page not found
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /home/desitcom/public_html/agrineer.org/includes/menu.inc on line 315.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /home/desitcom/public_html/agrineer.org/includes/menu.inc on line 315.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /home/desitcom/public_html/agrineer.org/includes/menu.inc on line 315.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /home/desitcom/public_html/agrineer.org/includes/menu.inc on line 315.
* warning: Invalid argument supplied for foreach() in /home/desitcom/public_html/agrineer.org/includes/theme.inc on line 435.
* warning: Invalid argument supplied for foreach() in /home/desitcom/public_html/agrineer.org/includes/theme.inc on line 442.
* warning: Invalid argument supplied for foreach() in /home/desitcom/public_html/agrineer.org/includes/theme.inc on line 435.
* warning: Invalid argument supplied for foreach() in /home/desitcom/public_html/agrineer.org/includes/theme.inc on line 442.
* warning: Invalid argument supplied for foreach() in /home/desitcom/public_html/agrineer.org/includes/theme.inc on line 435.
* warning: Invalid argument supplied for foreach() in /home/desitcom/public_html/agrineer.org/includes/theme.inc on line 442.
* warning: Invalid argument supplied for foreach() in /home/desitcom/public_html/agrineer.org/includes/theme.inc on line 435.
* warning: Invalid argument supplied for foreach() in /home/desitcom/public_html/agrineer.org/includes/theme.inc on line 442.
* warning: Invalid argument supplied for foreach() in /home/desitcom/public_html/agrineer.org/includes/theme.inc on line 435.
* warning: Invalid argument supplied for foreach() in /home/desitcom/public_html/agrineer.org/includes/theme.inc on line 442.
* user warning: Unknown column 'serialized' in 'field list' query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'theme_registry:' in /home/desitcom/public_html/agrineer.org/includes/cache.inc on line 26.
* user warning: Unknown column 'serialized' in 'field list' query: UPDATE cache SET data = 'a:139:{s:24:\"block_admin_display_form\";a:7:{s:8:\"template\";s:38:\"modules/block/block-admin-display-form\";s:4:\"file\";s:29:\"modules/block/block.admin.inc\";s:9:\"arguments\";a:1:{s:4:\"form\";N;}s:4:\"type\";s:6:\"module\";s:10:\"theme path\";s:13:\"modules/block\";s:11:\"theme paths\";a:1:{i:0;s:13:\"modules/block\";}s:20:\"preprocess functions\";a:2:{i:0;s:19:\"template_preprocess\";i:1;s:44:\"template_preprocess_block_admin_display_form\";}}s:17:\"color_scheme_form\";a:6:{s:9:\"arguments\";a:1:{s:4:\"form\";N;}s:4:\"type\";s:6:\"module\";s:10:\"theme path\";s:13:\"modules/color\";s:8:\"function\";s:23:\"theme_color_scheme_form\";s:11:\"theme paths\& in /home/desitcom/public_html/agrineer.org/includes/cache.inc on line 109.
* user warning: Unknown column 'info' in 'field list' query: SELECT info FROM system WHERE type = 'theme' AND name = 'ability' in /home/desitcom/public_html/agrineer.org/modules/system/system.module on line 957.
* warning: array_map() [function.array-map]: Argument #2 should be an array in /home/desitcom/public_html/agrineer.org/modules/system/system.module on line 958.
* warning: array_keys() [function.array-keys]: The first argument should be an array in /home/desitcom/public_html/agrineer.org/includes/theme.inc on line 1712.
* warning: Invalid argument supplied for foreach() in /home/desitcom/public_html/agrineer.org/includes/theme.inc on line 1712.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /home/desitcom/public_html/agrineer.org/includes/menu.inc on line 315.
The requested page could not be found.
copyright@agrineer.org 2007-2008

i am upgrading from 4.7 to 6.2 and this happened:
Warning: Unknown column 'serialized' in 'field list' query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'variables' in /home/.drusilla/edreibs/rootsvisiondesign.com/includes/database.mysqli.inc on line 128
Warning: Unknown column 'serialized' in 'field list' query: UPDATE cache SET data = 'a:266:{s:13:\"theme_default\";s:10:\"bluemarine\";s:13:\"filter_html_1\";i:1;s:18:\"node_options_forum\";a:1:{i:0;s:6:\"status\";}s:17:\"menu_primary_menu\";i:2;s:19:\"menu_secondary_menu\";i:2;s:19:\"file_directory_temp\";s:4:\"/tmp\";s:9:\"site_name\";s:19:\"Roots Vision Design\";s:9:\"site_mail\";s:24:\"ed@rootsvisiondesign.com\";s:12:\"site_mission\";s:0:\"\";s:11:\"site_footer\";s:34:\"copyright 2006 Roots Vision Design\";s:9:\"anonymous\";s:19:\"some random asshole\";s:14:\"site_frontpage\";s:4:\"node\";s:8:\"site_404\";s:0:\"\";s:11:\"error_level\";s:1:\"1\";s:14:\"watchdog_clear\";s:7:\"1209600\";s:5:\"cache\";s:1:\"1\&quo in /home/.drusilla/edreibs/rootsvisiondesign.com/includes/database.mysqli.inc on line 128
step to 5
You need to take the intermediate step to 5
Please check this for more info: http://drupal.org/videocasts/upgrading-to-5
i tried to go back to 4.7
i tried to go back to 4.7 using the backups and although what i get looks like my site, logging in or clicking any link at all gives me non drupal 404 messages.
any clue about that?
clean urls
What is the clean url situation?
filemanager module
by going to /?q=admin/modules i could log in and it tells me i need the filemanager module, which i did and enabled but i still get 404's?
upgrading
When upgrading it's recommended to disable all contrib modules and themes and turn clean urls off.
would something about that
would something about that be in .htaccess? if so no
Warning. Enabling "Clean
Warning. Enabling "Clean URLs" if your server is not properly configured can make it difficult to navigate back to administration pages to undo your mistake. If you find yourself in this situation, you can return to the administrative settings page by typing in the URL in the 'non-clean' form: http://www.example.com/?q=admin/settings. --http://drupal.org/node/15365
Read carefully the upgrade process. http://drupal.org/upgrade/
thx
thx