Jump to content

Recommended Posts

I'm having customer login issues....

I set up a account, when I tried to sign in to place an order, I get an error, Invalid username or password.

 

I have 3 customers in a row with the same issue. Running the most recent version, any ideas?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
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'

Share this post


Link to post
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.

Share this post


Link to post
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

Share this post


Link to post
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...