WordPress.org

1. TrueFlyingCow
   Member
   Posted 1 year ago #
   

   Hi,

   I've got wordpress and PHPBB forums on the same server, and I've got the plugin setup to work most of the time (users can sign in or out either via WP or on the forums, and they'll be automatically logged in/out on the other; password changes affect both login tables, etc). However, sometimes when trying to log in a user gets an error message about:

   Duplicate entry '(their username)' for key 'username_clean' [1062]

   and I'm trying to figure out why that's happening and how to stop it. My guess so far is that for some reason the script is trying to add the user to the database again, but since the user is already registered, trying to insert the username fails since there is already one in the same table. At the bottom of the error page, there's a note suggesting to contact the board administrator, which makes me feel like this could be with the phpBB side of things.

   Any tips about where to start would be great, even just which files generate those error messages would be a good start.

   Thanks!

   http://wordpress.org/extend/plugins/phpbb-single-sign-on/

2. sheba2
   Member
   Posted 1 year ago #
   

   Hi, I am thinking of using this plugin. Did you get your issue resolved? If yes, can you share what you did, so when I install it and encounter the issue, I know what to do.

   Thanks.

3. TrueFlyingCow
   Member
   Posted 1 year ago #
   

   Not resolved yet. I did find that the issue only comes up for users who have different capitalization between their wordpress login and phpBB username. Not sure why they would be different, since this plugin creates phpBB usernames only when people login with their WP names. But I'm trying to track down the parts in the code where case sensitive usernames are included and make things less picky.

4. sheba2
   Member
   Posted 1 year ago #
   

   Thanks for responding. I am eagerly waiting for the solution.

5. TrueFlyingCow
   Member
   Posted 1 year ago #
   

   And now it looks like I've solved my issue. Rather than searching through all the wordpress, phpBB, and the plugin's login/authentication code, I went to the database and changed the username column of the phpbb_users table from being utf8_bin, which was the default when it installed and was case sensitive, to utf8_general_ci, which is case insensitive.

6. sheba2
   Member
   Posted 1 year ago #
   

   Thanks for the update. I'll try it in a few days and let you know my outcome. I really appreciate your efforts.

7. crazy_cat
   Member
   Posted 1 year ago #
   

   Hello

   I sounds like the same problem and there is very bad my english, I wanted to ask for help. Please can you give me a step by step instructions explain exactly what should I do? I'd be really grateful! for the forum and wordpress page work so unfortunately not :-( (

   my website http://www.freie-bildung.ch and my forum http://www.freie-bildung.ch/forum

8. Zeek20
   Member
   Posted 11 months ago #
   

   http://wordpress.org/support/topic/plugin-phpbb-single-sign-on-duplicate-user-fix?replies=1

Topic Closed

This topic has been closed to new replies.