apache_error.log
php_error.log
mysql_error_log.err
が有ります。
apache_error.log
--------
[Sun Dec 07 13:49:33 2014] [notice] FastCGI: process manager initialized (pid 5589)
[Sun Dec 07 13:49:34 2014] [notice] Digest: generating secret for digest authentication ...
[Sun Dec 07 13:49:34 2014] [notice] Digest: done
[Sun Dec 07 13:49:34 2014] [notice] Apache/2.2.29 (Unix) mod_fastcgi/2.4.6 mod_wsgi/3.4 Python/2.7.8 PHP/5.6.2 mod_ssl/2.2.29 OpenSSL/0.9.8za DAV/2 mod_perl/2.0.8 Perl/v5.20.0 configured -- resuming normal operations
[Sun Dec 07 13:52:39 2014] [notice] caught SIGTERM, shutting down
[Sun Dec 07 13:52:41 2014] [notice] FastCGI: process manager initialized (pid 5744)
[Sun Dec 07 13:52:41 2014] [notice] Digest: generating secret for digest authentication ...
[Sun Dec 07 13:52:41 2014] [notice] Digest: done
[Sun Dec 07 13:52:41 2014] [notice] Apache/2.2.29 (Unix) mod_fastcgi/2.4.6 mod_wsgi/3.4 Python/2.7.8 PHP/5.5.18 mod_ssl/2.2.29 OpenSSL/0.9.8za DAV/2 mod_perl/2.0.8 Perl/v5.20.0 configured -- resuming normal operations
[Sun Dec 07 13:52:49 2014] [error] [client 127.0.0.1] File does not exist: /Applications/MAMP/htdocs/docs-assets, referer:http://localhost:8888/MAMP/?language=Japanese
[Sun Dec 07 14:34:20 2014] [error] [client ::1] client denied by server configuration: /Applications/MAMP/htdocs/.DS_Store, referer:http://localhost:8888/*****/index.php/
[Sun Dec 07 15:31:23 2014] [error] [client 127.0.0.1] script '/Applications/MAMP/bin/phpMyAdmin/main.php' not found or unable to stat, referer:http://localhost:8888/phpMyAdmin/?lang=ja
[Sun Dec 07 15:34:18 2014] [error] [client 127.0.0.1] script '/Applications/MAMP/bin/phpMyAdmin/main.php' not found or unable to stat, referer:http://localhost:8888/phpMyAdmin/?lang=ja
[Sun Dec 07 15:34:21 2014] [error] [client 127.0.0.1] script '/Applications/MAMP/bin/phpMyAdmin/main.php' not found or unable to stat, referer:http://localhost:8888/phpMyAdmin/?lang=ja
[Sun Dec 07 15:35:08 2014] [error] [client 127.0.0.1] script '/Applications/MAMP/bin/phpMyAdmin/main.php' not found or unable to stat, referer:http://localhost:8888/phpMyAdmin/?lang=ja
--------
php_error.logはかなりの量ですがここに載せても大丈夫でしょうか。
.errファイルは何で開いたらいいのでしょうか。
Re: MAMP 2.0.3 -> 3.0.7.3で以前のc5サイトが表示されない
2014年12月8日 at 10:37
私自身はMAMPの２→３のアップデートはしたことがないので、MySQLの挙動がどうなっているのかわかりません。（クリーンインストールならしましたが）
実際表示できなくなっているサイトには何が表示されていて（あるいはなにが表示されなくて）という情報など、もう少し具体的に教えていただければ、私以外の方でもアドバイスができると思うんです。
何かが出来ないというのは、なにか問題があるからだと思うので、
それを絞り込むには情報が足りません。
Re: MAMP 2.0.3 -> 3.0.7.3で以前のc5サイトが表示されない
2014年12月8日 at 11:54
テキストエディタで開きます。一度エラーログファイルの内容を削除してから、表示されない以前のサイトにアクセスし、再度エラーログファイルを開き、追加されたと思われるものだけ貼ってください。でないと、原因なのかどうかが分かりません。
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 です。
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データベースの移行に失敗したようですね。
takuro hishikawa
Re: MAMP 2.0.3 -> 3.0.7.3で以前のc5サイトが表示されない