Hello,

As a volunteer I developed a site in Drupal 6.22 (www.vvwaspik.nl). I would like to upgrade this site to Drupal 7.9. I tried to do it manually and must say I did not succeed. There were issues on images, panels did not show up etc. I figured it could not be so that upgrading a site would mean so much work. After upgrading the core and some modules it seemed like I had to correct lots of content items and views and what more .....
Then I read about DRUSH. Installed it and tried updates on my Drupal 6.22 site. I was amazed. It was a breeze. First time all modules were up to date. So I want to use DRUSH for upgrading.
I spend some time to get the upgrade starting to do its job. Now it does start I get some errors which I can not resolve without help. I thought it would be a good idea to document my findings and journey to do the upgrade so others can benefit from it. I am a user who needs detailed steps although I know something about computer, programming, office programs and the like. I think I can make a rather detailed description of what I do.
I do hope I will get support which will lead to an upgraded site and a detailed 'manual' for upgrading a site on a machine running Windows XP.

Comments

PvO’s picture

  • I dowloaded the windows installer and installed Drush in "D:\Program Files\Propeople\Drush"
  • As a result I have files in "C:\Documents and Settings\All Users\Application Data\Propeople\Drush"
  • From "example.aliases.drushrc.php" in "C:\Documents and Settings\All Users\Application Data\Propeople\Drush\examples" I created the file "aliases.drushrc.php" with the following content:
<?php
$aliases['targetsite'] = array( 
'uri' => 'http://127.0.0.1/vvwaspik7.html',
'root' => 'D:\xampp\waspik7',
)
?>
  • The file "aliases.drushrc.php" is in the root "D:\xampp\htdocs" of my site
  • I did not make any changes to the PATH environment
  • I execute DRUSH from the root ("D:\xampp\htdocs") of my Drupal site.
  • The output of DRUSH status is:
D:\xampp\htdocs>drush status
 Drupal version         :  6.22
 Site URI               :  http://default
 Database driver        :  mysql
 Database hostname      :  127.0.0.1
 Database username      :  pvo
 Database name          :  vvwaspik_drup1
 Database               :  Connected
 Drupal bootstrap       :  Successful
 Drupal user            :  Anoniem
 Default theme          :  pixture_reloaded
 Administration theme   :  pixture_reloaded
 PHP configuration      :  D:\Program Files\Propeople\Drush\Php\php.ini
 Drush version          :  5.0-dev
 Drush configuration    :
 Drush alias files      :  /xampp/htdocs/aliases.drushrc.php
                           D:/xampp/htdocs/aliases.drushrc.php
 Drupal root            :  D:/xampp/htdocs
 Site path              :  sites/default
 File directory path    :  sites/default/files


D:\xampp\htdocs>
PvO’s picture

For paths an versions see the description on DRUSH (status)
The settings.php file contains:

$db_url = 'mysql://pvo:waspik@127.0.0.1/vvwaspik_drup1';
$db_prefix = 'waspik_';
$base_url = 'http://127.0.0.1';  // NO trailing slash!

I enabled:

D:\xampp\htdocs>drush pml --no-core --status=enabled
 Package         Naam                                       Type    Versie

 Access control  ACL (acl)                                  Module  6.x-1.4

 Access control  Content Access (content_access)            Module  6.x-1.2

 Access control  Forum Access (forum_access)                Module  6.x-1.7

 Administration  Administration menu (admin_menu)           Module  6.x-1.8

 Administration  Fasttoggle (fasttoggle)                    Module  6.x-1.4

 Andere          Account menu (accountmenu)                 Module  6.x-1.x-dev

 Andere          AddToAny (addtoany)                        Module  6.x-3.4

 Andere          Advanced help (advanced_help)              Module  6.x-1.2

 Andere          Advanced help example (help_example)       Module  6.x-1.2

 Andere          Alternate Login (alt_login)                Module  6.x-1.2

 Andere          Backup and Migrate (backup_migrate)        Module  6.x-2.4

 Andere          Backup and Migrate Files                   Module  6.x-1.x-dev

                 (backup_migrate_files)

 Andere          Dynamic display block (ddblock)            Module  6.x-1.0-rc6

 Andere          Insert (insert)                            Module  6.x-1.1

 Andere          Job Scheduler (job_scheduler)              Module  6.x-1.0-bet

                                                                    a3

 Andere          Lightbox2 (lightbox2)                      Module  6.x-1.11

 Andere          Pathauto (pathauto)                        Module  6.x-1.6

 Andere          Poormanscron (poormanscron)                Module  6.x-2.2

 Andere          RealName (realname)                        Module  6.x-1.4

 Andere          Splash (splash)                            Module  6.x-2.7

 Andere          Token (token)                              Module  6.x-1.18

 Andere          User Import (user_import)                  Module  6.x-2.4

 CCK             Content (content)                          Module  6.x-3.x-dev

 CCK             Content Copy (content_copy)                Module  6.x-3.x-dev

 CCK             Content Permissions (content_permissions)  Module  6.x-3.x-dev

 CCK             Content Templates (contemplate)            Module  6.x-1.2

 CCK             Fieldgroup (fieldgroup)                    Module  6.x-3.x-dev

 CCK             FileField (filefield)                      Module  6.x-3.10

 CCK             ImageField (imagefield)                    Module  6.x-3.10

 CCK             LinkImage (linkimagefield)                 Module  6.x-1.0-bet

                                                                    a2

 CCK             Node Reference (nodereference)             Module  6.x-3.x-dev

 CCK             Node Reference URL Widget                  Module  6.x-1.11

                 (nodereference_url)

 CCK             Number (number)                            Module  6.x-3.x-dev

 CCK             Option Widgets (optionwidgets)             Module  6.x-3.x-dev

 CCK             Text (text)                                Module  6.x-3.x-dev

 CCK             User Reference (userreference)             Module  6.x-3.x-dev

 Chaos tool      Bulk Export (bulk_export)                  Module  6.x-1.8

 suite

 Chaos tool      Chaos tools (ctools)                       Module  6.x-1.8

 suite

 Chaos tool      Chaos Tools (CTools) Plugin Example        Module  6.x-1.8

 suite           (ctools_plugin_example)

 Chaos tool      Custom content panes                       Module  6.x-1.8

 suite           (ctools_custom_content)

 Chaos tool      Page manager (page_manager)                Module  6.x-1.8

 suite

 Chaos tool      Views content panes (views_content)        Module  6.x-1.8

 suite

 Date/Time       Calendar (calendar)                        Module  6.x-2.4

 Date/Time       Calendar Multiday (calendar_multiday)      Module  6.x-2.4

 Date/Time       Calendar Popup (jcalendar)                 Module  6.x-2.4

 Date/Time       Date (date)                                Module  6.x-2.7

 Date/Time       Date API (date_api)                        Module  6.x-2.7

 Date/Time       Date Locale (date_locale)                  Module  6.x-2.7

 Date/Time       Date PHP4 (date_php4)                      Module  6.x-2.7

 Date/Time       Date Popup (date_popup)                    Module  6.x-2.7

 Date/Time       Date Repeat API (date_repeat)              Module  6.x-2.7

 Date/Time       Date Timezone (date_timezone)              Module  6.x-2.7

 Date/Time       Date Tools (date_tools)                    Module  6.x-2.7

 Drupalace       Twitter Profile Widget                     Module  6.x-1.6

                 (twitter_profile_widget)

 Feeds           Feeds (feeds)                              Module  6.x-1.0-bet

                                                                    a11

 Feeds           Feeds Admin UI (feeds_ui)                  Module  6.x-1.0-bet

                                                                    a11

 Feeds           Feeds Import (feeds_import)                Module  6.x-1.0-bet

                                                                    a11

 Guestbook       Drupal Guestbook (dgb)                     Module  6.x-1.3

 Image           Image (image)                              Module  6.x-1.1

 Image           Image Attach (image_attach)                Module  6.x-1.1

 Image           Image Gallery (image_gallery)              Module  6.x-1.1

 Image           Image Import (image_import)                Module  6.x-1.1

 Image           ImageMagick Advanced Options               Module  6.x-1.1

                 (image_im_advanced)

 ImageCache      ImageAPI (imageapi)                        Module  6.x-1.10

 ImageCache      ImageAPI GD2 (imageapi_gd)                 Module  6.x-1.10

 ImageCache      ImageCache (imagecache)                    Module  6.x-2.0-bet

                                                                    a12

 ImageCache      ImageCache UI (imagecache_ui)              Module  6.x-2.0-bet

                                                                    a12

 Input filters   Image resize filter (image_resize_filter)  Module  6.x-1.13

 Location        Google Maps location (gmaplocation)        Module  6.x-2.0

 Media           Brilliant Gallery (brilliant_gallery)      Module  6.x-4.0

 Multilanguage   Localization update (l10n_update)          Module  6.x-1.0-bet

                                                                    a1

 Other           IP address manager (ip)                    Module  6.x-1.1

 Panels          Mini panels (panels_mini)                  Module  6.x-3.9

 Panels          Panel nodes (panels_node)                  Module  6.x-3.9

 Panels          Panels (panels)                            Module  6.x-3.9

 Panels          Panels In-Place Editor (panels_ipe)        Module  6.x-3.9

 Spam control    CAPTCHA (captcha)                          Module  6.x-2.4

 Spam control    KeyCAPTCHA (keycaptcha)                    Module  6.x-2.0

 User interface  CKEditor (ckeditor)                        Module  6.x-1.8

 User interface  jQuery UI (jquery_ui)                      Module  6.x-1.5

 User Interface  jQuery Update (jquery_update)              Module  6.x-1.1

 Views           Views (views)                              Module  6.x-2.16

 Views           Views attach (views_attach)                Module  6.x-2.2

 Views           Views Data Export (views_data_export)      Module  6.x-2.0-bet

                                                                    a5

 Views           Views exporter (views_export)              Module  6.x-2.16

 Views           Views Slideshow (views_slideshow)          Module  6.x-2.3

 Views           Views slideshow: DDblock                   Module  6.x-1.1

                 (views_slideshow_ddblock)

 Views           Views Slideshow: SingleFrame               Module  6.x-2.3

                 (views_slideshow_singleframe)

 Views           Views Slideshow: ThumbnailHover            Module  6.x-2.3

                 (views_slideshow_thumbnailhover)

 Views           Views UI (views_ui)                        Module  6.x-2.16

 Voting          Fivestar (fivestar)                        Module  6.x-1.19

 Voting          Fivestar Comments (fivestar_comment)       Module  6.x-1.19

 Voting          Voting API (votingapi)                     Module  6.x-2.3

 Andere          Pixture Reloaded (pixture_reloaded)        Theme   6.x-3.2

