CONTENTS


Lastmodified 2019-01-17 (木) 10:52:56


画像が変換・移行できない。 http://suama.biz/weblog/2012/06/openpne2-14-x%E2%86%923-8-0%E3%81%BE%E3%81%A7%E3%81%AE%E3%82%A2%E3%83%83%E3%83%97%E3%82%B0%E3%83%AC%E3%83%BC%E3%83%89/

OpenPNE3.6 OpenPNE.yml

アップロード画像のリンク先画像が小さくなる。

PHP 5.6.39 ⇒ PHP 7.* すると、OpenPNE2系は

Fatal error: Uncaught Error: Call to undefined function mysql_error() in /usr/home/tfc/public_html/openpne/lib/include/DB/mysql.php:249 Stack trace: #0 /usr/home/tfc/public_html/openpne/lib/include/DB.php(556): DB_mysql->connect(Array, false) #1 /usr/home/tfc/public_html/openpne/webapp/lib/OpenPNE/DB.php(60): DB::connect(Array) #2 /usr/home/tfc/public_html/openpne/webapp/lib/OpenPNE/DB.php(35): OpenPNE_DB->_connect() #3 /usr/home/tfc/public_html/openpne/webapp/lib/db/common.php(21): OpenPNE_DB->OpenPNE_DB(Array, false) #4 /usr/home/tfc/public_html/openpne/webapp/lib/db/common.php(18): db_get_instance() #5 /usr/home/tfc/public_html/openpne/webapp/lib/db/common.php(127): db_get_instance('main_reader', true) #6 /usr/home/tfc/public_html/openpne/webapp/lib/OpenPNE/Config.php(94): db_get_all('SELECT * FROM c...') #7 /usr/home/tfc/public_html/openpne/webapp/init.inc(94): OpenPNE_Config->db_load_config() #8 /usr/home/tfc/public_html/openpne/public_html/index.php(8): require_once('/usr/home/tfc/p...') #9 {main} thrown in /usr/home/tfc/public_html/openpne/lib/include/DB/mysql.php on line 249

OpenPNE2.14 to 3.6

mysqldump -u root -p database_name > dump.sql

mysql -u root -p -D PNE2 < /usr/home/db/MySQL/PNE2.sql

unzip openpne-OpenPNE3-OpenPNE-3.6.32.zip

chown -R www:www openpne-OpenPNE3-47251b6

mv openpne-OpenPNE3-47251b6 OpenPNE3

cp config/ProjectConfiguration.class.php.sample config/ProjectConfiguration.class.php

cp config/ProjectConfiguration.class.php.sample config/ProjectConfiguration.class.php

cp config/OpenPNE.yml.sample config/OpenPNE.yml

cp config/OpenPNE.yml.sample config/OpenPNE.yml

vi OpenPNE.yml

######################################
# 基本設定 (Basic)
######################################

# SNS の URL
# URL of the SNS
#base_url: "http://example.com"
base_url: "https://mail.smb.net/OpenPNE3/"

######################################
# メール (Mail)
######################################

# SNS からのメール送信に使うドメイン
# Domain to use for sending e-mail from the SNS
#mail_domain: "example.com"
mail_domain: "smb.net"

# resize_limit_size: 8192
resize_limit_size: 70000000

cp /usr/home/openpne/config.php /usr/home/OpenPNE3/config/config.OpenPNE2.php

./symfony opPlugin:sync

