Duplicate - Delete!

Hello,

Drupal 5.5, MySQL 4.4x, PHP4x

Whenever I try to add a relationship, I get the the following warning/error:

This page lets you setup user relationship types.

user warning: Duplicate entry '1' for key 1 query: INSERT INTO bobsprefix_user_relationship_types (rtid, name, plural_name, is_oneway, requires_approval, expires_val) VALUES (1, 'Org', 'Orgs', 1, 1, 0) in /home/bob/public_html/includes/database.mysql.inc on line 172. 

Relationship Org has been added.

Despite the success message, nothing is added to the database table (a good thing given the duplicate key!).

A quick look in the file user_relationships_actions.inc, (v 1.14 2007/10/30 01:17:04 jbchristy) on line 47:

$form_values['rtid'] = db_next_id('{user_relationship_types}_id');

changed the id field name to rtid

$form_values['rtid'] = db_next_id('{user_relationship_types}_rtid');

Still no joy.

A quick read on db_next_id yields an interesting thread from April 2007 on its use in Drupal with a possibly relevant mention of cheap hosts limiting the use of locks on MySQl -I have no idea!

Anyway, this is the first time I've visted this module's admin settings since my recent upgrade to D5.5 although I have been messing with some mucky nodeprofile/role signup stuff that I thought I rolled back/wiped.

Anyone else with this issue?