osCmax v2.5 User Manual
Results 1 to 3 of 3

MySQL: sessions is marked as crashed and should be repaired

This is a discussion on MySQL: sessions is marked as crashed and should be repaired within the osCmax v2 Customization/Mods forums, part of the osCmax v2.0 Forums category; Host went down yesterday and when it came back up today got this when trying to access site 145 - ...

      
  1. #1
    Active Member
    Join Date
    Apr 2007
    Posts
    207
    Rep Power
    6


    Default MySQL: sessions is marked as crashed and should be repaired

    Host went down yesterday and when it came back up today got this when trying to access site

    145 - Table './motorspo_catalog/sessions' is marked as crashed and should be repaired

    select value from sessions where sesskey = '717502f5f950b1e52c2c52dbb944dbac' and expiry > '1221739194'

    [TEP STOP]

  2. #2
    osCMax Testing Team typhus's Avatar
    Join Date
    Aug 2005
    Location
    Midlands, UK
    Posts
    28
    Rep Power
    0


    Default Re: Anyone know how to fix this!!!

    You need to open up phpmyadmin and select your site database. Find the sessions table in the list and check the box next to it. Then scroll to the bottom and select repair. That should sort things out

    I had a similar occurance when my (old) host started mucking around with the databases.

    J.

  3. #3
    jpf
    jpf is offline
    osCMax Testing Team
    jpf's Avatar
    Join Date
    Sep 2003
    Location
    Manitoba, Canada
    Posts
    2,699
    Rep Power
    22


    Default Re: Anyone know how to fix this!!!

    You can clear out all data in the session table... No problems there.
    JPF - osCMax Fourm Moderator - To contact, post on the forum or click here
    Try out our osCMax at: Live Catalog Demo
    Limited access Admin: Live Admin Demo
    Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped!

Similar Threads

  1. Spider Sessions
    By Studio143 in forum osCmax v1.7 Discussion
    Replies: 1
    Last Post: 05-14-2005, 01:21 PM
  2. Please help! sessions are breaking for some reason
    By thinkweb in forum osCmax v1.7 Discussion
    Replies: 1
    Last Post: 02-15-2005, 09:13 PM
  3. cookies and sessions ID setting
    By Dumb_Question in forum osCmax v1.7 Discussion
    Replies: 3
    Last Post: 11-16-2003, 09:44 PM
  4. Getting info out of the Sessions Table
    By Skidude in forum osCommerce 2.2 Modification Help
    Replies: 0
    Last Post: 11-08-2003, 06:05 AM
  5. Where to create /tmp for sessions
    By breag in forum osCommerce 2.2 Installation Help
    Replies: 10
    Last Post: 12-15-2002, 08:23 PM

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
  •