The word "Andere" is Dutch for 'Other'.

PvO’s picture

I did not create a directory, nore did I create a database. According to what I read it is not necessary to do that.

So I execute the command "drush site-upgrade @targetsite" (shorthand "drush sup @targetsite")
Windows-users: Wait for the execution, it may take some time...
The output before the question to proceed gives:

D:\xampp\htdocs>drush sup @targetsite
 Project         Titel                Installed  Available      Status

 acl             ACL                  6.x-1.4    7.x-1.0        Recommended
 content_access  Content Access       6.x-1.2    7.x-1.2-beta1  Recommended
 forum_access    Forum Access         6.x-1.7    7.x-1.0-beta1  Supported
 admin_menu      Administration menu  6.x-1.8    7.x-3.0-rc1    Recommended
 fasttoggle      Fasttoggle           6.x-1.4    7.x-1.0-beta2  Supported
 accountmenu     Account menu         6.x-1.x-d  -              NO 7.x RELEASES 
 addtoany        AddToAny             6.x-3.4    7.x-3.1        Recommended
 advanced_help   Advanced help        6.x-1.2    7.x-1.0        Recommended
                 example
 alt_login       Alternate Login      6.x-1.2    7.x-1.0        Recommended
 backup_migrate  Backup and Migrate   6.x-2.4    7.x-2.2        Recommended
 backup_migrate_files  Backup and Migrate Files  6.x-1.x-d  7.x-1.x-dev    Supported,Development                                                  

 ddblock         Dynamic display block      6.x-1.0-r  7.x-1.0        Recommended
 insert          Insert               6.x-1.1    7.x-1.1        Recommended
 job_scheduler   Job Scheduler        6.x-1.0-b  7.x-2.0-alpha  Supported
 lightbox2       Lightbox2            6.x-1.11   7.x-1.0-beta1  Recommended
 pathauto        Pathauto             6.x-1.6    7.x-1.0        Recommended
 realname        RealName             6.x-1.4    7.x-1.0-rc2    Recommended
 splash          Splash               6.x-2.7    -              NO 7.x RELEASES
 token           Token                6.x-1.18   7.x-1.0-beta7  Recommended
 user_import     User Import          6.x-2.4    -              NO 7.x RELEASES
 cck             User Reference       6.x-3.x-d  7.x-2.x-dev    Supported,Devel
                                      ev                        opment
 contemplate     Content Templates    6.x-1.2    7.x-1.0-rc3
 linkimagefield  LinkImage            6.x-1.0-b  -              NO 7.x RELEASES
                                      eta2
 nodereference_  Node Reference URL   6.x-1.11   7.x-1.12       Recommended
 url             Widget
 ctools          Views content panes  6.x-1.8    7.x-1.0-rc1    Recommended
 calendar        Calendar Popup       6.x-2.4    7.x-3.0-alpha  Recommended
                                                1
 date            Date Tools           6.x-2.7    7.x-2.0-alpha  Recommended
                                                 4
 twitter_profil  Twitter Profile      6.x-1.6    7.x-1.6        Recommended
 e_widget        Widget
 feeds           Feeds Import         6.x-1.0-b  7.x-2.0-alpha  Recommended
                                      eta11      4
 dgb             Drupal Guestbook     6.x-1.3    -              NO 7.x RELEASES
 image           ImageMagick          6.x-1.1    7.x-1.x-dev    Supported,Devel
                 Advanced Options                               opment
 image_resize_f  Image resize filter  6.x-1.13   7.x-1.13       Recommended
 ilter
 gmaplocation    Google Maps          6.x-2.0    -              NO 7.x RELEASES
                 location
 brilliant_gall  Brilliant Gallery    6.x-4.0    7.x-1.0        Recommended
 ery
 l10n_update     Localization update  6.x-1.0-b  7.x-1.0-beta2  Recommended
                                      eta1
 ip              IP address manager   6.x-1.1    7.x-1.3        Recommended
 panels          Panels In-Place      6.x-3.9    7.x-3.0-alpha  Recommended
                 Editor                          3
 captcha         CAPTCHA              6.x-2.4    7.x-1.0-beta1  Supported
 keycaptcha      KeyCAPTCHA           6.x-2.0    7.x-1.2        Supported
 ckeditor        CKEditor             6.x-1.8    7.x-1.6        Recommended
 jquery_update   jQuery Update        6.x-1.1    7.x-2.2        Recommended
 views           Views UI             6.x-2.16   7.x-3.0-rc3    Recommended
 views_attach    Views attach         6.x-2.2    -              NO 7.x RELEASES
 views_data_exp  Views Data Export    6.x-2.0-b  7.x-3.0-beta5  Supported
 ort                                  eta5
 views_slidesho  Views Slideshow:     6.x-2.3    7.x-3.0        Recommended
 w               ThumbnailHover
 views_slidesho  Views slideshow:     6.x-1.1    7.x-2.x-dev    Supported,Devel
 w_ddblock       DDblock                                        opment
 fivestar        Fivestar Comments    6.x-1.19   7.x-2.0-alpha  Recommended
                                                 1
 votingapi       Voting API           6.x-2.3    7.x-2.4        Recommended

