Author Topic: 167 - Out of range value for column 'id' at row 1  (Read 240 times)

xixion

  • Beginner
  • *
  • Posts: 2
  • A beginner
167 - Out of range value for column 'id' at row 1
« on: June 17, 2019, 16:33:34 pm »
Hi,

I've read about this item on the forum and I have the same problem. The answer was to change from INT to BIGINT, but I can't find how to do this. Can somebody help me?
I get this error when a person is new at the site and the customer presses "Confirm Order".

kind regards
Walter

xixion

  • Beginner
  • *
  • Posts: 2
  • A beginner
Re: 167 - Out of range value for column 'id' at row 1
« Reply #1 on: June 19, 2019, 13:27:35 pm »
nobody who can help me? When I press the "order" button I get the errorpage

Studio 42

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 3905
  • Joomla & Virtuemart developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3
Re: 167 - Out of range value for column 'id' at row 1
« Reply #2 on: June 19, 2019, 15:26:40 pm »
What post you refer ?
Changing int to bigint is in the mysql table.
BUt if you need to add bigint you have more then 4294967294 records !!!