質問編集履歴
1
書式改善
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -5,6 +5,18 @@
|
|
|
5
5
|
にkaminariでページネーションを設定しようとしたところ、
|
|
6
6
|
|
|
7
7
|
以下のようなSyntaxエラーのSQLが発行されてエラーになりました。
|
|
8
|
+
|
|
9
|
+
---
|
|
10
|
+
|
|
11
|
+
Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
|
|
12
|
+
|
|
13
|
+
users.id,
|
|
14
|
+
|
|
15
|
+
' at line 1: SELECT COUNT(users.id,
|
|
16
|
+
|
|
17
|
+
jobs.name) FROM `users` INNER JOIN `jobs` ON `users`.`id` = `jobs`.`user_id`
|
|
18
|
+
|
|
19
|
+
---
|
|
8
20
|
|
|
9
21
|
|
|
10
22
|
|
|
@@ -33,20 +45,6 @@
|
|
|
33
45
|
です。
|
|
34
46
|
|
|
35
47
|
正しい設定方法や解決方法がわかる方、どうぞ宜しくお願いします。
|
|
36
|
-
|
|
37
|
-
|
|
38
|
-
|
|
39
|
-
---
|
|
40
|
-
|
|
41
|
-
Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
|
|
42
|
-
|
|
43
|
-
users.id,
|
|
44
|
-
|
|
45
|
-
' at line 1: SELECT COUNT(users.id,
|
|
46
|
-
|
|
47
|
-
jobs.name) FROM `users` INNER JOIN `jobs` ON `users`.`id` = `jobs`.`user_id`
|
|
48
|
-
|
|
49
|
-
---
|
|
50
48
|
|
|
51
49
|
|
|
52
50
|
|