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?? Link to comment https://forums.phpfreaks.com/topic/91820-got-error-127-from-storage-engine/ 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. Link to comment https://forums.phpfreaks.com/topic/91820-got-error-127-from-storage-engine/#findComment-470381 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? Link to comment https://forums.phpfreaks.com/topic/91820-got-error-127-from-storage-engine/#findComment-473037 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 Link to comment https://forums.phpfreaks.com/topic/91820-got-error-127-from-storage-engine/#findComment-473042 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? Link to comment https://forums.phpfreaks.com/topic/91820-got-error-127-from-storage-engine/#findComment-473206 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... Link to comment https://forums.phpfreaks.com/topic/91820-got-error-127-from-storage-engine/#findComment-473619 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). Link to comment https://forums.phpfreaks.com/topic/91820-got-error-127-from-storage-engine/#findComment-473624 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.. Link to comment https://forums.phpfreaks.com/topic/91820-got-error-127-from-storage-engine/#findComment-478417 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? Link to comment https://forums.phpfreaks.com/topic/91820-got-error-127-from-storage-engine/#findComment-478425 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.