The following contrib modules were enabled in your Drupal site, but         [ok]
are now standard in core: poormanscron, filefield, imagefield,
date_timezone, imageapi, imageapi_gd, imagecache, imagecache_ui,
jquery_ui.  These modules may need to be reconfigured after the
upgrade is complete.
You are using the project token, which requires data migration or      [warning]
other special processing.  In Drupal 7, the contrib token module
handles UI, as well as field and profile tokens; all other
functionality has been migrated to core.
You are using the project cck, which requires data migration or other  [warning]
special processing.  Please see http://drupal.org/project/cck and
http://drupal.org/node/895314 for more information on how to do this.
You are using the project filefield, which requires data migration or  [warning]
other special processing.  Data migration for this module will be
provided by the Content Migrate submodule of cck.  Enable
content_migrate after upgrading; see http://drupal.org/node/781088.
You are using the project imagefield, which requires data migration    [warning]
or other special processing.  Data migration for this module will be
provided by the Content Migrate submodule of cck.  Enable
content_migrate after upgrading; see http://drupal.org/node/781088.
You are using the project date, which requires data migration or       [warning]
other special processing.  The d6 version of the date_api module in
the date project defines a table called date_formats, which is also
defined by system/system.install schema in d7.  If this problem has
not been fixed yet, then the updatedb function will fail, and it will
not be possible to upgrade to d7.  If this happens, disable and
uninstall the date_api module before running site-upgrade (i.e. add
'--uninstall=date_api' to site-upgrade call).  See
http://drupal.org/node/1013034.
Would you like to continue anyway? (y/n):

So I press y and and now I will split the output:

Project drupal (7.9) downloaded to D:\xampp/waspik7.                   [success]

Project drupal contains:                                               [success]

 - 3 profiles: testing, standard, minimal
 - 4 themes: stark, seven, garland, bartik
 - 47 modules: drupal_system_listing_incompatible_test,
drupal_system_listing_compatible_test, user, update, trigger,
translation, tracker, toolbar, taxonomy, system, syslog, statistics,
simpletest, shortcut, search, rdf, profile, poll, php, path, overlay,
openid, node, menu, locale, image, help, forum, filter, file,
field_ui, text, options, number, list, field_sql_storage, field,
dblog, dashboard, contextual, contact, comment, color, book, blog,
block, aggregator

Now that is allright.
But then (Issue 1):

The system cannot find the path specified.
The system cannot find the file specified.

I really do not know which path and which file. So I need help on this!
And then (Issue 2):

You will destroy data from db and replace with data from vvwaspik_drup1.

You might want to make a backup first, using the sql-dump command.

Do you really want to continue? (y/n): y

Well, I can not interrupt so I do not understand why this question is there. Or can I interrupt?
And then (Issue 3):

'mysqldump' is not recognized as an internal or external command,
operable program or batch file.

I do not know how to make this 'mysqldump' an internal or external command. I read nothing about it. So I need to know how to enable 'mysqldump'.
And then (Issue 4):

The system cannot find the file specified.

I do not know which specified file?
And then (Issue 5):

Command site-upgrade-prepare needs a higher bootstrap level to run -     [error]

you will need invoke drush from a more functional Drupal environment
to run this command.

This is abacadabra for me. So i need help here as well!
And then (Issue 6):

The drush command 'site-upgrade-prepare acl content_access               [error]
forum_access admin_menu fasttoggle accountmenu addtoany advanced_help
help_example alt_login backup_migrate backup_migrate_files ddblock
insert job_scheduler lightbox2 pathauto poormanscron realname splash
token user_import content content_copy content_permissions
contemplate fieldgroup filefield imagefield linkimagefield
nodereference nodereference_url number optionwidgets text
userreference bulk_export ctools ctools_plugin_example
ctools_custom_content page_manager views_content calendar
calendar_multiday jcalendar date date_api date_locale date_php4
date_popup date_repeat date_timezone date_tools
twitter_profile_widget feeds feeds_ui feeds_import dgb image
image_attach image_gallery image_import image_im_advanced imageapi
imageapi_gd imagecache imagecache_ui image_resize_filter gmaplocation
brilliant_gallery l10n_update ip panels_mini panels_node panels
panels_ipe captcha keycaptcha ckeditor jquery_ui jquery_update views
views_attach views_data_export views_export views_slideshow
views_slideshow_ddblock views_slideshow_singleframe
views_slideshow_thumbnailhover views_ui fivestar fivestar_comment
votingapi pixture_reloaded' could not be executed.

