Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2008
    Location
    In the mountains
    Posts
    63
    Plugin Contributions
    0

    Default 1016 Can't open file: 'sessions.MYI' (errno: 145) - can't get in to site or admin!!

    When I go to my site http://www.beadedpatterns.com/home I get the
    "Sorry!
    There seems to be a problem connecting to our database. Please give us a few minutes to remedy the problem. Thank you."

    When I go to my admin (which I have renamed) I get
    "1016 Can't open file: 'sessions.MYI' (errno: 145)
    in:
    [select value from sessions where sesskey = 'dd6610b0bb34e6db949e31f01a25719e' and expiry > '1216533317']
    If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields."

    I was working on it the onther day and it was fine.
    When I went to work on it tonight, that's what I got!

    Any ideas of what happened or what I should do?

    Dragon

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Help! can't get in to site or admin!!

    Try going into your Control Panel for your domain and use phpMyAdmin to do a repair on your sessions table of your database ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  3. #3
    Join Date
    Jun 2008
    Location
    In the mountains
    Posts
    63
    Plugin Contributions
    0

    Default Re: Help! can't get in to site or admin!!

    I can get to the phpMyAdmin, but I really don't know what to change once I get there.
    It says that none of those pages have been changed for over a month.
    Yet my configure files say the were changed yesterday, and I don't think I was on the site at all yesterday!

    dragon

  4. #4
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Help! can't get in to site or admin!!

    In phpMyAdmin, click on the table named "sessions". Then click on the "Operations" tab, and choose the "Repair" option.

    You may be advised to talk to your hosting company for futher assistance, since that error message indicates that something's amuck with your database tables. If the problem persists you may have a database integrity problem, which your host is best equipped to fix, especially if it's resulted from a system problem on their end.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. 1016 Can't open file: 'zen_sessions.MYI'. (errno: 145)
    By puffpuff in forum General Questions
    Replies: 5
    Last Post: 20 Oct 2008, 08:12 AM
  2. 1016 Can't open file: 'sessions.MYI'. (errno: 145)
    By Majik_Imaje in forum General Questions
    Replies: 1
    Last Post: 28 Jan 2008, 10:19 PM
  3. Replies: 6
    Last Post: 15 Aug 2007, 06:10 PM
  4. 1016 Can't open file: 'zen_whos_online.MYI' (errno: 145)
    By polarduality in forum General Questions
    Replies: 5
    Last Post: 20 Oct 2006, 07:48 AM
  5. 1016 Can't open file: 'whos_online.MYI' (errno: 145)
    By ernold in forum General Questions
    Replies: 2
    Last Post: 6 Jul 2006, 11:08 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR