如何使用drush site-upgrade升级Drupal 6到Drupal 7

24 則留言

1. 

   UPGRADE.txt Major Upgrade Step 13
   和楼主碰上了一样的问题 不过目前还是找不到问题在哪…
   似乎不是容量的问题

   1. 

      Author

      你的错误讯息是什么？或许可以一起研究一下。

      1. 

         Take the ‘database’ record from the result and put it in your ‘dev’ alias. Put another ‘database’ record in your @stage alias definition; if you make sure that the values are correct, then you do not need to install drush on the remote machine.

         Additional uncaught exception thrown while handling exception.OriginalPDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wecosls.system' doesn't exist: SELECT name, schema_version FROM {system} WHERE type = :type; Array
         (
         [:type] => module
         )
         in drupal_get_installed_schema_version() (line 155 of /home/yunchen/sls/includes/install.inc).AdditionalPDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wecosls.system' doesn't exist: SELECT * FROM {system} WHERE type = 'theme' OR (type = 'module' AND status = 1) ORDER BY weight ASC, name ASC; Array
         (
         )
         in system_list() (line 165 of /home/yunchen/sls/includes/module.inc).Drush command terminated abnormally due to an unrecoverable error. [error]

         硬碟的话我想容量应该是足够
         升级步骤也是按你的流程也操刀
         那drush在做小升级是ok的~ Drupal6也上至最新版
         现在就尽力在升级Drupal7啰

         1. 

            阿喔 第一段可以无视 我做笔记不小心多贴了一段(汗)

            1. 

               Author

               你是指这一段吗？
               Take the ‘database’ record from the result and put it in your ‘dev’ alias. Put another ‘database’ record in your @stage alias definition; if you make sure that the values are correct, then you do not need to install drush on the remote machine.

               不过我看到下一段的重要讯息：
               1146 Table ‘wecosls.system’ doesn’t exist: SELECT * FROM {system} WHERE type = ‘theme’ OR (type = ‘module’ AND status = 1) ORDER BY weight ASC, name ASC;
               可能是升级时新旧版本的资料表资料有问题，你可以检查一下程式码，比对一下用到的资料，做修改或许就可以正常了。

            2. 

               好 感谢提示 有结果我在来分享~

            3. 

               之前问的问题，先将网站用drush更新后(drush up)
               之后再upgrade这个问题就解掉了 中间出现不少状况也一一处理
               最后碰上这个就没头绪了 就这么短Orz
               SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘public://2_1.JPG’ for [error] key ‘uri’
               想问问你有什么看法?

2. 

   UPGRADE.txt Major Upgrade Step 13
   和楼主碰上了一样的问题 不过目前还是找不到问题在哪…
   似乎不是容量的问题

   1. 

      Author

      你的错误讯息是什么？或许可以一起研究一下。

      1. 

         Take the ‘database’ record from the result and put it in your ‘dev’ alias. Put another ‘database’ record in your @stage alias definition; if you make sure that the values are correct, then you do not need to install drush on the remote machine.

         Additional uncaught exception thrown while handling exception.OriginalPDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wecosls.system' doesn't exist: SELECT name, schema_version FROM {system} WHERE type = :type; Array
         (
         [:type] => module
         )
         in drupal_get_installed_schema_version() (line 155 of /home/yunchen/sls/includes/install.inc).AdditionalPDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wecosls.system' doesn't exist: SELECT * FROM {system} WHERE type = 'theme' OR (type = 'module' AND status = 1) ORDER BY weight ASC, name ASC; Array
         (
         )
         in system_list() (line 165 of /home/yunchen/sls/includes/module.inc).Drush command terminated abnormally due to an unrecoverable error. [error]

         硬碟的话我想容量应该是足够
         升级步骤也是按你的流程也操刀
         那drush在做小升级是ok的~ Drupal6也上至最新版
         现在就尽力在升级Drupal7啰

         1. 

            阿喔 第一段可以无视 我做笔记不小心多贴了一段(汗)

            1. 

               Author

               你是指这一段吗？
               Take the ‘database’ record from the result and put it in your ‘dev’ alias. Put another ‘database’ record in your @stage alias definition; if you make sure that the values are correct, then you do not need to install drush on the remote machine.

               不过我看到下一段的重要讯息：
               1146 Table ‘wecosls.system’ doesn’t exist: SELECT * FROM {system} WHERE type = ‘theme’ OR (type = ‘module’ AND status = 1) ORDER BY weight ASC, name ASC;
               可能是升级时新旧版本的资料表资料有问题，你可以检查一下程式码，比对一下用到的资料，做修改或许就可以正常了。

            2. 

               好 感谢提示 有结果我在来分享~

            3. 

               之前问的问题，先将网站用drush更新后(drush up)
               之后再upgrade这个问题就解掉了 中间出现不少状况也一一处理
               最后碰上这个就没头绪了 就这么短Orz
               SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘public://2_1.JPG’ for [error] key ‘uri’
               想问问你有什么看法?

