欢迎各位兄弟 发布技术文章

这里的技术是共享的

You are here

Incorrect key file for table sessions.MYI

shiping1 的头像

Posted 05 December 2009 - 05:08 AM

Hello, i have problem with my oscommerce store, it's say

126 - Incorrect key file for table './xxxxx/sessions.MYI'; try to repair it

select value from sessions where sesskey = '63c2900be2a796f909dc88b35aed8eee' and expiry > '1259988881'

[TEP STOP]

i try to repair sessions table with phpMyAdmin by go to my database select sessions table and drop down menu with Repair Table Command (also Optimize Table) but problem is still there. Could anyone please help and point me with the right direction to solve this problem? and i would like to know if i browse sessions table >> Check All >> Delete, it will gonna work ?

anyhelp is appreciate
Thankyou 

#2  voojoo

  • Members
  • 22 posts

Posted 05 December 2009 - 07:28 AM

Case closed.

ps. i need to delete my old sessions table and create new one. thanks for come and try to solve my problem. 

#3  Xpajun

  • Members
  • 1,295 posts

Posted 05 December 2009 - 09:11 AM

I think you need to take on board the fact that this is not a instant answer forum, the people that help here are store owners just like you, not programmers paid to answer your question.

A little patience goes a long way here, and if you solve your problem in the meantime then good for you - you're learning :) just PLEASE don't moan about nonexistent help in the middle of the night 

#4  tproud

  • Members
  • 10 posts

Posted 19 May 2010 - 08:51 PM

View Postvoojoo, on 05 December 2009 - 07:28 AM, said:

Case closed.

ps. i need to delete my old sessions table and create new one. thanks for come and try to solve my problem.

Can you tell me in simple terms where to find the sessions table, step by step? Thank you so much! 

#5  mvincik

  • Members
  • 4 posts

Posted 21 May 2010 - 09:03 PM

View Posttproud, on 19 May 2010 - 08:51 PM, said:

Can you tell me in simple terms where to find the sessions table, step by step? Thank you so much!

I was getting the same error but instead of deleting the table and recreating it I just used phpmyadmin and ran this query: DELETE FROM `sessions`;

It deletes all the session info but left the table in tack. I'm back on track now... and it cleared all that waisted space in my database so it helped 2 fold.

来自 http://forums.oscommerce.com/topic/350121-126-incorrect-key-file-for-table-sessions-myi/

普通分类: