- 追加された行はこの色です。
- 削除された行はこの色です。
#author("2018-10-04T11:49:04+09:00","default:kuji","kuji")
#author("2018-10-05T16:42:09+09:00","default:kuji","kuji")
CONTENTS
#contents
----
Lastmodified &lastmod;
Lastmodified &lastmod;
----
*OpenPNE2.17 to 3.632 [#ld0a5f70]
*OpenPNE2.14 to 3.632 [#ld0a5f70]
# ./symfony openpne:upgrade-from-2 --origin=2.14
***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]);