Done.

Processing users 1 - 201 of 15925

Importing webmaster - webmaster (2)
Importing - **DONOTDELETE**_dup1 (3) (Duplicate DisplayName)
Script:
Line#:
SQL Error:
SQL Error #: 0
Query: insert into ubbt_USERS (USER_LOGIN_NAME,USER_DISPLAY_NAME,USER_PASSWORD,USER_MEMBERSHIP_LEVEL,USER_REGISTRATION_EMAIL,USER_REGISTRATION_IP,USER_IS_APPROVED,USER_REGISTERED_ON,USER_IS_BANNED,USER_IS_UNDERAGE) values ( '' , '**DONOTDELETE**_dup1' , '' , 'User' , '' , '' , 'yes' , '' , 0 , 0 )


I just used phpmyadmin to look at the 6.5 database and there are 4 blank entries for users with the **donotdelete** values.

You had to access my setup in the past. Is it possible my current instance is no longer standard compliant?

Ok, that would definitely cause a problem. You can actually get rid of all of them. It automatically tries to skip the first one (user id 1) because we don't need to import it.

I have deleted the empty records, dropped the incomplete database, recreated the new database, ran createtable, and started the import.

Processing users 1 - 201 of 15921

Importing Steve - Steven (6)
Script:
Line#:
SQL Error:
SQL Error #: 0
Query: insert into ubbt_USER_PROFILE (USER_ID,USER_REAL_EMAIL,USER_DISPLAY_EMAIL,USER_SIGNATURE,USER_DEFAULT_SIGNATURE,USER_HOMEPAGE,USER_OCCUPATION, USER_LOCATION,USER_TOPICS_PER_PAGE,USER_TOPIC_VIEW_TYPE,USER_NOTIFY_ON_PM,USER_ICQ,USER_EXTRA_FIELD_1,USER_EXTRA_FIELD_2,USER_EXTRA_FIELD_3,USER_EXTRA_FIELD_4,USER_EXTRA_FIELD_5,USER_AVATAR,USER_SHOW_AVATARS,USER_VISIBLE_ONLINE_STATUS, USER_ACCEPT_PM,USER_TITLE,USER_POSTS_PER_TOPIC,USER_NAME_COLOR,USER_TIME_OFFSET,USER_TOTAL_POSTS,USER_SHOW_SIGNATURES,USER_RATING,USER_TOTAL_RATES,USER_AVATAR_WIDTH,USER_AVATAR_HEIGHT,USER_ACCEPT_ADMIN_EMAILS,USER_HOBBIES,USER_BIRTHDAY,USER_PUBLIC_BIRTHDAY,USER_TIME_FORMAT,USER_FLOOD_CONTROL_OVERRIDE) values ( 2 , 'bbs@divorcenet.com' , '' , '' , '' , '' , '' , '' , 10 , 'flat' , 'Off' , '' , '' , '' , '' , '' , '' , '' , 1 , 'yes' , 'yes' , 'New User' , '' , '' , 0 , 1 , 'yes' , 0 , 0 , '' , '' , 'On' , '' , 0 , 0 , 'm/d/y | h:i A' , 0 )


Run the query in phpmyadmin and receive:

MySQL said: Documentation
#1264 - Out of range value adjusted for column 'USER_AVATAR_WIDTH' at row 1

While, I am a patient person, this is beginning to become frustrating

I may have to update the import script to populate all of the fields with a default value. It's a bit strange as I've run this on both MySQL 5 and MySQL 4 versions and haven't come across this. It appears that I'll need ot make sure all integer type columns have a default value inserted if they are empty.

I'll work on these changes and then mail the updated importer to you when finished if you can PT me with the email address you'd like me to send to.