SQL error in product/stock/product.php

Dernières modifications

Cédric Salvador (csalvador)

03/06/2013 11:48 (Europe/Paris)

I updated this morning and checked again, it's still happening. Do you use Mysql strict mode?

Détails
Submitted by:	Cédric Salvador (csalvador)	Submitted on:	30/05/2013 15:04
Last Modified On:	31/05/2013 18:07
Summary:	SQL error in product/stock/product.php
Description:	In product/stock/product.php, when you modify the stock value and validate without filling the unit price field, it triggers a SQL syntax error.
Step to reproduce bug:	In product/stock/product.php, try to modify the stock value. Save without filling the unit price field.
Version:	3.4.0	Category:	Module: Stocks
Severity:	7	OS Type/Version:	Archlinux
PHP version:	5.4.15	Database type and version:	MySQL 5.5.30
Etat
Status:	Open	Assigned to:	Aucun
Resolution:	Aucun

Cédric Salvador 03/06/2013 11:48: I updated this morning and checked again, it's still happening. Do you use Mysql strict mode?
Marcos García 31/05/2013 18:07: Hi Cédric.

I can't reproduce the problem... If I don't enter unit price it is set as 0.00.... I've checked the code and the unit price input is validated before saving to the database...

Can you please refresh your installation and check if it is still happening? Files affected also don't show recent changes so I don't know...
Cédric Salvador 30/05/2013 15:06: This bug is also in the Develop version

From:	Doliforge
Subject:	[Dolibarr-bugtrack] [Bug #919] SQL error in product/stock/product.php
Date:	Mon, 03 Jun 2013 11:48:55 +0200