You may need to edit the ID numbers in links.db/validate.db and in linksid.txt to totally fix this problem. What you are describing should not be happening. Links should be using the highest ID+1 regardless of whether it is done from the admin screen or from the user add form.
Try this script to fix things (validate your records first). Put the script in your admin/data directory, chmod the directory to 777 and the script to 755 and then run it. It will create a new file, links_new.db, and should have all the ID numbers in order. When you are satisfied that the new file is correct, rename the old links.db to links_org.db (just to be on the safe side) and then rename links_new.db to links.db. This script will also update your linksid.txt to the correct value.
Code:
#!/usr/bin/perl
# -------------------------------------------
# Change next line to full path to links.cfg if you have problems with this script.
require "../links.cfg";
require "$db_lib_path/db_utils.pl";
require "$db_lib_path/links.def";
$counter = 0;
$ENV{'REQUEST_METHOD'} and (print "Content-type: text/plain\n\n");
open (DB, "<$db_links_name")
or print "Unable to open links database 'links.db'. Reason: $!\n" and exit;
open (DBOUT, ">$db_script_path/data/links_new.db")
or print "Unable to open output database. Reason: $!\n" and exit;
LINE: while (<DB> )
{
/^#/ and next LINE; # Skip comment Lines.
/^\s*$/ and next LINE; # Skip blank lines.
chomp; # Remove trailing new line.
$counter++;
@rec = &split_decode($_);
$rec[$db_key] = $counter;
print DBOUT &join_encode(&array_to_hash(0, @rec));
}
close DB;
close DBOUT;
open (DBID, ">$db_script_path/data/linksid_new.txt")
or print "Unable to open linksid.txt. Reason: $!" and exit;
print DBID $counter;
close DBID;
# ---------------------------------------------
I hope this helps.
