RE: Strange "Mull" in show fields and table keeps crashing
Do you have any sort of `shell` access to the box? SSH? Telnet? -Original Message- From: Karl J. Stubsjoen [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 9:51 AM To: [EMAIL PROTECTED] Subject: Re: Strange "Mull" in show fields and table keeps crashing I'm not sure what errors are being reported to the server. I'm not sure how to get those. I am not local to the box. Is there a way to look at the log files without being at the box? Karl - Original Message - From: "Victor Pendleton" <[EMAIL PROTECTED]> To: "'Karl J. Stubsjoen'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 2:20 PM Subject: RE: Strange "Mull" in show fields and table keeps crashing > The `MUL` indicates that the column have multiple values. When the server > `crashes`, what errors are being reported log file? > > -Original Message- > From: Karl J. Stubsjoen [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 24, 2003 4:13 PM > To: [EMAIL PROTECTED] > 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Strange "Mull" in show fields and table keeps crashing
I'm not sure what errors are being reported to the server. I'm not sure how to get those. I am not local to the box. Is there a way to look at the log files without being at the box? Karl - Original Message - From: "Victor Pendleton" <[EMAIL PROTECTED]> To: "'Karl J. Stubsjoen'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 2:20 PM Subject: RE: Strange "Mull" in show fields and table keeps crashing > The `MUL` indicates that the column have multiple values. When the server > `crashes`, what errors are being reported log file? > > -Original Message- > From: Karl J. Stubsjoen [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 24, 2003 4:13 PM > To: [EMAIL PROTECTED] > 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]
RE: Strange "Mull" in show fields and table keeps crashing
MUL indicates a that the column is part of a composite INDEX. SHOW INDEX FROM tablename Should let you know what columns make up the MUL column INDEX. If this was not supposed to be indexed, your table is corrupt, best try MyIsamChk Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Karl J. Stubsjoen [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 24, 2003 3:13 PM > To: [EMAIL PROTECTED] > 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/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Strange "Mull" in show fields and table keeps crashing
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]
RE: Strange "Mull" in show fields and table keeps crashing
The `MUL` indicates that the column have multiple values. When the server `crashes`, what errors are being reported log file? -Original Message- From: Karl J. Stubsjoen [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 4:13 PM To: [EMAIL PROTECTED] 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]