AND NOW: Can't create table (errno: 738)

[Peter Schulz]

thx for your help,

that fixed something not all... yesterday i found out how to restart / backup / restore to get my new config.ini work ... but back to problems:

following statement fails in errno: 738,
any idea? the verry LAST table i need in my db :/ unlucky -.-

first it fails with rowsize to large, i changed some varchar(255) to varchar(150) and TEXT but it doesn't help me a lot :/ 738 - what does that mean?

_pete®

CREATE TABLE tbl_temp_import (
temp_id bigint(20) unsigned NOT NULL auto_increment,
temp_session varchar(35) NOT NULL default '',
temp_order int(11) NOT NULL default '0',
temp_timestamp int(11) NOT NULL default '0',
temp_row text NOT NULL,
handle_import int(11) NOT NULL default '0',
recipient_prefix varchar(150) NOT NULL default '',
err_recipient_prefix tinyint(4) NOT NULL default '0',
recipient_title varchar(150) NOT NULL default '0',
err_recipient_title tinyint(4) NOT NULL default '0',
recipient_fname varchar(150) NOT NULL default '',
err_recipient_fname tinyint(4) NOT NULL default '0',
recipient_lname varchar(150) NOT NULL default '',
err_recipient_lname tinyint(4) NOT NULL default '0',
recipient_firm varchar(255) NOT NULL default '',
err_recipient_firm tinyint(4) NOT NULL default '0',
recipient_family_status varchar(150) NOT NULL default '',
err_recipient_family_status tinyint(4) NOT NULL default '0',
recipient_adress varchar(150) NOT NULL default '',
err_recipient_adress tinyint(4) NOT NULL default '0',
recipient_street varchar(150) NOT NULL default '',
err_recipient_street tinyint(4) NOT NULL default '0',
recipient_zip varchar(150) NOT NULL default '',
err_recipient_zip tinyint(4) NOT NULL default '0',
recipient_city varchar(150) NOT NULL default '',
err_recipient_city tinyint(4) NOT NULL default '0',
recipient_country varchar(150) NOT NULL default '',
err_recipient_country tinyint(4) NOT NULL default '0',
recipient_birthdate varchar(150) NOT NULL default '',
err_recipient_birthdate tinyint(4) NOT NULL default '0',
recipient_mail varchar(150) NOT NULL default '',
err_recipient_mail tinyint(4) NOT NULL default '0',
recipient_news_format varchar(150) NOT NULL default '',
err_recipient_news_format tinyint(4) NOT NULL default '0',
recipient_phone varchar(150) NOT NULL default '',
err_recipient_phone tinyint(4) NOT NULL default '0',
recipient_mobile varchar(30) NOT NULL default '',
err_recipient_mobile varchar(30) NOT NULL default '',
recipient_fax varchar(150) NOT NULL default '',
err_recipient_fax tinyint(4) NOT NULL default '0',
recipient_customer_n1 varchar(150) NOT NULL default '',
err_recipient_customer_n1 tinyint(4) NOT NULL default '0',
recipient_customer_n2 varchar(150) NOT NULL default '',
err_recipient_customer_n2 tinyint(4) NOT NULL default '0',
recipient_customer_n3 varchar(150) NOT NULL default '',
err_recipient_customer_n3 tinyint(4) NOT NULL default '0',
recipient_customer_n4 varchar(150) NOT NULL default '',
err_recipient_customer_n4 tinyint(4) NOT NULL default '0',
recipient_customer_n5 varchar(150) NOT NULL default '',
err_recipient_customer_n5 tinyint(4) NOT NULL default '0',
recipient_customer_n6 varchar(150) NOT NULL default '',
err_recipient_customer_n6 tinyint(4) NOT NULL default '0',
recipient_customer_n7 varchar(150) NOT NULL default '',
err_recipient_customer_n7 tinyint(4) NOT NULL default '0',
recipient_customer_n8 varchar(150) NOT NULL default '',
err_recipient_customer_n8 tinyint(4) NOT NULL default '0',
recipient_customer_n9 varchar(150) NOT NULL default '',
err_recipient_customer_n9 tinyint(4) NOT NULL default '0',
recipient_customer_n10 varchar(150) NOT NULL default '',
err_recipient_customer_n10 tinyint(4) NOT NULL default '0',
recipient_customer_n11 varchar(150) NOT NULL default '',
err_recipient_customer_n11 tinyint(4) NOT NULL default '0',
recipient_customer_n12 varchar(150) NOT NULL default '',
err_recipient_customer_n12 tinyint(4) NOT NULL default '0',
recipient_customer_t1 TEXT NOT NULL,
err_recipient_customer_t1 tinyint(4) NOT NULL default '0',
recipient_customer_t2 TEXT NOT NULL,
err_recipient_customer_t2 tinyint(4) NOT NULL default '0',
recipient_customer_t3 TEXT NOT NULL,
err_recipient_customer_t3 tinyint(4) NOT NULL default '0',
recipient_customer_t4 TEXT NOT NULL,
err_recipient_customer_t4 tinyint(4) NOT NULL default '0',
recipient_customer_t5 TEXT NOT NULL,
err_recipient_customer_t5 tinyint(4) NOT NULL default '0',
recipient_customer_t6 TEXT NOT NULL,
err_recipient_customer_t6 tinyint(4) NOT NULL default '0',
recipient_customer_t7 TEXT NOT NULL,
err_recipient_customer_t7 tinyint(4) NOT NULL default '0',
recipient_customer_t8 TEXT NOT NULL,
err_recipient_customer_t8 tinyint(4) NOT NULL default '0',
recipient_customer_t9 TEXT NOT NULL,
err_recipient_customer_t9 tinyint(4) NOT NULL default '0',
recipient_customer_t10 TEXT NOT NULL,
err_recipient_customer_t10 tinyint(4) NOT NULL default '0',
recipient_customer_t11 TEXT NOT NULL,
err_recipient_customer_t11 tinyint(4) NOT NULL default '0',
recipient_customer_t12 TEXT NOT NULL,
err_recipient_customer_t12 tinyint(4) NOT NULL default '0',
recipient_customer_d1 varchar(150) NOT NULL default '',
err_recipient_customer_d1 tinyint(4) NOT NULL default '0',
recipient_customer_d2 varchar(150) NOT NULL default '',
err_recipient_customer_d2 tinyint(4) NOT NULL default '0',
recipient_customer_d3 varchar(150) NOT NULL default '',
err_recipient_customer_d3 tinyint(4) NOT NULL default '0',
recipient_customer_d4 varchar(150) NOT NULL default '',
err_recipient_customer_d4 tinyint(4) NOT NULL default '0',
recipient_customer_d5 varchar(150) NOT NULL default '',
err_recipient_customer_d5 tinyint(4) NOT NULL default '0',
recipient_customer_d6 varchar(150) NOT NULL default '',
err_recipient_customer_d6 tinyint(4) NOT NULL default '0',
recipient_customer_d7 varchar(150) NOT NULL default '',
err_recipient_customer_d7 tinyint(4) NOT NULL default '0',
recipient_customer_d8 varchar(150) NOT NULL default '',
err_recipient_customer_d8 tinyint(4) NOT NULL default '0',
PRIMARY KEY (temp_id),
KEY temp_id (temp_id),
KEY recipient_mail (recipient_mail),
KEY temp_session (temp_session)
) ENGINE=NDBCLUSTER;



Edited 1 time(s). Last edit at 02/15/2006 04:12AM by Peter Schulz.