Author Topic: Error 1690  (Read 909 times)

fabioweb

  • Jr. Member
  • **
  • Posts: 131
Error 1690
« on: November 16, 2017, 19:19:08 pm »
Hello, i'm trying to delete this error in my admin area but i have this error:
BIGINT UNSIGNED value is out of range in '(`greenlabzkitalia`.`#__virtuemart_products`.`product_sales` - 1)'

V.M 3.2.4 with Joomla 3.8.2
PHP 7.0.23
DB version 5.6.34-log

What kind of error is this?

Regards

jimjam

  • Beginner
  • *
  • Posts: 5
Re: Error 1690
« Reply #1 on: February 13, 2018, 19:35:20 pm »
I wish I new because I'm getting it also. I'm starting to get a bit fedup with VM 3.2.12, Joomla 3.8.3 blah blah blah...... What exactly is 16-8+3 for fcks sake!

Studio 42

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 3402
  • Joomla & Virtuemart addon developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3.0.x.y
Re: Error 1690
« Reply #2 on: February 13, 2018, 21:25:08 pm »
YOu should never have product_sales < 0, it's why you get this error.

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9674
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Error 1690
« Reply #3 on: February 19, 2018, 21:36:37 pm »
is also changed in the new version to (without unsigned) avoid this stupid error.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

KennethNi

  • Beginner
  • *
  • Posts: 1
  • A beginner
Re: Error 1690
« Reply #4 on: March 10, 2018, 08:56:52 am »
I'm getting the same error. Are you saying the new version fixes this, Milbo?

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9674
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Error 1690
« Reply #5 on: March 15, 2018, 15:04:22 pm »
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/