MySQL Forums
Forum List  »  NDB clusters

Re: Can't create table (errno:4242 )
Posted by: Peter Schulz
Date: February 10, 2006 03:43AM

ok i found out that the problem ist the "unique key" in my statement... that causes errno: 4242....

CREATE TABLE `tbl_users` (
`user_id` int(11) NOT NULL auto_increment,
`user_login` varchar(15) NOT NULL default '',
PRIMARY KEY (`user_id`),
UNIQUE KEY `user_login` (`user_login`)
) ENGINE=NDBCLUSTER;


it seems to be a limitation error - because if my database don't has any tables i can perform that statement... if i have some tables in there that statement fails 4242... any ideas?

_pete®

Options: ReplyQuote


Subject
Views
Written By
Posted
2789
February 06, 2006 09:47AM
1429
February 06, 2006 11:39AM
1647
February 06, 2006 12:15PM
1615
February 07, 2006 09:21AM
1492
February 07, 2006 10:32AM
1528
February 07, 2006 10:36AM
1477
February 08, 2006 02:04AM
Re: Can't create table (errno:4242 )
1519
February 10, 2006 03:43AM
1552
February 12, 2006 01:08PM
1700
February 15, 2006 06:47AM
1447
February 15, 2006 07:09AM
1351
February 15, 2006 07:24AM
1475
February 15, 2006 07:48AM
1531
February 15, 2006 07:49AM
1394
February 15, 2006 08:02AM
1420
February 15, 2006 09:11AM
1609
March 07, 2006 11:34AM
1574
March 07, 2006 11:38AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.