Zen Cart Logo
Forums / Basic Configuration / sesskey error what does this mean

sesskey error what does this mean

Views: 2,244

Results 1 to 8 of 8
11 Jun 2013, 6:04 PM
#1
cshart avatar

cshart

Zen Follower

Join Date:
Mar 2005
Posts:
370
Plugin Contributions:
0

sesskey error what does this mean

Another error [11-Jun-2013 16:19:35 UTC] PHP Fatal error: 1406:Data too long for column 'sesskey' at row 1 :: insert into sessions
values ('p3ch31qe536dftrgot0qsor15uamh2ldc9gv9mip00o1lrrr5l0nem9mbs195viosvp90apmknq58dn762j6gabpfenqohklv1s2qq3', '1370968475', 'c2VjdXJpdHlUb2tlbnxzOjMyOiJhOTlmNDc2ZTE1ZjNmMzJkZTMxZGNjM2U4NjE5N2UxYSI7bGFuZ3VhZ2V8czo3OiJlbmdsaXNoIjtsYW5ndWFnZXNfaWR8czoxOiIxIjtsYW5ndWFnZXNfY29kZXxzOjI6ImVuIjtzZWxlY3RlZF9ib3h8czoxMzoiY29uZmlndXJhdGlvbiI7aHRtbF9lZGl0b3JfcHJlZmVyZW5jZV9zdGF0dXN8czo0OiJOT05FIjs=') in sitepath//includes/classes/db/mysql/query_factory.php on line 120

Why is it generating a session key that long anyway? And how do I get that to generate correct session key length?

C

11 Jun 2013, 7:01 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: sesskey error what does this mean

It's probably your PHP configuration.

What's your server operating system?
and your PHP version?
and your PHP setting for session.hash_function? (change it back to "1" and restart Apache/PHP)

See: http://www.zen-cart.com/showthread.php?205269-Duplicate-entry-error-on-sessions-table-with-new-install-on-Mountain-Lion-Server&p=1181306#post1181306

11 Jun 2013, 7:59 PM
#3
cshart avatar

cshart

Zen Follower

Join Date:
Mar 2005
Posts:
370
Plugin Contributions:
0

Re: sesskey error what does this mean

Still Error as you can see after reset to 1

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Zen Cart!</title> <link href="includes/stylesheet.css" rel="stylesheet" type="text/css" /> </head> <body id="login" onload="document.getElementById('admin_email').focus()"> <form id="loginForm" action="https://www.withnatureinmind.com/shoppingcart/kris/password_forgotten.php?action=update" method="post"> <input type="hidden" name="securityToken" value="89888fc3a3ba448b7af55b2cb98148c8" /><fieldset> <legend>Reset Password</legend> <label for="admin_email">Admin Email Address: <input type="text" id="admin_email" name="admin_email" value="" autocomplete="off" /></label> <p class="messageStackSuccess"></p> <input type="submit" name="submit" class="button" value="request reset" /> <input type="submit" name="login" class="button" value="cancel" /> </fieldset> </form> </body> </html> <div class="systemError">WARNING: An Error occurred, please refresh the page and try again.
11 Jun 2013, 8:26 PM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: sesskey error what does this mean

You didn't answer my questions.

11 Jun 2013, 9:28 PM
#5
cshart avatar

cshart

Zen Follower

Join Date:
Mar 2005
Posts:
370
Plugin Contributions:
0

Re: sesskey error what does this mean

Sorry its a MAC server, php is 5.3.15. It’s currently running with the session_hash set to one.
mysql is 5.6.11.

11 Jun 2013, 9:29 PM
#6
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: sesskey error what does this mean

Did you restart Apache after changing the hash value? If not, it won't take effect.

11 Jun 2013, 11:49 PM
#7
cshart avatar

cshart

Zen Follower

Join Date:
Mar 2005
Posts:
370
Plugin Contributions:
0

Re: sesskey error what does this mean

Yes we did restart and here is the error we are getting from the error files still

[11-Jun-2013 23:42:53 UTC] PHP Fatal error: 1406:Data too long for column 'sesskey' at row 1 :: insert into sessions
values ('dmnlfvev2nqdoijvt7s6i7upoetpbg74cm63k1902bsqaciinjsfivt8di6320v7lirgdjjqu1kc3vhca26v27us8t6lh8p3ct12vb3', '1370995073', 'c2VjdXJpdHlUb2tlbnxzOjMyOiI2MzFlN2NkMmZkNWNlMmJhZjE3MjQ5MWZjMGVjYWI4OSI7bGFuZ3VhZ2V8czo3OiJlbmdsaXNoIjtsYW5ndWFnZXNfaWR8czoxOiIxIjtsYW5ndWFnZXNfY29kZXxzOjI6ImVuIjtzZWxlY3RlZF9ib3h8czoxMzoiY29uZmlndXJhdGlvbiI7aHRtbF9lZGl0b3JfcHJlZmVyZW5jZV9zdGF0dXN8czo0OiJOT05FIjs=') in /path/shoppingcart/includes/classes/db/mysql/query_factory.php on line 120

12 Jun 2013, 1:43 AM
#8
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
177

Re: sesskey error what does this mean

Okay, that sounds like it didn't take effect properly.
What does phpinfo() tell you about the hash setting, both for Master and Local?