#author("2018-10-05T14:49:02+09:00","default:kuji","kuji")
#author("2018-10-05T16:42:09+09:00","default:kuji","kuji")
CONTENTS
#contents
----
Lastmodified  &lastmod;
----
*OpenPNE2.14 to 3.632 [#ld0a5f70]

***unzip OpenPNE-2.14.7.3.zip [#vc5d39cf]
***cd OpenPNE-2.14.7.3 [#a61a971c]
***tar xvfzp openpne_blackCube.tar.gz [#ld7c5178]
**unzip openpne-OpenPNE3-OpenPNE-3.6.32.zip [#cb5ebb45]

 cd /usr/local/www/openpne3632/config 
 cp config/ProjectConfiguration.class.php.sample config/ProjectConfiguration.class.php 
 cp config/OpenPNE.yml.sample config/OpenPNE.yml
 
   265  10:50   ./symfony opPlugin:sync
   266  10:52   ./symfony openpne:permission
   267  10:52   ./symfony openpne:upgrade-from-2 --origin=2.14


 # chown -R www:www /usr/local/www/OpenPNE3
 # ./symfony openpne:upgrade-from-2 --origin=2.14
 >> upgrade   Begin upgrading from 2.x
 >> upgrade   Processing build_model
 >> upgrade   Processed build_model (6.99 sec)
 >> upgrade   Processing create_tables
 >> upgrade   Processed create_tables (3.83 sec)
 >> upgrade   Processing member_basic
 >> upgrade   Processed member_basic (0.02 sec)
 >> upgrade   Processing files

 >> upgrade   Begin upgrading from 2.x
 >> upgrade   Processing build_model
 PHP Warning:  date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /usr/local/www/openpne3632/lib/vendor/symfony/lib/config/sfRootConfigHandler.class.php on line 91
 PHP Warning:  date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /usr/local/www/openpne3632/lib/vendor/symfony/lib/config/sfDefineEnvironmentConfigHandler.class.php on line 66
 PHP Warning:  date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /usr/local/www/openpne3632/lib/vendor/symfony/lib/config/sfDefineEnvironmentConfigHandler.class.php on line 66

このエラーは、php.ini
 
 [Date]
 
 date.timezone = "Asia/Tokyo"

で消えます。


 >> upgrade   Begin upgrading from 2.x
 >> upgrade   Processing build_model
 >> upgrade   Processed build_model (7.77 sec)
 >> upgrade   Processing create_tables
 SQLSTATE[HY000]: General error: 1005 Can't create table 'PNE2.#sql-390_28' (errno: 121). Failing Query: "ALTER TABLE community_event_member ADD CONSTRAINT community_event_member_member_id_member_id FOREIGN KEY (member_id) REFERENCES member(id) ON DELETE CASCADE". Failing Query: ALTER TABLE community_event_member ADD CONSTRAINT community_event_member_member_id_member_id FOREIGN KEY (member_id) REFERENCES member(id) ON DELETE CASCADE
 >> upgrade   Processed create_tables (0.37 sec)
 >> upgrade   Processing member_basic
 SQLSTATE[HY000]: General error: 1034 Incorrect key file for table 'c_member'; try to repair it. Failing Query: "INSERT INTO member (id, name, is_active, is_login_rejected, created_at, updated_at) (SELECT c_member_id, nickname, 1, is_login_rejected, r_date, u_datetime FROM c_member)"
 >> upgrade   Processed member_basic (0.04 sec)
 >> upgrade   Processing files


 >> upgrade   Processed build_model (7.04 sec)
 >> upgrade   Processing create_tables
 >> upgrade   Processed create_tables (4.56 sec)
 >> upgrade   Processing member_basic
 >> upgrade   Processed member_basic (0.18 sec)
 >> upgrade   Processing files
 
 >> upgrade   Processed files (2980.05 sec)
 >> upgrade   Processing admin_user
 >> upgrade   Processed admin_user (0.08 sec)
 >> upgrade   Processing member_secure
 >> upgrade   Processed member_secure (0.22 sec)
 >> upgrade   Processing member_email
 >> upgrade   Processed member_email (0.21 sec)
 >> upgrade   Processing intro_friend
 >> upgrade   Processed intro_friend (0.07 sec)
 >> upgrade   Processing member_relationship
 >> upgrade   Processed member_relationship (0.06 sec)
 >> upgrade   Processing profile
 >> upgrade   Processed profile (0.35 sec)
 >> upgrade   Processing member_image
 >> upgrade   Processed member_image (0.09 sec)
 >> upgrade   Processing member_image_cleanup
 >> upgrade   Processed member_image_cleanup (0.02 sec)
 >> upgrade   Processing member_config
 >> upgrade   Processed member_config (0.05 sec)
 >> upgrade   Processing album
 >> upgrade   Processed album (0.09 sec)
 >> upgrade   Processing diary
 >> upgrade   Processed diary (5.47 sec)
 >> upgrade   Processing community
 >> upgrade   Processed community (0.52 sec)
 >> upgrade   Processing community_member
 >> upgrade   Processed community_member (0.06 sec)
 >> upgrade   Processing community_config
 >> upgrade   Processed community_config (0.02 sec)
 >> upgrade   Processing community_topic
 >> upgrade   Processed community_topic (0.22 sec)
 >> upgrade   Processing ashiato
 >> upgrade   Processed ashiato (1.24 sec)
 >> upgrade   Processing blacklist
 >> upgrade   Processed blacklist (0.04 sec)
 >> upgrade   Processing favorite
 >> upgrade   Processed favorite (0.16 sec)
 >> upgrade   Processing admin_config
 >> upgrade   Processed admin_config (0.11 sec)
 >> upgrade   Processing sns_term
 >> upgrade   Processed sns_term (0.27 sec)
 >> upgrade   Processing skin_config
 >> upgrade   Processed skin_config (0.76 sec)
 >> upgrade   Processing decoration
 >> upgrade   Processed decoration (0.07 sec)
 >> upgrade   Processing mobile_color_config
 >> upgrade   Processed mobile_color_config (0.02 sec)
 >> upgrade   Processing load_data
 >> upgrade   Processed load_data (1.98 sec)
 >> upgrade   Processing gadget
 >> upgrade   Processed gadget (0.09 sec)
 >> upgrade   Processing message
 >> upgrade   Processed message (0.05 sec)
 >> upgrade   Processing banner
 >> upgrade   Processed banner (0.07 sec)
 >> upgrade   Processing confirmation
 >> upgrade   Processed confirmation (0.02 sec)
 >> upgrade   Processing mobile_uid_bc_config
 >> upgrade   Processed mobile_uid_bc_config (0.00 sec)
 >> upgrade   Processing login_layout
  SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'external_pc_login_url' for key 'name_UNIQUE_idx'
 >> upgrade   Processed login_layout (0.04 sec)
 >> upgrade   Processing fix_old_image_data
 
 PHP Fatal error:  Allowed memory size of 536870912 bytes exhausted (tried to allocate 4590957 bytes) in /usr/local/www/openpne3632/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection/Statement.php on line 257
 
 Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 4590957 bytes) in /usr/local/www/openpne3632/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection/Statement.php on line 257

/usr/local/etc/php.ini

 ;memory_limit = 512M
 memory_limit = 1024M

 apachectl restart
 ./symfony openpne:upgrade-from-2 --origin=2.14


 >> upgrade   Processing fix_old_image_data
 PHP Fatal error:  Allowed memory size of 1073741824 bytes exhausted (tried to allocate 4045231 bytes)  in /usr/local/www/openpne3632/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection/Statement.php on line 257
 
 Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 4045231 bytes) in /usr/local/www/openpne3632/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection/Statement.php on line 257

 ;memory_limit = 512M
 memory_limit = 256M
 
 // アップロード画像のファイルサイズ制限(KB)
 //define('IMAGE_MAX_FILESIZE', 20480);
 define('IMAGE_MAX_FILESIZE', 204800);


 >> upgrade   Processed fix_old_image_data (1.67 sec)
 >> upgrade   Completed Upgrading (9.22 sec)
 >> upgrade   The 91.00 MB memory allocated
 >> plugin    Configuring plugin - opAlbumPlugin
 >> plugin    Configuring plugin - opAshiatoPlugin
 >> plugin    Configuring plugin - opAuthMailAddressPlugin
 >> plugin    Configuring plugin - opAuthMobileUIDPlugin
 >> plugin    Configuring plugin - opAuthOpenIDPlugin
 >> plugin    Configuring plugin - opBlogPlugin
 >> plugin    Configuring plugin - opCommunityTopicPlugin
 >> plugin    Configuring plugin - opDiaryPlugin
 >> plugin    Configuring plugin - opFavoritePlugin
 >> plugin    Configuring plugin - opIntroFriendPlugin
 >> plugin    Configuring plugin - opMessagePlugin
 >> plugin    Configuring plugin - opOpenSocialPlugin
 >> plugin    Configuring plugin - opRankingPlugin
 >> plugin    Configuring plugin - opSkinBasicPlugin
 >> link+     /usr/local/www/openpne3632/web/opSkinBasicPlugin
 >> plugin    Configuring plugin - opSkinClassicPlugin
 >> link+     /usr/local/www/openpne3632/web/opSkinClassicPlugin
 >> plugin    Configuring plugin - opWebAPIPlugin
 >> plugin    Configuring plugin - sfDoctrinePlugin
 >> link+     /usr/local/www/openpne3632/web/sfDoctrinePlugin
 >> plugin    Configuring plugin - sfFormExtraPlugin
 >> link+     /usr/local/www/openpne3632/web/sfFormExtraPlugin
 >> plugin    Configuring plugin - sfImageHandlerPlugin
 >> plugin    Configuring plugin - sfProtoculousPlugin
 >> link+     /usr/local/www/openpne3632/web/sfProtoculousPlugin
 >> plugin    Configuring plugin - sfSymfonyTemplatingViewPlugin


member/login/authMode/MailAddress was not found on this server

と表示された場合は、web/.htaccess の設定が効いていません。つまりmod_rewite が効いてない。
http://www.love-mac.net/archives/01/729.html


 >> upgrade   Processing login_layout
 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'external_pc_login_url' for key 'name_UNIQUE_idx'
 >> upgrade   Processed login_layout (0.09 sec)

----
Total access &counter(total);:本日 &counter(today);:昨日 &counter(yesterday);
#counter([total|today|yesterday]);

トップ   編集 差分 履歴 添付 複製 名前変更 リロード   新規 一覧 検索 最終更新   ヘルプ   最終更新のRSS