Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
error when dealing with uuid
#15
This is the complete error message:
[2021-04-12 08:51:39,948] ERROR in app: Exception on /adduser1 [POST]
Traceback (most recent call last):
  File "C:\source\repos\pythonsql\pythonsql\env2\lib\site-packages\flask\app.py", line 2447, in wsgi_app
    response = self.full_dispatch_request()
  File "C:\source\repos\pythonsql\pythonsql\env2\lib\site-packages\flask\app.py", line 1952, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "C:\source\repos\pythonsql\pythonsql\env2\lib\site-packages\flask\app.py", line 1821, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "C:\source\repos\pythonsql\pythonsql\env2\lib\site-packages\flask\_compat.py", line 39, in reraise
    raise value
  File "C:\source\repos\pythonsql\pythonsql\env2\lib\site-packages\flask\app.py", line 1950, in full_dispatch_request
    rv = self.dispatch_request()
  File "C:\source\repos\pythonsql\pythonsql\env2\lib\site-packages\flask\app.py", line 1936, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "C:\xampp3\htdocs\app.py", line 151, in adduser1
    myresult = user.user().adduser(username, password, admin)
  File "C:\xampp3\htdocs\user.py", line 25, in adduser
    mysql = mycursor.execute("INSERT INTO user (username, userpassword, userguid ) VALUES (%s , %s, %s)")
  File "C:\source\repos\pythonsql\pythonsql\env2\lib\site-packages\mysql\connector\cursor.py", line 551, in execute
    self._handle_result(self._connection.cmd_query(stmt))
  File "C:\source\repos\pythonsql\pythonsql\env2\lib\site-packages\mysql\connector\connection.py", line 490, in cmd_query
    result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query))
  File "C:\source\repos\pythonsql\pythonsql\env2\lib\site-packages\mysql\connector\connection.py", line 395, in _handle_result
    raise errors.get_exception(packet)
mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%s , %s, %s)' at line 1
127.0.0.1 - - [12/Apr/2021 08:51:39] "←[35m←[1mPOST /adduser1 HTTP/1.1←[0m" 500 -
Reply


Messages In This Thread
error when dealing with uuid - by vj78 - Apr-10-2021, 02:07 PM
RE: error when dealing with uuid - by ibreeden - Apr-11-2021, 09:42 AM
RE: error when dealing with uuid - by vj78 - Apr-11-2021, 10:26 AM
RE: error when dealing with uuid - by vj78 - Apr-11-2021, 10:26 AM
RE: error when dealing with uuid - by ibreeden - Apr-11-2021, 11:52 AM
RE: error when dealing with uuid - by vj78 - Apr-11-2021, 02:39 PM
RE: error when dealing with uuid - by vj78 - Apr-11-2021, 03:14 PM
RE: error when dealing with uuid - by vj78 - Apr-11-2021, 05:34 PM
RE: error when dealing with uuid - by ibreeden - Apr-11-2021, 06:14 PM
RE: error when dealing with uuid - by vj78 - Apr-11-2021, 09:23 PM
RE: error when dealing with uuid - by vj78 - Apr-12-2021, 01:10 AM
RE: error when dealing with uuid - by ibreeden - Apr-12-2021, 07:33 AM
RE: error when dealing with uuid - by vj78 - Apr-12-2021, 09:03 AM
RE: error when dealing with uuid - by ibreeden - Apr-12-2021, 10:25 AM
RE: error when dealing with uuid - by vj78 - Apr-12-2021, 02:17 PM
RE: error when dealing with uuid - by ibreeden - Apr-12-2021, 05:59 PM
RE: error when dealing with uuid - by vj78 - Apr-13-2021, 12:16 AM
RE: error when dealing with uuid - by snippsat - Apr-13-2021, 12:10 PM
RE: error when dealing with uuid - by vj78 - Apr-13-2021, 01:25 PM

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020