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
