> % perror 143 > Error code 143: Unknown error: 143 > 143 = Conflicting table definitions in sub-tables of MERGE table > > Can you post the results for SHOW CREATE TABLE for the tables > you're trying to merge?
MAILBOX [snip] | Mailbox |CREATE TABLE `Mailbox` ( `ID` int(11) NOT NULL auto_increment, `Arrived` int(11) NOT NULL default '0', `Sent` int(11) NOT NULL default '0', `ReadDate` int(11) NOT NULL default '0', `Hold` tinyint(4) NOT NULL default '0', `Header` text NOT NULL, `Subject` tinytext NOT NULL, `Text` tinytext NOT NULL, `TextCom` tinytext NOT NULL, `FromStationID` tinytext NOT NULL, `Status` tinytext NOT NULL, `StatusDesc` text NOT NULL, `DontCharge` tinyint(4) NOT NULL default '0', `PendingTo` tinyint(4) NOT NULL default '0', `SentTo` tinytext NOT NULL, `FromAddress` text NOT NULL, `ToAddress` tinytext NOT NULL, `FromName` text NOT NULL, `ToName` text NOT NULL, `Size` int(11) NOT NULL default '0', `CompressedSize` int(11) NOT NULL default '0', `Type` tinytext NOT NULL, `Priority` tinyint(4) NOT NULL default '0', `ReadFlagSent` int(11) NOT NULL default '0', `Accounting` int(11) NOT NULL default '0', `QRG` tinytext NOT NULL, `Modulation` tinytext NOT NULL, `RetryCount` tinyint(4) NOT NULL default '0', `LastTry` int(11) NOT NULL default '0', `RemoteFaxID` tinytext NOT NULL, `LLCharge` tinytext NOT NULL, `LLTime` int(11) NOT NULL default '0', `LLPages` int(11) NOT NULL default '0', `ExternalSerial` text NOT NULL, `GPS` tinytext NOT NULL, `Price` double NOT NULL default '0', `PriceCalc` text NOT NULL, `PriceCalcValue` double NOT NULL default '0', `User_ID` int(11) NOT NULL default '0', `Pay_ID` int(11) NOT NULL default '0', `Tarif_ID` int(11) NOT NULL default '0', `CopyOf` int(11) NOT NULL default '0', `ShipID` int(11) NOT NULL default '0', PRIMARY KEY (`ID`), UNIQUE KEY `Messagenumber` (`ID`), KEY `PendingTo` (`PendingTo`), KEY `ToAddress` (`ToAddress`(25)), KEY `FromAddress` (`FromAddress`(25)), KEY `Size` (`Size`), KEY `CompressedSize` (`CompressedSize`), KEY `Status` (`Status`(15)), KEY `Size_2` (`Size`), KEY `CompressedSize_2` (`CompressedSize`), KEY `Hold` (`Hold`), KEY `FromStationID` (`FromStationID`(20)), KEY `Arrived` (`Arrived`), KEY `Sent` (`Sent`), KEY `ShipID` (`ShipID`), KEY `User_ID` (`User_ID`) ) TYPE=MyISAM [snip] Mailbox_Old [snip] | Mailbox_Old |CREATE TABLE `Mailbox_Old` ( `ID` int(11) NOT NULL auto_increment, `Arrived` int(11) NOT NULL default '0', `Sent` int(11) NOT NULL default '0', `ReadDate` int(11) NOT NULL default '0', `Hold` tinyint(4) NOT NULL default '0', `Header` text NOT NULL, `Subject` tinytext NOT NULL, `Text` tinytext NOT NULL, `TextCom` tinytext NOT NULL, `FromStationID` tinytext NOT NULL, `Status` tinytext NOT NULL, `StatusDesc` text NOT NULL, `DontCharge` tinyint(4) NOT NULL default '0', `PendingTo` tinyint(4) NOT NULL default '0', `SentTo` tinytext NOT NULL, `FromAddress` text NOT NULL, `ToAddress` tinytext NOT NULL, `FromName` text NOT NULL, `ToName` text NOT NULL, `Size` int(11) NOT NULL default '0', `CompressedSize` int(11) NOT NULL default '0', `Type` tinytext NOT NULL, `Priority` tinyint(4) NOT NULL default '0', `ReadFlagSent` int(11) NOT NULL default '0', `Accounting` int(11) NOT NULL default '0', `QRG` tinytext NOT NULL, `Modulation` tinytext NOT NULL, `RetryCount` tinyint(4) NOT NULL default '0', `LastTry` int(11) NOT NULL default '0', `RemoteFaxID` tinytext NOT NULL, `LLCharge` tinytext NOT NULL, `LLTime` int(11) NOT NULL default '0', `LLPages` int(11) NOT NULL default '0', `ExternalSerial` text NOT NULL, `GPS` tinytext NOT NULL, `Price` double NOT NULL default '0', `PriceCalc` text NOT NULL, `PriceCalcValue` double NOT NULL default '0', `User_ID` int(11) NOT NULL default '0', `Pay_ID` int(11) NOT NULL default '0', `Tarif_ID` int(11) NOT NULL default '0', `CopyOf` int(11) NOT NULL default '0', `ShipID` int(11) NOT NULL default '0', PRIMARY KEY (`ID`), UNIQUE KEY `Messagenumber` (`ID`), KEY `PendingTo` (`PendingTo`), KEY `ToAddress` (`ToAddress`(25)), KEY `FromAddress` (`FromAddress`(25)), KEY `Size` (`Size`), KEY `CompressedSize` (`CompressedSize`), KEY `Status` (`Status`(15)), KEY `Size_2` (`Size`), KEY `CompressedSize_2` (`CompressedSize`), KEY `Hold` (`Hold`), KEY `FromStationID` (`FromStationID`(20)), KEY `Arrived` (`Arrived`), KEY `Sent` (`Sent`), KEY `ShipID` (`ShipID`), KEY `User_ID` (`User_ID`) ) TYPE=MyISAM | [snip] SuperMailbox [snip] mysql> show create table SuperMailbox; ERROR 1016: Can't open file: 'SuperMailbox.MRG'. (errno: 143) [snip] Here is the query I used to create the Merge table.. create table SuperMailbox (ID int(11) Auto_Increment, Arrived int(11), Sent int(11), ReadDate INT(11),Hold tinyint(4), Header text, Subject tinytext, Text tinytext, textCom tinytext, FromStationID tinytext, Status tinytext, StatusDesc text, DontCharge tinyint(4), PendingTo tinyint(4), SentTo tinytext, FromAddress text, ToAddress tinytext, FromName text, ToName text, Size INT(11), CompressedSize INT(11), Type tinytext, Priority tinyint(4), ReadFlagSent int(11), Accounting int(11), QRG tinytext, Modulation tinytext, RetryCount tinyint(4), LastTry int(11), RemoteFaxID tinytext, LLCharge tinytext, LLTime int(11), LLPages int(11), ExternalSerial text, GPS tinytext, Price Double, User_ID int(11),Pay_ID int(11), Tarif_ID int(11), CopyOf int(11), ShipID int(11), key(ID)) Type=MERGE UNION=(Mailbox_Old,Mailbox); Jeff > -----Original Message----- > From: Paul DuBois [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 14, 2003 11:59 AM > To: Jeff McKeon; [EMAIL PROTECTED] > Subject: RE: Data from two tables in one query > > > At 11:50 -0400 10/14/03, Jeff McKeon wrote: > >Ok, created the merge table, now I get this error when I log > into the > >mysql server.... > > > >[snip] > >Didn't find any fields in table 'SuperMailbox' > >Welcome to the MySQL monitor. Commands end with ; or \g. > >Your MySQL connection id is 3903 to server version: 3.23.56 > > > >Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > > >mysql> show columns from SuperMailbox; > >ERROR 1016: Can't open file: 'SuperMailbox.MRG'. (errno: 143) > > > >[snip] > > > >Any ideas what I've screwed up now? > > > >Thanks, > > > >Jeff > > Hmmm... > > % perror 143 > Error code 143: Unknown error: 143 > 143 = Conflicting table definitions in sub-tables of MERGE table > > Can you post the results for SHOW CREATE TABLE for the tables > you're trying to merge? > > -- > Paul DuBois, Senior Technical Writer > Madison, Wisconsin, USA > MySQL AB, www.mysql.com > > Are you MySQL certified? http://www.mysql.com/certification/ > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]