CONTENTS


Lastmodified  2018-10-05 (金) 16:42:09


OpenPNE2.14 to 3.632

unzip OpenPNE-2.14.7.3.zip

cd OpenPNE-2.14.7.3

tar xvfzp openpne_blackCube.tar.gz

unzip openpne-OpenPNE3-OpenPNE-3.6.32.zip

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 799:本日 1:昨日 0

Counter: 799, today: 1, yesterday: 0

トップ   編集 凍結 差分 履歴 添付 複製 名前変更 リロード   新規 一覧 検索 最終更新   ヘルプ   最終更新のRSS
Last-modified: 2018-10-05 (金) 16:42:09