error when dealing with uuid

[vj78]

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 is:
userid
username
userpassword
userguid
admin

userid is auto increment
userguid is uuid() function

[ibreeden]

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]

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.

I am only getting this error message posted. It doesn’t tell me anything else. I tried running this statement inside of MySQL and from python it gives me the same errors.

[vj78]

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.

I am only getting this error message posted. It doesn’t tell me anything else. I tried running this statement inside of MySQL and from python it gives me the same errors.

[ibreeden]

userguid is uuid() function

Where and how is the uuid() function defined? Please show us the code.

[vj78]

userguid is uuid() function

Where and how is the uuid() function defined? Please show us the code.

Ok, I am 1 step further. There was a trigger that got created by default while creating this uuid or guid field. I deleted that trigger now it is inserting rows using the MySQL sql prompt screen.

The UUID function just inserts UUID() as a string inside of the userguid column. So, it’s not working as planned. I will post a print screen of how I created it.

[vj78]

Where and how is the uuid() function defined? Please show us the code.

Ok, I am 1 step further. There was a trigger that got created by default while creating this uuid or guid field. I deleted that trigger now it is inserting rows using the MySQL sql prompt screen.

The UUID function just inserts UUID() as a string inside of the userguid column. So, it’s not working as planned. I will post a print screen of how I created it.

I am going into the mysql admin panel. I select the database and then the table from left hand navigation. Then click add column.



In here, I am add the name, varchar, length 100, and selecting defined from default column and enter uuid().

[vj78]

Question now is how to use UUID function?

[ibreeden]

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?

[vj78]

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 should implement this function in Python instead.
The function is supposed to generate a GUID which is a unique id.
I deleted the old one that was causes the error. Now, I wish I could recover it to see how it was build.
I am trying to build this new trigger:

INSERT INTO user
SET action = 'insert',
user.userguid = UUID()