>> sfPearFrontendPlugin Attempting to discover channel "plugins.openpne.jp"...
>> sfPearFrontendPlugin downloading channel.xml ...
>> sfPearFrontendPlugin Starting to download channel.xml (796 bytes)
>> sfPearFrontendPlugin .
>> sfPearFrontendPlugin ...done: 796 bytes
>> sfPearFrontendPlugin Auto-discovered channel "plugins.openpne.jp", alias
>> sfPearFrontendPlugin "plugins.openpne.jp", adding to registry
>> plugin    installing plugin "opAuthMailAddressPlugin"
>> sfPearFrontendPlugin downloading opAuthMailAddressPlugin-1.3.6.tgz ...
>> sfPearFrontendPlugin Starting to download opAuthMailAddressPlugin-1.3.6.tgz (17,707
>> sfPearFrontendPlugin bytes)
>> sfPearFrontendPlugin ...done: 17,707 bytes
>> sfPearFrontendPlugin Package "plugins.openpne.jp/opAuthMailAddressPlugin"
>> sfPearFrontendPlugin dependency "plugins.openpne.jp/openpne" has no releases
>> opPluginManager Installation successful for plugin "opAuthMailAddressPlugin"
>> plugin    installing plugin "opAuthMobileUIDPlugin"
>> sfPearFrontendPlugin downloading opAuthMobileUIDPlugin-1.3.3.tgz ...
>> sfPearFrontendPlugin Starting to download opAuthMobileUIDPlugin-1.3.3.tgz (9,300
>> sfPearFrontendPlugin bytes)
>> sfPearFrontendPlugin ...done: 9,300 bytes
>> opPluginManager Installation successful for plugin "opAuthMobileUIDPlugin"
>> plugin    installing plugin "opAuthOpenIDPlugin"
>> sfPearFrontendPlugin downloading opAuthOpenIDPlugin-1.3.1.tgz ...
>> sfPearFrontendPlugin Starting to download opAuthOpenIDPlugin-1.3.1.tgz (9,544
>> sfPearFrontendPlugin bytes)
>> sfPearFrontendPlugin ...done: 9,544 bytes
>> sfPearFrontendPlugin Package "plugins.openpne.jp/opAuthOpenIDPlugin" dependency
>> sfPearFrontendPlugin "plugins.openpne.jp/openpne" has no releases
>> opPluginManager Installation successful for plugin "opAuthOpenIDPlugin"
>> plugin    installing plugin "opCommunityTopicPlugin"
>> sfPearFrontendPlugin downloading opCommunityTopicPlugin-1.0.5.1.tgz ...
>> sfPearFrontendPlugin Starting to download opCommunityTopicPlugin-1.0.5.1.tgz
>> sfPearFrontendPlugin (70,352 bytes)
>> sfPearFrontendPlugin ...done: 70,352 bytes
>> opPluginManager Installation successful for plugin "opCommunityTopicPlugin"
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> plugin    installing plugin "opWebAPIPlugin"
>> sfPearFrontendPlugin downloading opWebAPIPlugin-0.5.1.2.tgz ...
>> sfPearFrontendPlugin Starting to download opWebAPIPlugin-0.5.1.2.tgz (18,555 bytes)
>> sfPearFrontendPlugin ...done: 18,555 bytes
>> opPluginManager Installation successful for plugin "opWebAPIPlugin"
>> plugin    installing plugin "opDiaryPlugin"
>> sfPearFrontendPlugin downloading opDiaryPlugin-1.4.1.1.tgz ...
>> sfPearFrontendPlugin Starting to download opDiaryPlugin-1.4.1.1.tgz (50,693 bytes)
>> sfPearFrontendPlugin ...done: 50,693 bytes
>> sfPearFrontendPlugin Package "plugins.openpne.jp/opDiaryPlugin" dependency
>> sfPearFrontendPlugin "plugins.openpne.jp/openpne" has no releases
>> opPluginManager Installation successful for plugin "opDiaryPlugin"
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> plugin    installing plugin "opBlogPlugin"
>> sfPearFrontendPlugin downloading opBlogPlugin-1.0.3.tgz ...
>> sfPearFrontendPlugin Starting to download opBlogPlugin-1.0.3.tgz (77,548 bytes)
>> sfPearFrontendPlugin ...done: 77,548 bytes
>> opPluginManager Installation successful for plugin "opBlogPlugin"
>> plugin    installing plugin "opOpenSocialPlugin"
>> sfPearFrontendPlugin downloading opOpenSocialPlugin-1.2.6.1.tgz ...
>> sfPearFrontendPlugin Starting to download opOpenSocialPlugin-1.2.6.1.tgz (543,058
>> sfPearFrontendPlugin bytes)
>> sfPearFrontendPlugin ...done: 543,058 bytes
>> sfPearFrontendPlugin Attempting to discover channel "pear.symfony-project.com"...
>> sfPearFrontendPlugin downloading channel.xml ...
>> sfPearFrontendPlugin Starting to download channel.xml (865 bytes)
>> sfPearFrontendPlugin ...done: 865 bytes
>> sfPearFrontendPlugin Auto-discovered channel "pear.symfony-project.com", alias
>> sfPearFrontendPlugin "symfony", adding to registry
>> sfPearFrontendPlugin Package "plugins.openpne.jp/opOpenSocialPlugin" dependency
>> sfPearFrontendPlugin "pear.symfony-project.com/symfony" has no releases
>> opPluginManager Installation successful for plugin "opOpenSocialPlugin"
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> plugin    installing plugin "opAshiatoPlugin"
>> sfPearFrontendPlugin downloading opAshiatoPlugin-1.1.1.tgz ...
>> sfPearFrontendPlugin Starting to download opAshiatoPlugin-1.1.1.tgz (12,170 bytes)
>> sfPearFrontendPlugin ...done: 12,170 bytes
>> opPluginManager Installation successful for plugin "opAshiatoPlugin"
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> plugin    installing plugin "opMessagePlugin"
>> sfPearFrontendPlugin downloading opMessagePlugin-1.0.0.tgz ...
>> sfPearFrontendPlugin Starting to download opMessagePlugin-1.0.0.tgz (34,163 bytes)
>> sfPearFrontendPlugin ...done: 34,163 bytes
>> opPluginManager Installation successful for plugin "opMessagePlugin"
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> plugin    installing plugin "opAlbumPlugin"
>> sfPearFrontendPlugin downloading opAlbumPlugin-0.9.4.1.tgz ...
>> sfPearFrontendPlugin Starting to download opAlbumPlugin-0.9.4.1.tgz (17,936 bytes)
>> sfPearFrontendPlugin ...done: 17,936 bytes
>> opPluginManager Installation successful for plugin "opAlbumPlugin"
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> plugin    installing plugin "opIntroFriendPlugin"
>> sfPearFrontendPlugin downloading opIntroFriendPlugin-1.0.0.1.tgz ...
>> sfPearFrontendPlugin Starting to download opIntroFriendPlugin-1.0.0.1.tgz (17,642
>> sfPearFrontendPlugin bytes)
>> sfPearFrontendPlugin ...done: 17,642 bytes
>> opPluginManager Installation successful for plugin "opIntroFriendPlugin"
>> plugin    installing plugin "opFavoritePlugin"
>> sfPearFrontendPlugin downloading opFavoritePlugin-1.0.1.1.tgz ...
>> sfPearFrontendPlugin Starting to download opFavoritePlugin-1.0.1.1.tgz (13,855
>> sfPearFrontendPlugin bytes)
>> sfPearFrontendPlugin ...done: 13,855 bytes
>> opPluginManager Installation successful for plugin "opFavoritePlugin"
>> plugin    installing plugin "opRankingPlugin"
>> sfPearFrontendPlugin downloading opRankingPlugin-1.0.1.tgz ...
>> sfPearFrontendPlugin Starting to download opRankingPlugin-1.0.1.tgz (10,865 bytes)
>> sfPearFrontendPlugin ...done: 10,865 bytes
>> opPluginManager Installation successful for plugin "opRankingPlugin"
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin
>> opPluginManager Installing web data for plugin

