Announcement

Collapse
No announcement yet.

Editing Users After Forum Move

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

  • Editing Users After Forum Move

    Hi,
    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
    Script: http://buffy.phpwebhosting.com/forum...edit&userid=86
    Referer: http://buffy.phpwebhosting.com/forums/admin/


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

    The website is

    http://www.buffydownunder.com
    or
    http://buffy.phpwebhosting.com/forums/ will get you there aswell.

    Thanks guys.
    RussellGreenwood
    http://forums.buffydownunder.com

  • #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 [ vbulletin.com blog summary ]

    Comment

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