Hi, What about upgrading to MySQL 4.0.13 ? 4.0.0 is not a "production" release, and a lot of bugs have been fixed between 4.0.0 and 4.0.13.
Regards, Jocelyn ----- Original Message ----- From: "Karl J. Stubsjoen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 11:13 PM Subject: Strange "Mull" in show fields and table keeps crashing > Hello, > I have this table: > "CLUB" > Field Type Null Key Default Extra > clubid int(11) PRI NULL auto_increment > clubusgf int(11) UNI 0 > program char(3) > url varchar(75) > email varchar(75) > phone varchar(14) > fax varchar(14) > address1 varchar(75) MUL > address2 varchar(75) > city varchar(75) > notes varchar(255) > zip varchar(10) > clubname varchar(75) > contact_primary varchar(40) > state char(2) > contact_secondary varchar(40) > > > See address1 above the the "MUL" next to it. What is that? Also, this > table keeps crashing, it crashes when I make an edit to anything in this > field. So I copy the column, move the data over and then I can make edits > in this field. However, another field in my table will get this strange > "MUL" indication. From this point forward then, any changes to the data in > that column will cause the table to crash. > I've succesfully repaired the table a 1/2 dozen times or so... and > copied/renamed about 4 of the columns as they took on this "MUL" > characteristic. > Any ideas how to fix this problem? Any ideas what is going on? > > Here is my version of MySQL: > Server version: 4.0.0-alpha > > Karl > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
