| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Tom Brown | Date: | April 22 2004 1:29pm |
| Subject: | Create table results in (errno: 121) | ||
| View as plain text | |||
Hi, I'm trying to create a table with the following syntax CREATE TABLE TNSession ( SessionID int(11) NOT NULL auto_increment, IPAddress varchar(50) default NULL, Created datetime default NULL, Expired tinyint(4) default '0', AccountID int(11) default '0', PRIMARY KEY (SessionID), KEY FK_AccountID (AccountID), CONSTRAINT `0_20` FOREIGN KEY (`AccountID`) REFERENCES `TNAccount` (`AccountID`) ) TYPE=InnoDB ROW_FORMAT=DYNAMIC; it results in a ERROR 1005: Can't create table './TNMailServer/TNSession.frm' (errno: 121) This is on version mysql-standard-4.0.18-pc-linux-i686 Can anyone shed any light on this as it has me stumped - There is a TNAccount table with a AccountID column? thanks for any assistance Tom
| Thread | ||
|---|---|---|
| • Create table results in (errno: 121) | Tom Brown | 22 Apr |
| • Re: Create table results in (errno: 121) | Martijn Tonies | 22 Apr |
| • Re: Create table results in (errno: 121) | Tom Brown | 22 Apr |
| • Re: Create table results in (errno: 121) | Adam | 28 Apr |
| • urban myth? | Boyd E. Hemphill | 3 May |
| • Re: urban myth? | Peter J Milanese | 3 May |
| • Re: urban myth? | Daniel Clark | 3 May |
| • Re: urban myth? | Garth Webb | 3 May |
| • Re: urban myth? | Bob Ramsey | 3 May |
| • Re: urban myth? | Josh Trutwin | 3 May |
| • Re: urban myth? | Garth Webb | 3 May |
| • Re: urban myth? | Michael Stassen | 3 May |
| • RE: urban myth? | Boyd E. Hemphill | 3 May |
| • Re: urban myth? | Anders Karlsson | 3 May |
| • Re: urban myth? | Michael T. Babcock | 13 May |
| • Re: urban myth? | Josh Trutwin | 3 May |
| • Re: urban myth? | Jeremy Zawodny | 3 May |
| • Re: urban myth? | gerald_clark | 3 May |
| • Re: urban myth? | Peter J Milanese | 3 May |
| • Re: Create table results in (errno: 121) | beacker | 22 Apr |
| • RE: urban myth? | Mike Johnson | 3 May |
| • Re: urban myth? | Udikarni | 3 May |
