Joomla what what you do?

[tf76]

This is the line above the start of it:

(153073, '/index.php?option=com_content&view=article&id=59&Itemid=71&cal_offset=935p', 'Sponsors');


Regards,

 

[nlinecomputers]

Make a copy of it then remove it. As long as you have original copies what can it hurt? It either works or not.

 

[tf76]

In the configuration.php there are 2 var passwords?

//var $password = 'blahblah';
var $password = 'blahblah';


Regards,

 

[tf76]

I'm so ****** off with this Joomla CMS right now.

Spent hours trying to edit the configuration.php file.
Creating new databases/importing/dropping tables blah blah.

If I have this much trouble trying to transfer the site localy. How in the 355389 am I going to get it going on the hostgator server?

It just won't work.


Regards,

 

[tf76]

Can anyone share with me their configuration.php file for a localhost installation?

Regards,

 

[JustInspired]

This is not specific to Joomla but what I have done in the past is keep the whole thing domain specific by creating an entry in my hosts file that points that domain name to the local machine. Works perfectly.

 

[tf76]

Ok, thanks to another member here, he has alerted me to jos_session repair.

The problem is when I import the database there is no jos_session in the database?

 

[tf76]

OK, this is where I'm at with the localhost.

Didn't realise bu the apache service was not running when I had easyPHP running?

On further investigation it was not started and was trying to run from xampp?
The problem is that xampp was uninstalled.

So removed the service, removed easyPHP and gave xampp another go.
After installing and restarting xampp worked Mysql and Apache service started

So back to configuring the joomla site with xampp.
Again after editing configuration.php.

NOT WORKING. This is driving me crazy


Regards,

 

[LifelineIT]

Edit 2 because the first one didn't stick. I see from a reread that you're attempting to host this locally. There's no reason at all to do this. Save yourself hours of frustration and buy a ~$50/year hosting package. You can't possibly take care of security/backups/updates/redundant power/reboots on a public-facing webserver and run your business at the same time. I sandbox all my development in a subdomain, and when it's finished, I just change the DNS of the actual URL to point to the subdomain and prop a last second configuration.php edit.

I'm fairly certain you've made this waaaaaaaaaaaaaay harder than it has to be. I've done probably 50 Joomla site moves and never had any real issues. There are even programs like X-Cloner that will do it for you automagically.

The easiest way to move a Joomla site is as follows:

1. Make note of exact db name / username and passwords of existing site including admin user.
2. Recreate that db and username with the original password on the new site.
3. Fresh install Joomla into the new site / db / username and set admin pass to what it was before, OR use cPanel to zip and export the entire existing site, up the archive to your new server location and then use something like cPanel to extract and delete the archive. This is about 50x faster than ftp down/up the files.
4. Using something like phpMyAdmin, export the jos_ table from your original db, it should be whatever .sql or .sql.tar.gz
5. Using something like phpMyAdmin, import that table into the new db.
6. If using a fresh install, move over your configuration.php and possibly your .htaccess if using SEF. If the domain has changed (www.your-website.com becomes www.yourwebsite.com, for exampe), modify the configuration.php file to reflect the change.


That's it. Again, X-Cloner will do this for you for free, but I often have to manually edit the configuration.php file after using xcloner. If you are having additional issues, they are your issues and not Joomla's---for example wonky php.conf settings.

 

[nlinecomputers]

Edit 2 because the first one didn't stick. I see from a reread that you're attempting to host this locally. There's no reason at all to do this. Save yourself hours of frustration and buy a ~$50/year hosting package. You can't possibly take care of security/backups/updates/redundant power/reboots on a public-facing webserver and run your business at the same time. I sandbox all my development in a subdomain, and when it's finished, I just change the DNS of the actual URL to point to the subdomain and prop a last second configuration.php edit.

I'm fairly certain you've made this waaaaaaaaaaaaaay harder than it has to be. I've done probably 50 Joomla site moves and never had any real issues. There are even programs like X-Cloner that will do it for you automagically.

The easiest way to move a Joomla site is as follows:

1. Make note of exact db name / username and passwords of existing site including admin user.
2. Recreate that db and username with the original password on the new site.
3. Fresh install Joomla into the new site / db / username and set admin pass to what it was before, OR use cPanel to zip and export the entire existing site, up the archive to your new server location and then use something like cPanel to extract and delete the archive. This is about 50x faster than ftp down/up the files.
4. Using something like phpMyAdmin, export the jos_ table from your original db, it should be whatever .sql or .sql.tar.gz
5. Using something like phpMyAdmin, import that table into the new db.
6. If using a fresh install, move over your configuration.php and possibly your .htaccess if using SEF. If the domain has changed (www.your-website.com becomes www.yourwebsite.com, for exampe), modify the configuration.php file to reflect the change.


That's it. Again, X-Cloner will do this for you for free, but I often have to manually edit the configuration.php file after using xcloner. If you are having additional issues, they are your issues and not Joomla's---for example wonky php.conf settings.

I'm with him. At this point I would work on getting a blank new install of Joomla running on this system. You need to understand how to do that before you try and Frankenstein an existing install on your box. I suspect your setup isn't going to run ANY Joomla.

 

[tf76]

Guys I appreciate your replies.

I'm going to clear a few things up.

OK, I am not going to be hosting this site off of my PC.
I am trying to test it out on my PC before it goes on hostgator.

I have no access to the current sites backend.
I only have what the existing developer has given me which is a backup of the site that he has taken. This includes a sql dump.

I am concerned that when the transfer of the domain goes to hostgator that it won't work. Because I can't get it to work on localhost using Xampp.

I have almost come to the conclusion that his backup is corrupt.
Especially the sql database file. There is no jos_session table in it?
I have created this table by inserting some code into the sql section of phpmyadmin.

I will however attempt to try a joomla install on localhost with the same version.


Regards,

 

[LifelineIT]

Ok, that's all fine. There's no reason to suspect the backup is bad.

Your hostgator account, is it explicitly for the new domain, or do you have other sites hosted there as well?

I'm happy to help you work on it, I'm slow today---if you have msn/aol/gchat.

 

[tf76]

OK, some success.

So I added a new joomla install into the site directory.

Allowed me to install joomla and upload template through admin.

But the sql database is not working. There is no content on the pages and only 1 menu link.

Regards,

 

[LifelineIT]

I added you on skype, I know you're on the opposite side of the world.

I'm going to guess that your prefix is messed up or that the name of the db in either the config or the sql server is incorrect.

You installed 1.5, right? Not something else?

If you move over all the files and import the sql, there's no need to manually install the template.

 

[tf76]

Hey guys. With the help of another technibbler he told me that the databse is too big to import into localhost phpmyadmin. It's 35mb.

So now I'm trying to work out how to increase the size so it will accept it.
I have already increasing the size via php.ini. I think the max is 8mb.

I have incresed the size of the upload and it's still not working:
jtablesession::Store Failed
DB function failed with error number 1146
Table 'mvrail.jos_session' doesn't exist SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'feketbrafl84kq9j98g86c1ve5','1369891262','','0','1','0' )

Same as the site on hostgator.

Thank you to all who have helped me on this exhaustive journey.



Regards,

 

[LifelineIT]

Here's the script I was talking about to manually import a large sql file. I have used it successfully before.

Again, you can open a ticket at hostgator and ask them to insert the sql for you as well.

I'm fairly certain your errors are coming from the fact that it's getting part of the file imported before timing out.

 

[tf76]

Well guys the problem was that the mysql database was not exported correctly.

The guy got another backup and now it works

A big thank you to everyone who assisted me on this.



Regards,