|
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
|
|
|
