1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

eShop module problem after migration to new server

Discussion in 'SiteBuilder' started by beauchman22, Mar 11, 2009.

  1. beauchman22

    beauchman22 Guest

    0
     
    Previous convo from another thread:

    me: A few sites had eSHop modules that don't seem to have moved over properly. Is there anything I can do to recover those sites completely? There was a lot of work put into those shops.

    Haven't checked yet but will this happen for all modules transferred?

    you: Did you change publishing location for the sites? If so, content from the old storage should be moved to new one and after that site should be re-published.
    The thing is that Parallels Plesk Sitebuilder sites store database module on publication side, so in case of changing publishing location, old data should be moved to new location.

    previous convo end
    -------------------------------------------------------------
    Ok so yes I did change the publishing location. I've moved everything to a new server and IP address. I did a back up of the mysql sitbuilder 3 database and transferred everything over. The few sites I have, look to be ok. The problem is the modules and namely the eSHOP for the one site.

    I know you said the data is stored on the publication side so I transferred all the files exactly from the old server via FTP and then tried to re-publish the site and it fails.

    Here's what it says
    "The site has been published with errors.
    Cannot connect to the database host. Click here for details"

    Here's what it says after I click for details.

    Cannot connect to the database host.
    2 Cannot find data of 'Statistics' module (id is '16p8ko6g8vn'). All module data has been lost.
    3 Cannot find data of 'eShop' module (id is '0kes7z5jfax'). All module data has been lost.
    4 Cannot create an empty database for 'Statistics' module (id is '16p8ko6g8vn').
    5 Cannot create an empty database for 'eShop' module (id is '0kes7z5jfax').
    6 The data of 'Statistics' module (id is '16p8ko6g8vn') has not been published.
    7 The data of 'eShop' module (id is '0kes7z5jfax') has not been published.
    8 The modules data have been updated with errors.

    I know all of the data is there, can you please help me restore it somehow.

    Thanks a million!!
     
  2. beauchman22

    beauchman22 Guest

    0
     
    ???? Please help????
     
  3. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    Not sure what could be wrong here. Could you please specify all details for how you migrated these sites.
    Did you make any changes for the sites after they were migrated but before you copied modules database via FTP?
    Try also check data/storage/sb_modules.php file for the site and see which databases are included there:

    from the sites directory run:

    sqlite data/storage/sb_modules.php
    sqlite> .databases
     
  4. beauchman22

    beauchman22 Guest

    0
     
    I did exactly this http://kb.odin.com/en/5512

    Then I have also moved all site files via FTP.


    Looks like there is a lot of data in the sb_modules.php file that probably pertains to the .databases file.

    .databases file is empty. How do I execute the sb_modules.php file to restore the .databases file?

    And what do you mean :

    "from the sites directory run:

    sqlite data/storage/sb_modules.php
    sqlite> .databases "

    Please be more specific.

    Thanks for you help.
     
Loading...