News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

error 167 Out of range value for column

Started by redlo, February 10, 2016, 12:35:34 PM

Previous topic - Next topic

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.
Ayudo en todo lo que puedo, con tutoriales, traducciones, y alguna que otra extension, como modulos y plugins.

redlo

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

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

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

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
---------------------------------------------
Ayudo en todo lo que puedo, con tutoriales, traducciones, y alguna que otra extension, como modulos y plugins.

Milbo

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.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

redlo

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

redlo

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

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

`virtuemart_userinfo_id` int(1) unsigned NOT NULL AUTO_INCREMENT,

change to

`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

I wonder, how many user do you have on your store?
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

redlo

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

Milbo

Very strange that you hit the upper limit.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

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
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

Milbo

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