質問編集履歴
8
ログ差し替え
test
CHANGED
File without changes
|
test
CHANGED
@@ -25,6 +25,7 @@
|
|
25
25
|
F, [2022-01-18T08:00:11.713856 #4558] FATAL -- : [ea700483-a6b7-4916-b7cd-64444d18829b]
|
26
26
|
F, [2022-01-18T08:00:11.713974 #4558] FATAL -- : [ea700483-a6b7-4916-b7cd-64444d18829b] ActiveRecord::StatementInvalid (Mysql2::Error: Incorrect string value: '\xE3\x83\x86\xE3\x82\xB9...' for column 'name' at row 1: INSERT INTO `users` (`email`, `encrypted_password`, `image_id`, `name`, `created_at`, `updated_at`) VALUES ('test@test', '$2a$12$CzUc8yGNmRcMcUiLPyl5iexraum3ydrmUVTr4KCBovVppHoj8NTTa', NULL, 'テストユーザー', '2022-01-18 08:00:11', '2022-01-18 08:00:11')):
|
27
27
|
F, [2022-01-18T08:00:11.714088 #4558] FATAL -- : [ea700483-a6b7-4916-b7cd-64444d18829b]
|
28
|
+
|
28
29
|
```
|
29
30
|
|
30
31
|
ローカル環境のログ
|
@@ -53,6 +54,8 @@
|
|
53
54
|
Blog Load (0.1ms) SELECT "blogs".* FROM "blogs" WHERE "blogs"."user_id" = ? [["user_id", 10]]
|
54
55
|
Rendered users/mypage.html.erb within layouts/application (11.9ms)
|
55
56
|
Completed 200 OK in 126ms (Views: 98.0ms | ActiveRecord: 2.7ms)
|
57
|
+
|
58
|
+
|
56
59
|
```
|
57
60
|
|
58
61
|
Userモデル
|
7
追記
test
CHANGED
File without changes
|
test
CHANGED
@@ -15,10 +15,45 @@
|
|
15
15
|
原因、解決法のわかるからがいらっしゃいましたらご教示お願いいたします。
|
16
16
|
またそのほかに原因じゃないかと思われる点などございましたらお教えいただけますとありがたいです。
|
17
17
|
### ログ
|
18
|
-
|
18
|
+
```ここに言語を入力
|
19
|
+
I, [2022-01-18T08:00:11.405322 #4558] INFO -- : [ea700483-a6b7-4916-b7cd-64444d18829b] Parameters: {"utf8"=>"✓", "authenticity_token"=>"Y3dOxMiQMIeWdRCMs0dg8SBbptLqGN4L5fIXsNleyRDd9XLIZZSeyrEFQiUzDq6LQcPCFgLWf72DrB4YWxWwOg==", "user"=>{"image"=>"{}", "name"=>"テストユーザー", "email"=>"test@test", "password"=>"[FILTERED]", "password_confirmation"=>"[FILTERED]"}, "commit"=>"Sign up"}
|
20
|
+
D, [2022-01-18T08:00:11.707839 #4558] DEBUG -- : [ea700483-a6b7-4916-b7cd-64444d18829b] (0.8ms) BEGIN
|
21
|
+
D, [2022-01-18T08:00:11.709553 #4558] DEBUG -- : [ea700483-a6b7-4916-b7cd-64444d18829b] User Exists (1.0ms) SELECT 1 AS one FROM `users` WHERE `users`.`email` = BINARY 'test@test' LIMIT 1
|
22
|
+
D, [2022-01-18T08:00:11.711650 #4558] DEBUG -- : [ea700483-a6b7-4916-b7cd-64444d18829b] User Create (1.1ms) INSERT INTO `users` (`email`, `encrypted_password`, `image_id`, `name`, `created_at`, `updated_at`) VALUES ('test@test', '$2a$12$CzUc8yGNmRcMcUiLPyl5iexraum3ydrmUVTr4KCBovVppHoj8NTTa', NULL, 'テストユーザー', '2022-01-18 08:00:11', '2022-01-18 08:00:11')
|
23
|
+
D, [2022-01-18T08:00:11.712626 #4558] DEBUG -- : [ea700483-a6b7-4916-b7cd-64444d18829b] (0.8ms) ROLLBACK
|
24
|
+
I, [2022-01-18T08:00:11.712869 #4558] INFO -- : [ea700483-a6b7-4916-b7cd-64444d18829b] Completed 500 Internal Server Error in 307ms (ActiveRecord: 3.6ms)
|
25
|
+
F, [2022-01-18T08:00:11.713856 #4558] FATAL -- : [ea700483-a6b7-4916-b7cd-64444d18829b]
|
26
|
+
F, [2022-01-18T08:00:11.713974 #4558] FATAL -- : [ea700483-a6b7-4916-b7cd-64444d18829b] ActiveRecord::StatementInvalid (Mysql2::Error: Incorrect string value: '\xE3\x83\x86\xE3\x82\xB9...' for column 'name' at row 1: INSERT INTO `users` (`email`, `encrypted_password`, `image_id`, `name`, `created_at`, `updated_at`) VALUES ('test@test', '$2a$12$CzUc8yGNmRcMcUiLPyl5iexraum3ydrmUVTr4KCBovVppHoj8NTTa', NULL, 'テストユーザー', '2022-01-18 08:00:11', '2022-01-18 08:00:11')):
|
27
|
+
F, [2022-01-18T08:00:11.714088 #4558] FATAL -- : [ea700483-a6b7-4916-b7cd-64444d18829b]
|
28
|
+
```
|
19
29
|
|
20
30
|
ローカル環境のログ
|
21
|
-
|
31
|
+
```ここに言語を入力
|
32
|
+
Started POST "/users" for 101.102.239.190 at 2022-01-18 08:02:34 +0000
|
33
|
+
Cannot render console from 101.102.239.190! Allowed networks: 127.0.0.1, ::1, 127.0.0.0/127.255.255.255
|
34
|
+
Processing by Users::RegistrationsController#create as HTML
|
35
|
+
Parameters: {"utf8"=>"✓", "authenticity_token"=>"XyNOyDUyHA6WcGJLwTO253l9BTqOiSF284DFGc9VdcXXDtyvKAjOWS5Z+iZmJ1J115BAwzy8IQp3yDxQtDcYag==", "user"=>{"image"=>"{}", "name"=>"テストユーザー", "email"=>"test@test2", "password"=>"[FILTERED]", "password_confirmation"=>"[FILTERED]"}, "commit"=>"Sign up"}
|
36
|
+
(0.1ms) begin transaction
|
37
|
+
User Exists (0.2ms) SELECT 1 AS one FROM "users" WHERE "users"."email" = ? LIMIT ? [["email", "test@test2"], ["LIMIT", 1]]
|
38
|
+
User Create (3.1ms) INSERT INTO "users" ("email", "encrypted_password", "image_id", "name", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?) [["email", "test@test2"], ["encrypted_password", "$2a$12$6cTN0Ex4oZpjOaH3D5A.fO44fA.tlKk6fHmyg9xx4tXZUsym75yU."], ["image_id", nil], ["name", "テストユーザー"], ["created_at", "2022-01-18 08:02:35.150649"], ["updated_at", "2022-01-18 08:02:35.150649"]]
|
39
|
+
(4.2ms) commit transaction
|
40
|
+
Redirected to https://0acdecb5a0134f75bf79907b17a0cc95.vfs.cloud9.us-east-1.amazonaws.com/mypage
|
41
|
+
Completed 302 Found in 325ms (ActiveRecord: 7.6ms)
|
42
|
+
|
43
|
+
|
44
|
+
Started GET "/mypage" for 101.102.239.190 at 2022-01-18 08:02:35 +0000
|
45
|
+
Cannot render console from 101.102.239.190! Allowed networks: 127.0.0.1, ::1, 127.0.0.0/127.255.255.255
|
46
|
+
Processing by UsersController#mypage as HTML
|
47
|
+
User Load (1.8ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? ORDER BY "users"."id" ASC LIMIT ? [["id", 10], ["LIMIT", 1]]
|
48
|
+
(0.1ms) SELECT SUM("balances"."amount") FROM "balances" WHERE "balances"."user_id" = ? AND "balances"."period" BETWEEN ? AND ? AND "balances"."balance" = ? AND "balances"."period" BETWEEN ? AND ? [["user_id", 10], ["period", "2022-01-01"], ["period", "2022-01-31"], ["balance", 0], ["period", "2022-01-01"], ["period", "2022-01-31"]]
|
49
|
+
(0.1ms) SELECT SUM("balances"."amount") FROM "balances" WHERE "balances"."user_id" = ? AND "balances"."period" BETWEEN ? AND ? AND "balances"."balance" = ? AND "balances"."period" BETWEEN ? AND ? [["user_id", 10], ["period", "2022-01-01"], ["period", "2022-01-31"], ["balance", 1], ["period", "2022-01-01"], ["period", "2022-01-31"]]
|
50
|
+
(0.1ms) SELECT SUM("balances"."amount") FROM "balances" WHERE "balances"."user_id" = ? AND "balances"."balance" = ? [["user_id", 10], ["balance", 0]]
|
51
|
+
(0.1ms) SELECT SUM("balances"."amount") FROM "balances" WHERE "balances"."user_id" = ? AND "balances"."balance" = ? [["user_id", 10], ["balance", 1]]
|
52
|
+
Rendering users/mypage.html.erb within layouts/application
|
53
|
+
Blog Load (0.1ms) SELECT "blogs".* FROM "blogs" WHERE "blogs"."user_id" = ? [["user_id", 10]]
|
54
|
+
Rendered users/mypage.html.erb within layouts/application (11.9ms)
|
55
|
+
Completed 200 OK in 126ms (Views: 98.0ms | ActiveRecord: 2.7ms)
|
56
|
+
```
|
22
57
|
|
23
58
|
Userモデル
|
24
59
|
![イメージ説明](https://ddjkaamml8q8x.cloudfront.net/questions/2022-01-18/e8438c2e-8088-4aaf-b1c9-1ffb5b9b1216.png)
|
6
画像の差し替え
test
CHANGED
File without changes
|
test
CHANGED
@@ -23,3 +23,7 @@
|
|
23
23
|
Userモデル
|
24
24
|
![イメージ説明](https://ddjkaamml8q8x.cloudfront.net/questions/2022-01-18/e8438c2e-8088-4aaf-b1c9-1ffb5b9b1216.png)
|
25
25
|
|
26
|
+
### 追記
|
27
|
+
ログを見返したところ「500 Internal Server Error」が起こっていることが原因だとわかりましたが、そのエラーの意味を調べ、問題箇所を探しましたが見つかりませんでした。
|
28
|
+
解決方法がわかる方がいらっしゃいましたらご教示お願いいたします。
|
29
|
+
|
5
画像追加
test
CHANGED
File without changes
|
test
CHANGED
@@ -15,9 +15,7 @@
|
|
15
15
|
原因、解決法のわかるからがいらっしゃいましたらご教示お願いいたします。
|
16
16
|
またそのほかに原因じゃないかと思われる点などございましたらお教えいただけますとありがたいです。
|
17
17
|
### ログ
|
18
|
-
![イメージ説明](https://ddjkaamml8q8x.cloudfront.net/questions/2022-01-18/e
|
18
|
+
![イメージ説明](https://ddjkaamml8q8x.cloudfront.net/questions/2022-01-18/0f61d25f-e808-4d4e-971e-a9bf72020308.jpeg)
|
19
|
-
![イメージ説明](https://ddjkaamml8q8x.cloudfront.net/questions/2022-01-18/d4c55cbb-fdae-48ae-be29-9701826bc1ca.png)
|
20
|
-
ログを追加いたしました。
|
21
19
|
|
22
20
|
ローカル環境のログ
|
23
21
|
![イメージ説明](https://ddjkaamml8q8x.cloudfront.net/questions/2022-01-18/9928bf85-c690-428b-95de-6ed39dba7a27.png)
|
4
画像の追加
test
CHANGED
File without changes
|
test
CHANGED
@@ -22,3 +22,6 @@
|
|
22
22
|
ローカル環境のログ
|
23
23
|
![イメージ説明](https://ddjkaamml8q8x.cloudfront.net/questions/2022-01-18/9928bf85-c690-428b-95de-6ed39dba7a27.png)
|
24
24
|
|
25
|
+
Userモデル
|
26
|
+
![イメージ説明](https://ddjkaamml8q8x.cloudfront.net/questions/2022-01-18/e8438c2e-8088-4aaf-b1c9-1ffb5b9b1216.png)
|
27
|
+
|
3
ログの画像の追加
test
CHANGED
File without changes
|
test
CHANGED
@@ -19,3 +19,6 @@
|
|
19
19
|
![イメージ説明](https://ddjkaamml8q8x.cloudfront.net/questions/2022-01-18/d4c55cbb-fdae-48ae-be29-9701826bc1ca.png)
|
20
20
|
ログを追加いたしました。
|
21
21
|
|
22
|
+
ローカル環境のログ
|
23
|
+
![イメージ説明](https://ddjkaamml8q8x.cloudfront.net/questions/2022-01-18/9928bf85-c690-428b-95de-6ed39dba7a27.png)
|
24
|
+
|
2
文字の修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -14,4 +14,8 @@
|
|
14
14
|
```
|
15
15
|
原因、解決法のわかるからがいらっしゃいましたらご教示お願いいたします。
|
16
16
|
またそのほかに原因じゃないかと思われる点などございましたらお教えいただけますとありがたいです。
|
17
|
+
### ログ
|
18
|
+
![イメージ説明](https://ddjkaamml8q8x.cloudfront.net/questions/2022-01-18/ec7be955-4957-4a9d-bc30-6cc30bceb356.png)
|
19
|
+
![イメージ説明](https://ddjkaamml8q8x.cloudfront.net/questions/2022-01-18/d4c55cbb-fdae-48ae-be29-9701826bc1ca.png)
|
20
|
+
ログを追加いたしました。
|
17
21
|
|
1
test
CHANGED
File without changes
|
test
CHANGED
@@ -13,4 +13,5 @@
|
|
13
13
|
end
|
14
14
|
```
|
15
15
|
原因、解決法のわかるからがいらっしゃいましたらご教示お願いいたします。
|
16
|
+
またそのほかに原因じゃないかと思われる点などございましたらお教えいただけますとありがたいです。
|
16
17
|
|