try:
mydb = mysql.connector.connect(
host='localhost',
user='root',
password='',
database='tiktok', autocommit=True)
except Error as e:
print(e)
Exception in thread Thread-3:
Traceback (most recent call last):
File "C:\Users\Alex\AppData\Local\Programs\Python\Python39\lib\threading.py", line 954, in _bootstrap_inner
self.run()
File "C:\Users\Alex\AppData\Local\Programs\Python\Python39\lib\threading.py", line 892, in run
self._target(*self._args, **self._kwargs)
File "D:\Projects\tiktok\main.py", line 481, in _load_snaptik
myresult = mycursor.fetchall()
File "D:\Projects\tiktok\venv\lib\site-packages\mysql\connector\cursor.py", line 1025, in fetchall
raise errors.InterfaceError(ERR_NO_RESULT_TO_FETCH)
mysql.connector.errors.InterfaceError: No result set to fetch from
mycursor = mydb.cursor(buffered=True)
mycursor.execute(f"SELECT * FROM tokens WHERE user_id='{message.from_user.id}'")
myresult = mycursor.fetchall()
mycursor.close()
Exception in thread Thread-2:
Traceback (most recent call last):
File "C:\Users\Alex\AppData\Local\Programs\Python\Python39\lib\threading.py", line 954, in _bootstrap_inner
self.run()
File "C:\Users\Alex\AppData\Local\Programs\Python\Python39\lib\threading.py", line 892, in run
self._target(*self._args, **self._kwargs)
File "D:\Projects\tiktok\main.py", line 478, in _load_snaptik
mycursor = mydb.cursor(buffered=True)
File "D:\Projects\tiktok\venv\lib\site-packages\mysql\connector\connection.py", line 1025, in cursor
raise errors.OperationalError("MySQL Connection not available.")
mysql.connector.errors.OperationalError: MySQL Connection not available.
В чем может быть проблема?
