No announcement yet.

Blog stoppped working after moving to a new server

  • Filter
  • Time
  • Show
Clear All
new posts

  • Blog stoppped working after moving to a new server

    Hi, today I finished the move to a new server. Everything went well so far and is working properly.

    However, the Blog is not available anymore. The pulldown menu in the navbar is not popping up, and I received this strange database error message:

    Database error in vBulletin 3.8.3:

    Invalid SQL:

    blog.userid, blog.title, blog.blogid, blog.categories, blog.postedby_username, blog.postedby_userid,
    bu.title AS blogtitle, bu.options_guest & AS guestcanview
    FROM vb_blog AS blog
    LEFT JOIN vb_blog_user AS bu ON (blog.userid = bu.bloguserid)
    LEFT JOIN vb_user AS user ON (blog.userid = user.userid)
    state = 'visible' AND
    dateline <= 1248208213 AND
    blog.pending = 0 AND
    ~blog.options & AND
    bu.options_buddy & AND
    bu.options_member &
    ORDER BY dateline DESC
    LIMIT 1;

    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 'AS guestcanview
    FROM vb_blog AS blog
    LEFT JOIN vb_blog_user AS bu ON (blog.u' at line 4 Error Number : 1064 Request Date : Tuesday, July 21st 2009 @ 10:30:13 PM
    Error Date : Tuesday, July 21st 2009 @ 10:30:13 PM
    Script :
    Referrer :
    IP Address :
    Username : Unregistered
    Classname : vb_database
    MySQL Version :
    Can anybody help me and give me a hint how to solve that issue? I switched off vBSEO to see if this was the reason but it wasn't, still the same.

    Thanks a lot!

  • #2
    How did you move to the new server?


    • #3
      Backup of the forum content and the database. Dump (mSQLdumper) of the database on the new server, upload of all files, editing the config.php, run tools.php and so far it all worked fine, I think. I hope!


      • #4
        Run a repair on your tables, see if the products and plugins are all active and otherwise working.


        • #5
          I did, still the same. Everything else is working.


          • #6
            I jut found out that when I try to see a member's profile, I get database erros as well and the forum's style is destroyed. Could there be a connection?

            The forum has been running on that database since one week and everything was fine, only now where I use the files from the server (domain was transferred only today) the problems occurr.


            • #7
              Same error?

              Run 'Suspect File Version' in Diagnostics and report back the results.

              Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions
              Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
              Change CKEditor Colors to Match Style (for 4.1.4 and above)

              Steve Machol Photography

              Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


              • #8
                I attached a screenshot.

                Hope you can find something. All this appears so weird to me, as actually only the server environment changed...
                Attached Files


                • #9
                  Problem solved after re-setting the cookie domain. Sorry and thanks a lot anyway!


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