Converting from IPB 3.4.6, users amount converted not completely

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
Post Reply
User avatar
aeolustw
Registered User
Posts: 6
Joined: Thu Apr 05, 2012 6:04 am
Location: Taiwan

Converting from IPB 3.4.6, users amount converted not completely

Post by aeolustw » Thu Oct 11, 2018 3:07 am

My server's environment:
OS: Debian 7.x (Linux ipb 3.2.0-6-amd64)
MySQL: 5.5.60
PHP:5.4.45

phpBB: 3.0.12
IPB: 3.4.6

I read these this topic, and also dicuss here.
After fresh installed phpBB 3.0.12 and converted from IPB 3.4.6, I got no error during the process.

But my remaining issue is:
The phpbb_users only have 779 Rows converted from IPB 3.4.6 ibf_members that have 1725 Rows.
Not whole ipb members Rows converted to phpBB users.

I check my phpBB and ipb database,the name that converted not successfully included Chinese and English name.

And i also disable these codes of functions_ipb34.php.

Code: Select all

	//$drop_sql = 'DROP TABLE ' . USERCONV_TABLE;
	//$db->sql_query($drop_sql);
The phpbb_userconv has 1725 Rows that are all members Rows of IPB 3.4.6.

How to check and edit convertor's code, Please give me a hint.

Thanks.

User avatar
Ger
Recognised Extension Developer
Posts: 1737
Joined: Wed Jan 02, 2008 7:35 pm
Location: 192.168.1.100
Contact:

Re: Converting from IPB 3.4.6, users amount converted not completely

Post by Ger » Thu Oct 11, 2018 7:55 am

To add to this, I wrote earlier:
Ger wrote:
Wed Oct 10, 2018 2:48 pm
That's probably due to the function remove_invalid_users() in ./includes/functions_convert.php that's called after the users have been converted.
It basically removes any user that has an empty username_clean. That value is generated after encoding the original IPB username to UTF8, stripping any special characters, lowercasing them, etc. It might be that with Chinese characters, a problem arises.

Since I have no experience with such character and I'm also not very specialised in encoding stuff, you'd better open up a specific support topic to get the attention of more knowledgeable people on this manner. Feel free to refer to this topic and poke me if you need my insight.
As stated, this is beyond my field of expertise and I also think it's a generic conversion issue. There might be a simple solution to this, I'm just unaware of it ;)
My extensions:
Simple CMS, Feed post bot, Avatar Resize, Modbreak, Magic OGP, Live topic update, Modern Quote, Quoted Where (GDPR) and Autoresponder.
Newest: FAQ manager for 3.2

Like my work? Buy me a coffee to keep it coming. :ugeek:
-Available for custom work-

User avatar
orynider
Registered User
Posts: 155
Joined: Wed Nov 16, 2005 12:48 pm
Location: Arad, România
Name: Florin Bodin
Contact:

Re: Converting from IPB 3.4.6, users amount converted not completely

Post by orynider » Thu Oct 11, 2018 10:28 am

Hello,

You could also edit the members or users table manually in phpMyAdmin if is the only table that is not converted.

User avatar
aeolustw
Registered User
Posts: 6
Joined: Thu Apr 05, 2012 6:04 am
Location: Taiwan

Re: Converting from IPB 3.4.6, users amount converted not completely

Post by aeolustw » Thu Oct 11, 2018 1:41 pm

@orynider
How to edit?
There are 1725-779=946 that are not converted sucessfully, edit them one by one? :mrgreen:
I don't think it's efficient.

Post Reply

Return to “[3.2.x] Convertors”

Who is online

Users browsing this forum: No registered users and 6 guests