No announcement yet.

Moved to new server

  • Filter
  • Time
  • Show
Clear All
new posts

  • Moved to new server

    Hi all,

    We moved a site onto my VPS and backup the original database and imported it into the new database. We have done this numerous times now. Fresh installs, copy of all the old files.

    We get this error

    SELECT *
    FROM session
    WHERE sessionhash = '15efbe0bbee800705d87abe3dbcb57d0'
    AND lastactivity > 1362791046
    AND idhash = 'cd96f41c6706ee023196ee5fb1aa3fb6';

    MySQL Error : Table 'lmzfclanforum.session' doesn't exist
    Error Number : 1146
    Request Date : Saturday, March 9th 2013 @ 01:19:06 AM
    Error Date : Saturday, March 9th 2013 @ 01:19:06 AM
    Script : [URL=""][/URL=""]
    Referrer :
    IP Address :
    Username :
    Classname : vB_Database
    MySQL Version :

    Please help as we are stuck.

    [URL=""][/URL=""] is the site.

    Last edited by zapiy; Fri 8 Mar '13, 5:20pm.

  • #2
    Are you sure that your backup restored properly ? Also did you update config.php file?

    Former vBulletin Support Staff
    Need Help?, Or P.M. Me


    • #3
      Well how could I prove the import works properly. I am doing it with Putty.


      • #4
        Getting this as well.

        Database error in vBulletin 3.7.4:

        Invalid SQL:

        SELECT languageid,
        phrasegroup_global AS phrasegroup_global,
        phrasegroup_holiday AS phrasegroup_holiday,
        phrasegroupinfo AS lang_phrasegroupinfo,
        options AS lang_options,
        languagecode AS lang_code,
        charset AS lang_charset,
        locale AS lang_locale,
        imagesoverride AS lang_imagesoverride,
        dateoverride AS lang_dateoverride,
        timeoverride AS lang_timeoverride,
        registereddateoverride AS lang_registereddateoverride,
        calformat1override AS lang_calformat1override,
        calformat2override AS lang_calformat2override,
        logdateoverride AS lang_logdateoverride,
        decimalsep AS lang_decimalsep,
        thousandsep AS lang_thousandsep
        FROM language
        WHERE languageid = 1;

        MySQL Error : Unknown column 'phrasegroupinfo' in 'field list'
        Error Number : 1054
        Request Date : Saturday, March 9th 2013 @ 10:05:09 AM
        Error Date : Saturday, March 9th 2013 @ 10:05:09 AM
        Script :
        Referrer :
        IP Address :
        Username :
        Classname : vB_Database
        MySQL Version :


        • #5
          Ok a friend managed to get this working.

          We have this error though when running the rebuild search index.

          Database error in vBulletin 4.2.0:

          Invalid SQL:
          SELECT u.username, n.userid, a.contentid,
          a.pagetext, i.title, n.publishdate, i.creationdate, i.html_title, n.nosearch,

          FROM cms_article a
          LEFT JOIN cms_node n on n.contentid = a.contentid
          LEFT JOIN cms_nodeinfo i on i.nodeid = n.nodeid
          LEFT JOIN user u on u.userid = n.userid
          WHERE a.contentid = 0 AND n.contenttypeid =;

          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 '' at line 8
          Error Number : 1064
          Request Date : Sunday, March 10th 2013 @ 02:26:57 PM
          Error Date : Sunday, March 10th 2013 @ 02:26:57 PM
          Script :
          Referrer :
          IP Address :
          Username : zapiy
          Classname : vB_Database
          MySQL Version : 5.0.95

          Any help please?


          • #6
            Did you uninstall the CMS in 4.2.0?


            • #7
              Why in post 4 does it say the database is for version 3.7.4, and then in post 5 it says it is for 4.2.0? What did you do between the two? Did you run the upgrade.php script?

              Please don't PM or VM me for support - I only help out in the threads.
              vBulletin Manual & vBulletin 4.0 Code Documentation (API)
              Want help modifying your vbulletin forum? Head on over to
              If I post CSS and you don't know where it goes, throw it into the additional.css template.

              W3Schools <- awesome site for html/css help


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