Announcement

Collapse
No announcement yet.

Moved to new server

Collapse
X
 
  • 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="http://www.lmzf.com/"]http://www.lmzf.com/[/URL="http://www.lmzf.com/"]
    Referrer :
    IP Address : 81.107.220.137
    Username :
    Classname : vB_Database
    MySQL Version :

    Please help as we are stuck.

    [URL="http://www.lmzf.com"]www.lmzf.com[/URL="http://www.lmzf.com"] is the site.

    Cheers
    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

    Comment


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

      Comment


      • #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 : http://www.lmzf.com/
        Referrer : http://www.lmzf.com/
        IP Address : 175.44.35.22
        Username :
        Classname : vB_Database
        MySQL Version :

        Comment


        • #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,
          n.new
          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 : http://www.lmzf.com/forums/admincp/m...o=doindextypes
          Referrer : http://www.lmzf.com/forums/admincp/misc.php?do=chooser
          IP Address : 81.107.220.137
          Username : zapiy
          Classname : vB_Database
          MySQL Version : 5.0.95

          Any help please?

          Comment


          • #6
            Did you uninstall the CMS in 4.2.0?

            Comment


            • #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 vbulletin.org
              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

              Comment

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