Announcement

Collapse
No announcement yet.

Moved to new server

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

  • Lynne
    replied
    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?

    Leave a comment:


  • BirdOPrey5
    replied
    Did you uninstall the CMS in 4.2.0?

    Leave a comment:


  • zapiy
    replied
    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?

    Leave a comment:


  • zapiy
    replied
    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 :

    Leave a comment:


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

    Leave a comment:


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

    Leave a comment:


  • zapiy
    started a topic Moved to new server

    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.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X