duplicate user-roles error reported
drofnar - October 10, 2007 - 20:56
| Project: | Drupal for Facebook |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
Hi Dave, I get this error at the top of every page. Every page from the facebook app side that is, the error never shows in the drupal website. I only have 2 users, 1 is my site first account admin the other was a user created by drupal when I installed the app on my facebook account.
"... user warning: Duplicate entry '2-4' for key 1 query: INSERT INTO users_roles (uid, rid) VALUES (2, 4) in /home/ranford/public_html/forcefb/includes/database.mysql.inc on line 172...."
Rgds, mark
#1
Agreed this is a bug and should be fixed. But for now, try changing (or not setting), the New User Role field of the Facebook App.
#2
Thanks David, I had entered a number for the new user to be assigned a role, and that was obviously causing a duplication. I removed so that the filed is empty, and everything is working like a peach... Thanks Dave,
I just love this module Dave, I cant believe more people aren't going mad over it.
#3
Me either!
Hey don't change the title of an active issue. This one still needs to be fixed.
#4
I experienced this issue with the 6.x-2.x release. I followed your advice Dave, and changed the new user assigned role (there wasn't a way to un-select it), and that seemed to fix things. FYI.