Fork me on GitHub
Subscribe 1

Ticket #627 (fixed bug)

Duplicate error on similar usernames

  • Created: 2012-02-19 08:57:28
  • Reported by: daris
  • Assigned to: daris
  • Milestone: 1.0-beta
  • Component: systems
  • Priority: normal
unikum wrote:

Hi, thanks for this tool.
I encountered a problem with convert user nicknames in Russian. Converter recieve letter "е" and "ё" as one letter. I tried convert phpbb3 to fluxbb 1.4.8.
Error output:

File: /srv/http/forum/converter/include/fluxbb.class.php
Line: 135

FluxBB reported: Unable to insert values

Database reported: Duplicate entry 'Алена' for key 'forum_users_username_idx' (Errno: 1062)

Failed query: INSERT INTO forum_users (id, group_id, username, password, url, icq, msn, aim, yahoo, num_posts, location, email_setting, timezone, registered, last_visit, signature, email) VALUES('158', '4', 'Алена', 'pass', '', '', '', '', '', '3', '', '', '3.00', '1269778285', '1270310468', '', 'xxxxxx@xxx') 

And another: may be necessary to add convert user_ip to registration_ip values?


daris 2012-02-19 09:29:42

Commit 4d17cba to converter master

Fix Duplicate error when converting from phpbb3 and some users have similar usernames, fixes #627

daris 2012-02-19 09:41:09

  • Owner set to daris.
  • Status changed from open to fixed.