Support

UNiTE, Remote CLI, eXtract Wizard

#3624 – Data base erro after kcking star

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.
Thursday, 18 March 2010 09:18 CDT
user9193
The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working) ... I use appserv 2.5.9 in local host computer. As I remeber, it is all right to restore the data base when i use the version of Joomla pack 2.0, and after I use updated joomlapack 2.4, even use the Akeeba Backup 3.0.a4, it cames up the same problem as above, anybody can tell me why?
Thursday, 18 March 2010 17:23 CDT
dlb
I believe it was in the 2.4 series that the "Disable foreign key checks" option was added to JoomlaPack. I don't see that option in Akeeba, but it is using a new database dump engine by default. What error are you getting during the database restore?


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, 18 March 2010 22:18 CDT
user9193
thank you man for repsonse, I use the akeeba comes up the same problem. don't know why. the erro message is below:

Error at the line 241: CREATE TABLE `akb_captcha_session` ( `id` int(10) unsigned NOT NULL auto_increment, `sessionid` varchar(64) NOT NULL default '', `password` varchar(8) NOT NULL default '', `date` datetime NOT N ... MySQL: MySQL query failed with error 1289 (The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working). The query was:CREATE TABLE `jos_captcha_session` ( `id` int(10) unsigned NOT NULL auto_increment, `sessionid` varchar(64) NOT NULL default '', `password` varchar(8) NOT NULL default '', `date` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) TYPE=InnoDB AUTO_INCREMENT=6955

please help me.
Friday, 19 March 2010 06:22 CDT
dlb
Ah! Now it makes sense. The table is tagged as an InnoDB table, but your MySQL server doesn't support InnoDB. Jooomla! itself doesn't require the InnoDB engine, some extensions do require it (CiviCRM, for example).

I think step 1 is to check with your host to see if the InnoDB engine is available. If it is not, we need to figure out if some of your extensions require the features of the InnoDB engine.


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)

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!