-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathcreate_db_error.log
157 lines (101 loc) · 2.33 KB
/
create_db_error.log
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
-------
31/21/2018 19:21:53
-------
-------
31/56/2018 19:56:42
-------
-------
31/35/2018 20:35:52
-------
-------
31/43/2018 20:43:14
-------
-------
31/29/2018 22:29:47
-------
-------
31/43/2018 22:43:55
-------
-------
01/06/2018 00:06:48
-------
-------
01/57/2018 08:57:59
-------
Error executing 'CREATE TABLE studentsubject(
sem_id varchar(8),
student_id varchar(9),
subject_id varchar(8),
PRIMARY KEY (sem_id,subject_id,subject_id)
)
' (line 6): Duplicate column name 'subject_id'
-------
01/58/2018 08:58:31
-------
-------
01/05/2018 09:05:53
-------
-------
01/11/2018 09:11:08
-------
-------
01/15/2018 09:15:54
-------
-------
01/24/2018 12:24:05
-------
-------
01/35/2018 12:35:51
-------
Error executing 'CREATE TABLE users (
username varchar(10) NOT NULL PRIMARY KEY,
password varchar(64) NOT NULL,
faculty_id varchar(8) NOT NULL,
PRIMARY KEY (username),
FOREIGN KEY (faculty_id) REFERENCES faculties(code)
) ' (line 7): Multiple primary key defined
-------
01/36/2018 12:36:21
-------
-------
04/00/2018 12:00:50
-------
-------
05/50/2018 23:50:20
-------
-------
07/14/2018 21:14:27
-------
Error executing 'INSERT INTO users(username, password, faculty_id) VALUES ('danushka','1234','1') ' (line 5): Cannot add or update a child row: a foreign key constraint fails (`nsbm`.`users`, CONSTRAINT `users_ibfk_1` FOREIGN KEY (`faculty_id`) REFERENCES `faculties` (`code`))
-------
07/52/2018 21:52:08
-------
Error executing 'INSERT INTO users(username, password, faculty_id) VALUES ('danushka','1234','1') ' (line 5): Cannot add or update a child row: a foreign key constraint fails (`nsbm`.`users`, CONSTRAINT `users_ibfk_1` FOREIGN KEY (`faculty_id`) REFERENCES `faculties` (`code`))
-------
07/53/2018 21:53:08
-------
-------
07/53/2018 21:53:30
-------
Error executing 'INSERT INTO users(username, password, faculty_id) VALUES ('danushka','1234','1') ' (line 5): Cannot add or update a child row: a foreign key constraint fails (`nsbm`.`users`, CONSTRAINT `users_ibfk_1` FOREIGN KEY (`faculty_id`) REFERENCES `faculties` (`code`))
-------
07/54/2018 21:54:10
-------
-------
08/34/2018 21:34:30
-------
-------
08/05/2018 22:05:23
-------
-------
08/17/2018 23:17:38
-------
-------
08/26/2018 23:26:49
-------
-------
09/01/2018 13:01:21
-------
-------
13/49/2018 22:49:45
-------