OSDN -- Develop and Download Open Source Software

Forums: 質問コーナー (Thread #38350)
Return to Thread list RSS

PostgressSQLのフォトギャラリー (2017-02-01 11:17 by magic3Fan #79335)

SQLでソートエラーと思われます。
DB failed: SQLSTATE[42P10]: Invalid column reference: 7 ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 1: ...arent_id > 0 AND pc1.hc_language_id = $1 ORDER BY pc2.hc_sor... ^ error code: 42P10

Reply to #79335×

You can not use Wiki syntax
You are not logged in. To discriminate your posts from the rest, you need to pick a nickname. (The uniqueness of nickname is not reserved. It is possible that someone else could use the exactly same nickname. If you want assurance of your identity, you are recommended to login before posting.) Login

Re: PostgressSQLのフォトギャラリー　追記 (2017-02-02 15:50 by magic3Fan #79342)

日付が入っていないとデータ更新ができません
DB failed: SQLSTATE[22007]: Invalid datetime format: 7 ERROR: invalid input syntax for type date: "" error code: 22007DB failed: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block error code: 25P02DB failed: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block error code: 25P02
Reply to #79335

Reply to #79342×

You can not use Wiki syntax
You are not logged in. To discriminate your posts from the rest, you need to pick a nickname. (The uniqueness of nickname is not reserved. It is possible that someone else could use the exactly same nickname. If you want assurance of your identity, you are recommended to login before posting.) Login

Re: PostgressSQLのフォトギャラリー　追記 (2017-02-06 20:06 by fishbone #79358)

修正しました。
v2.18.4以降、対応済みです。
Reply to #79342

Reply to #79358×

You can not use Wiki syntax
You are not logged in. To discriminate your posts from the rest, you need to pick a nickname. (The uniqueness of nickname is not reserved. It is possible that someone else could use the exactly same nickname. If you want assurance of your identity, you are recommended to login before posting.) Login

Re: PostgressSQLのフォトギャラリー　追記 (2017-02-15 12:52 by magic3Fan #79405)

[メッセージ #79358 への返信]
> 修正しました。
> v2.18.4以降、対応済みです。

いつもながらご対応に感謝いたします
Reply to #79358

Reply to #79405×

You can not use Wiki syntax
You are not logged in. To discriminate your posts from the rest, you need to pick a nickname. (The uniqueness of nickname is not reserved. It is possible that someone else could use the exactly same nickname. If you want assurance of your identity, you are recommended to login before posting.) Login