problem in upgrading from 5 to 6

Posted by drupal17 on October 24, 2008 at 10:14pm

Hi,
I have searched the forum but i could not find any situation like mine. I have d5 installation on my windows pc. my conf is here: apache 2.0.63 and PHP 5.2.3 and mysql 5.

There are three sites on D5: mysite, copyOfMysite, testSite. My Drupal installation is under C:\www\drupal, by the way. So, C:\www\drupal\sites\mysite and so on. There is no problem with my installation. when i point to " mysite" with my explorer, i can reach mysite. No problem.

Here my problem starts. I want to upgrade my drupal to 6. And i dont want to lost my data and D5 installation since i need it during upgrade process. As a solution, i unzipped the drupal 6 in C:\www\drupal6. And in my apache conf file made configuration for virtual host like configuration for D5. Add windows hosts file "127.0.0.9 drup6"

And then i create a database called drupal6 with necessary tables. In fact i get this database from someone else. This db is for D6 but it is empty. Then copied the "mysite" folder under C:\www\drupal6\sites\mysite".

Change my settings.php file. When i write "drup6 in explorer, i get an blank page. I mean there is nothing, no errror or sth else. Where is my problem. Shouldnt i get an error at least?
Read upgrade docs but couldnt get the point. Please help, thanks in advance.

Comments

Check your webserver error

Posted by lyricnz on October 24, 2008 at 11:35pm

Check your webserver error logs to find out what's going wrong. It'll probably be called something like error_log or php_error_log. You should read the docs about how to upgrade your site between versions at http://drupal.org/upgrade

Taniwha Solutions- Drupal Consulting and Implementation. Site design and construction, module development, customization, etc.

error log

Posted by drupal17 on October 25, 2008 at 1:02pm

Thanks for reply, i checked the apache error log. There are many error lines start with following. I think i have db problem. I tryed to restore my database from th db that i used with D5. But i got an error says " There is no access table" . In fact ı can see access table exist in phpmyadmin. But it is empty.

This is the error log :

PHP Warning: Table 'drupal6.access' doesn't exist\nquery: SELECT 1 FROM access WHERE type = 'host' AND LOWER('127.0.0.9') LIKE LOWER(mask) AND status = 0 LIMIT 0, 1 in C:\\My Webs\\drupal6\\includes\\database.mysql.inc on line 128
[Sat Oct 25 15:53:14 2008] [error] [client 127.0.0.9] PHP Warning: Table 'drupal6.cache' doesn't exist\nquery: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'variables' in C:\\My Webs\\drupal6\\includes\\database.mysql.inc on line 128
[Sat Oct 25 15:53:15 2008] [error] [client 127.0.0.9] PHP Warning: Table 'drupal6.variable' doesn't exist\nquery: SELECT * FROM variable in C:\\My Webs\\drupal6\\includes\\database.mysql.inc on line 128
[Sat Oct 25 15:53:15 2008] [error] [client 127.0.0.9] PHP Notice: Undefined variable: variables in C:\\My Webs\\drupal6\\includes\\bootstrap.inc on line 432
[Sat Oct 25 15:53:15 2008] [error] [client 127.0.0.9] PHP Warning: Table 'drupal6.cache' doesn't exist\nquery: UPDATE cache SET data = '', created = 1224939195, expire = 0, headers = '', serialized = 0 WHERE cid = 'variables' in C:\\My Webs\\drupal6\\includes\\database.mysql.inc on line 128
[Sat Oct 25 15:53:15 2008] [error] [client 127.0.0.9] PHP Notice: Undefined variable: variables in C:\\My Webs\\drupal6\\includes\\bootstrap.inc on line 439
[Sat Oct 25 15:53:15 2008] [error] [client 127.0.0.9] PHP Warning: Table 'drupal6.system' doesn't exist\nquery: SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 AND bootstrap = 1 ORDER BY weight ASC, filename ASC in C:\\My Webs\\drupal6\\includes\\database.mysql.inc on line 128
[Sat Oct 25 15:53:15 2008] [error] [client 127.0.0.9] PHP Warning: Table 'drupal6.url_alias' doesn't exist\nquery: SELECT COUNT(pid) FROM url_alias in C:\\My Webs\\drupal6\\includes\\database.mysql.inc on line 128
[Sat Oct 25 15:53:20 2008] [error] [client 127.0.0.9] File does not exist: C:/My Webs/drupal6/favicon.ico
[Sat Oct 25 15:53:23 2008] [error] [client 127.0.0.9] File does not exist: C:/My Webs/drupal6/favicon.ico