./symfony openpne:permission

>> chmod 777 /usr/home/OpenPNE3632/cache
>> chmod 777 /usr/home/OpenPNE3632/log
>> chmod 777 /usr/home/OpenPNE3632/symfony
>> chmod 777 /usr/home/OpenPNE3632/cache/config
>> chmod 777 /usr/home/OpenPNE3632/cache/.pear
>> chmod 777 /usr/home/OpenPNE3632/cache/.pear/opAuthMailAddressPlugin-1.3.6
>> chmod 777 /usr/home/OpenPNE3632/cache/.pear/opAuthMailAddressPlugin-1.3.6/apps
>> chmod 777 /usr/home/OpenPNE3632/cache/.pear/opAuthMailAddressPlugin-1.3.6/apps/mobile_frontend
                 :                :
>> chmod 666 /usr/home/OpenPNE3632/cache/project_autoload.cache
>> chmod 666 /usr/home/OpenPNE3632/log/.gitignore
>> dir+      /usr/home/OpenPNE3632/web/cache
>> chmod 777 /usr/home/OpenPNE3632/web/cache

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

>> upgrade   Begin upgrading from 2.x
>> upgrade   Processing build_model
>> upgrade   Processed build_model (6.39 sec)
>> upgrade   Processing create_tables
>> upgrade   Processed create_tables (1.27 sec)
>> upgrade   Processing member_basic
>> upgrade   Processed member_basic (0.02 sec)
>> upgrade   Processing files
                   : : :
