Hello,
i did this many times. I have always a copy on a second subdomain to check for new things (components, modules and plugins) without to harm the site and its works always great with akeeba to take a new copy of the site to the subdomain - until this weekend! I just wonder because after a total update on AkeebaBackup and Rockettheme Extensions like RokGallery or RokSprocket the new installation do not work, the permissions and Aria engine are fine, nothing has change expect the updates (I deinstalled all of this and reinstalled it without any sucess, except lot of work) – I tried to some of the Related results helps (actually all) and its still always fails with this:
Database restoration
An error occurred while restoring the database. The error message can be found below. Click on the × button at the top right of this dialog message to close it and return to the database restoration page.
Database error processing line 3
Database server error reply:
ErrNo #0
Raw query text:
i did this many times. I have always a copy on a second subdomain to check for new things (components, modules and plugins) without to harm the site and its works always great with akeeba to take a new copy of the site to the subdomain - until this weekend! I just wonder because after a total update on AkeebaBackup and Rockettheme Extensions like RokGallery or RokSprocket the new installation do not work, the permissions and Aria engine are fine, nothing has change expect the updates (I deinstalled all of this and reinstalled it without any sucess, except lot of work) – I tried to some of the Related results helps (actually all) and its still always fails with this:
Database restoration
An error occurred while restoring the database. The error message can be found below. Click on the × button at the top right of this dialog message to close it and return to the database restoration page.
Database error processing line 3
Database server error reply:
ErrNo #0
SQL=CREATE TABLE `wiot3_rokgallery_file_views` ( `file_id` int(10) unsigned NOT NULL DEFAULT '0', `kount` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`file_id`), UNIQUE KEY `file_id` (`file_id`), CONSTRAINT `wiot3_file_views_file_id__files_id` FOREIGN KEY (`file_id`) REFERENCES `wiot3_rokgallery_files` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
Raw query text:
CREATE TABLE `#__rokgallery_file_views` ( `file_id` int(10) unsigned NOT NULL DEFAULT '0', `kount` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`file_id`), UNIQUE KEY `file_id` (`file_id`), CONSTRAINT `wiot3_file_views_file_id__files_id` FOREIGN KEY (`file_id`) REFERENCES `#__rokgallery_files` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8
