Forum OpenACS Q&A: Re: myfirstpackage: ERROR: duplicate key violates unique constraint

Ok. Seems the better way to do it is to patch the file as indicated in the link in my previous post. Then use the script in the tutorial. Anyhow this works only if no note has been inserted or all notes has been previously deleted.
Btw. My notes-delete.tcl script does not work unless I comment the

set title [item::get_title $item_id]

instruction. Otherwise I get the following exception:

Database operation "0or1row" failed
(exception ERROR, "ERROR: invalid input syntax for integer: "item_id"
")

while executing
"ns_pg_bind 0or1row nsdb0 {

select content_item__get_title(:item_id,:is_live)

}"
...

Maybe someone of you has some hints for me.