Joomla what what you do?

tf76

Active Member
Reaction score
133
Location
South Australia
I have a Joomla 1.5 template that is the current site for a non for profit job I am doing.

I need to move this to another web host. The current developer is moving on.


Should I:

1. Try and install Joomla 1.5 manually to work with the template.

2. Install the latest Joomla 3.1 I think and start the site again with a new Joomla 3 template

I am aware that the title is not proper grammar :)

Regards,
 
I would copy the files and dump the SQL and move it that way. Change the config and then you have the site functioning exactly the same way.
 
Changing it to Joomla 3 is going to be a rewrite of the site is it not? Are you being PAID to UPGRADE the site or are you simply been hired to move it to a new host?

Don't work for free dude. Changing it to 3 is gonna take several man hours of making a new theme work and look good for the site owner. I would not do that unless the client is requesting look or feature changes. You go changing things without the client's input and you'll just anger them and lose a client.
 
Thanks for your input guys.

The other developer has copied the site and mysql dump for me.

I'm just trying to install it locally first using easyphp.

It's not going well.

localhost is coming up with this

jtablesession::Store Failed
DB function failed with error number 1146

I've copied the site into the right directory.
I've imported the mysql datable into phpmyadmin.
I've also edited the configuration.php

Regards,
 
Thanks guys.

Let me explain this further.

I'm not doing the on site change just as yet. Still waiting for the EPP codes for the domains to transfer.

What I'm doing is trying to get the localhost on my computer working using easyPHP. I just copied over the joomla directory and imported the mysql dump. The site and template supports Joomla 1.5.

In my configuration.php it is set to 'jos_'. That is not the problem





Regards,
 
Thanks guys.

Let me explain this further.

I'm not doing the on site change just as yet. Still waiting for the EPP codes for the domains to transfer.

What I'm doing is trying to get the localhost on my computer working using easyPHP. I just copied over the joomla directory and imported the mysql dump. The site and template supports Joomla 1.5.

In my configuration.php it is set to 'jos_'. That is not the problem

Regards,

Have you tried asking in the joomla forums? I think you will reach more knowledgeable users of joomla there.

coffee
 
Thanks again everyone for your input it is appreciated.

And I thought this would be relatively easy?

I have a new acronym for CMS.


Regards,
 
If it was easy your client would do it himself and you wouldnt get paid :)

Having the right tools though and a little help from the joomla forums and you should be fine.

coffee
 
I haven't got access to the server it is currently running on.

The guy has created a backup for me as well as the mysql dump.

Not sure if he's done the sql dump correctly?

When I import it it says this
Error
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> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link rel="icon" href="./favicon.ico" type="image/x-icon" /> <link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" /> <title>phpMyAdmin</title> <link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?server=1&amp;token=7a88f2f3f56b1d30447f945338c31a87&amp;js_frame=right&amp;nocache=5406696958" /> <link rel="stylesheet" type="text/css" href="print.css" media="print" /> <link rel="stylesheet" type="text/css" href="./themes/pmahomme/jquery/jquery-ui-1.8.custom.css" /> <meta name="robots" content="noindex,nofollow" /> <script src="./js/cross_framing_protection.js?ts=1344778698" type="text/javascript"></script> <script src="./js/jquery/jquery-1.4.4.js?ts=1344778[...]

MySQL said:

#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


I'm not happy :(

I've checked the slq file and it does contain html code in it?

Not sure where to go from here.

Would this error be the reason it's not working correctly?

Regards,
 
-- phpMyAdmin SQL Dump
-- version 3.4.11.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 17, 2013 at 05:54 AM
-- Server version: 5.5.31
-- PHP Version: 5.2.17

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

The size of it is nearly 35MB?


Regards,

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
 
Yes.

I deleted the </body> and </html> at the bottom of the sql file?

Found it.

Near the bottom.

<!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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?server=1&amp;token=7a88f2f3f56b1d30447f945338c31a87&amp;js_frame=right&amp;nocache=5406696958" />
<link rel="stylesheet" type="text/css" href="print.css" media="print" />
<link rel="stylesheet" type="text/css" href="./themes/pmahomme/jquery/jquery-ui-1.8.custom.css" />
<meta name="robots" content="noindex,nofollow" />
<script src="./js/cross_framing_protection.js?ts=1344778698" type="text/javascript"></script>
<script src="./js/jquery/jquery-1.4.4.js?ts=1344778698" type="text/javascript"></script>
<script src="./js/update-location.js?ts=1344778698" type="text/javascript"></script>
<script src="./js/config.js?ts=1344778698" type="text/javascript"></script>
<script src="./js/functions.js?ts=1344778698" type="text/javascript"></script>
<script src="./js/jquery/jquery.qtip-1.0.0.min.js?ts=1344778698" type="text/javascript"></script>
<script src="./js/messages.php?lang=en&amp;db=rawling4_mvrail&amp;token=7a88f2f3f56b1d30447f945338c31a87" type="text/javascript"></script>
<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 = 'box596.bluehost.com / localhost / rawling4_mvrail / jos_jstats_page_request_c | phpMyAdmin 3.4.11.1';
}

