error 167 Out of range value for column

[redlo]

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.

[redlo]

Version php 5.5 - VM 3.0.12 - Joomla 3.4.8

[Milbo]

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

I need the full error report.

[redlo]

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
---------------------------------------------

[Milbo]

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.

[redlo]

Yes, strange . What solution can have?

[redlo]

The url > http://xxxx/~tattoonos/index.php?lang=es is copy of www.tattoonova.com (The same error in two sites)

[redlo]

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

[Milbo]

I wonder, how many user do you have on your store?

[redlo]

+ / - 3000 users

[Milbo]

Very strange that you hit the upper limit.

[Jörgen]

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

[Milbo]

right, nice calculation