Can't set price for any new products added since latest upgrade (1.2.9)

[Antoine]

I can't set a price (any type) to new products, while I can update products that were set before lastest upgrade.
That's kind of weird !
Any info about that ?

[netshine]

Sounds like there is something wrong with your database - please submit a support ticket giving me access to the site so I can look into it.

[Antoine]

Actually the issue only happens for newly created vendors.
I can set new products and price for older vendors, but not for newly created ones.

[netshine]

Ah, I just noticed you said 1.2.9. Is there any reason why you are not using version 1.2_10?

I just created a new product on your site ('test') and was able to modify the price ok...

[netshine]

This problem might be caused by having changed the vendor for a product, in which case, running the following SQL query on your database (eg. using phpMyAdmin) may solve the problem:

DELETE jos_inv_product_price.* FROM jos_inv_product_price LEFT JOIN jos_inv_product ON jos_inv_product_price.product_id = jos_inv_product.id AND jos_inv_product_price.vendor_id = jos_inv_product.vendor_id WHERE jos_inv_product.vendor_id is NULL

[Antoine]

Can you confirm that this sql request will no harm the product database ?
Indeed I have 19 rows returned.

[netshine]

It is safe - it only deletes 'orphan' records where a price was entered while the product was assigned to a different vendor. The most you would need to do is re-enter some of your prices, but even that should not be necessary.