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!
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!