HOME画面が内部エラーになる。

[okahe...@gmail.com]

2013-07-31 17:54:48 Error: [PDOException] SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near "SELECT"
LINE 1: ..."id")  WHERE "Project"."status" = 1 AND "EXISTS" (SELECT em....

HOME画面が内部エラーになります。

ログで上記が吐かれますが、これだけだとエラー箇所が特定できず、困っております。
(初心者ゆえ、かもしれません)
何か特定する方法や情報をご教授願います。

[Yusuke Ando]

御連絡ありがとうございます。

お使いのDBとPHPのバージョンと完全なエラーメッセージを提示して頂けますか？

2013/7/31 <okahe...@gmail.com>

--
このメールは Google グループのグループ「candycane-users」の登録者に送られています。
このグループから退会し、メールの受信を停止するには、candycane-use...@googlegroups.com にメールを送信します。
その他のオプションについては、https://groups.google.com/groups/opt_out にアクセスしてください。
 
 

[okahe...@gmail.com]

お世話になります。


DB：postgresql

PHP：phpPgAdmin5.1

です。


今朝のログです。


2013-08-01 09:35:44 Error: [PDOException] SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near "SELECT"

LINE 1: ..."id")  WHERE "Project"."status" = 1 AND "EXISTS" (SELECT em....

                                                             ^
Request URL: /candycane-master/
Stack Trace:
#0 /var/www/html/candycane-master/lib/Cake/Model/Datasource/DboSource.php(460): PDOStatement->execute(Array)
#1 /var/www/html/candycane-master/lib/Cake/Model/Datasource/DboSource.php(426): DboSource->_execute('SELECT "News"."...', Array)
#2 /var/www/html/candycane-master/lib/Cake/Model/Datasource/DboSource.php(670): DboSource->execute('SELECT "News"."...', Array, Array)
#3 /var/www/html/candycane-master/lib/Cake/Model/Datasource/DboSource.php(1081): DboSource->fetchAll('SELECT "News"."...', false)
#4 /var/www/html/candycane-master/lib/Cake/Model/Model.php(2696): DboSource->read(Object(News), Array)
#5 /var/www/html/candycane-master/app/Model/News.php(58): Model->find('all', Array)
#6 /var/www/html/candycane-master/app/Controller/WelcomeController.php(16): News->latest(Array)
#7 [internal function]: WelcomeController->index()
#8 /var/www/html/candycane-master/lib/Cake/Controller/Controller.php(486): ReflectionMethod->invokeArgs(Object(WelcomeController), Array)
#9 /var/www/html/candycane-master/lib/Cake/Routing/Dispatcher.php(187): Controller->invokeAction(Object(CakeRequest))
#10 /var/www/html/candycane-master/lib/Cake/Routing/Dispatcher.php(162): Dispatcher->_invoke(Object(WelcomeController), Object(CakeRequest), Object(CakeResponse))
#11 /var/www/html/candycane-master/app/webroot/index.php(96): Dispatcher->dispatch(Object(CakeRequest), Object(CakeResponse))
#12 {main}


よろしくお願いいたします。

[okahe...@gmail.com]

お世話になっております。
追記です。

下記SQL文が発行されておりました。

SELECT "News"."id" AS "News__id", "News"."project_id" AS "News__project_id", "News"."title" AS "News__title", "News"."summary" AS "News__summary", "News"."description" AS "News__description", "News"."author_id" AS "News__author_id", "News"."created_on" AS "News__created_on", "News"."comments_count" AS "News__comments_count", "Project"."id" AS "Project__id", "Project"."name" AS "Project__name", "Project"."description" AS "Project__description", "Project"."homepage" AS "Project__homepage", "Project"."is_public" AS "Project__is_public", "Project"."parent_id" AS "Project__parent_id", "Project"."projects_count" AS "Project__projects_count", "Project"."created_on" AS "Project__created_on", "Project"."updated_on" AS "Project__updated_on", "Project"."identifier" AS "Project__identifier", "Project"."status" AS "Project__status", "Author"."id" AS "Author__id", "Author"."login" AS "Author__login", "Author"."hashed_password" AS "Author__hashed_password", "Author"."firstname" AS "Author__firstname", "Author"."lastname" AS "Author__lastname", "Author"."mail" AS "Author__mail", "Author"."mail_notification" AS "Author__mail_notification", "Author"."admin" AS "Author__admin", "Author"."status" AS "Author__status", "Author"."last_login_on" AS "Author__last_login_on", "Author"."language" AS "Author__language", "Author"."auth_source_id" AS "Author__auth_source_id", "Author"."created_on" AS "Author__created_on", "Author"."updated_on" AS "Author__updated_on", "Author"."type" AS "Author__type" FROM "public"."news" AS "News" LEFT JOIN "public"."projects" AS "Project" ON ("News"."project_id" = "Project"."id") LEFT JOIN "public"."users" AS "Author" ON ("News"."author_id" = "Author"."id")

WHERE "Project"."status" = 1

AND "EXISTS" (SELECT em.id FROM enabled_modules em WHERE em.name='news' AND em.project_id = "Project"."id") 'TRUE'
ORDER BY "News"."created_on" DESC LIMIT 5

AND "EXISTS" (SELECT em.id FROM enabled_modules em WHERE em.name='news' AND em.project_id = "Project"."id") 'TRUE'
でのエラーであることがわかりました。
これはphpとpostgresの相性？の問題になりますでしょうか。

何か解決策ありましたらご教授願います。

lib/Cake/VERSION.txt　2.3.4
PostgreSQL 8.4.13



2013年7月31日水曜日 18時00分49秒 UTC+9 okahe...@gmail.com:

[Yusuke Ando]

こちら修正をプッシュしておきました。

最新のコードで試してみて下さい。

2013/8/5 <okahe...@gmail.com>

--

[okahe...@gmail.com]

お世話になります。
先ほど、新しい環境にて、インストールして実行いたしましたが、
同様のエラーにて、動作も同じでした。

postgreのバージョンを9.1.4にすれば、解決する問題なのでしょうか？




2013年8月6日火曜日 1時04分56秒 UTC-7 yando:

こちら修正をプッシュしておきました。

最新のコードで試してみて下さい。

2013/8/5 <okahe...@gmail.com>

このグループから退会し、メールの受信を停止するには、candycane-users+unsubscribe@googlegroups.com にメールを送信します。
その他のオプションについては、https://groups.google.com/groups/opt_out にアクセスしてください。
 
 

[okahe...@gmail.com]

postgre: 8.4.13

[okahe...@gmail.com]

お世話になります。
追記です。


1     Bug     New     Normal     Sample Ticket

チケットの一覧にて、[Sample Ticket]をクリックすると、
下記エラーが発生いたします。
あわせて、お願い申し上げます。


Error: [PDOException] SQLSTATE[42803]: Grouping error: 7 ERROR:  column "Status.position" must appear in the GROUP BY clause or be used in an aggregate function
Request URL: /candycane/issues/show/1
Stack Trace:
#0 /var/www/html/candycane/lib/Cake/Model/Datasource/DboSource.php(460): PDOStatement->execute(Array)
#1 /var/www/html/candycane/lib/Cake/Model/Datasource/DboSource.php(426): DboSource->_execute('SELECT "Status"...', Array)
#2 /var/www/html/candycane/lib/Cake/Model/Datasource/DboSource.php(670): DboSource->execute('SELECT "Status"...', Array, Array)
#3 /var/www/html/candycane/lib/Cake/Model/Datasource/DboSource.php(1081): DboSource->fetchAll('SELECT "Status"...', false)
#4 /var/www/html/candycane/lib/Cake/Model/Model.php(2696): DboSource->read(Object(Workflow), Array)
#5 /var/www/html/candycane/app/Model/IssueStatus.php(111): Model->find('all', Array)
#6 /var/www/html/candycane/app/Model/Issue.php(481): IssueStatus->find_new_statuses_allowed_to(1, 1, 1)
#7 /var/www/html/candycane/app/Controller/IssuesController.php(255): Issue->findStatusList(1)
#8 [internal function]: IssuesController->show()
#9 /var/www/html/candycane/lib/Cake/Controller/Controller.php(486): ReflectionMethod->invokeArgs(Object(IssuesController), Array)
#10 /var/www/html/candycane/lib/Cake/Routing/Dispatcher.php(187): Controller->invokeAction(Object(CakeRequest))
#11 /var/www/html/candycane/lib/Cake/Routing/Dispatcher.php(162): Dispatcher->_invoke(Object(IssuesController), Object(CakeRequest), Object(CakeResponse))
#12 /var/www/html/candycane/app/webroot/index.php(96): Dispatcher->dispatch(Object(CakeRequest), Object(CakeResponse))
#13 {main}
2013-08-06 22:35:08 Warning: Warning (2): date() [http://php.net/function.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 'America/Los_Angeles' for 'PDT/-7.0/DST' instead in [/var/www/html/candycane/app/View/Layouts/base.ctp, line 90]
Trace:
date - [internal], line ??
include - APP/View/Layouts/base.ctp, line 90
View::_evaluate() - CORE/Cake/View/View.php, line 947
View::_render() - CORE/Cake/View/View.php, line 909
View::renderLayout() - CORE/Cake/View/View.php, line 535
View::render() - CORE/Cake/View/View.php, line 479
Controller::render() - CORE/Cake/Controller/Controller.php, line 948
ExceptionRenderer::_outputMessage() - CORE/Cake/Error/ExceptionRenderer.php, line 274
ExceptionRenderer::error500() - CORE/Cake/Error/ExceptionRenderer.php, line 243
ExceptionRenderer::render() - CORE/Cake/Error/ExceptionRenderer.php, line 176
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 123
[main] - [internal], line ??




2013年7月31日水曜日 2時00分49秒 UTC-7 okahe...@gmail.com: