My site seems to have a big problem! Adding a new link works just fine, but adding a new category gives an error message similar to:
----
Unable to add category: + Failed to execute query: 'INSERT INTO Category (FatherID,Meta_Description,Meta_Keywords,Footer,JACS,Newest_Link....,Category_Template,Header,ID) VALUES(?,?,?,?,?,?,?,?,?,?,NULL)' Reason: Column 'ID' cannot be null
----
There are quite a few extra fields that I've added to the table (hence the ... above to save space). But the ?,?,?,?,?,NULL thing looks as if Links SQL is wiping all my new category information before attempting to write it to the database.
I've done a rebuild and reindex, but no joy. Everything else works fine, ie the rebuilt site works OK and the category table looks fine when I browse it. It's just that I can't add any new categories.
I don't know when this problem started, because I've been doing lots of stuff on the site recently yet I haven't added any new categories. But as far as I know, I can't think what might be causing this.
I have another instance of Links SQL running on the same server, for test purposes, and that one works fine. So it's nothing wrong with the mysql installation on the server.
I'd really appreciate some help here. Thanks!
Rob
----
Unable to add category: + Failed to execute query: 'INSERT INTO Category (FatherID,Meta_Description,Meta_Keywords,Footer,JACS,Newest_Link....,Category_Template,Header,ID) VALUES(?,?,?,?,?,?,?,?,?,?,NULL)' Reason: Column 'ID' cannot be null
----
There are quite a few extra fields that I've added to the table (hence the ... above to save space). But the ?,?,?,?,?,NULL thing looks as if Links SQL is wiping all my new category information before attempting to write it to the database.
I've done a rebuild and reindex, but no joy. Everything else works fine, ie the rebuilt site works OK and the category table looks fine when I browse it. It's just that I can't add any new categories.
I don't know when this problem started, because I've been doing lots of stuff on the site recently yet I haven't added any new categories. But as far as I know, I can't think what might be causing this.
I have another instance of Links SQL running on the same server, for test purposes, and that one works fine. So it's nothing wrong with the mysql installation on the server.
I'd really appreciate some help here. Thanks!
Rob