I also noticed one other error at the top of the one i first posted:
Unsuccessfully inserted record for anonymous user into phpbb_groups table DB Error:
INSERT INTO phpbb_groups (group_id, group_type, group_name, group_description, group_moderator, group_single_user) VALUES (1, 1, 'Anonymous', 'Personal User', 0, 1); [nativecode=Cannot insert explicit value for identity column in table 'phpbb_groups' when IDENTITY_INSERT is set to OFF.]
Ok i fixed this by editing the convert/members.php file. I edited line 40 so that where it starts saying "INSERT INTO ... " it now says:
"SET IDENTITY_INSERT ". $table_prefix ."groups ON; INSERT INTO ..."
and at the end of the same line, i added:
SET IDENTITY_INSERT ". $table_prefix ."groups OFF;"
But i'm still having problems inserting members. It seens that the field user_emailtime cant be null. Thats the error i am getting when i run the query in query analyzer.
So i changed the database to allow nulls in that field which is easier for me right now since i'm not familar with php and didnt want to try and figure out how to check for a null value and replace it with a 0 or something.
now most of the users import although i still get some errors, most/all of which seem to be for unclosed quotations. Seems that it is using a backslash to escape the quotes instead of justing using a 2nd quote. I think i saw someone else post on here about that problem as well.
What i wound up doing was any place in the members.php file where it was using addslashes, i replaced that with str_replace
the correct format for using that (as someone else already pointed out) is
str_replace("'", "''", string)
In most cases it'll look something like str_replace("'", "''", trim ($memberfile))
In case thats not clear, its dbl quote single quote dbl quote, dbl quote single quote single quote dbl quote, string
" ' ", " ' ' ", string
The import is running right now on my board and so far its up to 1700 users with no errors, so hopefully its importing the users correctly now. I'll have to see what errors come up when importing the actual forums.