osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 
 

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 - ...


Go Back   osCommerce and osCMax shopping cart software forums > osCMax v2.0 Forums > osCMax v2 Customization/Mods

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Reply

 

LinkBack Thread Tools
  #1  
Old 09-18-2008, 09:35 AM
Member
 
Join Date: Apr 2007
Posts: 55
Thanks: 2
Thanked 0 Times in 0 Posts
Rep Power: 2
cujo is on a distinguished road
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]
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
Advertisement
  #2  
Old 09-18-2008, 09:54 AM
typhus's Avatar
osCMax Testing Team
 
Join Date: Aug 2005
Location: Midlands, UK
Posts: 28
Thanks: 15
Thanked 5 Times in 3 Posts
Rep Power: 0
typhus is on a distinguished road
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3  
Old 09-18-2008, 01:20 PM
jpf's Avatar
jpf jpf is offline
Moderator

 
Join Date: Sep 2003
Location: Manitoba, Canada
Posts: 1,788
Thanks: 5
Thanked 104 Times in 90 Posts
Rep Power: 12
jpf is a name known to alljpf is a name known to alljpf is a name known to alljpf is a name known to alljpf is a name known to alljpf is a name known to all
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
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!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
Advertisement
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

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


All times are GMT -8. The time now is 01:00 AM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax