Can not add links to database!!!
Hello,
I am getting the following error whenever a user try to add a new link into my database:
Failed to execute query: 'INSERT INTO lsql_CatLinks (LinkID,CategoryID) VALUES (?,?)' Reason: Duplicate entry '1' for key 1
Somehow, I have corrupted the lsql_CatLinks database by clicking on Primary/Index/Unique...etc. So, I am unable to add records to my database anymore...
This is what I am getting when I build:
Building Detailed pages ...
A fatal error has occured:
GT::SQL::Table (25683): Wrong argument passed to this subroutine. Usage: Must pass category id to template_set at (eval 39) line 7.
Please enable debugging in setup for more details.
Can you help please or show me what would the default DB has:
thank you in advance
Mark
This is what I have in the MySqlMan:
MySQL message:
Column LinkID set as index.
Field Type Null Key Default Extra ACTION
LinkID int(10) unsigned MUL 0 Change Drop Primary Index Unique
CategoryID int(10) unsigned PRI 0 Change Drop Primary Index Unique
Keys:
Key name Unique Field Action
PRIMARY YES CategoryID Drop
CategoryID YES CategoryID Drop
catlnndx YES CategoryID Drop
lndx No LinkID Drop
LinkID No LinkID Drop
LinkID_2 No LinkID Drop
I am getting the following error whenever a user try to add a new link into my database:
Failed to execute query: 'INSERT INTO lsql_CatLinks (LinkID,CategoryID) VALUES (?,?)' Reason: Duplicate entry '1' for key 1
Somehow, I have corrupted the lsql_CatLinks database by clicking on Primary/Index/Unique...etc. So, I am unable to add records to my database anymore...
This is what I am getting when I build:
Building Detailed pages ...
A fatal error has occured:
GT::SQL::Table (25683): Wrong argument passed to this subroutine. Usage: Must pass category id to template_set at (eval 39) line 7.
Please enable debugging in setup for more details.
Can you help please or show me what would the default DB has:
thank you in advance
Mark
This is what I have in the MySqlMan:
Code:
MySQL message:
Column LinkID set as index.
Field Type Null Key Default Extra ACTION
LinkID int(10) unsigned MUL 0 Change Drop Primary Index Unique
CategoryID int(10) unsigned PRI 0 Change Drop Primary Index Unique
Keys:
Key name Unique Field Action
PRIMARY YES CategoryID Drop
CategoryID YES CategoryID Drop
catlnndx YES CategoryID Drop
lndx No LinkID Drop
LinkID No LinkID Drop
LinkID_2 No LinkID Drop
Can not add links to database!!!