Support

During database restoration, I get the following error. Can you tell me what I can do to enable kickstart to restore the db? Thanks!


Error at the line 0: CREATE TABLE `akb_banner` ( `bid` int(11) NOT NULL AUTO_INCREMENT, `cid` int(11) NOT NULL DEFAULT '0', `type` varchar(30) NOT NULL DEFAULT 'banner', `name` varchar(255) NOT NULL DEFAULT '', `alias` varchar(255) NOT NULL DEFAULT '', `imptotal` int(11) NOT NULL DEFAULT '0', `impmade` int(11) NOT NULL DEFAULT '0', `clicks` int(11) NOT NULL DEFAULT '0', `imageurl` varchar(100) NOT NULL DEFAULT '', `clickurl` varchar(200) NOT NULL DEFAULT '', `date` datetime DEFAULT NULL, `showBanner` tinyint(1) NOT NULL DEFAULT '0', `checked_out` tinyint(1) NOT NULL DEFAULT '0', `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `editor` varchar(50) DEFAULT NULL, `custombannercode` text, `catid` int(10) unsigned NOT NULL DEFAULT '0', `description` text NOT NULL, `sticky` tinyint(1) unsigned NOT NULL DEFAULT '0', `ordering` int(11) NOT NULL DEFAULT '0', `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `tags` text NOT NULL, `params` text NOT NULL, PRIMARY KEY (`bid`), KEY `viewbanner` (`showBanner`), KEY `idx_banner_catid` (`catid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Query:DROP TABLE IF EXISTS `akb_banner`;

MySQL: MySQL query failed with error 1142 (DROP command denied to user 'C279008_admin'@'98.130.0.202' for table 'jos_banner'). The query was:DROP TABLE IF EXISTS `jos_banner`;

That looks like a permissions problem with your MySQL user. The MySQL user should have all permissions for this database. In this case, the user does not have permission to DROP the existing table, which prevents the restore function from restoring the backup table.

The right way to fix this is to give your MySQL user all rights to the database. An alternate method is to manually drop the tables before you do the restore.

I have a similar problem but the error message is:

DROP TABLE IF EXISTS `akb_banner`;

MySQL: MySQL query failed with error 6 (Error on delete of '.\mdash\mduk_banner.MYI' (Errcode: 13)). The query was:DROP TABLE IF EXISTS `mduk_banner`;

It worked OK, in the same database and same user with one set of table prefixes but not the other. I was using a common user with ALL privileges. This is on my localhost.

I have tried with root, a specific user and created a new user with all privileges.

I am using Kickstart 2.3.2 with JoomlaPack 2.3.3 Plus with some (based on prefix) DB tables and directories excluded. I have same problem with both version 3 and 4 installer.

For Information: initially it did not want to restore administrator and some other directories but I got over that (not sure how) even though it was working on another set of tables for another site (same db, different prefix/directory. It has only been a problem since I went from 2.3.3 to Plus and added exclsuions to backup different sites in same database separately.

Any thoughts? I do not really want to have to go to the extra work of a multi step process with manual dropping of tables. It shoudld be possible as it is working for my other site.

The user permissions are normally set on a database level. I think they can be set per table, but I wouldn't even know how, so that doesn't seem a likely cause. I'll ask Nicholas to look a this.

Thanks Nicholas,
I had the same error information. and I checked the database privileges, it hadn't set to have the privileges to Drop, i think that is the cause of the problem. set the right privileges and problem is gone