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}

Quote:

---

Permission denied

---

Check the permission of the system/tmp/ folder

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

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

Thanks.

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

Why is this happening?

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.

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...)

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.

Quote:

---

... using what seems to be a program that has a lot of errors.

---

Craig - I think you meant to say:

Quote:

---

... 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.

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.

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?

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.

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

Quote:

---

No database selected

---

TYPOlight is not able to connect to the database.

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

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.

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/

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

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?

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.

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}

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.