Cannot login and search for users with æøå.

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Get Involved
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
User avatar
DoYouSpeakWak
Registered User
Posts: 2307
Joined: Fri Jul 25, 2008 1:32 pm
Location: Island of Wak-Wak
Name: Hans Lassen
Contact:

Cannot login and search for users with æøå.

Post by DoYouSpeakWak » Fri Feb 14, 2014 6:35 pm

Support Request Template
What version of phpBB are you using? phpBB 3.0.12
What is your board's URL? http://www.smorumnet.dk/cms/phpbb/index.php
Who do you host your board with? dcmediahosting.com
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Conversion from phpBB2
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
What styles do you currently have installed? prosilver and subsilver2
What language(s) is your board currently using? Danish and English
Which database type/version are you using? MySQL 5
What is your level of experience? Experienced with PHP and phpBB
When did your problem begin? After converting the board. I check the posts, usernames. all seemed fine. Apperently a perfect conversion.
Please describe your problem.
1: You cannot login with a username that containts the nordic letters æøå.
2: You cannot search for a user in acp (User management) that has æøå in the username.

Otherwise it runs perfectly.

What can cause these problems ?
Generated by SRT Generator

P.S. Support Request Template generator does not support æøå letters.
Whatever you share comes back. Support the phpBB Communities
My Validated and Released Modifications
Offering paid phpBB help and System administrator services.

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Cannot login and search for users with æøå.

Post by Oyabun1 » Fri Feb 14, 2014 9:06 pm

What character set and collation do you have set for the users table? You can find out using a query like

Code: Select all

SHOW CREATE TABLE phpbb_users
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

User avatar
DoYouSpeakWak
Registered User
Posts: 2307
Joined: Fri Jul 25, 2008 1:32 pm
Location: Island of Wak-Wak
Name: Hans Lassen
Contact:

Re: Cannot login and search for users with æøå.

Post by DoYouSpeakWak » Fri Feb 14, 2014 10:01 pm

Code: Select all

