Support

When I am trying to do DB Restore using kickstart, I got these errors:

Error at the line 291: CREATE TABLE `akb_jp_exclusion` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `profile` int(10) unsigned NOT NULL, `class` varchar(255) NOT NULL, `value` longtext NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Query:CREATE TABLE `akb_jp_exclusion` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `profile` int(10) unsigned NOT NULL, `class` varchar(255) NOT NULL, `value` longtext NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8

MySQL: MySQL query failed with error 1005 (Can't create table 'xyz.jos_jp_exclusion' (errno: 121)). The query was:CREATE TABLE `jos_jp_exclusion` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `profile` int(10) unsigned NOT NULL, `class` varchar(255) NOT NULL, `value` longtext NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8


Can someone please help me. Thanks.

What did you use to do the backup, JoomlaPack or Akeeba? What table prefix are you using?

The first two sections of the error message show the table name as akb_jp_exclusion, the last section shows it as jos_jp_exclusion. I Googled the error message, most of the possibilities involve the INNODB engine. Several of the hits involve duplicate foreign keys. That's a JoomlaPack table, there are no foreign keys.

I am using joomlapack. I got rid of the error by unchecking "Suppress Foreign Key checks while restoring" in fine-tuning tab under DB restore. Everything went fine in restoring database and website files onto my localhost. I have one more problem that after the restore of my site onto the localhost, when I browse to it, it is pointing to the hosting URL from where I backedup my site. Is there any setting that I need to make changes for to avoid it?

The two most common reasons for this are the $live_site variable in the configuration.php file and a redirection in the .htaccess file. :)

I checked the $live_site variable. It's blank but even when I put localhost as value in it, it doesn't work. Also, I am not sure where exactly I need to change the setting to point to my new domain because, I searched in the file for my old domain name and couldn't find any. Can you point me exactly where is that?

Rename your .htaccess file in the root of the site. This is a diagnostic step, not a solution. You may get 404 errors as a result of this, that's OK, we're trying to pinpoint what is redirecting the site to the old address.

I renamed .htaccess and still it does the same. It is still redirecting to the old URL.

OK, what are you seeing? What tells you that it is redirecting to the old url?

whenever I opens my http://localhost/test/index.php it redirects to http://www.xyz.com/test/index.php and shows me 404 - component not found page where test is the folder on my localhost where I copied my site to and xyz.com is the site from where I backedup my site. However, if I open http://localhost/administrator/index.php, it opens fine and I can see the joomla backend of my site.

That is strange. Are you using VirtueMart on this site? VirtueMart could do this under some circumstances.

No I am not using VirtueMart

OK, I give up. Time to call in the big guns! :(

I don't have any SEF component installed on my system. Can you point me where exactly is that? thanks.

There are many possible SEF components, sh404SEF, AceSEF, etc. These are all third party components, so you would have to install them on your site, it isn't something that you would just activate. The built in SEF wouldn't redirect like this.

Check your menu entries t make sure that the original site's url is not included in the menu entry.

I am not sure what do you mean by menu entries. what are they?

The actual menu entries on your site. They can contain a url. I did that once on one of my sites and it led me merry chase figuring out why I was still working on the live site from my local server. :D Check the "Home" entry, it may be directing to the url of the old site.

I checked the Home entry and the link value is this: "index.php?option=com_content&view=frontpage" . Is that what you are talking about? I checked some others also and they have link values as "index.php?option=com_content&view=article&id=1" and so on. I am going into individual menu items and looking under by clicking on them.

Finally, i figured out what is causing the problem by doing the way like you said. I disabled one plugin at a time to see what is redirecting and saw there is a plugin called system-canonicalization which is doing that. I changed the site name there to localhost which now works. Thanks for all your help.