Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def membership_reactivation(self):
- connection.connect(user="root", password="")
- email = self.EmailBox.get()
- password = self.PasswordBox.get()
- query = "UPDATE users SET Status = 'ACTIVE' WHERE Email = %s AND Password = %s;"
- cursor.execute(query, (email, password,))
- result = cursor.fetchall()
- if result:
- connection.commit()
- connection.close()
- self.controller.show_frame("ThankYou")
- else:
- print("Credentials Not Found in Database.")
- connection.close()
- Exception in Tkinter callback
- Traceback (most recent call last):
- File "C:UsersAJEAppDataLocalProgramsPythonPython36-32libtkinter__init__.py", line 1699, in __call__
- return self.func(*args)
- File "C:UsersAJEPycharmProjectsReactivateMembership.py", line 58, in membership_reactivation
- result = cursor.fetchall()
- File "C:UsersAJEAppDataLocalProgramsPythonPython36-32libsite-packagesmysqlconnectorcursor.py", line 1002, in fetchall
- raise errors.InterfaceError("No result set to fetch from.")
- mysql.connector.errors.InterfaceError: No result set to fetch from.
Add Comment
Please, Sign In to add comment