// ]]>
</script>
<meta name="OBGZip" content="true" />
<!--[if IE 6]>
<style type="text/css">
/* <![CDATA[ */
html {
overflow-y: scroll;
}
/* ]]> */
</style>
<![endif]-->
</head>

<body>
<div id="prefs_autoload" class="notice" style="display:none">
<form action="prefs_manage.php" method="post">
<input type="hidden" name="token" value="7a88f2f3f56b1d30447f945338c31a87" />
<input type="hidden" name="json" value="" />
<input type="hidden" name="submit_import" value="1" />
<input type="hidden" name="return_url" value="export.php?" />
Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session? <br />
<a href="#yes">Yes</a> / <a href="#no">No</a>
</form>
</div>
<div id="serverinfo">
<a href="main.php?token=7a88f2f3f56b1d30447f945338c31a87" class="item"> <img class="icon" src="./themes/pmahomme/img/s_host.png" width="16" height="16" alt="" />
localhost</a>
<span class="separator"><img class="icon" src="./themes/pmahomme/img/item_ltr.png" width="5" height="9" alt="-" /></span>
<a href="db_structure.php?db=rawling4_mvrail&amp;token=7a88f2f3f56b1d30447f945338c31a87" class="item"> <img class="icon" src="./themes/pmahomme/img/s_db.png" width="16" height="16" alt="" />
rawling4_mvrail</a>
<span class="separator"><img class="icon" src="./themes/pmahomme/img/item_ltr.png" width="5" height="9" alt="-" /></span>
<a href="sql.php?db=rawling4_mvrail&amp;table=jos_jstats_page_request_c&amp;token=7a88f2f3f56b1d30447f945338c31a87" class="item"> <img class="icon" src="./themes/pmahomme/img/s_tbl.png" width="16" height="16" alt="" />
jos_jstats_page_request_c</a>
</div>
<!-- PMA-SQL-ERROR -->
<div class="error"><h1>Error</h1>
<p><strong>SQL query:</strong>
<a href="tbl_sql.php?sql_query=SHOW+TABLE+STATUS+FROM+%60rawling4_mvrail%60+LIKE+%27jos_jstats_page_request_c%27&amp;show_query=1&amp;db=rawling4_mvrail&amp;table=jos_jstats_page_request_c&amp;token=7a88f2f3f56b1d30447f945338c31a87"><span class="nowrap"><img src="./themes/pmahomme/img/b_edit.png" title="Edit" alt="Edit" class="icon" width="16" height="16" /> Edit</span></a> </p>
<p>
<span class="syntax"><span class="inner_sql"><a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Fshow.html&amp;token=7a88f2f3f56b1d30447f945338c31a87" target="mysql_doc"><span class="syntax_alpha syntax_alpha_reservedWord">SHOW</span></a> <span class="syntax_alpha syntax_alpha_reservedWord">TABLE</span> <span class="syntax_alpha syntax_alpha_reservedWord">STATUS</span> <span class="syntax_alpha syntax_alpha_reservedWord">FROM</span> <span class="syntax_quote syntax_quote_backtick">`rawling4_mvrail`</span> <span class="syntax_alpha syntax_alpha_reservedWord">LIKE</span> <span class="syntax_quote syntax_quote_single">'jos_jstats_page_request_c'</span></span></span>
</p>
<p>
<strong>MySQL said: </strong><a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Ferror-messages-server.html&amp;token=7a88f2f3f56b1d30447f945338c31a87" target="mysql_doc"><img class="icon" src="./themes/pmahomme/img/b_help.png" width="11" height="11" alt="Documentation" title="Documentation" /></a>
</p>
<code>
#2006 - MySQL server has gone away
</code><br />
</div><script type="text/javascript">
//<![CDATA[
$(document).ready(function(){
// updates current settings
if (window.parent.setAll) {
window.parent.setAll('en', 'utf8_general_ci', '1', 'rawling4_mvrail', 'jos_jstats_page_request_c', '7a88f2f3f56b1d30447f945338c31a87');
}
// set current db, table and sql query in the querywindow
if (window.parent.reload_querywindow) {
window.parent.reload_querywindow(
'rawling4_mvrail',
'jos_jstats_page_request_c',
'');
}

if (window.parent.frame_content) {
// reset content frame name, as querywindow needs to set a unique name
// before submitting form data, and navigation frame needs the original name
if (typeof(window.parent.frame_content.name) != 'undefined'
&& window.parent.frame_content.name != 'frame_content') {
window.parent.frame_content.name = 'frame_content';
}
if (typeof(window.parent.frame_content.id) != 'undefined'
&& window.parent.frame_content.id != 'frame_content') {
window.parent.frame_content.id = 'frame_content';
}
//window.parent.frame_content.setAttribute('name', 'frame_content');
//window.parent.frame_content.setAttribute('id', 'frame_content');
}
});

//]]>
</script>


Do I just delete it?

I wonder if this guy knew what he was doing?

Regards,
 
Last edited:
Yes.

I deleted the </body> and </html> at the bottom of the sql file?


Regards,

???? There shouldn't be any html commands in a SQL file. With the exception of HTML commands that might be stored in a comment. Your query puked on line one and what is displayed doesn't match your snip.
 
Back
Top