Jump to content

Login issues


Christopher Short

Recommended Posts

If this just started, we should look first to determine if your hosting provider did anything.

But, if you are able to log in to your admin, and stay logged in, then we can probably rule out session persistence issues.

Link to comment
Share on other sites

Just now, bsmither said:

If this just started, we should look first to determine if your hosting provider did anything.

But, if you are able to log in to your admin, and stay logged in, then we can probably rule out session persistence issues.

I can stay logged in. When I go from admin and login as a customer, it doesn't login but takes me to the site home page. 

Table 'cc_CubeCart_sessions' is marked as crashed and should be repaired

last 60 secs error log:

File: [controller.admin.pre_session.inc.php] Line: [24] "SET @@time_zone = 'America/New_York'" - Unknown or incorrect time zone: 'America/New_York'
Today, 16:23 File: [session.class.php] Line: [681] "SELECT SQL_CALC_FOUND_ROWS * FROM `cc_CubeCart_sessions` WHERE cc_CubeCart_sessions.session_id = '73f0a4654995dd2b2c87c9f76ef4c79a' LIMIT 1;" - Table 'cc_CubeCart_sessions' is marked as crashed and should be repaired
Today, 16:23 File: [session.class.php] Line: [693] "INSERT INTO `cc_CubeCart_sessions` (`admin_id`,`customer_id`,`ip_address`,`location`,`session_id`,`session_last`,`session_start`,`useragent`,`acp`) VALUES ('0','0','71.92.48.70','','73f0a4654995dd2b2c87c9f76ef4c79a','1555014229','1555014229','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.86 Safari/537.36','1');" - Duplicate entry '73f0a4654995dd2b2c87c9f76ef4c79a' for key 'PRIMARY'
Today, 16:23 File: [controller.admin.pre_session.inc.php] Line: [24] "SET @@time_zone = 'America/New_York'" - Unknown or incorrect time zone: 'America/New_York'
Today, 16:23 File: [session.class.php] Line: [681] "SELECT SQL_CALC_FOUND_ROWS * FROM `cc_CubeCart_sessions` WHERE cc_CubeCart_sessions.session_id = '73f0a4654995dd2b2c87c9f76ef4c79a' LIMIT 1;" - Table 'cc_CubeCart_sessions' is marked as crashed and should be repaired
Today, 16:23 File: [session.class.php] Line: [693] "INSERT INTO `cc_CubeCart_sessions` (`admin_id`,`customer_id`,`ip_address`,`location`,`session_id`,`session_last`,`session_start`,`useragent`,`acp`) VALUES ('0','0','71.92.48.70','','73f0a4654995dd2b2c87c9f76ef4c79a','1555014221','1555014221','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.86 Safari/537.36','1');" - Duplicate entry '73f0a4654995dd2b2c87c9f76ef4c79a' for key 'PRIMARY'
Today, 16:23 File: [session.class.php] Line: [589] "UPDATE `cc_CubeCart_sessions` SET `location` = 'https://www.csrocketry.com/admin_jPwsTd.php?_g=plugins',`session_last` = '1555014221',`acp` = '1' WHERE cc_CubeCart_sessions.session_id = '73f0a4654995dd2b2c87c9f76ef4c79a';" - Table 'cc_CubeCart_sessions' is marked as crashed and should be repaired
Today, 16:23 File: [controller.admin.pre_session.inc.php] Line: [24] "SET @@time_zone = 'America/New_York'" - Unknown or incorrect time zone: 'America/New_York'
Today, 16:23 File: [session.class.php] Line: [681] "SELECT SQL_CALC_FOUND_ROWS * FROM `cc_CubeCart_sessions` WHERE cc_CubeCart_sessions.session_id = '73f0a4654995dd2b2c87c9f76ef4c79a' LIMIT 1;" - Table 'cc_CubeCart_sessions' is marked as crashed and should be repaired
Today, 16:23 File: [session.class.php] Line: [693] "INSERT INTO `cc_CubeCart_sessions` (`admin_id`,`customer_id`,`ip_address`,`location`,`session_id`,`session_last`,`session_start`,`useragent`,`acp`) VALUES ('0','0','71.92.48.70','','73f0a4654995dd2b2c87c9f76ef4c79a','1555014220','1555014220','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.86 Safari/537.36','1');" - Duplicate entry '73f0a4654995dd2b2c87c9f76ef4c79a' for key 'PRIMARY'
Today, 16:23 File: [session.class.php] Line: [589] "UPDATE `cc_CubeCart_sessions` SET `location` = 'https://www.csrocketry.com/admin_jPwsTd.php?_g=plugins',`session_last` = '1555014220',`acp` = '1' WHERE cc_CubeCart_sessions.session_id = '73f0a4654995dd2b2c87c9f76ef4c79a';" - Table 'cc_CubeCart_sessions' is marked as crashed and should be repaired
Today, 16:23 File: [controller.admin.pre_session.inc.php] Line: [24] "SET @@time_zone = 'America/New_York'" - Unknown or incorrect time zone: 'America/New_York'
Today, 16:23 File: [session.class.php] Line: [681] "SELECT SQL_CALC_FOUND_ROWS * FROM `cc_CubeCart_sessions` WHERE cc_CubeCart_sessions.session_id = '73f0a4654995dd2b2c87c9f76ef4c79a' LIMIT 1;" - Table 'cc_CubeCart_sessions' is marked as crashed and should be repaired
Today, 16:23 File: [session.class.php] Line: [693] "INSERT INTO `cc_CubeCart_sessions` (`admin_id`,`customer_id`,`ip_address`,`location`,`session_id`,`session_last`,`session_start`,`useragent`,`acp`) VALUES ('0','0','71.92.48.70','','73f0a4654995dd2b2c87c9f76ef4c79a','1555014212','1555014212','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.86 Safari/537.36','1');" - Duplicate entry '73f0a4654995dd2b2c87c9f76ef4c79a' for key 'PRIMARY'
Today, 16:23 File: [session.class.php] Line: [589] "UPDATE `cc_CubeCart_sessions` SET `location` = 'https://www.csrocketry.com/admin_jPwsTd.php?_g=plugins',`session_last` = '1555014212',`acp` = '1' WHERE cc_CubeCart_sessions.session_id = '73f0a4654995dd2b2c87c9f76ef4c79a';" - Table 'cc_CubeCart_sessions' is marked as crashed and should be repaired
Today, 16:23 File: [controller.index.inc.php] Line: [25] "SET @@time_zone = 'America/New_York'" - Unknown or incorrect time zone: 'America/New_York'
Today, 16:23 File: [session.class.php] Line: [693] "INSERT INTO `cc_CubeCart_sessions` (`admin_id`,`customer_id`,`ip_address`,`location`,`session_id`,`session_last`,`session_start`,`useragent`,`acp`) VALUES ('0','0','54.36.148.10','','3fdbc52a2e635a418f57c2ad5158a8a2','1555014187','1555014187','Mozilla/5.0 (compatible; AhrefsBot/6.1; +http://ahrefs.com/robot/)','');" - Duplicate entry '0' for key 'acp'
Link to comment
Share on other sites

A crashed table. Yup, that will also cause problems. But I haven't heard of crashed tables for quite a while.

The timezone thing can be fixed only by the database server's technical support crew. If you are your own server environment admin, then there is the task of loading a server database system table with data often found in a Linux system file. If Windows, there are timezone files one can fetch from numerous places. There are instructions aplenty on how to load the system table to be found on the internet.

Link to comment
Share on other sites

16 hours ago, bsmither said:

A crashed table. Yup, that will also cause problems. But I haven't heard of crashed tables for quite a while.

A MySQL table can very (very) rarely crash for no discernable reason (it is generally a faulty block on the disk or an issue somewhere else with the hosting either hardware or software.  The main reason you get a crashed table and this especially affects the session table in CubeCart, is if the MySQL server was not shut down correctly usually because of a server crash.

16 hours ago, bsmither said:

The timezone thing can be fixed only by the database server's technical support crew. There are instructions aplenty on how to load the system table to be found on the internet.

It is simple to do either by yourself if (as Brian says) you have admin / root access to the server but also by your hosting company (although many refuse for no good reason) and has been covered in many threads on here in the last few weeks

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...