Python Forum
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 1,921 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 1,921 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 1,921 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 1,921 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 1,921 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 1,921 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 1,921 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 1,921 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 1,921 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 1,921 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 1,921 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 1,921 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 818 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 818 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 818 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 818 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 1,456 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 825 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 825 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 825 Apr-04-2021, 12:01 PM

User Panel Messages

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