Re: Re: MAMP 2.0.3 -> 3.0.7.3で以前のc5サイトが表示されない

2014年12月8日 at 12:13

一つのc5にアクセスしたものが下記です。
apache_error.log
--------
[Mon Dec 08 12:00:58 2014] [error] [client 127.0.0.1] File does not exist: /Applications/MAMP/htdocs/*****

mysql_error_log.err
--------
141208 12:00:58 [ERROR] Cannot find or open table *c5インストール名*/config from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
Seehttp://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.

141208 12:00:59 [ERROR] Cannot find or open table *c5インストール名*/logs from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
Seehttp://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.

141208 12:00:59 [ERROR] Cannot find or open table *c5インストール名*/config from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
Seehttp://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.

141208 12:00:59 [ERROR] Cannot find or open table *c5インストール名*/logs from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
Seehttp://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting.html
how you can resolve the problem.
--------
php_error.log
-------
[08-Dec-2014 04:00:59 Europe/Berlin] PHP Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1146: Table '*c5インストール名*.logs' doesn't exist] in EXECUTE("insert into Logs (logType, logText, logIsInternal, logUserID) values ('exceptions', 'Exception Occurred: /Applications/MAMP/htdocs/*c5インストール名*/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 mysql error: [1146: Table \'*c5インストール名*.config\' doesn\'t exist] in EXECUTE("select * from Config where uID = 0 order by cfKey asc")\n (1146)\n\n#0 /Applications/MAMP/htdocs/*c5インストール名*/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw(\'mysql\', \'EXECUTE\', 1146, \'Table \'*c5インストール名*...\', \'select * from C...\', false, Object(ADODB_mysql))\n#1 /Applications/MAMP/htdocs/*c5インストール名*/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute(\'select * from C...\', false)\n#2 /Applications/MAMP/htdocs/*c5インストール名*/concrete/core/models/config.php(182): ADOConnection->Execute(\'select * from C...\')\n#3 /Applications/MAMP/htdocs/*c5インストール名*/concrete/core/models in /Applications/MAMP/htdocs/*c5インストール名*/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
[08-Dec-2014 04:00:59 Europe/Berlin] PHP Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1146: Table '*c5インストール名*.logs' doesn't exist] in EXECUTE("insert into Logs (logType, logText, logIsInternal, logUserID) values ('exceptions', 'Exception Occurred: /Applications/MAMP/htdocs/*c5インストール名*/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 mysql error: [1146: Table \'*c5インストール名*.config\' doesn\'t exist] in EXECUTE("select * from Config where uID = 0 order by cfKey asc")\n (1146)\n\n#0 /Applications/MAMP/htdocs/*c5インストール名*/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw(\'mysql\', \'EXECUTE\', 1146, \'Table \'*c5インストール名*...\', \'select * from C...\', false, Object(ADODB_mysql))\n#1 /Applications/MAMP/htdocs/*c5インストール名*/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute(\'select * from C...\', false)\n#2 /Applications/MAMP/htdocs/*c5インストール名*/concrete/core/models/config.php(182): ADOConnection->Execute(\'select * from C...\')\n#3 /Applications/MAMP/htdocs/*c5インストール名*/concrete/core/models in /Applications/MAMP/htdocs/*c5インストール名*/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
---------
以上ですが、これでいいでしょうか。
c5は v5.6.2.1 です。

Re: MAMP 2.0.3 -> 3.0.7.3で以前のc5サイトが表示されない

2014年12月8日 at 12:35
Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database?


InnoDBデータファイルを削除または再作成した際に、InnoDBテーブルに対応する .frm ファイルを削除し忘れたか、.frm ファイルを他のデータベースに移していませんか?と書いてありますね。これ以上は私もよく分かりませんが、MAMPのバージョンアップの際にどのようなデータベース移行作業をしたかですが、ともかくMAMPのアップグレード時にMySQLデータベースの移行に失敗したようですね。