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]
