Akeeba Backup for Joomla!

#14654 Restore Proceedure is not working

Posted in ‘Akeeba Backup for Joomla! 4 & 5’

This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version

n/a

PHP version

n/a

Akeeba Backup version

n/a

Latest post by on Tuesday, 12 February 2013 18:00 CST

Saturday, 12 January 2013 17:20 CST

user71349

None of my restore points are working. Now my site is down and I am not able to work on it.

I am receiving a data base error during the restore process. I have tried to paste the error but your ticket system is not allowing me too. I will try one more time

Error at the line 1230: CREATE TABLE `ncbs3_newsfeeds` ( `catid` int(11) NOT NULL DEFAULT '0', `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL DEFAULT '', `alias` varchar(255) CHARACTER SE ... MySQL: MySQL query failed with error 1005 (Can't create table 'db123923_dev3_aerobyte.ncbs3_newsfeeds' (errno: 121)). The query was:CREATE TABLE `ncbs3_newsfeeds` ( `catid` int(11) NOT NULL DEFAULT '0', `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL DEFAULT '', `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `link` varchar(200) NOT NULL DEFAULT '', `filename` varchar(200) DEFAULT NULL, `published` tinyint(1) NOT NULL DEFAULT '0', `numarticles` int(10) unsigned NOT NULL DEFAULT '1', `cache_time` int(10) unsigned NOT NULL DEFAULT '3600', `checked_out` int(10) unsigned NOT NULL DEFAULT '0', `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `ordering` int(11) NOT NULL DEFAULT '0', `rtl` tinyint(4) NOT NULL DEFAULT '0', `access` int(10) unsigned NOT NULL DEFAULT '0', `language` char(7) NOT NULL DEFAULT '', `params` text NOT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_by` int(10) unsigned NOT NULL DEFAULT '0', `created_by_alias` varchar(255) NOT NULL DEFAULT '', `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(10) unsigned NOT NULL DEFAULT '0', `metakey` text NOT NULL, `metadesc` text NOT NULL, `metadata` text NOT NULL, `xreference` varchar(50) NOT NULL COMMENT 'A reference to enable linkages to external data sets.', `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`), KEY `idx_state` (`published`), KEY `idx_catid` (`catid`), KEY `idx_createdby` (`created_by`), KEY `idx_language` (`language`), KEY `idx_xreference` (`xreference`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8

Can't get it to work? Click here for troubleshooting instructions.

Edited by user71349 on 2013-01-12 17:22 CST

Sunday, 13 January 2013 02:45 CST

nicholas

You have to contact your host a.s.a.p.! This error message indicates one of the following:

Your database user doesn't have enough permissions to create tables. This prevents backup restoration as well as extensions and Joomla! installation and updates.
Your database is over its quota limit.
Your database is corrupt.
The disk where your database server stores its files is full, corrupt or has permission issues which prevent MySQL from creating the table.

With the exception of the first potential issue there's nothing you can do to check if that's the problem or fix it.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Tuesday, 12 February 2013 18:00 CST

System Task

system

This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Support