Well this is probably the same problem as the one before. Is it?
And then a bootstrap failure again (Issue 7):

Drush was not able to start (bootstrap) the Drupal database.             [error]

Hint: This error often occurs when Drush is trying to bootstrap a
site that has not been installed or does not have a configured
database.

Well, I thought the upgrade is going to install my site and configure my database.
So i need help on this one too.
Then the last part which belongs to the one just before here:

Drush was attempting to connect to :
  Drupal version    : 6.22
  Site URI          : db
  Database driver   : mysql
  Database hostname : 127.0.0.1
  Database username : pvo
  Database name     : db
  Default theme     : garland
  Administration theme: garland
  PHP configuration : D:\Program Files\Propeople\Drush\Php\php.ini
  Drush version     : 5.0-dev
  Drush configuration:
  Drush alias files : /xampp/htdocs/aliases.drushrc.php
D:/xampp/htdocs/aliases.drushrc.php
  Drupal root       : D:/xampp/htdocs
  Site path         : sites/db
  Modules path      : sites/all/modules
  Themes path       : sites/all/themes
  %paths            : Array

You can select another site with a working database setup by
specifying the URI to use with the --uri parameter on the command
line or $options['uri'] in your drushrc.php file.

So, it was not just "a push on a button and voila". Did not expect it to be. But there will be lots of people starting a site on Drupal running into likewise problems trying to upgrade a site. Let us try and do something about it.

Thanks for helping me (and probably others!)

PvO’s picture

  1. A new directory "D:\xampp\waspik7"
  2. A settings.php file which contains:
$db_url = 'mysql://pvo:waspik@127.0.0.1/vvwaspik_drup1';
$db_prefix = 'waspik_';
$base_url = 'http://127.0.0.1;  // NO trailing slash!

which is the same as in the Drupal 6 site. I expected a database with name 'waspik7'

I see no new database.

PvO’s picture

As if figured lots of warnings and errors in the first attempt where related to the database I changed the "aliases.drushrc.php" by adding a line for the database. Now it is:

<?php
$aliases['targetsite'] = array( 
'uri' => 'http://127.0.0.1/vvwaspikd7.html',
'root' => 'D:\xampp\waspikd7',
'db-url' => 'mysql://pvo:waspik@127.0.0.1/vvw_drup7',
)
?>

I created a database called 'vvw_drup7' by means of phphadmin. No tables.
As you see I made a little change to the 'uri' and 'root'. I added a 'd' before the 7. Just to know this is about Drupal 7.

The last part of the output is (the first part of the ouput is the same):

The system cannot find the path specified.
The system cannot find the file specified.

You will destroy data from vvw_drup7 and replace with data from vvwaspik_drup1.

You might want to make a backup first, using the sql-dump command.

Do you really want to continue? (y/n): y
'mysqldump' is not recognized as an internal or external command,
operable program or batch file.
The system cannot find the file specified.
Table &#039;vvw_drup7.waspik_access&#039; doesn&#039;t exist           [warning]

