checkout_process page

[textbook]

Hello,

 

Whenever someone presses "Confirm Order" on "checkout_confirmation.php", I get an error message on "checkout_process.php" that says:

 

1062 - Duplicate entry '2147483647' for key 'PRIMARY'

 

Can someone please help me out with it?

 

Thank you!

[Bob Terveuren]

Hi

 

It's you database telling you that your code is trying to add a record that holds a value of '2147483647' and that value is already in there.

 

It may be an order number (but that's a lot of orders!) so, to find out go to your phpMyadmin (or whatever your host has for db access) and do a global search for 2147483647 - where that turns up is your likely suspect

[textbook]

Thx I figured it out. I just changed int to to bigint

[Bob Terveuren]

I'm impressed - that's a lot of orders!