File size: 19,074 Bytes
a597f2c |
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 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 |
2024-06-26 15:05:45,671 - INFO - File upload start
2024-06-26 15:06:10,308 - INFO - File upload start
2024-06-26 20:56:57,535 - INFO - File upload start
2024-06-27 10:23:14,083 - INFO - File upload start
2024-06-27 10:25:33,473 - INFO - File upload start
2024-06-27 19:46:45,688 - INFO - File upload start
2024-06-28 11:30:27,909 - INFO - File upload start
2024-06-28 11:31:34,367 - INFO - File upload start
2024-06-28 11:45:59,119 - INFO - File upload start
2024-06-28 12:03:18,147 - INFO - File upload start
2024-06-28 12:23:09,794 - INFO - File upload start
2024-06-28 12:40:34,867 - INFO - File upload start
2024-06-28 12:50:31,907 - INFO - File upload start
2024-06-28 12:52:50,973 - INFO - File upload start
2024-06-28 14:13:58,362 - INFO - File upload start
2024-06-28 14:15:39,003 - INFO - File upload start
2024-06-28 14:16:38,501 - INFO - File upload start
2024-06-28 14:30:55,406 - INFO - File upload start
2024-06-28 14:31:33,800 - INFO - File upload start
2024-06-28 14:32:14,903 - INFO - File upload start
2024-06-28 14:33:13,832 - INFO - File upload start
2024-06-28 14:37:37,770 - INFO - File upload start
2024-06-28 14:38:27,848 - INFO - File upload start
2024-06-28 14:38:45,450 - INFO - File upload start
2024-06-28 14:39:22,595 - INFO - File upload start
2024-06-28 14:41:45,804 - INFO - File upload start
2024-06-28 14:42:28,047 - INFO - File upload start
2024-06-28 14:42:52,537 - INFO - File upload start
2024-06-28 14:42:55,555 - INFO - File upload start
2024-06-28 14:43:43,017 - INFO - File upload start
2024-06-28 14:46:42,645 - INFO - File upload start
2024-06-28 14:47:57,404 - INFO - File upload start
2024-06-28 14:51:18,761 - INFO - File upload start
2024-06-28 14:51:45,278 - INFO - File upload start
2024-06-28 14:52:18,757 - INFO - File upload start
2024-06-28 14:54:31,946 - INFO - File upload start
2024-06-28 14:54:43,198 - INFO - File upload start
2024-07-05 14:37:16,254 - INFO - File upload start
2024-07-09 10:24:45,033 - INFO - File upload start
2024-07-09 10:27:12,902 - INFO - File upload start
2024-07-09 10:28:05,599 - INFO - File upload start
2024-07-09 10:28:32,249 - INFO - File upload start
2024-07-09 10:30:40,884 - INFO - File upload start
2024-07-09 10:32:49,297 - INFO - File upload start
2024-07-09 10:33:52,842 - INFO - File upload start
2024-07-09 10:36:09,099 - INFO - File upload start
2024-07-09 10:41:58,156 - INFO - File upload start
2024-07-09 10:44:11,534 - INFO - File upload start
2024-07-09 13:48:26,883 - INFO - File upload start
2024-07-09 13:51:02,458 - INFO - File upload start
2024-07-09 13:52:43,802 - INFO - File upload start
2024-07-09 13:53:24,800 - INFO - File upload start
2024-07-09 14:13:09,374 - INFO - File upload start
2024-07-09 14:15:08,118 - INFO - File upload start
2024-07-09 14:20:15,337 - INFO - File upload start
2024-07-09 15:18:47,858 - INFO - File upload start
2024-07-09 15:20:43,515 - INFO - File upload start
2024-07-09 15:22:10,977 - INFO - File upload start
2024-07-09 15:23:11,741 - INFO - File upload start
2024-07-09 15:24:02,811 - INFO - File upload start
2024-07-09 15:24:51,644 - INFO - File upload start
2024-07-09 15:26:57,307 - INFO - File upload start
2024-07-09 15:27:47,890 - INFO - File upload start
2024-07-09 15:28:54,605 - INFO - File upload start
2024-07-09 15:32:04,124 - INFO - File upload start
2024-07-10 10:48:52,249 - INFO - File upload start
2024-07-18 12:33:01,569 - INFO - File upload start
2024-07-18 12:43:49,151 - INFO - File upload start
2024-07-18 12:50:59,304 - INFO - File upload start
2024-07-18 12:51:05,343 - INFO - File upload start
2024-07-18 13:46:12,984 - INFO - File upload start
2024-07-18 13:47:27,113 - INFO - File upload start
2024-07-18 13:53:14,622 - INFO - File upload start
2024-07-18 13:55:23,502 - INFO - File upload start
2024-07-18 14:08:29,239 - INFO - File upload start
2024-07-18 14:16:55,475 - INFO - File upload start
2024-07-18 14:25:44,967 - INFO - File upload start
2024-07-18 14:36:46,313 - INFO - File upload start
2024-07-18 14:40:11,808 - INFO - File upload start
2024-07-18 14:40:42,615 - INFO - Received question: what is the weather in chennai
2024-07-18 14:40:43,629 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-18 14:40:55,968 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-18 14:40:55,984 - INFO - Executing SQL query: This question is not related to the provided database schema, as it is about the weather in a specific location (Chennai) and cannot be answered using the data in the tables. You would need to use a weather API or service to get the current weather information for Chennai.
2024-07-18 14:40:56,620 - ERROR - Error executing query: This question is not related to the provided database schema, as it is about the weather in a specific location (Chennai) and cannot be answered using the data in the tables. You would need to use a weather API or service to get the current weather information for Chennai., Error: (mysql.connector.errors.ProgrammingError) 1064 (42000): 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 'This question is not related to the provided database schema, as it is about the' at line 1
[SQL: This question is not related to the provided database schema, as it is about the weather in a specific location (Chennai) and cannot be answered using the data in the tables. You would need to use a weather API or service to get the current weather information for Chennai.]
(Background on this error at: https://sqlalche.me/e/20/f405)
2024-07-18 14:40:57,382 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-18 14:41:08,706 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-18 14:41:08,720 - INFO - Executing SQL query: This question is not related to the provided database schema and cannot be answered using SQL queries. You may need to use a weather API or service to get the current weather information for Chennai.
2024-07-18 14:41:09,363 - ERROR - Error executing query: This question is not related to the provided database schema and cannot be answered using SQL queries. You may need to use a weather API or service to get the current weather information for Chennai., Error: (mysql.connector.errors.ProgrammingError) 1064 (42000): 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 'This question is not related to the provided database schema and cannot be answe' at line 1
[SQL: This question is not related to the provided database schema and cannot be answered using SQL queries. You may need to use a weather API or service to get the current weather information for Chennai.]
(Background on this error at: https://sqlalche.me/e/20/f405)
2024-07-18 14:41:10,032 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-18 14:41:21,325 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-18 14:41:21,335 - INFO - Executing SQL query: This question is not related to the provided database schema and cannot be answered using SQL queries. You may need to use a weather API or service to get the current weather information for Chennai.
2024-07-18 14:41:43,996 - INFO - File upload start
2024-07-18 14:42:14,242 - INFO - Received question: what is the college name
2024-07-18 14:42:15,023 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-18 14:42:27,078 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-18 14:42:27,094 - INFO - Executing SQL query: SELECT CollegeName
FROM buildings;
2024-07-18 14:42:27,843 - INFO - Query successful: [('SCCC',), ('SCCC',), ('SCCC',), ('SCCC',), ('SCCC',)]
2024-07-18 14:42:28,479 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-18 14:42:29,471 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-18 14:42:29,476 - INFO - Response generated: The college name is SCCC.
2024-07-18 14:44:53,957 - INFO - File upload start
2024-07-18 14:54:50,464 - INFO - File upload start
2024-07-18 14:55:14,833 - INFO - File upload start
2024-07-18 14:55:40,011 - INFO - Received question: what is the college name
2024-07-18 14:55:40,909 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-18 14:55:51,399 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-18 14:55:51,415 - INFO - Executing SQL query: SELECT CollegeName
FROM buildings;
2024-07-18 14:55:52,048 - INFO - Query successful: [('SCCC',), ('SCCC',), ('SCCC',), ('SCCC',), ('SCCC',)]
2024-07-18 14:55:52,599 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-18 14:55:53,523 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-18 14:55:53,526 - INFO - Response generated: The college name is SCCC (retrieved from the database).
2024-07-18 14:59:35,543 - INFO - Received question: what is the college name
2024-07-18 14:59:36,526 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-18 14:59:48,046 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-18 14:59:48,046 - INFO - Executing SQL query: SELECT CollegeName
FROM buildings;
2024-07-18 14:59:48,723 - INFO - Query successful: [('SCCC',), ('SCCC',), ('SCCC',), ('SCCC',), ('SCCC',)]
2024-07-18 14:59:49,583 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-18 14:59:50,459 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-18 14:59:50,461 - INFO - Response generated: The college name is "SCCC".
2024-07-19 10:58:51,724 - INFO - File upload start
2024-07-19 11:25:35,546 - WARNING - Did not find CR at end of boundary (40)
2024-07-19 11:26:36,567 - WARNING - Did not find CR at end of boundary (40)
2024-07-19 11:29:24,545 - INFO - File upload start
2024-07-19 11:29:46,970 - INFO - Received question: what is the college name
2024-07-19 11:29:47,868 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 11:29:59,588 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 11:29:59,602 - INFO - Executing SQL query: SELECTSELECT CollegeName
FROM buildings;
2024-07-19 11:30:00,235 - ERROR - Error executing query: SELECTSELECT CollegeName
FROM buildings;, Error: (mysql.connector.errors.ProgrammingError) 1064 (42000): 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 'SELECTSELECT CollegeName
FROM buildings' at line 1
[SQL: SELECTSELECT CollegeName
FROM buildings;]
(Background on this error at: https://sqlalche.me/e/20/f405)
2024-07-19 11:30:00,856 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 11:30:11,376 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 11:30:11,378 - INFO - Executing SQL query: SELECT CollegeName
FROM buildings;
2024-07-19 11:30:12,379 - INFO - Query successful: [('SCCC',), ('SCCC',), ('SCCC',), ('SCCC',), ('SCCC',)]
2024-07-19 11:30:13,039 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 11:30:14,129 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 11:30:14,130 - INFO - Response generated: The college name is SCCC (appears multiple times in the data).
2024-07-19 11:31:25,438 - INFO - Received question: what is the college name
2024-07-19 11:31:26,456 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 11:31:36,647 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 11:31:36,649 - INFO - Executing SQL query: SELECT CollegeName
FROM buildings;
2024-07-19 11:31:37,289 - INFO - Query successful: [('SCCC',), ('SCCC',), ('SCCC',), ('SCCC',), ('SCCC',)]
2024-07-19 11:31:38,107 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 11:31:39,172 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 11:31:39,173 - INFO - Response generated: The college name is SCCC (repeated multiple times in the data).
2024-07-19 11:32:01,191 - INFO - Received question: what is the college name
2024-07-19 11:32:01,981 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 11:32:13,386 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 11:32:13,388 - INFO - Executing SQL query: SELECT CollegeName
FROM buildings;
2024-07-19 11:32:14,108 - INFO - Query successful: [('SCCC',), ('SCCC',), ('SCCC',), ('SCCC',), ('SCCC',)]
2024-07-19 11:32:14,872 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 11:32:15,784 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 11:32:15,786 - INFO - Response generated: The college name is SCCC.
2024-07-19 12:32:42,687 - INFO - File upload start
2024-07-19 12:33:09,641 - INFO - File upload start
2024-07-19 12:33:47,562 - INFO - File upload start
2024-07-19 12:34:08,515 - INFO - Received question: what are the faculty names
2024-07-19 12:34:09,305 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 12:34:21,872 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 12:34:21,884 - INFO - Executing SQL query: SELECT FacultyName AS name FROM faculty;
2024-07-19 12:34:22,691 - INFO - Query successful: [('Tanya Ferguson',), ("Guy O'Neill",), ('Dennis Wilks',), ('Kenneth Mason',), ('Mike Briley',), ('Mary George',), ('June Walkters',), ('Angela Mendez',), ('John Leak',), ('Carey Cochran',)]
2024-07-19 12:34:23,315 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 12:34:25,037 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 12:34:25,037 - INFO - Response generated: The faculty names are as follows:
1. Tanya Ferguson
2. Guy O'Neill
3. Dennis Wilks
4. Kenneth Mason
5. Mike Briley
6. Mary George
7. June Walkters
8. Angela Mendez
9. John Leak
10. Carey Cochran
2024-07-19 12:35:10,296 - INFO - Received question: what is the college name
2024-07-19 12:35:11,275 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 12:35:23,826 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 12:35:23,826 - INFO - Executing SQL query: SELECT CollegeName
FROM buildings;
2024-07-19 12:35:24,533 - INFO - Query successful: [('SCCC',), ('SCCC',), ('SCCC',), ('SCCC',), ('SCCC',)]
2024-07-19 12:35:25,144 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 12:35:26,577 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 12:35:26,577 - INFO - Response generated: The college name is SCCC (repeated multiple times in the database).
2024-07-19 13:17:17,036 - INFO - File upload start
2024-07-19 13:19:33,261 - INFO - File upload start
2024-07-19 13:21:21,623 - INFO - Received question: what is the college name
2024-07-19 13:21:22,303 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 13:21:33,883 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 13:21:33,890 - INFO - Executing SQL query: SELECT CollegeName
FROM buildings;
2024-07-19 13:21:34,550 - INFO - Query successful: [('SCCC',), ('SCCC',), ('SCCC',), ('SCCC',), ('SCCC',)]
2024-07-19 13:21:35,158 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 13:21:35,946 - INFO - HTTP Request: POST https://api.openai.com/v1/chat/completions "HTTP/1.1 200 OK"
2024-07-19 13:21:35,949 - INFO - Response generated: The college name is SCCC.
2024-07-19 14:53:48,407 - INFO - File upload start
2024-07-22 10:12:26,425 - INFO - File upload start
2024-07-22 10:12:43,516 - INFO - File upload start
2024-07-22 10:29:30,854 - INFO - File upload start
2024-07-22 10:34:39,763 - INFO - File upload start
2024-07-22 10:45:52,996 - INFO - File upload start
2024-07-22 10:54:35,696 - ERROR - Error handling file uploads: expected str, bytes or os.PathLike object, not NoneType
2024-07-22 11:03:11,588 - ERROR - Error handling file uploads: expected str, bytes or os.PathLike object, not NoneType
2024-07-22 11:32:50,544 - ERROR - Error handling file uploads: expected str, bytes or os.PathLike object, not NoneType
2024-07-22 11:34:11,514 - INFO - File upload start
2024-07-22 11:35:17,929 - ERROR - Error handling file uploads: expected str, bytes or os.PathLike object, not NoneType
2024-07-22 11:35:51,872 - INFO - File upload start
2024-07-22 11:35:55,811 - ERROR - Error handling file uploads: expected str, bytes or os.PathLike object, not NoneType
2024-07-22 11:47:11,227 - ERROR - Error handling file uploads: expected str, bytes or os.PathLike object, not NoneType
2024-07-22 11:57:15,569 - INFO - File upload start
2024-07-22 12:08:32,603 - INFO - File upload start
2024-07-22 12:09:31,581 - INFO - File upload start
2024-07-22 12:10:00,231 - ERROR - Error handling file uploads: expected str, bytes or os.PathLike object, not NoneType
2024-07-22 12:11:49,767 - INFO - File upload start
2024-07-22 12:12:11,229 - ERROR - Error handling file uploads: expected str, bytes or os.PathLike object, not NoneType
2024-07-22 12:12:33,191 - INFO - File upload start
2024-07-22 12:12:42,069 - ERROR - Error handling file uploads: expected str, bytes or os.PathLike object, not NoneType
2024-07-22 12:14:01,202 - ERROR - Error handling file uploads: expected str, bytes or os.PathLike object, not NoneType
2024-07-22 12:30:49,041 - INFO - File upload start
2024-07-22 12:31:09,887 - INFO - File upload start
2024-07-22 12:32:09,656 - ERROR - Error handling file uploads: expected str, bytes or os.PathLike object, not NoneType
2024-07-22 12:32:39,727 - INFO - File upload start
2024-07-22 12:33:21,572 - ERROR - Error handling file uploads: expected str, bytes or os.PathLike object, not NoneType
|