bubbaboss Posted November 29, 2015 Share Posted November 29, 2015 (edited) Is there a way to clear all sessions from this database entry (sessions) ??How can i clear it all and have it start from scratch..I am upgraded to v6.08 Thanks Edited November 29, 2015 by bubbaboss Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 29, 2015 Share Posted November 29, 2015 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. Quote Link to comment Share on other sites More sharing options...
bubbaboss Posted November 29, 2015 Author Share Posted November 29, 2015 (edited) 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 November 29, 2015 by bubbaboss Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 29, 2015 Share Posted November 29, 2015 The CubeCart_sessions table has these columns:session_idsession_startsession_lastadmin_idcustomer_idlocationip_addressuseragentIt 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. Quote Link to comment Share on other sites More sharing options...
bubbaboss Posted November 29, 2015 Author Share Posted November 29, 2015 (edited) 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 tableI went ahead and used EMPTY .... thanks for the Help! Edited November 29, 2015 by bubbaboss Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 29, 2015 Share Posted November 29, 2015 I have no answer about table size in MB. Perhaps a record count? Quote Link to comment Share on other sites More sharing options...
bubbaboss Posted November 29, 2015 Author Share Posted November 29, 2015 I will keep an eye on that table and see if it grows larger again thru the year's etc,,,I have never emptied that table or really paid it much thought over the last 7 years...The websites are all working fine... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.