Please read the upgrade

Posted by lyricnz on October 26, 2008 at 12:22am

Please read the upgrade guide I posted in my first message. In particular, your step

And then i create a database called drupal6 with necessary tables. In fact i get this database from someone else. This db is for D6 but it is empty. Then copied the "mysite" folder under C:\www\drupal6\sites\mysite".

is wrong. You should COPY the entire database from the D5 install into wherever the D6 install points to. Drupal knows how to upgrade the data from D5 to D6. Please follow the instructions at that URL carefully.

Taniwha Solutions- Drupal Consulting and Implementation. Site design and construction, module development, customization, etc.

after upgrade blank page

Posted by drupal17 on November 17, 2008 at 11:08am

I upgrade to 6 from strach like you said. Finally i could reach upgrade page by entering update. php. AFter update process finished, review log page appeared. There are info about module updates. Some of the scripts tagged as "failed". For example Failed: "ALTER TABLE {filters} ADD UNIQUE KEY fmd (format, module, delta) " under sytem module.

So i dont know these are major errors or just warnings. Then I thought i upgraded to D6 succesfully. But when i enter //mysite, just a blank page. I tryed to log in mysite/user again blank page.

in apache error log there are no errors. Also no entry in watchdog table. What is the point I miss?
Thanks in adv

Sounds like you had all your

Posted by lyricnz on November 17, 2008 at 11:27am

Sounds like you had all your contributed modules in the directory when you did the upgrade - you should not do this. It is all described at the document I referred to, just follow it properly, without skipping any steps. Summary: get your working D5 install, disable all contributed modules and set theme to garland, set site in maintenance mode, unpack a stock D6 (core only) into a new directory, and update your settings.php to point to the D5 database, open drupal6 site /update.php and perform the updates as direct, then (one by one), put the D6 versions of your contributed modules into sites/all/modules and re-run /update.php on each. Test between phases. Done.

Taniwha Solutions- Drupal Consulting and Implementation. Site design and construction, module development, customization, etc.

upgrade to 6

Posted by drupal17 on November 17, 2008 at 11:36am

thanks for quick reply i will try it right now

update modules

Posted by drupal17 on November 17, 2008 at 2:25pm

Now I am trying to update modules one by one. When i updated image module, i got an error :

An error occurred. http://drup6/update.php?id=7&op=do
Fatal error: Call to undefined function image_get_sizes() in C:\My Webs\drupal6\sites\all\modules\image\image.install on line 250

But i contiune updating the other modules one by one. I think i can resolve image module problem after all.

This is a known issue:

Posted by lyricnz on November 17, 2008 at 11:44pm

This is a known issue:

#295317: Upgrading image module
#297806: Error on install of latest image module version
#306259: Image Module: update.php generates error despite Image module not even being enabled?
#219808: Fixed still big questions unanswered ????

I vaguely recall getting this myself. Also, the upgrade broke all my image-attach, so I needed to run

INSERT INTO image (nid, fid, image_size) SELECT u.nid, f.fid, f.filename FROM files f LEFT JOIN upload u ON f.fid=u.fid

as described in #257743: 6.x upgrade error: Unknown column 'f.nid' in 'field list' query

Taniwha Solutions- Drupal Consulting and Implementation. Site design and construction, module development, customization, etc.

it works

Posted by drupal17 on December 21, 2008 at 11:00pm

I've just been able to try it and worked. Thanks...