Hello,
I obtain an extrange error when I try to manualy add a new category to my LSQL database. This *only* happen when I try to insert a new category (Database -> Category -> Add or Browse the category tree) *after* a backup restore, import from a dump or import from Links 2. This not happen when I delete all my database and try to add category for first time.
The error is:Failed to execute query: 'INSERT INTO lsql_Category (Description,Newest_Link,Category_Template,Timestmp,Meta_Description,Name,Footer,Header,Has_New_Links,Number_of_Links,Has_Changed_Links,Full_Name,Meta_Keywords,FatherID,ID) VALUES (?,NULL,?,?,?,?,?,?,?,?,?,?,?,?,NEXTVAL('lsql_Category_seq'))' Reason: ERROR: Cannot insert a duplicate key into unique index lsql_category_pkey
I show in my category idīs to see if I could have one or more with the same ID, but I have not any and all seems correct.
I run LSQL in Redhat 7.2 with PostgreSQL. Any help?
Thanks!
I obtain an extrange error when I try to manualy add a new category to my LSQL database. This *only* happen when I try to insert a new category (Database -> Category -> Add or Browse the category tree) *after* a backup restore, import from a dump or import from Links 2. This not happen when I delete all my database and try to add category for first time.
The error is:
I show in my category idīs to see if I could have one or more with the same ID, but I have not any and all seems correct.
I run LSQL in Redhat 7.2 with PostgreSQL. Any help?
Thanks!