The free forums are no longer in use. It remains available as read-only archive.
Log In
12:23 am
March 9, 2012
Offline
I'm getting an error (multiple error if I choose skip this querry) and I'm not sure what to make of it.
This is occuring while ausing automatic restore. 39.10% processed
###MYSQL error
Can't create table 'database_name.gtaq_rokgallery_file_loves' (errno: 150)
###On Query:
#
# Table structure for table `gtaq_rokgallery_file_loves`
#
CREATE TABLE `gtaq_rokgallery_file_loves` (
`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 `gtaq_file_loves_file_id_files_id` FOREIGN KEY (`file_id`) REFERENCES `gtaq_rokgallery_files` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8
I've skipped this step and recieved ~20 more errors with the same extension rokgallery.
When trying to access the url of the new location I get error -- 42 - SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database_name.gtaq_rokgallery_file_views' doesn't exist --
Anyone have any ideas??
10:09 am
September 26, 2010
Offline
Try and check if your mysql server supports the InnoDB Engine, otherwise you might need to enable it in order to make those quesries run!
Ovidiu
4:45 pm
March 9, 2012
Offline
Thank you Ovidiu.
InnoDB is not skipped in the my.cnf file. And the extension, with the InnoDB, seems to work fine. Do I need to make it the default DB for xcloner to work with it?
9:33 am
September 26, 2010
Offline
This error is not from XCloner, but from the mysql server which seems to reject that create table query, i would suggest to try and manually run that query and see if it works, if so, you can simply restore the administrator/backups/database-sql.sql file that way.
Regards, Ovidiu
All RSS1 Guest(s)