>> 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.18 sec)
>> upgrade   Processing fix_old_image_data

PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 2955488 bytes) in /usr/home/OpenPNE3632/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection/Statement.php on line 257

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 2955488 bytes) in /usr/home/OpenPNE3632/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection/Statement.php on line 257



./symfony openpne:upgrade-from-2 --origin=2.14 --rules=fix_old_image_data

>> upgrade   Begin upgrading from 2.x
>> upgrade   Processing fix_old_image_data
>> upgrade   Processed fix_old_image_data (1624.83 sec)
>> upgrade   Completed Upgrading (1624.83 sec)
>> upgrade   The 47.25 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/home/OpenPNE3632/web/opSkinBasicPlugin
>> plugin    Configuring plugin - opSkinClassicPlugin
>> link+     /usr/home/OpenPNE3632/web/opSkinClassicPlugin
>> plugin    Configuring plugin - opWebAPIPlugin
>> plugin    Configuring plugin - sfDoctrinePlugin
>> link+     /usr/home/OpenPNE3632/web/sfDoctrinePlugin
>> plugin    Configuring plugin - sfFormExtraPlugin
>> link+     /usr/home/OpenPNE3632/web/sfFormExtraPlugin
>> plugin    Configuring plugin - sfImageHandlerPlugin
>> plugin    Configuring plugin - sfProtoculousPlugin
>> link+     /usr/home/OpenPNE3632/web/sfProtoculousPlugin
>> plugin    Configuring plugin - sfSymfonyTemplatingViewPlugin

./symfony openpne:upgrade-from-2 --origin=2.14 --rules=create_tables

>> upgrade   Begin upgrading from 2.x
>> upgrade   Processing create_tables
SQLSTATE[HY000]: General error: 1005 Can't create table 'PNE2.#sql-3e7_a3' (errno: 121). Failing Query: "ALTER TABLE activity_data ADD CONSTRAINT activity_data_member_id_member_id FOREIGN KEY (member_id) REFERENCES member(id) ON DELETE CASCADE". Failing Query: ALTER TABLE activity_data ADD CONSTRAINT activity_data_member_id_member_id FOREIGN KEY (member_id) REFERENCES member(id) ON DELETE CASCADE
>> upgrade   Processed create_tables (0.47 sec)

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

>> upgrade   Begin upgrading from 2.x
>> upgrade   Processing build_model
>> upgrade   Processed build_model (7.86 sec)
>> upgrade   Processing create_tables
 SQLSTATE[HY000]: General error: 1005 Can't create table 'PNE2.#sql-3e7_3e4' (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.14 sec)
>> upgrade   Processing member_basic
 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'. 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.01 sec)
>> upgrade   Processing files
 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'PNE2.c_image' doesn't exist. Failing Query: "INSERT IGNORE INTO file (id, name, type, original_filename, created_at, updated_at) (SELECT c_image_id, filename, type, filename, r_datetime, r_datetime FROM c_image);"
>> upgrade   Processed files (0.00 sec)
>> upgrade   Processing admin_user
 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'. Failing Query: "INSERT INTO admin_user (id, username, password, created_at, updated_at) (SELECT c_admin_user_id, username, password, NOW(), NOW() FROM c_admin_user WHERE auth_type = "all");"
>> upgrade   Processed admin_user (0.00 sec)
>> upgrade   Processing member_secure
>> upgrade   Processed member_secure (0.02 sec)
>> upgrade   Processing member_email
>> upgrade   Processed member_email (0.04 sec)
>> upgrade   Processing intro_friend
 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'PNE2.c_friend' doesn't exist. Failing Query: "INSERT INTO intro_friend (id, member_id_to, member_id_from, content, created_at, updated_at) (SELECT NULL, c_member_id_to, c_member_id_from, intro, r_datetime_intro, r_datetime_intro FROM c_friend WHERE intro <> "");"
>> upgrade   Processed intro_friend (0.00 sec)
>> upgrade   Processing member_relationship
 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'PNE2.c_friend' doesn't exist. Failing Query: "SELECT c_member_id_from, c_member_id_to FROM c_friend"
>> upgrade   Processed member_relationship (0.00 sec)
>> upgrade   Processing profile
 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'PNE2.c_profile' doesn't exist
>> upgrade   Processed profile (0.00 sec)
>> upgrade   Processing member_image
>> upgrade   Processed member_image (0.02 sec)
>> upgrade   Processing member_image_cleanup
>> upgrade   Processed member_image_cleanup (0.00 sec)
>> upgrade   Processing member_config
>> upgrade   Processed member_config (0.02 sec)
>> upgrade   Processing album
 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'PNE2.c_album' doesn't exist. Failing Query: "ALTER TABLE c_album CHANGE album_cover_image album_cover_image text CHARACTER SET utf8 COLLATE utf8_unicode_ci;"
>> upgrade   Processed album (0.00 sec)
>> upgrade   Processing diary
 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'PNE2.c_diary' doesn't exist. Failing Query: "INSERT INTO diary (id, member_id, title, body, public_flag, has_images, created_at, updated_at) (SELECT c_diary_id, c_member_id, subject, body, public_flag, 1, r_datetime, u_datetime FROM c_diary WHERE image_filename_1 <> "" OR image_filename_2 <> "" OR image_filename_3 <> "");"
>> upgrade   Processed diary (0.00 sec)
>> upgrade   Processing community
 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'
>> upgrade   Processed community (0.04 sec)
>> upgrade   Processing community_member
 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'. Failing Query: "INSERT INTO community_member (id, community_id, member_id, is_receive_mail_pc, is_receive_mail_mobile, created_at, updated_at) (SELECT c_commu_member_id, c_commu_id, c_member_id, is_receive_mail_pc, is_receive_mail, r_datetime, r_datetime FROM c_commu_member);"
>> upgrade   Processed community_member (0.00 sec)
>> upgrade   Processing community_config
>> upgrade   Processed community_config (0.03 sec)
>> upgrade   Processing community_topic
 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'PNE2.c_commu_topic' doesn't exist. Failing Query: "INSERT INTO community_topic (id, community_id, member_id, name, body, topic_updated_at, created_at, updated_at) (SELECT c_commu_topic_id, c_commu_id, c_member_id, name, "", u_datetime, r_datetime, r_datetime FROM c_commu_topic WHERE event_flag = 0);"
>> upgrade   Processed community_topic (0.00 sec)
>> upgrade   Processing ashiato
 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'PNE2.c_ashiato' doesn't exist. Failing Query: "INSERT INTO ashiato (id, member_id_from , member_id_to, r_date, created_at, updated_at) (SELECT c_ashiato_id, c_member_id_from, c_member_id_to, r_date, r_datetime, r_datetime FROM c_ashiato);"
>> upgrade   Processed ashiato (0.00 sec)
>> upgrade   Processing blacklist
 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'PNE2.c_blacklist' doesn't exist. Failing Query: "INSERT INTO blacklist (id, uid, memo, created_at, updated_at) (SELECT c_blacklist_id, easy_access_id, info, NOW(), NOW() FROM c_blacklist);"
>> upgrade   Processed blacklist (0.00 sec)
>> upgrade   Processing favorite
 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'. Failing Query: "INSERT INTO favorite (id, member_id_to, member_id_from, created_at, updated_at) (SELECT c_bookmark_id, c_member_id_to, c_member_id_from, r_datetime, r_datetime FROM c_bookmark);"
>> upgrade   Processed favorite (0.00 sec)
>> upgrade   Processing admin_config
 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'sns_name' for key 'name_UNIQUE_idx'
