Support

UNiTE, Remote CLI, eXtract Wizard

#3619 – Error during database restore using kickstart

Posted in ‘UNiTE, Remote CLI, eXtract Wizard’
This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Monday, 01 March 2010 09:05 CST
user8389
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.
Monday, 01 March 2010 15:37 CST
dlb
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.


Dale L. Brackin
Support Specialist


us.gifEnglish: native


Please keep in mind my timezone and cultural differences when reading my replies. Thank you!


????
My time zone is EST (UTC -5) (click here to see my current time in Philadelphia, PA)

Tuesday, 02 March 2010 03:59 CST
user8389
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?
Tuesday, 02 March 2010 06:57 CST
dlb
The two most common reasons for this are the $live_site variable in the configuration.php file and a redirection in the .htaccess file. :)


Dale L. Brackin
Support Specialist


us.gifEnglish: native


Please keep in mind my timezone and cultural differences when reading my replies. Thank you!


????
My time zone is EST (UTC -5) (click here to see my current time in Philadelphia, PA)

Tuesday, 02 March 2010 12:10 CST
user8389
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?
Wednesday, 03 March 2010 02:38 CST
dlb
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.


Dale L. Brackin
Support Specialist


us.gifEnglish: native


Please keep in mind my timezone and cultural differences when reading my replies. Thank you!


????
My time zone is EST (UTC -5) (click here to see my current time in Philadelphia, PA)

Wednesday, 03 March 2010 04:02 CST
user8389
I renamed .htaccess and still it does the same. It is still redirecting to the old URL.
Wednesday, 03 March 2010 05:16 CST
dlb
OK, what are you seeing? What tells you that it is redirecting to the old url?


Dale L. Brackin
Support Specialist


us.gifEnglish: native


Please keep in mind my timezone and cultural differences when reading my replies. Thank you!


????
My time zone is EST (UTC -5) (click here to see my current time in Philadelphia, PA)

Wednesday, 03 March 2010 05:26 CST
user8389
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.
Wednesday, 03 March 2010 08:49 CST
dlb
That is strange. Are you using VirtueMart on this site? VirtueMart could do this under some circumstances.


Dale L. Brackin
Support Specialist


us.gifEnglish: native


Please keep in mind my timezone and cultural differences when reading my replies. Thank you!


????
My time zone is EST (UTC -5) (click here to see my current time in Philadelphia, PA)

Wednesday, 03 March 2010 08:53 CST
user8389
No I am not using VirtueMart
Wednesday, 03 March 2010 09:16 CST
dlb
OK, I give up. Time to call in the big guns! :(


Dale L. Brackin
Support Specialist


us.gifEnglish: native


Please keep in mind my timezone and cultural differences when reading my replies. Thank you!


????
My time zone is EST (UTC -5) (click here to see my current time in Philadelphia, PA)

Wednesday, 03 March 2010 23:31 CST
nicholas
The redirection comes from three possible sources:
- $live_site in your configuration.php
- a manual redirection in .htaccess
- a SEF component which has a parameter for the site URL
Since you have eliminated the other two, I'd suggest looking into the third potential cause.


Nicholas K. Dionysopoulos

Lead Developer and Director



🇬🇷Greek: native

🇬🇧English: excellent

🇫🇷French: basic



Please keep in mind my timezone and cultural differences when reading my replies. Thank you!



Thursday, 04 March 2010 03:08 CST
user8389
I don't have any SEF component installed on my system. Can you point me where exactly is that? thanks.
Thursday, 04 March 2010 04:21 CST
dlb
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.


Dale L. Brackin
Support Specialist


us.gifEnglish: native


Please keep in mind my timezone and cultural differences when reading my replies. Thank you!


????
My time zone is EST (UTC -5) (click here to see my current time in Philadelphia, PA)

Thursday, 04 March 2010 04:34 CST
user8389
I am not sure what do you mean by menu entries. what are they?
Thursday, 04 March 2010 04:43 CST
dlb
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.


Dale L. Brackin
Support Specialist


us.gifEnglish: native


Please keep in mind my timezone and cultural differences when reading my replies. Thank you!


????
My time zone is EST (UTC -5) (click here to see my current time in Philadelphia, PA)

Thursday, 04 March 2010 04:48 CST
user8389
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.
Thursday, 04 March 2010 05:08 CST
nicholas
The only other thing left - although extremely unlikely - is to have installed some system plugin which forces the redirection. It's clearly a site configuration issue; the problem is that we have neither setup your site, nor are we logged in its back-end, so we have to try guiding you towards a solution.

Please recheck your .htaccess file. If you are unsure, remove it. If this stops the redirection (and breaks all links on the front-page) then the problem was in the .htaccess all the time. If not, please recheck your configuration.php for any $live_site variable. If this is still leads to dead end, try disabling System plug-ins one by one.


Nicholas K. Dionysopoulos

Lead Developer and Director



🇬🇷Greek: native

🇬🇧English: excellent

🇫🇷French: basic



Please keep in mind my timezone and cultural differences when reading my replies. Thank you!



Thursday, 04 March 2010 05:41 CST
user8389
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.
Thursday, 04 March 2010 07:06 CST
nicholas
See? Nothing in the web world defies rational explanation. It's just a matter of figuring out which question you have to ask yourself to reach the explanation :D I am glad this is fixed!


Nicholas K. Dionysopoulos

Lead Developer and Director



🇬🇷Greek: native

🇬🇧English: excellent

🇫🇷French: basic



Please keep in mind my timezone and cultural differences when reading my replies. Thank you!



This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.

Support Information

Working hours: Typically we work Monday to Friday, 9am to 7pm Cyprus timezone (EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets, but we cannot respond to them, outside of our working hours.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!