The Joomla! Forum ™



Forum rules


Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.



Post new topic Reply to topic  [ 10 posts ] 
Author Message
PostPosted: Sun Mar 11, 2007 2:18 am 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Wed Aug 24, 2005 11:38 am
Posts: 915
Location: North Carolina
I'm going to sticky the topic http://forum.joomla.org/index.php/topic,149110.0.html so if you would like to discuss the tutorial, please do it here.  If I have made any errors, please let me know.  If you know shortcuts, post them here.
Thanks
Montaon

_________________
Joomla! website design, custom template design and template modification
www.montanodesigns.com


Top
 Profile  
 
PostPosted: Fri Apr 13, 2007 5:38 pm 
User avatar
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Fri Apr 07, 2006 1:42 pm
Posts: 7
Location: UK
This is very helpful to me, as I want to give Media Temple a trial run, before moving everything their way.

As I know you have Joomla and GS Media Temple, I was wondering if you have noticed that the permissions on the configuration.php are 'writable' even when I've set them using FTP to 644.

Also, I get thrown out... back to the login screen after certain tasks. I can edit content sometimes, other times it won't and just logs me out.

using v1.0.12 on Media Temple GS

_________________
Near enough is good enough, if no-one knows what you're doin'


Top
 Profile  
 
PostPosted: Fri Apr 13, 2007 6:55 pm 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Wed Aug 24, 2005 11:38 am
Posts: 915
Location: North Carolina
Hi,
I don't want to make a wall of shame or disparage any web host, but I'll tell you I've just moved away from MT. For whatever reason...maybe it was the box I was on,  I couldn't stay connected to the database.
I'm glad you could use the tutorial.
Regards,
Montano

_________________
Joomla! website design, custom template design and template modification
www.montanodesigns.com


Top
 Profile  
 
PostPosted: Sat May 12, 2007 2:59 am 
Joomla! Explorer
Joomla! Explorer
Offline

Joined: Thu Jul 27, 2006 10:27 am
Posts: 251
Thanks montano for your tutorial!

I have tried and it works partially!