>> upgrade   Processed admin_config (0.00 sec)
>> upgrade   Processing sns_term
>> upgrade   Processed sns_term (0.07 sec)
>> upgrade   Processing skin_config
 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'PNE2.c_config_color' doesn't exist
>> upgrade   Processed skin_config (0.36 sec)
>> upgrade   Processing decoration
 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'richtextarea_unenable_buttons' for key 'name_UNIQUE_idx'. Failing Query: "INSERT INTO sns_config (id, name, value) VALUES (NULL, "richtextarea_unenable_buttons", 'a:0:{}');"
>> upgrade   Processed decoration (0.00 sec)
>> upgrade   Processing mobile_color_config
 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'PNE2.c_config_color_ktai' doesn't exist. Failing Query: "INSERT INTO sns_config (id, name, value) (SELECT NULL, "mobile_frontend_core_color_1", CONCAT("#", color_1) FROM c_config_color_ktai LIMIT 1);"
>> upgrade   Processed mobile_color_config (0.00 sec)
>> upgrade   Processing load_data
 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'OpenPNE_revision' for key 'name_UNIQUE_idx'
>> upgrade   Processed load_data (0.84 sec)
>> upgrade   Processing gadget
>> upgrade   Processed gadget (0.00 sec)
>> upgrade   Processing message
 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'PNE2.c_message' doesn't exist. Failing Query: "INSERT INTO message (id, member_id, subject, body, is_deleted, is_send, thread_message_id, return_message_id, message_type_id, foreign_id, created_at, updated_at) (SELECT c_message_id, c_member_id_from, subject, body, is_deleted_from, is_send, NULL, hensinmoto_c_message_id, 1, NULL, r_datetime, r_datetime FROM c_message);"
>> upgrade   Processed message (0.00 sec)
>> upgrade   Processing banner
 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'PNE2.c_banner' doesn't exist. Failing Query: "ALTER TABLE c_banner CHANGE image_filename image_filename text CHARACTER SET utf8 COLLATE utf8_unicode_ci;"
>> upgrade   Processed banner (0.00 sec)
>> upgrade   Processing confirmation
 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'PNE2.c_commu_admin_confirm' doesn't exist. Failing Query: "INSERT INTO community_member_position (id, community_id, member_id, community_member_id, name, created_at, updated_at) (SELECT NULL, c_commu_id, c_member_id_to, (SELECT cm.id FROM community_member AS cm WHERE cm.community_id = c_commu_id AND cm.member_id = c_member_id_to LIMIT 1), "admin_confirm", r_datetime, r_datetime FROM c_commu_admin_confirm);"
>> upgrade   Processed confirmation (0.00 sec)
>> upgrade   Processing mobile_uid_bc_config
 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'op_auth_MobileUID_plugin_uid_type' for key 'name_UNIQUE_idx'. Failing Query: "INSERT INTO sns_config (name, value) VALUES ("op_auth_MobileUID_plugin_uid_type", "0");"
>> 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.00 sec)
>> upgrade   Processing fix_old_image_data
>> upgrade   Processed fix_old_image_data (1.72 sec)
>> upgrade   Completed Upgrading (11.20 sec)
>> upgrade   The 91.25 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
>> plugin    Configuring plugin - opSkinClassicPlugin
>> plugin    Configuring plugin - opWebAPIPlugin
>> plugin    Configuring plugin - sfDoctrinePlugin
>> plugin    Configuring plugin - sfFormExtraPlugin
>> plugin    Configuring plugin - sfImageHandlerPlugin
>> plugin    Configuring plugin - sfProtoculousPlugin
>> plugin    Configuring plugin - sfSymfonyTemplatingViewPlugin

http://ohimesama-y.hatenablog.com/entry/2014/04/08/145403


Total access 968:本日 1:昨日 0

Counter: 968, today: 1, yesterday: 0

トップ   編集 凍結 差分 履歴 添付 複製 名前変更 リロード   新規 一覧 検索 最終更新   ヘルプ   最終更新のRSS
Last-modified: 2019-01-17 (木) 10:52:56