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

Booked, ordered products field get value 4294967295

Started by Venkko, December 28, 2011, 10:39:21 AM

Previous topic - Next topic

Venkko

Hi!

Is this a bug or does this 4294967295 mean something?

I am using J 1.5.23 and VM2.0.0 stable.

If I have order where is 1 pcs product xxx123 and on product xxx123 there is stock level quantity 6 and "booked, ordered product" field with value 0.
After changing order status to shipped I get stock quantity 5 (which is correct , 6-1=5) but "booked, ordered product" have value 4294967295.

I know that this situation should not come up in normal situation but on some cases this could be possible and in my case it is problem if I want to get my stock controller to work as I would like to.



[attachment cleanup by admin]
www.pikkukoala.fi (J 1.5 & VM 1.1.5)
www.lastentavarat.fi (J 1.5.23 & V2.0.0)

Milbo

haha interesting, thanks :-)

Is almost fixed, nice bug. Afaik we use unsigned int, so when you do 0-1 you get the highest number.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Venkko

So will this be fixed when VM 2.0.1 will be released?
www.pikkukoala.fi (J 1.5 & VM 1.1.5)
www.lastentavarat.fi (J 1.5.23 & V2.0.0)

Milbo

oh I just removed the unsigned from the table.... the updater will adjust this. Just change the product_in_stock and product_ordered in __virtuemart_products, remove the unsigned and it should just count -1, which is correct.

When you start from 0, when you see later -5 in your stock, you knwo that you have to order 5.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/