Project

General

Profile

Bug(バグ) #234

The display of the type of the date in the profile is not correct (プロフィール画面の日付型データが表示が正しくない)

Added by Shingo Yamada over 10 years ago. Updated over 10 years ago.

Status:
Fixed(完了)
Priority:
Normal(通常)
Target version:
Start date:
2009-11-13
Due date:
% Done:

100%

3.6 で発生するか:
Unknown (未調査)
3.8 で発生するか:
Unknown (未調査)

Description

■現象
プロフィール画面の生年月日表示がおかしい
(添付画像参照)

【環境】
3.1.5-dev(公式デモサイト)

【備考】
新規登録メンバーのみに発生している

クリップボード01.gif View (25.2 KB) Shingo Yamada, 2009-11-13 18:04

Associated revisions

Revision b6445a0a (diff)
Added by Kousuke Ebihara over 10 years ago

member_profile.value_datetime is now for presetting datetime profile. And also "0000-00-00 00:00:00" is now handled as null in getter (fixes #234)

History

#1 Updated by Shingo Yamada over 10 years ago

DBレコードに問題はなさそうです

mysql> select * from member_profile where member_id=862;
+------+-----------+------------+-------------------+--------------+-------------+----------+------+------+-------+---------------------+---------------------+---------------------+
| id   | member_id | profile_id | profile_option_id | value        | public_flag | tree_key | lft  | rgt  | level | created_at          | updated_at          | value_datetime      |
+------+-----------+------------+-------------------+--------------+-------------+----------+------+------+-------+---------------------+---------------------+---------------------+
| 4390 |       862 |          1 |                 1 |              |           1 |     4390 |    1 |    2 |     0 | 2009-11-10 17:11:35 | 2009-11-10 17:11:36 | NULL                |
| 4391 |       862 |          2 |              NULL |              |           1 |     4391 |    1 |    8 |     0 | 2009-11-10 17:11:36 | 2009-11-10 17:11:36 | 0001-01-01 00:00:00 |
| 4392 |       862 |          2 |                 2 | 2009         |        NULL |     4391 |    2 |    3 |     1 | 2009-11-10 17:11:36 | 2009-11-10 17:11:36 | 0000-00-00 00:00:00 |
| 4393 |       862 |          2 |                 3 | 11           |        NULL |     4391 |    4 |    5 |     1 | 2009-11-10 17:11:36 | 2009-11-10 17:11:36 | 0000-00-00 00:00:00 |
| 4394 |       862 |          2 |                 4 | 10           |        NULL |     4391 |    6 |    7 |     1 | 2009-11-10 17:11:36 | 2009-11-10 17:11:36 | 0000-00-00 00:00:00 |
| 4395 |       862 |          3 |              NULL | わたしだ     |           1 |     4395 |    1 |    2 |     0 | 2009-11-10 17:11:36 | 2009-11-10 17:11:36 | NULL                |
+------+-----------+------------+-------------------+--------------+-------------+----------+------+------+-------+---------------------+---------------------+---------------------+
6 rows in set (0.00 sec)

#2 Updated by Kousuke Ebihara over 10 years ago

  • Target version deleted (OpenPNE 3.1.5)

#3 Updated by Shogo Kawahara over 10 years ago

  • Status changed from New(新規) to Pending Fixing(修正待ち)

When MemberProfile get data of date type, if value_datetime exists, it doesn't read tree data.

データ取得の際に、value_datetimeに値が存在するならばツリーの内容を読み取らないのが原因です。

#4 Updated by Shogo Kawahara over 10 years ago

  • Subject changed from プロフィール画面の生年月日表示がおかしい to The display of the type of the date in the profile is not correct (プロフィール画面の生年月日表示が正しくない)

#5 Updated by Shogo Kawahara over 10 years ago

  • Subject changed from The display of the type of the date in the profile is not correct (プロフィール画面の生年月日表示が正しくない) to The display of the type of the date in the profile is not correct (プロフィール画面の日付型データが表示が正しくない)

#6 Updated by Shogo Kawahara over 10 years ago

  • Target version set to OpenPNE 3.2beta1

#7 Updated by Kousuke Ebihara over 10 years ago

  • Status changed from Pending Fixing(修正待ち) to Accepted(着手)
  • Assignee set to Kousuke Ebihara

#8 Updated by Kousuke Ebihara over 10 years ago

  • Status changed from Accepted(着手) to Pending Review(レビュー待ち)
  • % Done changed from 0 to 50

更新履歴commit:"b6445a0a40700daa193d1f43280fbef493da02aa"で適用されました。

#9 Updated by Kousuke Ebihara over 10 years ago

  • Status changed from Pending Review(レビュー待ち) to Fixed(完了)
  • % Done changed from 50 to 100

Also available in: Atom PDF