Jump to content

CubeCart Sessions in Database - Can it Be Cleared?


bubbaboss

Recommended Posts

CubeCart is supposed to delete any record older than X-number of hours - typically 7 days for CC608.

First, be sure to log out as a customer and as an admin, if you are currently logged in.

You can use an external utility such as phpMyAdmin to delete all the records in the CubeCart_sessions table.

CubeCart will not be damaged by this.

Link to comment
Share on other sites

This version of v6.08 is from uipgrades back from versions in the v4.5 area.

For some reason i seem to have a large sessions database file compared to other cubecart installs.

If i understand correctly i can just EMPTY that table via phpmyadmin and that will be fine?

 

Edited by bubbaboss
Link to comment
Share on other sites

The CubeCart_sessions table has these columns:

session_id
session_start
session_last
admin_id
customer_id
location
ip_address
useragent

It is session_last that is compared to a value that is X-number of seconds less than now (www.unixtimestamp.com). If any record has a value less than that answer, it is deleted.

So, if the table has too many records, then either the table has no session_last column, or the user does not have permission to delete from this table -- which is weird.

Feel free to empty the table - but do not drop the table.

Link to comment
Share on other sites

The largest sessions table size i have is 6.4mb... Is that a normal operating size?

Too me it just seemed large...

Maybe i am just noticing normal sessions table operation if 6.4mb is a common table size???

 

I DO HAVE ALL THOSE REQUIRED COLUMNS in my sessions database table

I went ahead and used EMPTY .... thanks for the Help!

Edited by bubbaboss
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...