acidglitter Posted February 19, 2008 Share Posted February 19, 2008 I keep getting this error everyday. My table will crash, I'll repair it, then it will crash again the next day! The table is only going to get bigger. What should I do so it will stop crashing?? Quote Link to comment Share on other sites More sharing options...
aschk Posted February 19, 2008 Share Posted February 19, 2008 Sounds like you might have a hard disk failure on the way. Quote Link to comment Share on other sites More sharing options...
acidglitter Posted February 21, 2008 Author Share Posted February 21, 2008 If thats it how can I fix or prevent it? Quote Link to comment Share on other sites More sharing options...
effigy Posted February 21, 2008 Share Posted February 21, 2008 What do the logs say? http://dev.mysql.com/doc/refman/5.0/en/corrupted-myisam-tables.html Quote Link to comment Share on other sites More sharing options...
billabong0202 Posted February 21, 2008 Share Posted February 21, 2008 i think i have that same problem, no matter what i save in one of my fields, 127 the value it is given. What does that mean? Quote Link to comment Share on other sites More sharing options...
aschk Posted February 22, 2008 Share Posted February 22, 2008 LOL, you didn't say that. So basically it's putting 127 (one hundread and twenty seven) into one of the columns/fields of your table? i.e. SMALLINT ? Sounds like it's truncating the number that you're using... Quote Link to comment Share on other sites More sharing options...
fenway Posted February 22, 2008 Share Posted February 22, 2008 LOL, you didn't say that. So basically it's putting 127 (one hundread and twenty seven) into one of the columns/fields of your table? i.e. SMALLINT ? Sounds like it's truncating the number that you're using... Yes, agreed... I really wish mysql wouldn't do this silently (well, I guess it doesn't in v5). Quote Link to comment Share on other sites More sharing options...
acidglitter Posted February 27, 2008 Author Share Posted February 27, 2008 i started out with int, and then just changed them to bigint a couple weeks ago so i dont think thats it.. Quote Link to comment Share on other sites More sharing options...
fenway Posted February 27, 2008 Share Posted February 27, 2008 i think i have that same problem, no matter what i save in one of my fields, 127 the value it is given. What does that mean? What version of mysql? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.