Hello,
Drupal 5.5, MySQL 4.4x, PHP4x
Whenever I try to add a relationship, I get the the following warning/error:
<h3>This page lets you setup user relationship types.</h3><br>
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. <p>
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!
Comment #2
drusnake CreditAttribution: drusnake commented