Guest User

Untitled

a guest
Mar 9th, 2018
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. def membership_reactivation(self):
  2. connection.connect(user="root", password="")
  3. email = self.EmailBox.get()
  4. password = self.PasswordBox.get()
  5. query = "UPDATE users SET Status = 'ACTIVE' WHERE Email = %s AND Password = %s;"
  6. cursor.execute(query, (email, password,))
  7. result = cursor.fetchall()
  8. if result:
  9. connection.commit()
  10. connection.close()
  11. self.controller.show_frame("ThankYou")
  12. else:
  13. print("Credentials Not Found in Database.")
  14. connection.close()
  15.  
  16. Exception in Tkinter callback
  17. Traceback (most recent call last):
  18. File "C:UsersAJEAppDataLocalProgramsPythonPython36-32libtkinter__init__.py", line 1699, in __call__
  19. return self.func(*args)
  20. File "C:UsersAJEPycharmProjectsReactivateMembership.py", line 58, in membership_reactivation
  21. result = cursor.fetchall()
  22. File "C:UsersAJEAppDataLocalProgramsPythonPython36-32libsite-packagesmysqlconnectorcursor.py", line 1002, in fetchall
  23. raise errors.InterfaceError("No result set to fetch from.")
  24. mysql.connector.errors.InterfaceError: No result set to fetch from.
Add Comment
Please, Sign In to add comment