#1005 - Can't create table './dbname/aa_survey.frm' (errno: 4318)
Posted by:
hydrosan
Date: December 19, 2006 11:31AM
I keep receiving this error and have no idea why. The table worked just fine with MyISAM (i know ndbcluster has quite a few restrictions.) Any help would be appreciated!
#1005 - Can't create table './dbname/aa_survey.frm' (errno: 4318)
Here is the table I am trying to import:
(originally the varchars were 255, but it complained about size, changing them to 1 created the above mentioned error)
CREATE TABLE `aa_survey` (
`id_num` int(11) NOT NULL auto_increment,
`english_id` int(11) NOT NULL default '0',
`language_id` varchar(1) NOT NULL ,
`related_table_1` varchar(1) NOT NULL ,
`related_table_2` varchar(1) NOT NULL ,
`related_table_3` varchar(1) NOT NULL ,
`related_table_4` varchar(1) NOT NULL ,
`related_table_5` varchar(1) NOT NULL ,
`related_table_6` varchar(1) NOT NULL ,
`related_table_7` varchar(1) NOT NULL ,
`sort_num` int(11) NOT NULL default '0',
`search_keywords` varchar(1) NOT NULL ,
`title` varchar(1) NOT NULL ,
`related_table_8` varchar(1) NOT NULL ,
`short_desc` longtext NOT NULL,
`thumb_1` varchar(1) NOT NULL ,
`thumb_1_title` varchar(1) NOT NULL ,
`content_1_header` varchar(1) NOT NULL ,
`content_1_desc` longtext NOT NULL,
`content_1_link_title` varchar(1) NOT NULL ,
`content_1_link_url` varchar(1) NOT NULL ,
`content_1_med` varchar(1) NOT NULL ,
`content_1_med_title` varchar(1) NOT NULL ,
`content_1_large` varchar(1) NOT NULL ,
`content_1_large_desc` varchar(1) NOT NULL ,
`content_2_header` varchar(1) NOT NULL ,
`content_2_desc` longtext NOT NULL,
`content_2_link_title` varchar(1) NOT NULL ,
`content_2_link_url` varchar(1) NOT NULL ,
`content_2_med` varchar(1) NOT NULL ,
`content_2_med_title` varchar(1) NOT NULL ,
`content_2_large` varchar(1) NOT NULL ,
`content_2_large_desc` varchar(1) NOT NULL ,
`content_3_header` varchar(1) NOT NULL ,
`content_3_desc` longtext NOT NULL,
`content_3_link_title` varchar(1) NOT NULL ,
`content_3_link_url` varchar(1) NOT NULL ,
`content_3_med` varchar(1) NOT NULL ,
`content_3_med_title` varchar(1) NOT NULL ,
`content_3_large` varchar(1) NOT NULL ,
`content_3_large_desc` varchar(1) NOT NULL ,
`content_4_header` varchar(1) NOT NULL ,
`content_4_desc` longtext NOT NULL,
`content_4_link_title` varchar(1) NOT NULL ,
`content_4_link_url` varchar(1) NOT NULL ,
`content_4_med` varchar(1) NOT NULL ,
`content_4_med_title` varchar(1) NOT NULL ,
`content_4_large` varchar(1) NOT NULL ,
`content_4_large_desc` varchar(1) NOT NULL ,
`content_5_header` varchar(1) NOT NULL ,
`content_5_desc` longtext NOT NULL,
`content_5_link_title` varchar(1) NOT NULL ,
`content_5_link_url` varchar(1) NOT NULL ,
`content_5_med` varchar(1) NOT NULL ,
`content_5_med_title` varchar(1) NOT NULL ,
`content_5_large` varchar(1) NOT NULL ,
`content_5_large_desc` varchar(1) NOT NULL ,
`label_1_title` varchar(1) NOT NULL ,
`label_1_desc` varchar(1) NOT NULL ,
`label_2_title` varchar(1) NOT NULL ,
`label_2_desc` varchar(1) NOT NULL ,
`label_3_title` varchar(1) NOT NULL ,
`label_3_desc` varchar(1) NOT NULL ,
`label_4_title` varchar(1) NOT NULL ,
`label_4_desc` varchar(1) NOT NULL ,
`label_5_title` varchar(1) NOT NULL ,
`label_5_desc` varchar(1) NOT NULL ,
`label_6_title` varchar(1) NOT NULL ,
`label_6_desc` varchar(1) NOT NULL ,
`label_7_title` varchar(1) NOT NULL ,
`label_7_desc` varchar(1) NOT NULL ,
`label_8_title` varchar(1) NOT NULL ,
`label_8_desc` varchar(1) NOT NULL ,
`label_9_title` varchar(1) NOT NULL ,
`label_9_desc` varchar(1) NOT NULL ,
`label_10_title` varchar(1) NOT NULL ,
`label_10_desc` varchar(1) NOT NULL ,
`label_11_title` varchar(1) NOT NULL ,
`label_11_desc` varchar(1) NOT NULL ,
`label_12_title` varchar(1) NOT NULL ,
`label_12_desc` varchar(1) NOT NULL ,
`label_13_title` varchar(1) NOT NULL ,
`label_13_desc` varchar(1) NOT NULL ,
`label_14_title` varchar(1) NOT NULL ,
`label_14_desc` varchar(1) NOT NULL ,
`label_15_title` varchar(1) NOT NULL ,
`label_15_desc` varchar(1) NOT NULL ,
`start_year` int(11) NOT NULL default '0',
`start_month` int(11) NOT NULL default '0',
`start_day` int(11) NOT NULL default '0',
`end_year` int(11) NOT NULL default '0',
`end_month` int(11) NOT NULL default '0',
`end_day` int(11) NOT NULL default '0',
`pdf_1_file` varchar(1) NOT NULL ,
`pdf_1_title` varchar(1) NOT NULL ,
`pdf_1_desc` varchar(1) NOT NULL ,
`pdf_2_file` varchar(1) NOT NULL ,
`pdf_2_title` varchar(1) NOT NULL ,
`pdf_2_desc` varchar(1) NOT NULL ,
`pdf_3_file` varchar(1) NOT NULL ,
`pdf_3_title` varchar(1) NOT NULL ,
`pdf_3_desc` varchar(1) NOT NULL ,
`pdf_4_file` varchar(1) NOT NULL ,
`pdf_4_title` varchar(1) NOT NULL ,
`pdf_4_desc` varchar(1) NOT NULL ,
`pdf_5_file` varchar(1) NOT NULL ,
`pdf_5_title` varchar(1) NOT NULL ,
`pdf_5_desc` varchar(1) NOT NULL ,
`word_1_file` varchar(1) NOT NULL ,
`word_1_title` varchar(1) NOT NULL ,
`word_1_desc` varchar(1) NOT NULL ,
`word_2_file` varchar(1) NOT NULL ,
`word_2_title` varchar(1) NOT NULL ,
`word_2_desc` varchar(1) NOT NULL ,
`word_3_file` varchar(1) NOT NULL ,
`word_3_title` varchar(1) NOT NULL ,
`word_3_desc` varchar(1) NOT NULL ,
`word_4_file` varchar(1) NOT NULL ,
`word_4_title` varchar(1) NOT NULL ,
`word_4_desc` varchar(1) NOT NULL ,
`word_5_file` varchar(1) NOT NULL ,
`word_5_title` varchar(1) NOT NULL ,
`word_5_desc` varchar(1) NOT NULL ,
`file1_file` varchar(1) NOT NULL ,
`file1_title` varchar(1) NOT NULL ,
`file1_desc` varchar(1) NOT NULL ,
`file2_file` varchar(1) NOT NULL ,
`file2_title` varchar(1) NOT NULL ,
`file2_desc` varchar(1) NOT NULL ,
`file3_file` varchar(1) NOT NULL ,
`file3_title` varchar(1) NOT NULL ,
`file3_desc` varchar(1) NOT NULL ,
`file4_file` varchar(1) NOT NULL ,
`file4_title` varchar(1) NOT NULL ,
`file4_desc` varchar(1) NOT NULL ,
`file5_file` varchar(1) NOT NULL ,
`file5_title` varchar(1) NOT NULL ,
`file5_desc` varchar(1) NOT NULL ,
`button_1` varchar(1) NOT NULL ,
`button_2` varchar(1) NOT NULL ,
`button_width` int(11) NOT NULL default '0',
`button_height` int(11) NOT NULL default '0',
`contact_type` varchar(1) NOT NULL ,
`contact_territory` varchar(1) NOT NULL ,
`company_name` varchar(1) NOT NULL ,
`address1` varchar(1) NOT NULL ,
`address2` varchar(1) NOT NULL ,
`city` varchar(1) NOT NULL ,
`state` varchar(1) NOT NULL ,
`zip` int(11) NOT NULL default '0',
`country` varchar(1) NOT NULL ,
`phone` varchar(1) NOT NULL ,
`fax` varchar(1) NOT NULL ,
`url` varchar(1) NOT NULL ,
`fname` varchar(1) NOT NULL ,
`lname` varchar(1) NOT NULL ,
`contact_title` varchar(1) NOT NULL ,
`email` varchar(1) NOT NULL ,
`logo` varchar(1) NOT NULL ,
PRIMARY KEY (`id_num`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1;