3. 

   Author

   是不是在uri这个栏位有重复的纪录”public://2_1.JPG”，检查一下这个资料表的用途，重设资料结构或是删除重复记录，应该就可以解决。

   1. 

      好喔! 我再详细检查一下!
      果然还是db的问题Orz 感谢: p

4. 

   Author

   是不是在uri这个栏位有重复的纪录”public://2_1.JPG”，检查一下这个资料表的用途，重设资料结构或是删除重复记录，应该就可以解决。

   1. 

      好喔! 我再详细检查一下!
      果然还是db的问题Orz 感谢: p

5. 

   呼~ 最后我也升级成功了 只不过目前网站页面还不能动XD
   在这边附上一些我们这碰到的问题 & 解法 尚未完全整理好 排版不太优请见谅

   aliases.drushrc.php 我们是这样设定才会过…
   ‘localhost’,
   ‘root’ => ‘yourroot’,
   ‘db-url’ => ‘mysqli://youraccount:password@localhost/dbname’,
   ‘databases’ =>
   array (
   ‘default’ =>
   array (
   ‘default’ =>
   array (
   ‘driver’ => ‘mysql’,
   ‘username’ => ‘yourusername’,
   ‘password’ => ‘yourpassword’,
   ‘port’ => ”,
   ‘host’ => ‘localhost’,
   ‘database’ => ‘yournewdbname’,
   ),
   ),
   ),
   );
   ?>

   Q0:
   12-a
   Unknown option: –uninstall. See `drush help pm-disable` for [error]
   available options. To suppress this error, add the option –strict=0.

   A0:
   sudo cp /usr/share/php/drush/example/example.drushrc.php ~/.drush/drushrc.php
   sudo vim ~/.drush/drushrc.php
   补上最后一行 $command_specific[‘pm-disable’] = array(‘strict’ => 0);

   Q1:
   SQLSTATE[42S02]: Base table or view not found: 1146 Table [error]
   ‘wecosls.watchdog’ doesn’t exist

   A1:
   到 sls 资料库中建资料表

   mysql -u root -p
   mysql>use yourdbname;
   mysql>CREATE TABLE `watchdog` (
   `wid` int(11) NOT NULL auto_increment,
   `uid` int(11) NOT NULL default ‘0’,
   `type` varchar(16) NOT NULL default ”,
   `message` longtext NOT NULL,
   `variables` longtext NOT NULL,
   `severity` tinyint(3) unsigned NOT NULL default ‘0’,
   `link` varchar(255) NOT NULL default ”,
   `location` text NOT NULL,
   `referer` varchar(128) NOT NULL default ”,
   `hostname` varchar(128) NOT NULL default ”,
   `timestamp` int(11) NOT NULL default ‘0’,
   PRIMARY KEY (`wid`),
   KEY `type` (`type`)
   ) DEFAULT CHARSET=utf8;

   Q2:

   WD php: PDOException: SQLSTATE[42S02]: Base table or view not found: [error]
   1146 Table ‘wecosls.profile_field’ doesn’t exist: SELECT f.name,
   f.type, v.uid, v.value FROM {profile_field} f INNER JOIN
   {profile_value} v ON f.fid = v.fid WHERE uid IN (:uids_0); Array
   (
   [:uids_0] => 0
   )
   in profile_user_load() (line 254 of
   /home/sls/wecosls/modules/profile/profile.module).
   PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'we cosls.profile_field' doesn't exist: SELECT f.name, f.type, v.uid, v.va lue FROM {profile_field} f INNER JOIN {profile_value} v ON f.fid = v.fid WHERE u id IN (:uids_0); Array
   (
   [:uids_0] => 0
   )
   in profile_user_load() (line 254 of /home/sls/wecosls/modules/profile/profile.m odule).

   A2:

   到 sls 资料库中 重新命名 profile_fields 资料表

   mysql -u root -p
   mysql>use yourdbname;
   mysql>RENAME TABLE sls.profile_fields TO sls.profile_field;
   mysql>exit

   Q3 :
   [ok]
   WD php: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table [error]
   ‘wecosls.profile_value’ doesn’t exist: SELECT f.name, f.type, v.uid, v.value FROM
   {profile_field} f INNER JOIN {profile_value} v ON f.fid = v.fid WHERE uid IN (:uids_0); Array
   (
   [:uids_0] => 0
   )
   in profile_user_load() (line 254 of /home/sls/wecosls/modules/profile/profile.module).
   PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wecosls.profile_value' doesn't exist: SELECT f.name, f.type, v.uid, v.value FROM {profile_field} f INNER JOIN {profile_value} v ON f.fid = v.fid WHERE uid IN (:uids_0); Array
   (
   [:uids_0] => 0
   )
   in profile_user_load() (line 254 of /home/sls/wecosls/modules/profile/profile.module).

   A3 :

   到 sls 资料库中 重新命名 profile_values 资料表

   mysql -u root -p
   mysql>use yourdbname;
   mysql>RENAME TABLE sls.profile_values TO sls.profile_value;
   mysql>exit

   Q4:

   SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘public://2_1.JPG’ for [error]
   key ‘uri’

   A4:

   参考资料 : https://www.drupal.org/node/1260938

   mysql -u root -p
   mysql>use yourdbname;
   mysql>CREATE TABLE tmp SELECT * FROM files GROUP BY filepath, filename;
   mysql>DROP TABLE files;
   mysql>ALTER TABLE tmp RENAME TO files;

   Q5:
   找不到 sls.profile_fields 的table

   A5:

   mysql -u root -p
   mysql>use yourdbname;
   mysql>RENAME TABLE sls.profile_field TO sls.profile_fields;
   mysql>exit

   Q6:
   找不到 sls.profile_values 的table

   A6:

   mysql -u root -p
   mysql>use yourdbname;
   mysql>RENAME TABLE sls.profile_value TO sls.profile_values;
   mysql>exit

   Q7:

   Cannot change the definition of field accesslog.sid: field doesn’t exist.

   A7:

   mysql>CREATE TABLE IF NOT EXISTS `accesslog` (
   `aid` int(11) NOT NULL AUTO_INCREMENT COMMENT ‘Primary Key: Unique accesslog ID.’,
   `sid` varchar(128) NOT NULL DEFAULT ” COMMENT ‘Browser session ID of user that visited page.’,
   `title` varchar(255) DEFAULT NULL COMMENT ‘Title of page visited.’, `path` varchar(255) DEFAULT NULL COMMENT ‘Internal path to page visited (relative to Drupal root.)’,
   `url` text COMMENT ‘Referrer URI.’,
   `hostname` varchar(128) DEFAULT NULL COMMENT ‘Hostname of user that visited the page.’,
   `uid` int(10) unsigned DEFAULT ‘0’ COMMENT ‘User users.uid that visited the page.’,
   `timer` int(10) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘Time in milliseconds that the page took to load.’,
   `timestamp` int(10) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘Timestamp of when the page was visited.’,
   PRIMARY KEY (`aid`),
   KEY `accesslog_timestamp` (`timestamp`),
   KEY `uid` (`uid`)
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’Stores site access information for statistics.’ AUTO_INCREMENT=1 ;

   Q8:

   SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘wecosls.search_index’ doesn’t exist

   A8:

   mysql>CREATE TABLE IF NOT EXISTS `search_index` (
   `word` varchar(50) NOT NULL default ”,
   `sid` int(10) unsigned NOT NULL default ‘0’,
   `type` varchar(16) default NULL,
   `fromsid` int(10) unsigned NOT NULL default ‘0’,
   `fromtype` varchar(16) default NULL,
   `score` float default NULL,
   KEY `sid_type` (`sid`,`type`),
   KEY `from_sid_type` (`fromsid`,`fromtype`),
   KEY `word` (`word`)
   ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

   1. 

      Author

      辛苦了

6. 

   呼~ 最后我也升级成功了 只不过目前网站页面还不能动XD
   在这边附上一些我们这碰到的问题 & 解法 尚未完全整理好 排版不太优请见谅

   aliases.drushrc.php 我们是这样设定才会过…
   ‘localhost’,
   ‘root’ => ‘yourroot’,
   ‘db-url’ => ‘mysqli://youraccount:password@localhost/dbname’,
   ‘databases’ =>
   array (
   ‘default’ =>
   array (
   ‘default’ =>
   array (
   ‘driver’ => ‘mysql’,
   ‘username’ => ‘yourusername’,
   ‘password’ => ‘yourpassword’,
   ‘port’ => ”,
   ‘host’ => ‘localhost’,
   ‘database’ => ‘yournewdbname’,
   ),
   ),
   ),
   );
   ?>

   Q0:
   12-a
   Unknown option: –uninstall. See `drush help pm-disable` for [error]
   available options. To suppress this error, add the option –strict=0.

   A0:
   sudo cp /usr/share/php/drush/example/example.drushrc.php ~/.drush/drushrc.php
   sudo vim ~/.drush/drushrc.php
   补上最后一行 $command_specific[‘pm-disable’] = array(‘strict’ => 0);

   Q1:
   SQLSTATE[42S02]: Base table or view not found: 1146 Table [error]
   ‘wecosls.watchdog’ doesn’t exist

   A1:
   到 sls 资料库中建资料表

   mysql -u root -p
   mysql>use yourdbname;
   mysql>CREATE TABLE `watchdog` (
   `wid` int(11) NOT NULL auto_increment,
   `uid` int(11) NOT NULL default ‘0’,
   `type` varchar(16) NOT NULL default ”,
   `message` longtext NOT NULL,
   `variables` longtext NOT NULL,
   `severity` tinyint(3) unsigned NOT NULL default ‘0’,
   `link` varchar(255) NOT NULL default ”,
   `location` text NOT NULL,
   `referer` varchar(128) NOT NULL default ”,
   `hostname` varchar(128) NOT NULL default ”,
   `timestamp` int(11) NOT NULL default ‘0’,
   PRIMARY KEY (`wid`),
   KEY `type` (`type`)
   ) DEFAULT CHARSET=utf8;

   Q2:

   WD php: PDOException: SQLSTATE[42S02]: Base table or view not found: [error]
   1146 Table ‘wecosls.profile_field’ doesn’t exist: SELECT f.name,
   f.type, v.uid, v.value FROM {profile_field} f INNER JOIN
   {profile_value} v ON f.fid = v.fid WHERE uid IN (:uids_0); Array
   (
   [:uids_0] => 0
   )
   in profile_user_load() (line 254 of
   /home/sls/wecosls/modules/profile/profile.module).
   PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'we cosls.profile_field' doesn't exist: SELECT f.name, f.type, v.uid, v.va lue FROM {profile_field} f INNER JOIN {profile_value} v ON f.fid = v.fid WHERE u id IN (:uids_0); Array
   (
   [:uids_0] => 0
   )
   in profile_user_load() (line 254 of /home/sls/wecosls/modules/profile/profile.m odule).

   A2:

   到 sls 资料库中 重新命名 profile_fields 资料表

   mysql -u root -p
   mysql>use yourdbname;
   mysql>RENAME TABLE sls.profile_fields TO sls.profile_field;
   mysql>exit

   Q3 :
   [ok]
   WD php: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table [error]
   ‘wecosls.profile_value’ doesn’t exist: SELECT f.name, f.type, v.uid, v.value FROM
   {profile_field} f INNER JOIN {profile_value} v ON f.fid = v.fid WHERE uid IN (:uids_0); Array
   (
   [:uids_0] => 0
   )
   in profile_user_load() (line 254 of /home/sls/wecosls/modules/profile/profile.module).
   PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wecosls.profile_value' doesn't exist: SELECT f.name, f.type, v.uid, v.value FROM {profile_field} f INNER JOIN {profile_value} v ON f.fid = v.fid WHERE uid IN (:uids_0); Array
   (
   [:uids_0] => 0
   )
   in profile_user_load() (line 254 of /home/sls/wecosls/modules/profile/profile.module).

   A3 :

   到 sls 资料库中 重新命名 profile_values 资料表

   mysql -u root -p
   mysql>use yourdbname;
   mysql>RENAME TABLE sls.profile_values TO sls.profile_value;
   mysql>exit

   Q4:

   SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘public://2_1.JPG’ for [error]
   key ‘uri’

   A4:

   参考资料 : https://www.drupal.org/node/1260938

   mysql -u root -p
   mysql>use yourdbname;
   mysql>CREATE TABLE tmp SELECT * FROM files GROUP BY filepath, filename;
   mysql>DROP TABLE files;
   mysql>ALTER TABLE tmp RENAME TO files;

   Q5:
   找不到 sls.profile_fields 的table

   A5:

   mysql -u root -p
   mysql>use yourdbname;
   mysql>RENAME TABLE sls.profile_field TO sls.profile_fields;
   mysql>exit

   Q6:
   找不到 sls.profile_values 的table

   A6:

   mysql -u root -p
   mysql>use yourdbname;
   mysql>RENAME TABLE sls.profile_value TO sls.profile_values;
   mysql>exit

   Q7:

   Cannot change the definition of field accesslog.sid: field doesn’t exist.

   A7:

   mysql>CREATE TABLE IF NOT EXISTS `accesslog` (
   `aid` int(11) NOT NULL AUTO_INCREMENT COMMENT ‘Primary Key: Unique accesslog ID.’,
   `sid` varchar(128) NOT NULL DEFAULT ” COMMENT ‘Browser session ID of user that visited page.’,
   `title` varchar(255) DEFAULT NULL COMMENT ‘Title of page visited.’, `path` varchar(255) DEFAULT NULL COMMENT ‘Internal path to page visited (relative to Drupal root.)’,
   `url` text COMMENT ‘Referrer URI.’,
   `hostname` varchar(128) DEFAULT NULL COMMENT ‘Hostname of user that visited the page.’,
   `uid` int(10) unsigned DEFAULT ‘0’ COMMENT ‘User users.uid that visited the page.’,
   `timer` int(10) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘Time in milliseconds that the page took to load.’,
   `timestamp` int(10) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘Timestamp of when the page was visited.’,
   PRIMARY KEY (`aid`),
   KEY `accesslog_timestamp` (`timestamp`),
   KEY `uid` (`uid`)
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’Stores site access information for statistics.’ AUTO_INCREMENT=1 ;

   Q8:

   SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘wecosls.search_index’ doesn’t exist

   A8:

   mysql>CREATE TABLE IF NOT EXISTS `search_index` (
   `word` varchar(50) NOT NULL default ”,
   `sid` int(10) unsigned NOT NULL default ‘0’,
   `type` varchar(16) default NULL,
   `fromsid` int(10) unsigned NOT NULL default ‘0’,
   `fromtype` varchar(16) default NULL,
   `score` float default NULL,
   KEY `sid_type` (`sid`,`type`),
   KEY `from_sid_type` (`fromsid`,`fromtype`),
   KEY `word` (`word`)
   ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

   1. 

      Author

      辛苦了

7. 2015年四月积点免费送新竹国宾大饭店自助下午茶/午餐/晚餐/套餐通用券 - 工作达人(Job Da Ren)
   

   2015/04/03

   Permalink
8. 2015年四月积点免费送新竹国宾大饭店自助下午茶/午餐/晚餐/套餐通用券 - 工作达人(Job Da Ren)
   

   2015/04/03

   Permalink