Home » Forums » Support » Upgrading Drupal

Can anyone help me upgrade

·
michael2574661 - July 23, 2006 - 04:17

Hello all,

I am using drupal on my site at www.michael-and-mary.net

This is drupal ver 4.6.8. I would like to upgrade to the latest version - 4.7 but am unsuccessful in upgrading. The upgrade seems to go OK but I see ? all over, where the content should have been. If anyone can upgrade my content database from 4.6 to 4.7 such that I can install 4.7 and use the converted database, I will be thankful to you. I am offering Us $30 for this. Sorry, it ay be a little low, but that is all I can afford with a Taiwan salary.

If anyone is interested in helping me, please mail me at nicholson.robert@gmail.com so that I can give you the database.

Thanks and Regards,
Michael David.

» Login or register to post comments

Implemented modules

trantt - July 23, 2006 - 05:58

can you give us the list of modules that currently installed on your system right now?

Login or register to post comments

Here are the modules

michael2574661 - July 23, 2006 - 09:49

Thanks for your reply. The following modules are installed:

aggregator
archive
badbehavior
block
blog
blogapi
book
bookmarks
comment
contact
currency
currency_api
drupal
emailpage
feedback
filter
forum
frameprevention
help
htmlcorrector
image
image_exact
image_filter
img_assist
legacy
locale
menu
node
page
path
paypal_framework
paypal_tipjar
ping
poll
porterstemmer
print
privatemsg
profile
queue
quote
search
service_links
spam
spam_surbl
statistics
story
system
taxonomy
throttle
trackback_blackhole
tracker
upload
user
watchdog
weather

The problem is the update fails even with all the extra modules removed. Please help.

Login or register to post comments

charset problem?

yelvington - July 23, 2006 - 12:54

The upgrade seems to go OK but I see ? all over, where the content should have been.

4.7 expects UTF-8 character encoding. Check your database and make sure it is set to use UTF-8 as the default and UTF-8 for each of the tables.

If you don't have yours set up that way, first BACK UP YOUR DATA and then try running this code with your username, password and databasename replaced appropriately:

<?php
header('Content-type: text/plain;');
mysql_connect('localhost','username','password');
mysql_select_db('databasename');
$res = mysql_query("SHOW TABLES");
while ($r = mysql_fetch_array($res)){
  $tablename = $r[0];
  echo $sql = "ALTER TABLE $tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci";
  echo "\r\n";
mysql_query($sql);
}

Login or register to post comments

No good news on the conversion

michael2574661 - July 23, 2006 - 13:53

Thank you yelvington. During the update process, with your script, I got this:

--------------------------------------------------------------------------

ALTER TABLE access CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE accesslog CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE aggregator_category CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE aggregator_category_feed CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE aggregator_category_item CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE aggregator_feed CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE aggregator_item CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE authmap CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE bad_behavior_log CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE blocks CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE book CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE bookmarks CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE boxes CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE cache CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE client CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE client_system CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE comments CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE contact CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE directory CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE file_revisions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE files CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE filter_formats CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE filters CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE flood CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE forum CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE history CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE img_assist_map CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE locales_meta CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE locales_source CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE locales_target CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE menu CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE moderation_filters CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE moderation_roles CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE moderation_votes CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE node CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE node_access CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE node_comment_statistics CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE node_counter CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE node_revisions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE permission CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE poll CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE poll_choices CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE poll_votes CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE privatemsg CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE privatemsg_archive CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE privatemsg_folder CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE profile_fields CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE profile_values CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE queue CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE recipe CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE recipe_ingredients CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE role CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE search_dataset CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE search_index CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE search_total CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE sequences CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE sessions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE spam_custom CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE spam_log CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE spam_surbl_cctlds CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE spam_tokens CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE spam_tracker CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE system CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE term_data CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE term_hierarchy CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE term_node CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE term_relation CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE term_synonym CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE url_alias CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE users CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE users_roles CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE variable CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE vocabulary CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE vocabulary_node_types CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE watchdog CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
------------------------------------------------------------------------------------------------------------------------------------------

The result is a 'Page not found' [http://www.michael-and-mary.net/new-drup/]. What do I do now?

Login or register to post comments

MySql version number

trantt - July 23, 2006 - 14:56

what is your MySQL version number? The older version will fail at CHARACTER SET utf8 COLLATE utf8_general_ci.

Login or register to post comments

Thank you for your suggestions

michael2574661 - July 26, 2006 - 12:25

Thank you for your suggestions. I am presently installling PHP 5 and MySQL 5 and will then try. Will let everyone know how it went.

Login or register to post comments

Needs error checking

yelvington - July 28, 2006 - 13:58

The script would benefit from some error checking. :-)

Login or register to post comments

Upgrade 4.6 MySQL DBs with UTF8 data to 4.7 - this worked!

levavie - November 16, 2006 - 16:03

Follow this tip: http://drupal.org/node/84214
After a long search, it's the only thing which worked for me.

Amnon
-
Drupal Focused Search Engine | Drupal Israel | Organic Web Strategy Consulting

Login or register to post comments
 
 

Drupal is a registered trademark of Dries Buytaert.