teratail
回答率
85.47%
質問するログイン新規登録
トップに関する質問【MySQL】Error: Incorrect datetime value

編集履歴

質問編集履歴

1

関連ファイルが違うものを記載していたため修正

2020/03/29 04:56

投稿

ryouya
ryouya

スコア14

test CHANGED
File without changes
test CHANGED
@@ -74,79 +74,67 @@
74
74
 
75
75
  ```
76
76
 
77
- #users.yml
78
-
79
- michael:
80
-
81
- name: Michael Example
82
-
83
- email: michael@example.com
84
-
85
- password_digest: <%= User.digest('password') %>
86
-
87
- admin: true
88
-
89
- activated: true
90
-
91
- activated_at: <%= Time.zone.now %>
92
-
93
-
94
-
95
- archer:
96
-
97
- name: Sterling Archer
98
-
99
- email: duchess@example.gov
100
-
101
- password_digest: <%= User.digest('password') %>
102
-
103
- activated: true
104
-
105
- activated_at: <%= Time.zone.now %>
106
-
107
-
108
-
109
- lana:
110
-
111
- name: Lana Kane
112
-
113
- email: hands@example.gov
114
-
115
- password_digest: <%= User.digest('password') %>
116
-
117
- activated: true
118
-
119
- activated_at: <%= Time.zone.now %>
120
-
121
-
122
-
123
- malory:
124
-
125
- name: Malory Archer
126
-
127
- email: boss@example.gov
128
-
129
- password_digest: <%= User.digest('password') %>
130
-
131
- activated: true
132
-
133
- activated_at: <%= Time.zone.now %>
134
-
135
-
77
+ #posts.yml
78
+
79
+ one:
80
+
81
+ store_name: MyString
82
+
83
+ address: MyString
84
+
85
+ image: MyString
86
+
87
+ environment: MyString
88
+
89
+ evaluation: MyString
90
+
91
+ time_start: MyString
92
+
93
+ time_end: MyString
94
+
95
+ user: one
96
+
97
+ created_at: <%= 2.hours.ago %>
98
+
99
+ user: michael
100
+
101
+
102
+
103
+ two:
104
+
105
+ store_name: MyString
106
+
107
+ address: MyString
108
+
109
+ image: MyString
110
+
111
+ environment: MyString
112
+
113
+ evaluation: MyString
114
+
115
+ time_start: MyString
116
+
117
+ time_end: MyString
118
+
119
+ user: two
120
+
121
+ created_at: convert_tz('<%= Time.zone.now %>', '+00:00','+09:00');
122
+
123
+ user: ants
124
+
125
+
136
126
 
137
127
  <% 30.times do |n| %>
138
128
 
139
- user_<%= n %>:
129
+ post_<%= n %>:
140
-
130
+
141
- name: <%= "User #{n}" %>
131
+ store_name: <%= Faker::Lorem.sentence(5) %>
142
-
132
+
143
- email: <%= "user-#{n}@example.com" %>
133
+ address: <%= Faker::Lorem.sentence(5) %>
144
-
145
- password_digest: <%= User.digest('password') %>
134
+
146
-
147
- activated: true
148
-
149
- activated_at: <%= Time.zone.now %>
135
+ created_at: <%= 42.days.ago %>
136
+
137
+ user: michael
150
138
 
151
139
  <% end %>
152
140