![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
#author("2019-01-17T10:48:31+09:00","default:kuji","kuji") #author("2019-01-17T10:52:56+09:00","default:kuji","kuji") CONTENTS #contents ---- Lastmodified &lastmod; ---- 画像が変換・移行できない。 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 [#e74cc87c] アップロード画像のリンク先画像が小さくなる。 * PHP 5.6.39 ⇒ PHP 7.* すると、OpenPNE2系は [#w4ccaed5] 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 [#i1364e36] mysqldump -u root -p database_name > dump.sql ** mysql -u root -p -D PNE2 < /usr/home/db/MySQL/PNE2.sql [#z088abc1] **unzip openpne-OpenPNE3-OpenPNE-3.6.32.zip [#c7555188] **chown -R www:www openpne-OpenPNE3-47251b6 [#x1a5763e] **mv openpne-OpenPNE3-47251b6 OpenPNE3 [#ee198441] **cp config/ProjectConfiguration.class.php.sample config/ProjectConfiguration.class.php [#l0903006] cp config/ProjectConfiguration.class.php.sample config/ProjectConfiguration.class.php **cp config/OpenPNE.yml.sample config/OpenPNE.yml [#pca72f35] cp config/OpenPNE.yml.sample config/OpenPNE.yml **vi OpenPNE.yml [#ja6b1b60] ###################################### # 基本設定 (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 [#dcf5a321] **./symfony opPlugin:sync [#med6d028] >> 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 [#r55be650] >> 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 [#e5846a88] >> 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 [#y83a25e4] >> 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 [#ef215a83] >> 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 [#i712c322] >> 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 &counter(total);：本日 &counter(today);：昨日 &counter(yesterday); #counter([total|today|yesterday]);