Here is what I have done:
*******************************
    *  Assume:

  1. Joomla: Joomla_1.0.12-Full_Package(Chinese-Beta1).tar.gz
  2. addons: VirtueMart_1.0.10-COMPLETE_PACKAGE.zip
  3. addons: G2 bridge v2.0.14beta (com_gallery2_v2.0.14_beta.zip & com_joomlalib_1_3_1.zip) + update patch
  4. 3rd party application: Gallery2 v2.2.1 (gallery-2.2.1-full.tar.gz)


    * Suppose your site is originally hosted here:

        * program directory: /home/mysite01/public_html/mac
        * database name: mysite01_mac [Note: Don't forget to record down dbase user name and password]

        -> Here you back up the program directory and database

    * and will be moved to another hosting company with:

        * program directory: /home/mysite02/public_html/mac
        * database name: mysite02_mac

        -> Here you re-store the program directory and database

    * the 3rd step: Update the configuration file "configuration.php" to reflect new settings as follows:

line06: $mosConfig_absolute_path = '/home/mysite02/public_html/mac';
line10: $mosConfig_cachepath = '/home/mysite02/public_html/mac/cache';
line13: $mosConfig_db = 'mysite02_mac';      // i.e. dbase name
line69: $mosConfig_user = 'mysite02_mac';    // i.e. dbase user name

//*** If domain name also changed to http://mysite02.com , you need to change also:
line29: $mosConfig_helpurl = 'http://www.mysite02.com';
line44: $mosConfig_live_site = 'http://www.mysite02.com/mac';
line47: $mosConfig_mailfrom = 'admin@mysite02.com';

    * Step4: check all the Joomla addons if server path or URL needs to be updated:

        * e.g. Virtuemart's settings:
        * In Joomla Admin backend,
        * go "components" -> "Virtuemart"
        * then go "admin" -> "configuration" -> "Path & URL"

        -> update the "SECUREURL" to: http://www.mysite02.com/mac/
        -> then click the "Downloads" tab
        -> update the "DOWNLOADROOT" to: /home/mysite02/public_html/mac/

*************************************************

all the above works, until I start updating G2 bridge to make it works in the new site, "mysite02"!
-> I tried to edit manually or using the wizard of G2 bridge to update the G2 server path and URL, both get it correctly:
    Gallery 2 Path: /home/mysite02/public_html/macg2/embed.php
      Gallery 2 Url: http://www.mysite02.com/macg2/

-> what I get is just a "blank page" when I click on the new links I created to link the G2 bridge component!

-> I have checked that the standalone Gallery2 is working!


Any ideas what's wrong?
Do you think re-installing Joomla will solve the problem?


Thanks for any kind of help!

Rgds,

_________________
JMY(晉明夷)
http://mfYoga.org -- Mindfulness Yoga Association 靜觀瑜伽協會 |瑜伽班 |瑜伽課程 |靜坐班
http://YogaJM.com -- JinMing Yoga 晉明瑜伽 |瑜伽班 |瑜伽課程 |靜坐班


Top
 Profile  
 
PostPosted: Thu May 24, 2007 4:43 pm 
User avatar
Joomla! Explorer
Joomla! Explorer
Offline

Joined: Thu Sep 07, 2006 5:46 pm
Posts: 369
Hello,

I am changing a site's URL from a temp to the permanent eg. http://www.mysiteTEMP.com to http://www.mysite.com

The VIRTUEMART settings is very imporant to me and I have stuffed it up before

Do you change the SECURESITEURL that is currently http://mysiteTEMP.com before I move/change URL in configuration.php or after?

_________________
"... Yesterday is History, Tomorrow is a Mystery, Today is a gift, that's why we call it Present"
http://www.sapromo.com
http://www.southafricanshop.com


Top
 Profile  
 
PostPosted: Mon Jul 02, 2007 9:35 pm 
Joomla! Fledgling
Joomla! Fledgling
Offline

Joined: Mon Jul 02, 2007 9:27 pm
Posts: 3
I have been following these instructions for the last week. I have gotten to the point where I would perform the Configuration.php edit. This step is vague and may be missing something.

Can we do this any other way?

Can we get more detail on these final steps?

I am very afraid that I will have to scrap my existing site only to have to rebuild it AGAIN. 

Please help.  :'(


Top
 Profile  
 
PostPosted: Tue Jul 03, 2007 10:31 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Tue Mar 20, 2007 11:13 pm
Posts: 39
cnl1 wrote:
I have gotten to the point where I would perform the Configuration.php edit. This step is vague and may be missing something.

I'm in the same boat as you, except I can't even do the db import because I did a complete (default) install of Joomla on the new host and now need to delete the default db.

For your situation, why are you worried about losing your site on this step?  If the configuration.php file on the new site isn't correct, the site will just fail to load, right?  Your original site should be untouched.  Hopefully when you review the file you'll see clear references to the old host name/site and these are all that need to be changed.  If there was any vagueness, I think that's only because the author didn't bother to give a series of examples.


Top
 Profile  
 
PostPosted: Tue Jul 03, 2007 10:55 pm 
User avatar
Joomla! Guru
Joomla! Guru
Offline

Joined: Wed Aug 24, 2005 11:38 am
Posts: 915
Location: North Carolina
Simply create a new empty database and import your .sql file dump into that database.  Update your configuration.php file with the correct username, dbname, hostname, password for db and that should do the trick.

_________________
Joomla! website design, custom template design and template modification
www.montanodesigns.com


Top
 Profile  
 
PostPosted: Thu Jul 05, 2007 4:44 pm 
Joomla! Apprentice
Joomla! Apprentice
Offline

Joined: Tue Mar 20, 2007 11:13 pm
Posts: 39
unfortunately, I've got other add-in modules (both Joomla and phpBB) that are programmed with the db name.  So hopefully there's a simple way to delete the existing unnecessary db?

Also, reading between the lines of the "FAQ", does this mean that Joomla can be -- should be? -- installed on a new site without using the install script?  I'd assumed that I should start by doing a new install, to make sure that the install script was 'satisfied'.  Apparently, I should also have done this with a temp db name!  Can the FAQ be updated with this suggestion?


Top
 Profile  
 
PostPosted: Sat Oct 18, 2008 7:30 pm 
Joomla! Fledgling
Joomla! Fledgling
Offline

Joined: Sat Oct 18, 2008 7:12 pm
Posts: 1
Can you help? I am fine with exporting my db and files to the remote, but I get an error message when I try to import the db. I am a novice at working with sql. The error reads as follows;
Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 274
STR: />
SQL: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=7a9b165a445718431a515da85afae9fe&amp;js_frame=right&amp;nocache=3630605815" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<script type="text/javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = 'localhost / localhost / / general_log | phpMyAdmin 2.11.7';<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
[b]<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=7a9b165a445718431a515da85afae9fe&amp;js_frame=right&amp;nocache=3630605815" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<script type="text/javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = 'localhost / localhost / / general_log | phpMyAdmin 2.11.7';<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=7a9b165a445718431a515da85afae9fe&amp;js_frame=right&amp;nocache=3630605815" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<script type="text/javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = 'localhost / localhost / / general_log | phpMyAdmin 2.11.7';<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=7a9b165a445718431a515da85afae9fe&amp;js_frame=right&amp;nocache=3630605815" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<script type="text/javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = 'localhost / localhost / / general_log | phpMyAdmin 2.11.7';<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=7a9b165a445718431a515da85afae9fe&amp;js_frame=right&amp;nocache=3630605815" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<script type="text/javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = 'localhost / localhost / / general_log | phpMyAdmin 2.11.7';<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=7a9b165a445718431a515da85afae9fe&amp;js_frame=right&amp;nocache=3630605815" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<script type="text/javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = 'localhost / localhost / / general_log | phpMyAdmin 2.11.7';<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=7a9b165a445718431a515da85afae9fe&amp;js_frame=right&amp;nocache=3630605815" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<script type="text/javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = 'localhost / localhost / / general_log | phpMyAdmin 2.11.7';<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=7a9b165a445718431a515da85afae9fe&amp;js_frame=right&amp;nocache=3630605815" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<script type="text/javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = 'localhost / localhost / / general_log | phpMyAdmin 2.11.7';<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=7a9b165a445718431a515da85afae9fe&amp;js_frame=right&amp;nocache=3630605815" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<script type="text/javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = 'localhost / localhost / / general_log | phpMyAdmin 2.11.7';<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=7a9b165a445718431a515da85afae9fe&amp;js_frame=right&amp;nocache=3630605815" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<script type="text/javascript">
// <![CDATA[
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = 'localhost / localhost / / general_log | phpMyAdmin 2.11.7';


SQL query:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr"> <head> <link rel="icon" href="./favicon.ico" type="image/x-icon" /> <link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" /> <title>phpMyAdmin</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?token=7a9b165a445718431a515da85afae9fe&amp;js_frame=right&amp;nocache=3630605815" /> <link rel="stylesheet" type="text/css" href="print.css" media="print" /> <script type="text/javascript"> // <![CDATA[ // Updates the title of the frameset if possible (ns4 does not allow this) if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown' && typeof(parent.document.title) == 'string') { parent.document.title = 'localhost / localhost / / general_log | phpMyAdmin 2.11.7';

MySQL said: Documentation
#1064 - 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 '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w' at line 1


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 10 posts ] 



Who is online

Users browsing this forum: No registered users and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group