Announcement

Collapse
No announcement yet.

User Merge After Import Completed

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

  • User Merge After Import Completed

    Code:
    Database error in vBulletin 4.2.0:
    
    Invalid SQL:
    
            INSERT IGNORE INTO userlist
                (userid, relationid, type, friend)
            SELECT , relationid, type, friend
            FROM userlist
            WHERE userid = 11;
    
    MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' relationid, type, friend
            FROM userlist
            WHERE userid = 11' at line 3
    Error Number  : 1064
    Request Date  : Saturday, June 23rd 2012 @ 11:32:10 PM
    Error Date    : Saturday, June 23rd 2012 @ 11:32:11 PM
    Script        : http://XXXXXXXXXX/admin/usertools.php?do=reallydomerge
    Referrer      : http://XXXXXXXXX/admin/usertools.php?do=domerge
    IP Address    : XXX.XXX.XXX.XX
    Username      : XXXXXXXXXX
    Classname     : vB_Database
    MySQL Version : 5.1.63-community-log

    The Import went smooth. But, I'm trying to merge users. It doesn't matter what user I try to merge; I get this error message.

    - - - Updated - - -

    I've already deleted the import. Cleaned up everything and the site is running great!

    This is the only error I have run across so far.

    - - - Updated - - -

    I turned off plugins, one of these is affecting the admincp and site links.

    all good now. now im looking to see what plugin is causing this minor issue

  • #2
    Originally posted by G.I.JOE*MFA* View Post
    im looking to see what plugin is causing this minor issue
    Try to have as few plugins as possible to avoid major headaches like this.

    Turn them all off and one by one turn them on to see which one is the one that is causing the problems.

    Comment

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