query: SELECT 1 FROM waspik_access WHERE type = &#039;host&#039; AND
LOWER(&#039;127.0.0.1&#039;) LIKE LOWER(mask) AND status = 0 LIMIT 0,
1 database.mysql.inc:135
Table &#039;vvw_drup7.waspik_cache&#039; doesn&#039;t exist            [warning]

query: SELECT data, created, headers, expire, serialized FROM
waspik_cache WHERE cid = &#039;variables&#039; database.mysql.inc:135
Table &#039;vvw_drup7.waspik_variable&#039; doesn&#039;t exist         [warning]

query: SELECT * FROM waspik_variable database.mysql.inc:135
Table &#039;vvw_drup7.waspik_cache&#039; doesn&#039;t exist            [warning]

query: UPDATE waspik_cache SET data = &#039;&#039;, created =
1322379827, expire = 0, headers = &#039;&#039;, serialized = 0 WHERE
cid = &#039;variables&#039; database.mysql.inc:135
Table &#039;vvw_drup7.waspik_system&#039; doesn&#039;t exist           [warning]

query: SELECT name, filename, throttle FROM waspik_system WHERE type
= &#039;module&#039; AND status = 1 AND bootstrap = 1 ORDER BY weight
ASC, filename ASC database.mysql.inc:135
Table &#039;vvw_drup7.waspik_url_alias&#039; doesn&#039;t exist        [warning]

query: SELECT COUNT(pid) FROM waspik_url_alias database.mysql.inc:135
Drush command terminated abnormally due to an unrecoverable error.       [error]

Error: Call to undefined function filter_xss() in
D:\xampp\htdocs\includes\common.inc, line 655

So some things are better, but still some problems.

PvO’s picture

There are no tables in vvw_drup7. Probably due to the 'mysqldump' problem.
I ask myself wether this has something to do with the PATH environment.
Also no new modules were downloaded, but maybe this would have been done in a later part of the process.

john_b’s picture

Upgrading is a pain. One of the big downsides of Drupal. Sounds like it is no easier with drush than without....

Digit Professionals specialising in Drupal, WordPress & CiviCRM support for publishers in non-profit and related sectors

PvO’s picture

Can't we 'all together' make it work?

Is the structure I use all right. I mean putting the d7 site in D:\xampp\waspikd7.
Should I be able to see it by means of "localhost\waspikd7" in the addressbar of my browser?

Thanks for answering. I'll try youre 'output' tip next time.

PvO’s picture

I must say my first attempt updating Drupal 6,22 site worked perfectly. So we must make upgrading work. I am not a professional website builder, but I managed to come this far. So please help me do the 'trick'.

PvO’s picture

As I had a dump of my Drupal 6.22 database I decided to import it in the database vvw_drup7. All tables were created and data inserted except for the tables cache_menu and cache_update. As they are cache tables (and gave troubles importing) I left them empty.

I started the upgrade and wow ...... was this the upgrade I waited for. I asked myself: "How do I catch this output of DRUSH? Can't read it and can't copy and paste it because lots of lines are gone." But then, after a minute or so (maybe two) the upgrade stopped. I waited some more to be sure. There was this cursor flickering. Nothing happens anymore. No warning, no error. This is the output at that moment:

votingapi module :
  7201 -   Renaming the 'content_type' and 'content_id' columns to entity_type a
nd entity_id.  Reduces confusion about 'content types' versus 'node types'.

Do you wish to run all pending updates? (y/n): y
Performing pathauto_update_6200                                             [ok]
Performing pathauto_update_6201                                             [ok]
Performing pathauto_update_6202                                             [ok]
Performing pathauto_update_7000                                             [ok]
Performing feeds_update_7100                                                [ok]
Performing feeds_update_7201                                                [ok]
Performing pathauto_update_7001                                             [ok]
Performing feeds_update_7202                                                [ok]
| (cursor flickering here)

Oh, by the way: I did not answer the question about "run all pending update?"

Well, what to do now?

john_b’s picture

drush --debug --pipe > /path/to/logfile.txt
maybe?

Digit Professionals specialising in Drupal, WordPress & CiviCRM support for publishers in non-profit and related sectors

PvO’s picture

I looked at the Task manager and there were processes running like:
php.exe consuming about 45% CPU
another 3 php.exe switching from 0% to about 7%
mysqld.exe about 7%
system idle about 47%

Lots of modules were in D:\xampp\waspikd7\modules. So that is nice!

In settings.php no pointer to vvw_drup7, but maybe that is because the process was not finished.

I wonder wehter it is the feeds of pathauto module what is causing the problem. I would think it will be feeds.

Finally I killed one of the "idle" php.exe processes, looked at DRUSH and s h o c k: the process had resumed, but was it before or after killing one php.exe process in the Task Manager.

The (last part of the) output now is:

number is already enabled.                                                  [ok]
text is already enabled.                                                    [ok]
garland is already enabled.                                                 [ok]
No release history was found for the requested project                 [warning]
(node_reference).
Module nodereference_url cannot be enabled because it depends on the     [error]
following modules which could not be found: node_reference

Well, I have to test if something works on the d7 site.....

PvO’s picture

Well, no working site.
I do get a page header and a working ddblock banner and then a page not found message. I can not recall where the page com from.
I entered localhost/waspikd7 in the adressbar.

I changed the settings.php to

$db_url = 'mysql://pvo:waspik@127.0.0.1/vvw_drup7';
$db_prefix = 'waspik_';
$base_url = 'http://127.0.0.1/waspikd7';  // NO trailing slash!

Hm, I think I will need a (big) pause. Feels like I am stuck in the middle of nowhere.......

PvO’s picture

I first tried a standard Drupal 7 install in htdocs and it worked.
Then I moved the waspikd7 folder to htdocs and now I get my 'homepage' when entering "localhost/waspikd7" in the address bar.
I will report later about the status of the upgrade.

PvO’s picture

The list of themes is not available. When trying to get to "http://127.0.0.1/waspikd7/admin/build/themes" i get the warning:
Warning: call_user_func_array() expects parameter 1 to be a valid callback, function 'system_themes_form' not found or invalid function name in drupal_retrieve_form() (line 785 of D:\xampp\htdocs\waspikd7\includes\form.inc).

On my live site www.vvwaspik.nl I use Pixture Reloaded with Superfish Drop Menus enabled. In the Garland theme these dropdown do not show up and I do not even know how to get to them.

Well, maybe it is a good idea to disable and uninstall all modules in Drupal 6.22 which do not have a Drupal 7 version. Lik you have to do when upgrading manually. I recon I can not use the data of these modules.
Also I think it is better to disable (maybe uninstall) Pixture Reloaded. All menu-items will still be there I hope so when I reistall Pixture Reloaded it should work again.

I must say in comparison with manually upgrading now all "7 modules" are in the list. I left some '6 modules' while manually upgrading because I thought they were needed. Then after the upgrade I could not remove them (maybe it could have been done in the database, but that is not the way I wanted it to do).

So, I think I will have to prepare a fourth attempt.

Is someone following me and interested in this 'journal'?

PvO’s picture

Well, I decided to upgrade after 'stripping' my Drupal 6.22 site. This 'stripping' means:

1. Disable and unistall all modules incompatable with Drupal 7. In my site they were:

  • Account-menu
  • Splash
  • User-import
  • Linkimagefield
  • dgb Drupal Guestbook
  • gmaplocation Google Maps Location
  • views_attach Views attach

2. Disable and uninstall CKEditor and WYSIWYG
3.CKEditor gave troubles while updating in 6.22. I think they both can pretty easily be re-installed in Drupal 7.

Then I update the Drupal 6.22 website succesfully.
I made a backup of the 'htdocs' directory and exported the database
I imported the database in vvw_drup7

I started the upgrade. I saw the same warnings flying by but the upgrade went on till it hanged on approxametily the same spot as in attempt three:

Performing feeds_update_7100                                                [ok]
Performing feeds_update_7201                                                [ok]
Performing pathauto_update_7001                                             [ok]
|

Again I killed one of the php.exe processes. No luck this time: proces stopped.

So, up to the fifth attempt!

PvO’s picture

Before the fifth attempt I did the following:

  • Make Garland the default theme.
  • Disable feeds modules:Feeds admin ui, Feeds import, Feeds

At this very moment I have:


Do you wish to run all pending updates? (y/n): y

Performing pathauto_update_6200                                             [ok]
Performing pathauto_update_6201                                             [ok]
Performing pathauto_update_6202                                             [ok]
Performing pathauto_update_7000                                             [ok]
Performing pathauto_update_7001                                             [ok]
Performing views_update_6014                                                [ok]
|

Again, hanging with four php.exe processes running. I will wait patiently for about 45 minutes.

Well nothing happen anymore, so I killed the process again. For now: end of my yourney until anyone helps me out!

raelianer’s picture

Maybe you wanna uninstall the modules that make problems one by one until it runs... you could also try to update every module seperately.

PvO’s picture

I do not know which modules cause problems, I uninstalled the ones which have no Drupal 7 version and at last also uninstalled Date Api.
Still it hangs on the "same spot".
As far as I know on the command site-upgrade there is no choice for modules.

raelianer’s picture

yeah, just delete them from the modules directory, to find out ;-)