No announcement yet.

Editing Users After Forum Move

  • Filter
  • Time
  • Show
Clear All
new posts

  • Editing Users After Forum Move

    Recently moved to a new [email protected] current server, so I just got them to transfer the Database & the files accross, now nothing has changed except I downloaded all the forum php files and uploaded them again. The database was just directly transferred at the server end.

    NOW, when I go to edit a users' details in the Admin CP, I get this error

    Database error in vBulletin Control Panel 2.2.1:

    Invalid SQL: SELECT *,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,FROM_UNIXTIME(awaydate) AS awaydate
    avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
    FROM user
    LEFT JOIN avatar ON avatar.avatarid=user.avatarid
    LEFT JOIN customavatar ON customavatar.userid=user.userid
    WHERE user.userid=86
    mysql error: You have an error in your SQL syntax near 'avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
    ' at line 2

    mysql error number: 1064

    Date: Tuesday 22nd of January 2002 08:39:14 AM

    I have NO clue what I could do to rectify this.

    The website is
    or will get you there aswell.

    Thanks guys.

  • #2
    reupload all php files in ASCII mode via ftp
    :: Always Back Up Forum Database + Attachments BEFORE upgrading !
    :: Nginx SPDY SSL - World Flags Demo [video results]
    :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ blog summary ]


    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.