samsamsam Posted July 14, 2003 Share Posted July 14, 2003 My shop has barely been up a week and already there is an error. Can you please tell me how to correct this? This is the error message I get when trying to log onto my shop... 1030 - Got error 127 from table handler delete from whos_online where time_last_click < '1058209477' [TEP STOP] -------- awaiting your replies! thanks Link to comment Share on other sites More sharing options...
Guest Posted July 14, 2003 Share Posted July 14, 2003 That , most likely is an upgrade by your host to php, your whos on line ask your host to fix the problem , or do a search on whosonline for the answer Link to comment Share on other sites More sharing options...
samsamsam Posted July 16, 2003 Author Share Posted July 16, 2003 hi horseonetwo, thanks for your response. I contacted my host and they assured me that no changes were made. Do you or anybody esle have any other ideas as to how I can correct this? I'm losing orders by the day :cry: thanks sam Link to comment Share on other sites More sharing options...
Dave_L Posted July 16, 2003 Share Posted July 16, 2003 $ perror 127 Error code 127: Unknown error 127 127 = Record-file is crashed Try the query: REPAIR TABLE whos_online Or clearing the whos_online table might also be a solution, since that table probably only contains temporary data. But I'm not sure about that. Link to comment Share on other sites More sharing options...
samsamsam Posted July 16, 2003 Author Share Posted July 16, 2003 thank you Dave; where do I make this query? Thanks in advance... sam Link to comment Share on other sites More sharing options...
wizardsandwars Posted July 16, 2003 Share Posted July 16, 2003 Your 'whos_online' table is corrupt becasue your host's cpanel update updated your MySQL server software to v4.0.1x, but your host did not update the client software to the same version. the client software 3.xx is not compatible with the server software v 4.0.1x. You need to let them know. In the meantime, you need to drop and re-create the table using 'phpmyadmin' which you should have access to from your cpanel. For more information, look through the 'Tips and Tricks' forum for "whos_online" ------------------------------------------------------------------------------------------------------------------------- NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit. If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help. Link to comment Share on other sites More sharing options...
cybervin Posted September 11, 2003 Share Posted September 11, 2003 Encounter this too, it is affected by corrupt table in database. usually whos online table, but this time its not. hence in phpmyadmin i tried selecting a few products related table and click repair. it solve the problem. see your error for clue on which tables are affected and repair the respective table accordingly should solve this. hope this help :) Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.