Advertisement
damildrizzy

operational error

Oct 18th, 2019
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.75 KB | None | 0 0
  1. Traceback (most recent call last):
  2. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\sqlalchemy\engine\base.py", line 1249, in _execute_context
  3. cursor, statement, parameters, context
  4. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\sqlalchemy\engine\default.py", line 580, in do_execute
  5. cursor.execute(statement, parameters)
  6. sqlite3.OperationalError: no such table: employees
  7.  
  8. The above exception was the direct cause of the following exception:
  9.  
  10. Traceback (most recent call last):
  11. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\flask\app.py", line 2446, in wsgi_app
  12. response = self.full_dispatch_request()
  13. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\flask\app.py", line 1951, in full_dispatch_request
  14. rv = self.handle_user_exception(e)
  15. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\flask\app.py", line 1820, in handle_user_exception
  16. reraise(exc_type, exc_value, tb)
  17. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\flask\_compat.py", line 39, in reraise
  18. raise value
  19. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\flask\app.py", line 1949, in full_dispatch_request
  20. rv = self.dispatch_request()
  21. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\flask\app.py", line 1935, in dispatch_request
  22. return self.view_functions[rule.endpoint](**req.view_args)
  23. File "C:\Users\user\Desktop\Automated management system\app\blueprints\auth\views.py", line 13, in register
  24. if form.validate_on_submit():
  25. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\flask_wtf\form.py", line 101, in validate_on_submit
  26. return self.is_submitted() and self.validate()
  27. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\wtforms\form.py", line 310, in validate
  28. return super(Form, self).validate(extra)
  29. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\wtforms\form.py", line 152, in validate
  30. if not field.validate(self, extra):
  31. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\wtforms\fields\core.py", line 206, in validate
  32. stop_validation = self._run_validation_chain(form, chain)
  33. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\wtforms\fields\core.py", line 226, in _run_validation_chain
  34. validator(form, self)
  35. File "C:\Users\user\Desktop\Automated management system\app\blueprints\auth\forms.py", line 19, in validate_email
  36. if Employee.query.filter_by(email=field.data).first():
  37. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\sqlalchemy\orm\query.py", line 3240, in first
  38. ret = list(self[0:1])
  39. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\sqlalchemy\orm\query.py", line 3018, in __getitem__
  40. return list(res)
  41. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\sqlalchemy\orm\query.py", line 3342, in __iter__
  42. return self._execute_and_instances(context)
  43. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\sqlalchemy\orm\query.py", line 3367, in _execute_and_instances
  44. result = conn.execute(querycontext.statement, self._params)
  45. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\sqlalchemy\engine\base.py", line 988, in execute
  46. return meth(self, multiparams, params)
  47. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\sqlalchemy\sql\elements.py", line 287, in _execute_on_connection
  48. return connection._execute_clauseelement(self, multiparams, params)
  49. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\sqlalchemy\engine\base.py", line 1107, in _execute_clauseelement
  50. distilled_params,
  51. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\sqlalchemy\engine\base.py", line 1253, in _execute_context
  52. e, statement, parameters, cursor, context
  53. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\sqlalchemy\engine\base.py", line 1473, in _handle_dbapi_exception
  54. util.raise_from_cause(sqlalchemy_exception, exc_info)
  55. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\sqlalchemy\util\compat.py", line 398, in raise_from_cause
  56. reraise(type(exception), exception, tb=exc_tb, cause=cause)
  57. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\sqlalchemy\util\compat.py", line 152, in reraise
  58. raise value.with_traceback(tb)
  59. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\sqlalchemy\engine\base.py", line 1249, in _execute_context
  60. cursor, statement, parameters, context
  61. File "c:\users\user\anaconda3\envs\emsenv\lib\site-packages\sqlalchemy\engine\default.py", line 580, in do_execute
  62. cursor.execute(statement, parameters)
  63. sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: employees
  64. [SQL: SELECT employees.id AS employees_id, employees.username AS employees_username, employees.first_name AS employees_first_name, employees.last_name AS employees_last_name, employees.date_of_birth AS employees_date_of_birth, employees.date_of_first_appointment AS employees_date_of_first_appointment, employees.next_of_kin AS employees_next_of_kin, employees.age AS employees_age, employees.department_name AS employees_department_name, employees.educational_qualification AS employees_educational_qualification, employees.present_grade_level AS employees_present_grade_level, employees.post AS employees_post, employees.address AS employees_address, employees.phone_nmuber AS employees_phone_nmuber, employees.email AS employees_email, employees.marital_status AS employees_marital_status, employees.password_hash AS employees_password_hash, employees.is_admin AS employees_is_admin
  65. FROM employees
  66. WHERE employees.email = ?
  67. LIMIT ? OFFSET ?]
  68. [parameters: ('damiloladrizzy@yahoo.com', 1, 0)]
  69. (Background on this error at: http://sqlalche.me/e/e3q8)
  70. 127.0.0.1 - - [18/Oct/2019 15:55:22] "POST /register HTTP/1.1" 500 -
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement