SQL error in product/stock/product.php

Latest modifications

Laurent Destailleur (eldy)

2013-06-04 00:31 (Europe/Paris)

The bug has been corrected inside GIT sources
(http://www.github.com/Dolibarr/dolibarr).

So fix should be available with next stable release.

Changes:

Assigned to:	~~None~~ → Laurent Destailleur (eldy)
Resolution:	~~None~~ → Fixed

Details
Submitted by:	Cédric Salvador (csalvador)	Submitted on:	2013-05-30 15:04
Last Modified On:	2013-06-03 11:48
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
Status
Status:	Open	Assigned to:	Laurent Destailleur (eldy)
Resolution:	Fixed

Laurent Destailleur 2013-06-04 00:31: The bug has been corrected inside GIT sources
(http://www.github.com/Dolibarr/dolibarr).

So fix should be available with next stable release.
Cédric Salvador 2013-06-03 11:48: I updated this morning and checked again, it's still happening. Do you use Mysql strict mode?
Marcos García 2013-05-31 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 2013-05-30 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:	Tue, 04 Jun 2013 00:31:13 +0200