Author Topic: error 167 Out of range value for column  (Read 2195 times)

redlo

  • Beginner
  • *
  • Posts: 31
  • Si ayudas, te sentiras mejor.
    • www.solojoomla.com
error 167 Out of range value for column
« on: February 10, 2016, 12:35:34 pm »
When a new user buy a product without being registered, and registers and purchase during the checkout process, jump the following error ...

error 167 Out of range value for column 'virtuemart userinfo _id' at row 1 SQL=INSERT INTO ...

Help please.
Ayudo en todo lo que puedo, con tutoriales, traducciones, y alguna que otra extension, como modulos y plugins.

redlo

  • Beginner
  • *
  • Posts: 31
  • Si ayudas, te sentiras mejor.
    • www.solojoomla.com
Re: error 167 Out of range value for column
« Reply #1 on: February 10, 2016, 12:37:23 pm »
Version php 5.5 - VM 3.0.12 - Joomla 3.4.8
Ayudo en todo lo que puedo, con tutoriales, traducciones, y alguna que otra extension, como modulos y plugins.

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10070
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: error 167 Out of range value for column
« Reply #2 on: February 10, 2016, 14:33:02 pm »
error 167 Out of range value for column 'virtuemart userinfo _id' at row 1 SQL=INSERT INTO

I need the full error report.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

redlo

  • Beginner
  • *
  • Posts: 31
  • Si ayudas, te sentiras mejor.
    • www.solojoomla.com
Re: error 167 Out of range value for column
« Reply #3 on: February 10, 2016, 15:10:05 pm »
Ups !! Sorry

167 Out of range value for column 'virtuemart_userinfo_id' at row 1 SQL=INSERT INTO `w47fa_virtuemart_userinfos` (`virtuemart_user_id`,`virtuemart_userinfo_id`,`address_type`,`address_type_name`,`name`,`company`,`last_name`,`first_name`,`phone_1`,`phone_2`,`fax`,`address_1`,`address_2`,`city`,`virtuemart_state_id`,`virtuemart_country_id`,`zip`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`,`nif_cif`) VALUES ('3177','0','BT','','Prohost','','Prohost','Loren','','','','C/ las palmas','','Santomera','355','195','30140','2016-02-10 13:56:37','0','2016-02-10 13:56:37','0','0','0','34544664L')

Then go back and find that the data has been inserted into the database, active user makes a purchase perfectly, including the selection of the shipping option.

Example
--------------------------------------------
¡Gracias por su pedido!
Método de pago Contrarembolso (Recargo 5%) Mínimo 4 Euros
Nº de pedido 3YNT05564
Total 13,98 €
Ver su pedido
---------------------------------------------
Ayudo en todo lo que puedo, con tutoriales, traducciones, y alguna que otra extension, como modulos y plugins.

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10070
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: error 167 Out of range value for column
« Reply #4 on: February 10, 2016, 15:20:41 pm »
Quote
167 Out of range value for column 'virtuemart_userinfo_id' at row 1 SQL=INSERT INTO `w47fa_virtuemart_userinfos` (`virtuemart_user_id`,`virtuemart_userinfo_id`,`address_type`,`address_type_name`,`name`,`company`,`last_name`,`first_name`,`phone_1`,`phone_2`,`fax`,`address_1`,`address_2`,`city`,`virtuemart_state_id`,`virtuemart_country_id`,`zip`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`,`nif_cif`) VALUES ('3177','0',

Means that the system tries to write an entry with virtuemart_userinfo_id = 0, but that should create automatically a new entry. Strange.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

redlo

  • Beginner
  • *
  • Posts: 31
  • Si ayudas, te sentiras mejor.
    • www.solojoomla.com
Re: error 167 Out of range value for column
« Reply #5 on: February 10, 2016, 15:29:47 pm »
Yes, strange :) . What solution can have?
Ayudo en todo lo que puedo, con tutoriales, traducciones, y alguna que otra extension, como modulos y plugins.

redlo

  • Beginner
  • *
  • Posts: 31
  • Si ayudas, te sentiras mejor.
    • www.solojoomla.com
Re: error 167 Out of range value for column
« Reply #6 on: February 10, 2016, 15:31:39 pm »
The url > http://xxxx/~tattoonos/index.php?lang=es is copy of www.tattoonova.com (The same error in two sites)
Ayudo en todo lo que puedo, con tutoriales, traducciones, y alguna que otra extension, como modulos y plugins.

redlo

  • Beginner
  • *
  • Posts: 31
  • Si ayudas, te sentiras mejor.
    • www.solojoomla.com
Re: error 167 Out of range value for column
« Reply #7 on: February 10, 2016, 20:20:23 pm »
Hello, I solved the problem  :)

The last inserted value is 4294967295, and the next record and out of range of int. The records from that table start well, with auto_increment 1, but then something must happen to get to these values. I changed to bigint and it works.

In xxx_virtuemart_userinfos

Code: [Select]
`virtuemart_userinfo_id` int(1) unsigned NOT NULL AUTO_INCREMENT,
change to

Code: [Select]
`virtuemart_userinfo_id` bigint(1) unsigned NOT NULL AUTO_INCREMENT,
And now is work ;)


Ayudo en todo lo que puedo, con tutoriales, traducciones, y alguna que otra extension, como modulos y plugins.

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10070
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: error 167 Out of range value for column
« Reply #8 on: February 10, 2016, 22:50:46 pm »
I wonder, how many user do you have on your store?
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

redlo

  • Beginner
  • *
  • Posts: 31
  • Si ayudas, te sentiras mejor.
    • www.solojoomla.com
Re: error 167 Out of range value for column
« Reply #9 on: February 11, 2016, 00:04:10 am »
+ / - 3000 users
Ayudo en todo lo que puedo, con tutoriales, traducciones, y alguna que otra extension, como modulos y plugins.

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10070
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: error 167 Out of range value for column
« Reply #10 on: February 11, 2016, 18:15:23 pm »
Very strange that you hit the upper limit.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 2854
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: error 167 Out of range value for column
« Reply #11 on: February 11, 2016, 23:23:30 pm »
Do you have a number of "bad" virtuemart_userinfo_id entries ? or is it just one that has got screwed up ? Resetting the auto increment counter would be a better idea than changing the size of the storage. The number 4294967295 is astronomical. Autoincrementing one userinfo per second it would take 4294967295 / 60 / 60 / 24 / 365,25 = 136 years to reach the limit. This is simply not possible. Just my two cents.

regards

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10070
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: error 167 Out of range value for column
« Reply #12 on: February 12, 2016, 01:47:42 am »
right, nice calculation
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/