Announcement

Collapse
No announcement yet.

avatarid sql error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • avatarid sql error

    Help....

    Trying to import Users... NO assocoation was done as this is a clean install; but can't get past this....

    ImpEx from dead server data VB3.8.3 to new install VB3.8.4PL1.. Don't have a .sql backup; just have the raw data from the hard drive array from the dead server...

    Module 1 --> Success
    Module 2 --> SKIPPED
    Module 3 --> Success
    Module 4 --> Errror below
    Module 5 --> Success - 1549



    ImpEx Database errormysql error: Invalid SQL:
    INSERT INTO user
    (
    username, email, usergroupid,
    importuserid, password, salt,
    passworddate, options, homepage,
    posts, joindate, icq,
    daysprune, aim, membergroupids,
    displaygroupid, styleid, parentemail,
    yahoo, showvbcode, usertitle,
    customtitle, lastvisit, lastactivity,
    lastpost, reputation, reputationlevelid,
    timezoneoffset, pmpopup, avatarid,
    avatarrevision, birthday, birthday_search, maxposts,
    startofweek, ipaddress, referrerid,
    languageid, msn, emailstamp,
    threadedmode, pmtotal, pmunread,
    autosubscribe, profilepicrevision, lastpostid,
    sigpicrevision, ipoints, infractions,
    warnings, infractiongroupids, infractiongroupid,
    adminoptions
    )
    VALUES
    (
    'imported_tmcarter',
    '[email protected]',
    '22',
    '1',
    '(REMOVED),'
    'X\"W',
    '2003-09-26',
    '45095383',
    'http://www.strategicconsultants.net',
    '0',
    '1064592000',
    '1697400',
    '0',
    '',
    '',
    '6',
    '0',
    '',
    'ty_carter3',
    '2',
    'Administrator',
    '0',
    '1255078200',
    '1255095261',
    '1245024706',
    '32767',
    '13',
    '-5',
    '1',
    '',
    '0',
    '09-21-1969',
    '1969-09-21',
    '-1',
    '1',
    '',
    '',
    '0',
    '[email protected]',
    '0',
    '0',
    '0',
    '0',
    '0',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    '',
    ''
    )

    mysql error: Incorrect integer value: '' for column 'avatarid' at row 1
    mysql error number: 1366
    Last edited by tmcarter; Fri 9 Oct '09, 7:09am.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X