Results 1 to 22 of 22

Thread: Host Transfer

  1. #1
    New user
    Join Date
    10-12-09.
    Posts
    14

    Default Host Transfer

    I'm trying to move the site from one host to another -- how would I go about doing this...

    From what I gather, I can click on the back-up database link on the backend, and then press the Start SQL backup followed by Create website template.

    When I click create website template, I get the following error:
    Warning: fopen(/home/.sites/123/site46/web/system/tmp/6d651b94ef8165aafb7ae1e069f16d2b) [function.fopen]: failed to open stream: Permission denied in /home/.sites/123/site46/web/system/libraries/FTP.php on line 109
    Fatal error: Uncaught exception Exception with message Cannot create file "/tmp/Ottawa_West-Nepean_NDP_Riding_Association.sql" thrown in /home/.sites/123/site46/web/system/libraries/File.php on line 113
    #0 /home/.sites/123/site46/web/system/modules/BackupDB/MakeWsTemplateRun.php(188): File->__construct('/tmp/Ottawa_Wes...')
    #1 /home/.sites/123/site46/web/system/modules/BackupDB/MakeWsTemplateRun.php(272): BackupWsTemplate->run()
    #2 {main}

  2. #2
    User PaoloB's Avatar
    Join Date
    06-19-09.
    Location
    Italy
    Posts
    238

    Default Re: Host Transfer

    Permission denied
    Check the permission of the system/tmp/ folder
    Paolo B.
    Contao ambassador
    ContaoCms.it - Sito di riferimento per la comunità italiana

  3. #3
    New user
    Join Date
    10-12-09.
    Posts
    14

    Default Re: Host Transfer

    That's what I thought -- but I checked the permission on the file itself -- what should the permission be?

  4. #4
    New user
    Join Date
    10-12-09.
    Posts
    14

    Default Re: Host Transfer

    Nevermind -- just played around with things. Working, as of now.

    Thanks.

  5. #5
    New user
    Join Date
    10-12-09.
    Posts
    14

    Default Re: Host Transfer

    So now, the files get created, but both the .txt and .sql files are empty.

    Why is this happening?

  6. #6
    Experienced user
    Join Date
    06-10-09.
    Location
    Atlanta, Georgia
    Posts
    611

    Default Re: Host Transfer

    When I transfer TYPOlight sites from one host to another, I grab all the files via ftp and grab the database from phpMyAdmin. Then, upload all the files and import the database through phpMyAdmin. You'll probably need to update a few variables in /system/config/localconfig.php.

  7. #7
    User
    Join Date
    10-05-09.
    Location
    Dallas, TX, US
    Posts
    70

    Default Re: Host Transfer

    I do the same thing as Ben - export the DB and FTP all of the files over. I find this to be a lot quicker and less error-prone than using the BackupDB extension which requires manual re-installation of each extension (assuming you follow the directions...)

  8. #8
    New user
    Join Date
    10-12-09.
    Posts
    14

    Default Re: Host Transfer

    Thanks -- that was going to be the plan, such as when I move a forum, but wasn't sure how it would all work using what seems to be a program that has a lot of errors.

    Too bad nobody from the site actually offers help like vBulletin does.

    Thanks.

  9. #9
    Experienced user
    Join Date
    06-10-09.
    Location
    Atlanta, Georgia
    Posts
    611

    Default Re: Host Transfer

    ... using what seems to be a program that has a lot of errors.
    Craig - I think you meant to say:
    ... using what seems to be a program that has a lot of error messages when file permissions are not properly set and/or the hosting server doesn't give permission to write files.
    :D

    Regarding support: don't forget that everyone here is donating their time to provide help and that TYPOlight is not a commercial product like vBulletin.

  10. #10
    New user
    Join Date
    10-12-09.
    Posts
    14

    Default Re: Host Transfer

    No -- you're right -- the host really sucks, which is why we're leaving -- but I posted the thread five days ago and it took me a negative post for someone from TYPOlight to make a snide remark.

    All's good though -- I get that it's free, but would still be nice to have a decent response time.

  11. #11
    Experienced user
    Join Date
    08-21-09.
    Posts
    563

    Default Re: Host Transfer

    Look at the message dates/times again...

    You sent a message initially and got a response 4 hours later.

    Then you sent 3 messages on the 17th in the span of about 20 minutes. You got 2 responses with the span of a little over an hour.

    Then four days later you sent a smart-a$$ comment. Again you got a response in an hour.

    What kind of response time are you expecting?
    Brian

  12. #12
    New user
    Join Date
    10-12-09.
    Posts
    14

    Default Re: Host Transfer

    I was expecting a response from TYPOlight -- not users.

    I appreciate the comments from the users -- because they're just fans of the prodct -- but I expect that other users have run into such a problem and the creators of the product might have had a different answer.

    Nevertheless, I didn't mean to ruffle any feathers. My apologies.

  13. #13
    New user
    Join Date
    10-12-09.
    Posts
    14

    Default Re: Host Transfer

    Could anyone pleaes tell me what this means:

    Fatal error: Uncaught exception Exception with message Query error: No database selected (SELECT * FROM tl_page WHERE (id='~ownndp' OR alias='~ownndp') AND (start='' OR start<1261466696) AND (stop='' OR stop>1261466696) AND published=1) thrown in /home/ownndp/public_html/system/libraries/Database.php on line 502
    #0 /home/ownndp/public_html/index.php(93): Database_Statement->execute('~ownndp', '~ownndp', 1261466696, 1261466696)
    #1 /home/ownndp/public_html/index.php(254): Index->run()
    #2 {main}



    Thanks,
    Craig

  14. #14
    Experienced user
    Join Date
    06-10-09.
    Location
    Atlanta, Georgia
    Posts
    611

    Default Re: Host Transfer

    No database selected
    TYPOlight is not able to connect to the database.

  15. #15
    New user
    Join Date
    10-12-09.
    Posts
    14

    Default Re: Host Transfer

    Ben,
    Do you happen to know why that might be? I've changed all of the necessary settings in localconfig.php and all of the files are in PHPMyAdmin

  16. #16
    Experienced user
    Join Date
    06-10-09.
    Location
    Atlanta, Georgia
    Posts
    611

    Default Re: Host Transfer

    Double check your connection parameters. Most likely something is not correct. Also, it might be helpful if you mentioned what you did to receive the error message.

  17. #17
    New user
    Join Date
    10-12-09.
    Posts
    14

    Default Re: Host Transfer

    This is what I have in the localconfig.php file

    Code:
    <?php if (!defined('TL_ROOT')) die('You can not access this file directly!');
    
    /**
     * TYPOlight webCMS
     * Copyright (C) 2005 Leo Feyer
     *
     * This program is free software: you can redistribute it and/or
     * modify it under the terms of the GNU Lesser General Public
     * License as published by the Free Software Foundation, either
     * version 2.1 of the License, or (at your option) any later version.
     * 
     * This program is distributed in the hope that it will be useful,
     * but WITHOUT ANY WARRANTY; without even the implied warranty of
     * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
     * Lesser General Public License for more details.
     * 
     * You should have received a copy of the GNU Lesser General Public
     * License along with this program. If not, please visit the Free
     * Software Foundation website at http://www.gnu.org/licenses/.
     *
     * PHP version 5
     * @copyright  Leo Feyer 2005
     * @author     Leo Feyer <leo@typolight.org>
     * @package    Config
     * @license    LGPL
     * @filesource
     */
    
    
    ### INSTALL SCRIPT START ###
    $GLOBALS['TL_CONFIG']['installPassword'] = '********';
    $GLOBALS['TL_CONFIG']['encryptionKey'] = '********';
    $GLOBALS['TL_CONFIG']['dbDriver'] = 'MySQL';
    $GLOBALS['TL_CONFIG']['dbHost'] = 'localhost';
    $GLOBALS['TL_CONFIG']['dbUser'] = '********_********';
    $GLOBALS['TL_CONFIG']['dbPass'] = 'password goes here';
    $GLOBALS['TL_CONFIG']['dbDatabase'] = '********_********';
    $GLOBALS['TL_CONFIG']['dbPconnect'] = false;
    $GLOBALS['TL_CONFIG']['dbCharset'] = 'UTF8';
    $GLOBALS['TL_CONFIG']['dbPort'] = 3306;
    $GLOBALS['TL_CONFIG']['adminEmail'] = '********@********.com';
    $GLOBALS['TL_CONFIG']['dateFormat'] = 'm/d/y';
    $GLOBALS['TL_CONFIG']['timeFormat'] = 'g:i';
    $GLOBALS['TL_CONFIG']['datimFormat'] = 'm/d/y g:i';
    $GLOBALS['TL_CONFIG']['defaultChmod'] = 'a:6:{i:0;s:2:"u1";i:1;s:2:"u2";i:2;s:2:"u3";i:3;s:2:"u4";i:4;s:2:"u5";i:5;s:2:"u6";}';
    $GLOBALS['TL_CONFIG']['websiteTitle'] = 'Ottawa West-Nepean NDP Riding Association';
    $GLOBALS['TL_CONFIG']['timeZone'] = 'Canada/Eastern';
    $GLOBALS['TL_CONFIG']['imageWidth'] = 900;
    $GLOBALS['TL_CONFIG']['websitePath'] = '';
    $GLOBALS['TL_CONFIG']['installCount'] = 0;
    $GLOBALS['TL_CONFIG']['exampleWebsite'] = 1220683014;
    $GLOBALS['TL_CONFIG']['cron_daily'] = 20080906;
    $GLOBALS['TL_CONFIG']['useFTP'] = true;
    $GLOBALS['TL_CONFIG']['ftpHost'] = '********.ca';
    $GLOBALS['TL_CONFIG']['ftpUser'] = '********';
    $GLOBALS['TL_CONFIG']['ftpPass'] = 'password goes here';
    $GLOBALS['TL_CONFIG']['ftpPath'] = 'public_html';
    $GLOBALS['TL_CONFIG']['rewriteURL'] = true;
    $GLOBALS['TL_CONFIG']['cron_weekly'] = 200945;
    $GLOBALS['TL_CONFIG']['displayErrors'] = true;
    
    ?>
    My PHP username is ********
    My Database name is ********

    I get this error when I go to the site -- which right now doesn't have it's name servers changed, so the backdoor way of viewing the site is:
    http://gator1124.hostgator.com/~ownndp/

  18. #18
    Experienced user
    Join Date
    06-10-09.
    Location
    Atlanta, Georgia
    Posts
    611

    Default Re: Host Transfer

    I've removed all sensitive info from your posting. For starters, you should set your website root to be '/~ownndp'.

  19. #19
    New user
    Join Date
    10-12-09.
    Posts
    14

    Default Re: Host Transfer

    All of my files are located in the public_html folder. The only reason it's using ~ownndp is because I don't have my name servers forwarded yet -- not until I get this thing up and running. So the actual root is public_html, is it not?

  20. #20
    Experienced user
    Join Date
    06-10-09.
    Location
    Atlanta, Georgia
    Posts
    611

    Default Re: Host Transfer

    Please just do what I say. I know what I'm talking about. Add this line to your localconfig:
    Code:
    $GLOBALS['TL_CONFIG']['websitePath'] = '/~ownndp';
    This is necessary when you are hosted on a cPanel server and the domain name has not propagated.

  21. #21
    New user
    Join Date
    10-12-09.
    Posts
    14

    Default Re: Host Transfer

    I have no doubt you know what you're talking about -- but I didn't have a clue what the hell you were asking of me. I posted in the newbie forum, because I don't have a clue what I'm doing when it comes to this stuff.


    Fatal error: Uncaught exception Exception with message Query error: No database selected (SELECT id FROM tl_page WHERE type='root' AND (dns='gator1124.hostgator.com' OR dns='www.gator1124.hostgator.com') AND language='en' AND (start='' OR start<1261509030) AND (stop='' OR stop>1261509030) AND published=1 LIMIT 0,1) thrown in /home/ownndp/public_html/system/libraries/Database.php on line 502
    #0 /home/ownndp/public_html/system/modules/frontend/Frontend.php(130): Database_Statement->execute('root', 'gator1124.hostg...', 'www.gator1124.h...', 'en', 1261509030, 1261509030)
    #1 /home/ownndp/public_html/index.php(86): Frontend->getRootIdFromUrl()
    #2 /home/ownndp/public_html/index.php(254): Index->run()
    #3 {main}

  22. #22
    Experienced user
    Join Date
    06-10-09.
    Location
    Atlanta, Georgia
    Posts
    611

    Default Re: Host Transfer

    Three things:
    1. I still don't think the database connection string works, since the error says "No database selected". I would create a new database, save a copy of your current localconfig, and upload the original / blank localconfig. Then, go through the install script and see if it can populate the demo website into the new database. Actually, I think you only need to go into the install script as everything currently is to see if it can connect to the database.
    2. Hostgator is not a good hosting company, in my opinion. I have many clients on Site5 where TYPOlight runs perfectly even before domain propagation.
    3. I think these issues may self-resolve once the domain name propagates.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •