Foros: 質問コーナー (Thread #38350)

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

Responder al #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.) Entrar

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
Responder al #79335

Responder al #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.) Entrar

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

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

Responder al #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.) Entrar

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

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

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

Responder al #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.) Entrar