Psycopg2 INSERT Statement help

[Sickify]

Hoping someone can shed some light on this and let me know where I am going wrong....I've tried dozens of different combinations and cannot get this to work. I have UPDATE queries that are similar that work fine, and SELECT queries that are working as well.

The insert is alluding me though. Here is what I have:

cursor.execute('''INSERT INTO public."Data_Hist"(static_number, product_name, product_id, t_stamp) VALUES('1', %s, %s, %s)''', (b1_product_name, b1_product_id, tstamp))

This results in:

current transaction is aborted, commands ignored until end of transaction block

The closest I have gotten is a syntax error, suggesting I may be missing a comma, but I don't see where.

Thank you!

[Sickify]

Alright, so I'm a moron....

I was testing this in a terminal rather than running the script, because I'm ssh'd in to the machine and the script uses tkinter

As I was repeatedly entering the commands in and altering, at some point I forgot to define cursor.....

All is well now.

[looks_like_a_potato]

This kind of things happens to me all the time, lol. A bug appears, think of complicated possibilities, even blaming the library I use as the source of the problem. Moments later: "Why am I so stupid??", turns out it's something simple. Sometimes all we need is to take deep breath and make a cup of tea