OSDN -- 開發和下載開源軟體
繁體中文翻譯狀態 translation status for zh-tw

討論區: 質問コーナー (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

回覆 #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.) 登入

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
回覆: #79335

回覆 #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.) 登入

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

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

回覆 #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.) 登入

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

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

いつもながらご対応に感謝いたします
回覆: #79358

回覆 #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.) 登入