Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1062 - Duplicate entry '2147483647' for key 1


selmaboyd

Recommended Posts

Does anyone know a fix for this error? I thought I had it fixed when I set the database index key to autoincrement, but that was only a temporary fix. After a certain amount of created sessions, this error eventually pops up:

 

 

1062 - Duplicate entry '2147483647' for key 1

 

insert into sessions values ('f4df299ecc836254b3255b0d85333bad', '1148444800', 'cart|O:12:\"shoppingcart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}')

 

 

THis is how myphp admin database sessions table is set up:

 

Field Type Collation Attributes Null Default Extra

sesskey int(32) No auto_increment

expiry int(11) UNSIGNED No 0

value text latin1_swedish_ci No

 

Is there something I have configured wrong?

Link to comment
Share on other sites

I've searched various threads on here and there seems to be no definite answer to this. Or if there is anyone who has not encountered this problem could you post what your sessions table looks like please? So that I can try to configure my table to match.

 

 

Thank you

Link to comment
Share on other sites

I don't know the answer, but I'll paste my info if it helps

 

Field Type Collation Attributes Null Default Extra

sesskey varchar(32) latin1_swedish_ci No

expiry int(11) UNSIGNED No 0

value text latin1_swedish_ci No

 

any one know the answer to this please?
Link to comment
Share on other sites

I don't know the answer, but I'll paste my info if it helps

 

Field Type Collation Attributes Null Default Extra

sesskey varchar(32) latin1_swedish_ci No

expiry int(11) UNSIGNED No 0

value text latin1_swedish_ci No

 

 

Thank you. This was helpful. It turns out that this is not the problem. Something in my files thats written wrong

 

 

Thank you again for your generous kindness

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...