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?
Comments
Comment #1
drusnake CreditAttribution: drusnake commentedSorry!
How do I delete these (my own) issues?
Comment #2
Bevan CreditAttribution: Bevan commentedYou can't. Just leave it set to duplicate and it will be closed by the bot and dissappear of all the important queues. :)