Icy Phoenix

I am trying to import users from another phpbb data base to my ICPhoenix database, using the technique described here -

Quote:

http://www.icyphoenix.com/viewtopic.php?f=4&t=7147

I get this kind of garbled information in the username field -

Quote:

wûƒÏɽ/"øô>í·–þÂP\oÞõ:

Also, it only imported 79 records of a possible 297.

I created a CSV file by exporting the old database, and named it "users_to_add.csv" as instructed. I then uploaded it to my site, and after running the users_add.php file I got the above results.

Does anyone have some idea of what I did wrong here?

Do you have users with strange chars in their username?

To improve security and readability, Icy Phoenix doesn't allow special chars in usernames (unless you want to enable some of them by editing core files).

Can you please check the usernames? Can you try to clean all special chars from there?

Here is more information to help find out what is causing my problem.

I'm working with ICPhoenix version 1.3.0.53a, PHP version 5.2.13, and MySQL version 5.1.47.

I am trying to import the users table from a phpBB version 2.0.22.

I am getting some conflicting results when trying to run your "users_add.php" per your instructions.

The first problem is that the "users_add.php" file is not set up to accommodate a table created in phpBB version 2.0.22. The file uses this sequence of fields -

Quote:

('username', 'user_password', 'user_email', 'user_style', 'user_lang', 'user_timezone', 'user_dateformat');

This sequence of fields does not match those in a phpBB 2.0.22 DB which actually are in this sequence -

Quote:

('id', 'active', 'username', 'password', 'email', 'user_timezone'. 'user_dateformat')

I believe this may have led to the garbled entries in the username field as I described in my original post.

But if I change the entire setup of the file "users_add.php" to match the actual sequence, and run the file, no names are added even though the message tells me that all names have been added.

I hope this can shed some light on my problem.

I just noticed that the file - users_to_add.csv - after uploading has been converted to the garbled text as I quoted in my original post.

Maybe your issue is the program you are using to edit that file.

Can you please try to send me the CSV file in a PM?

I will have a look at it for you.

It seems that my problem has been mysteriously fixed! I was offline for a few days and when I returned, all the users that I had attempted unsuccessfully to move had somehow been added to the new forum database. I have no idea how this happened, but it did, so I guess this case can be closed.

Great, thanks for reporting.