-
Notifications
You must be signed in to change notification settings - Fork 62
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
numeric value out of range #20
Comments
Thats saying the value for row 'product_qty' is out of range. 'product_qty' cant be less than the number 0. There is a row in table where 'product_qty' is less than 0 |
I see when I bought one product the system will decrement all 'product_qty'
in table product, not only product in the chart table but all product in
table product will decrement, how about this mr? so if there are product
in table product value of 'product_qty' = 0 the system will error even
through this product not in table cart or not I bought.
…On 18 Jul 2017 2:30 a.m., "David Trushkov" ***@***.***> wrote:
Thats saying the value for row 'product_qty' is out of range.
'product_qty' cant be less than the number 0. There is a row in table where
'product_qty' is less than 0
—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
<#20 (comment)>,
or mute the thread
<https://github.com/notifications/unsubscribe-auth/AU_KjcJcLFRbkaFlG6Gh1626uF16Ty6Dks5sO7ZygaJpZM4OZeqK>
.
|
Did that solution solve your problem? |
yes Mr, thanks you a lot for your great application. |
was solved after change the code to : |
please help me :
https://stackoverflow.com/questions/45409487/decrease-product-quantity-in-database-after-checkout
On 18 Jul 2017 5:00 a.m., "ubaidillah umar" <ubaidillahumar@gmail.com>
wrote:
… I see when I bought one product the system will decrement all
'product_qty' in table product, not only product in the chart table but all
product in table product will decrement, how about this mr? so if there
are product in table product value of 'product_qty' = 0 the system will
error even through this product not in table cart or not I bought.
On 18 Jul 2017 2:30 a.m., "David Trushkov" ***@***.***>
wrote:
> Thats saying the value for row 'product_qty' is out of range.
> 'product_qty' cant be less than the number 0. There is a row in table where
> 'product_qty' is less than 0
>
> —
> You are receiving this because you authored the thread.
> Reply to this email directly, view it on GitHub
> <#20 (comment)>,
> or mute the thread
> <https://github.com/notifications/unsubscribe-auth/AU_KjcJcLFRbkaFlG6Gh1626uF16Ty6Dks5sO7ZygaJpZM4OZeqK>
> .
>
|
when I order the product, I got error :
SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in '(
store
.products
.product_qty
- 1)' (SQL: updateproducts
setproduct_qty
=product_qty
- 1)please help me.
The text was updated successfully, but these errors were encountered: