Search Results
|
Post |
Author |
Forum |
Replies |
Views |
Posted
[asc]
|
|
|
Thread: error when dealing with uuid
Post: RE: error when dealing with uuid
(Apr-13-2021, 12:10 PM)snippsat Wrote: There is no reason to use phpMyAdmin/XAMPP when using Flask,i would never use it this Python usage not PHP.
The standard way to deal to with database in Flask ... |
|
vj78 |
Web Scraping & Web Development |
18 |
7,305 |
Apr-13-2021, 01:25 PM |
|
|
Thread: error when dealing with uuid
Post: RE: error when dealing with uuid
(Apr-12-2021, 05:59 PM)ibreeden Wrote: Not exactly what I hoped for. Can you not run it outside the web page? And in your code you print the tuple "myparams". What does it print? Are the parameters ... |
|
vj78 |
Web Scraping & Web Development |
18 |
7,305 |
Apr-13-2021, 12:16 AM |
|
|
Thread: error when dealing with uuid
Post: RE: error when dealing with uuid
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-p... |
|
vj78 |
Web Scraping & Web Development |
18 |
7,305 |
Apr-12-2021, 02:17 PM |
|
|
Thread: error when dealing with uuid
Post: RE: error when dealing with uuid
(Apr-12-2021, 07:33 AM)ibreeden Wrote: (Apr-12-2021, 01:10 AM)vj78 Wrote: mysql = mycursor.execute("INSERT INTO user (username, userpassword, userguid ) VALUES (%s, %s, uuid())")I think you shoul... |
|
vj78 |
Web Scraping & Web Development |
18 |
7,305 |
Apr-12-2021, 09:03 AM |
|
|
Thread: error when dealing with uuid
Post: RE: error when dealing with uuid
Ok, as per suggestion, I used python to include the UUID() in the INSERT statement and it works.
I have another error when I use %s. The reason I said %s is when I hard code the values it works.
Er... |
|
vj78 |
Web Scraping & Web Development |
18 |
7,305 |
Apr-12-2021, 01:10 AM |
|
|
Thread: error when dealing with uuid
Post: RE: error when dealing with uuid
(Apr-11-2021, 06:14 PM)ibreeden Wrote: You could of course also implement this function in Python. But the question is: what does the function do? Can you find the text of the trigger?Yes, I think I... |
|
vj78 |
Web Scraping & Web Development |
18 |
7,305 |
Apr-11-2021, 09:23 PM |
|
|
Thread: error when dealing with uuid
Post: RE: error when dealing with uuid
Question now is how to use UUID function? |
|
vj78 |
Web Scraping & Web Development |
18 |
7,305 |
Apr-11-2021, 05:34 PM |
|
|
Thread: error when dealing with uuid
Post: RE: error when dealing with uuid
(Apr-11-2021, 02:39 PM)vj78 Wrote: (Apr-11-2021, 11:52 AM)ibreeden Wrote: Where and how is the uuid() function defined? Please show us the code.
Ok, I am 1 step further. There was a trigger that g... |
|
vj78 |
Web Scraping & Web Development |
18 |
7,305 |
Apr-11-2021, 03:14 PM |
|
|
Thread: error when dealing with uuid
Post: RE: error when dealing with uuid
(Apr-11-2021, 11:52 AM)ibreeden Wrote: (Apr-10-2021, 02:07 PM)vj78 Wrote: userguid is uuid() functionWhere and how is the uuid() function defined? Please show us the code.
Ok, I am 1 step further.... |
|
vj78 |
Web Scraping & Web Development |
18 |
7,305 |
Apr-11-2021, 02:39 PM |
|
|
Thread: error when dealing with uuid
Post: RE: error when dealing with uuid
(Apr-11-2021, 09:42 AM)ibreeden Wrote: You will have to show more of your program. And show the complete error message. The error you mention does not originate from the insert statement you show us... |
|
vj78 |
Web Scraping & Web Development |
18 |
7,305 |
Apr-11-2021, 10:26 AM |
|
|
Thread: error when dealing with uuid
Post: RE: error when dealing with uuid
(Apr-11-2021, 09:42 AM)ibreeden Wrote: You will have to show more of your program. And show the complete error message. The error you mention does not originate from the insert statement you show us... |
|
vj78 |
Web Scraping & Web Development |
18 |
7,305 |
Apr-11-2021, 10:26 AM |
|
|
Thread: error when dealing with uuid
Post: error when dealing with uuid
I have this sql statement and it gives me error: Unknown column 'guid' in 'NEW' mysql
SQL Statement in python: INSERT INTO user (username, userpassword , admin) VALUES (%s, %s, %s )
Table structure ... |
|
vj78 |
Web Scraping & Web Development |
18 |
7,305 |
Apr-10-2021, 02:07 PM |
|
|
Thread: error in python and mysql statement
Post: RE: error in python and mysql statement
(Apr-08-2021, 01:29 PM)vj78 Wrote: (Apr-08-2021, 05:26 AM)buran Wrote: params that you pass to execute() as second argument must be tuple, even if it is one-element tuple like (2, ) - note the com... |
|
vj78 |
Web Scraping & Web Development |
4 |
2,838 |
Apr-08-2021, 02:08 PM |
|
|
Thread: error in python and mysql statement
Post: RE: error in python and mysql statement
(Apr-08-2021, 05:26 AM)buran Wrote: params that you pass to execute() as second argument must be tuple, even if it is one-element tuple like (2, ) - note the comma
Now the error message is different... |
|
vj78 |
Web Scraping & Web Development |
4 |
2,838 |
Apr-08-2021, 01:29 PM |
|
|
Thread: error in python and mysql statement
Post: RE: error in python and mysql statement
I updated the SQL Statement it complains on %s. If I hard code the value 2 it works?
SELECT usertimein FROM userstimeclock WHERE userid = %s AND usertimeout IS NULL ORDER BY timeclockid DESC LIMIT 1 |
|
vj78 |
Web Scraping & Web Development |
4 |
2,838 |
Apr-07-2021, 10:31 PM |
|
|
Thread: error in python and mysql statement
Post: error in python and mysql statement
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 AND usertimeout IS NULL DESC LIMIT 1' at line 1
mysql = "SE... |
|
vj78 |
Web Scraping & Web Development |
4 |
2,838 |
Apr-07-2021, 10:15 PM |
|
|
Thread: Python cookies
Post: Python cookies
I am trying to set cookies and retrieve them.
How to get and set the cookies? in python. |
|
vj78 |
Web Scraping & Web Development |
2 |
3,109 |
Apr-05-2021, 10:50 PM |
|
|
Thread: Python Stored Procedure call is not working
Post: RE: Python Stored Procedure call is not working
(Apr-04-2021, 02:17 PM)buran Wrote: Please, don't edit your post AFTER you get a response. This breaks the flow of discussion - now my message seems incorrect after you added some error message. I r... |
|
vj78 |
Web Scraping & Web Development |
5 |
2,937 |
Apr-04-2021, 03:17 PM |
|
|
Thread: Python Stored Procedure call is not working
Post: RE: Python Stored Procedure call is not working
It works now.
I had to look at this link and change my code:
for result in mycursor.stored_results():
myresult = result.fetchall() |
|
vj78 |
Web Scraping & Web Development |
5 |
2,937 |
Apr-04-2021, 12:22 PM |
|
|
Thread: Python Stored Procedure call is not working
Post: RE: Python Stored Procedure call is not working
(Apr-04-2021, 07:33 AM)buran Wrote: (Apr-04-2021, 03:00 AM)vj78 Wrote: Code below does not workwhat does this exactly mean? Do you get any error? What version of MySQL do you use?
Did you check co... |
|
vj78 |
Web Scraping & Web Development |
5 |
2,937 |
Apr-04-2021, 12:01 PM |