Re: Problem with the NDB database engine

[Massimiliano Ziccardi]

HI all!
The previous error has gone, however, it fails creating this table:

create table User_ (
    uuid_ varchar(75) null,
    userId bigint not null primary key,
    companyId bigint,
    createDate datetime null,
    modifiedDate datetime null,
    defaultUser tinyint,
    contactId bigint,
    password_ varchar(75) null,
    passwordEncrypted tinyint,
    passwordReset tinyint,
    passwordModifiedDate datetime null,
    digest varchar(255) null,
    reminderQueryQuestion varchar(75) null,
    reminderQueryAnswer varchar(75) null,
    graceLoginCount integer,
    screenName varchar(75) null,
    emailAddress varchar(75) null,
    facebookId bigint,
    openId varchar(1024) null,
    portraitId bigint,
    languageId varchar(75) null,
    timeZoneId varchar(75) null,
    greeting varchar(255) null,
    comments longtext null,
    firstName varchar(75) null,
    middleName varchar(75) null,
    lastName varchar(75) null,
    jobTitle varchar(100) null,
    loginDate datetime null,
    loginIP varchar(75) null,
    lastLoginDate datetime null,
    lastLoginIP varchar(75) null,
    lastFailedLoginDate datetime null,
    failedLoginAttempts integer,
    lockout tinyint,
    lockoutDate datetime null,
    agreedToTermsOfUse tinyint,
    active_ tinyint
) engine NDB;

the error is :

ERROR 1005 (HY000): Can't create table 'lportal.user_' (errno: 140)

and

perror --ndb 140

Illegal ndb error code: 140
MySQL error code 140: Wrong create options
Win32 error code 140: The system tried to join a drive to a directory on a
substituted drive.

Any help?

Thank you in advance,
Massimiliano Ziccardi