CREATE TABLE `phpbb3_users` (
 `user_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
 `user_type` tinyint(2) NOT NULL DEFAULT '0',
 `group_id` mediumint(8) unsigned NOT NULL DEFAULT '3',
 `user_permissions` mediumtext COLLATE utf8_bin NOT NULL,
 `user_perm_from` mediumint(8) unsigned NOT NULL DEFAULT '0',
 `user_ip` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
 `user_regdate` int(11) unsigned NOT NULL DEFAULT '0',
 `username` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
 `username_clean` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
 `user_password` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
 `user_passchg` int(11) unsigned NOT NULL DEFAULT '0',
 `user_pass_convert` tinyint(1) unsigned NOT NULL DEFAULT '0',
 `user_email` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
 `user_email_hash` bigint(20) NOT NULL DEFAULT '0',
 `user_birthday` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
 `user_lastvisit` int(11) unsigned NOT NULL DEFAULT '0',
 `user_lastmark` int(11) unsigned NOT NULL DEFAULT '0',
 `user_lastpost_time` int(11) unsigned NOT NULL DEFAULT '0',
 `user_lastpage` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
 `user_last_confirm_key` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
 `user_last_search` int(11) unsigned NOT NULL DEFAULT '0',
 `user_warnings` tinyint(4) NOT NULL DEFAULT '0',
 `user_last_warning` int(11) unsigned NOT NULL DEFAULT '0',
 `user_login_attempts` tinyint(4) NOT NULL DEFAULT '0',
 `user_inactive_reason` tinyint(2) NOT NULL DEFAULT '0',
 `user_inactive_time` int(11) unsigned NOT NULL DEFAULT '0',
 `user_posts` mediumint(8) unsigned NOT NULL DEFAULT '0',
 `user_lang` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT '',
 `user_timezone` decimal(5,2) NOT NULL DEFAULT '0.00',
 `user_dst` tinyint(1) unsigned NOT NULL DEFAULT '0',
 `user_dateformat` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT 'd M Y H:i',
 `user_style` mediumint(8) unsigned NOT NULL DEFAULT '0',
 `user_rank` mediumint(8) unsigned NOT NULL DEFAULT '0',
 `user_colour` varchar(6) COLLATE utf8_bin NOT NULL DEFAULT '',
 `user_new_privmsg` int(4) NOT NULL DEFAULT '0',
 `user_unread_privmsg` int(4) NOT NULL DEFAULT '0',
 `user_last_privmsg` int(11) unsigned NOT NULL DEFAULT '0',
 `user_message_rules` tinyint(1) unsigned NOT NULL DEFAULT '0',
 `user_full_folder` int(11) NOT NULL DEFAULT '-3',
 `user_emailtime` int(11) unsigned NOT NULL DEFAULT '0',
 `user_topic_show_days` smallint(4) unsigned NOT NULL DEFAULT '0',
 `user_topic_sortby_type` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 't',
 `user_topic_sortby_dir` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 'd',
 `user_post_show_days` smallint(4) unsigned NOT NULL DEFAULT '0',
 `user_post_sortby_type` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 't',
 `user_post_sortby_dir` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT 'a',
 `user_notify` tinyint(1) unsigned NOT NULL DEFAULT '0',
 `user_notify_pm` tinyint(1) unsigned NOT NULL DEFAULT '1',
 `user_notify_type` tinyint(4) NOT NULL DEFAULT '0',
 `user_allow_pm` tinyint(1) unsigned NOT NULL DEFAULT '1',
 `user_allow_viewonline` tinyint(1) unsigned NOT NULL DEFAULT '1',
 `user_allow_viewemail` tinyint(1) unsigned NOT NULL DEFAULT '1',
 `user_allow_massemail` tinyint(1) unsigned NOT NULL DEFAULT '1',
 `user_options` int(11) unsigned NOT NULL DEFAULT '230271',
 `user_avatar` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
 `user_avatar_type` tinyint(2) NOT NULL DEFAULT '0',
 `user_avatar_width` smallint(4) unsigned NOT NULL DEFAULT '0',
 `user_avatar_height` smallint(4) unsigned NOT NULL DEFAULT '0',
 `user_sig` mediumtext COLLATE utf8_bin NOT NULL,
 `user_sig_bbcode_uid` varchar(8) COLLATE utf8_bin NOT NULL DEFAULT '',
 `user_sig_bbcode_bitfield` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
 `user_from` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
 `user_icq` varchar(15) COLLATE utf8_bin NOT NULL DEFAULT '',
 `user_aim` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
 `user_yim` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
 `user_msnm` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
 `user_jabber` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
 `user_website` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT '',
 `user_occ` text COLLATE utf8_bin NOT NULL,
 `user_interests` text COLLATE utf8_bin NOT NULL,
 `user_actkey` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
 `user_newpasswd` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
 `user_form_salt` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
 `user_new` tinyint(1) unsigned NOT NULL DEFAULT '1',
 `user_reminded` tinyint(4) NOT NULL DEFAULT '0',
 `user_reminded_time` int(11) unsigned NOT NULL DEFAULT '0',
 PRIMARY KEY (`user_id`),
 UNIQUE KEY `username_clean` (`username_clean`),
 KEY `user_birthday` (`user_birthday`),
 KEY `user_email_hash` (`user_email_hash`),
 KEY `user_type` (`user_type`)
) ENGINE=InnoDB AUTO_INCREMENT=67679 DEFAULT CHARSET=utf8 COLLATE=utf8_bin
However, after going over the db, i found just 8 users with æåø in their usernames, cleaned the username_clean entries and now it does seem to work. I was sure i had been over those once before. There was also a few extra things found in the database cleaner, even though both the phpbb2 board and the new board are both vanilla.
Whatever you share comes back. Support the phpBB Communities
My Validated and Released Modifications
Offering paid phpBB help and System administrator services.

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Cannot login and search for users with æøå.

Post by Oyabun1 » Fri Feb 14, 2014 10:12 pm

The Support Toolkit has a Reclean Username tool (in case you missed any).
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

Locked

Return to “[3.0.x] Support Forum”