Gossamer Forum
Home : Products : Gossamer Links : Discussions :

add.cgi problem

Quote Reply
add.cgi problem
Just installed Links SQL (using Oracle). Works great, except:

When somebody tries to use add.cgi, all that happens when they hit submit is add.cgi comes back up - nothing is submitted into the database.

Looking at some older threads here, I restored the default template, then changed POST to GET. Now, if you fill out the form completely, the same thing happens. If you leave out a category, though, you get an error message that you've left out a category. If you then choose one and hit submit again, this error message comes up:

Failed to execute query: 'INSERT INTO lsql_Links (Description,Title,LinkOwner,Rating,Hits,Votes,isNew,URL,Status,Contact_Name,Contact_Email,isChanged,Mod_Date,isPopular,isValidated,Add_Date,ID) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,lsql_Links_seq.NEXTVAL)' Reason: ORA-00001: unique constraint (GFORUM.SYS_C004519) violated (DBD ERROR: OCIStmtExecute)

If it matters, I have added several custom fields to both the category and links tables.

Suggestions gratefully accepted!