Fork me on GitHub
Bienvenue, Invité
Nom d'utilisateur Mot de passe: Se souvenir de moi

MySQL error when updating selling price
(1 visualisation(s)) (1) Invité
  • Page:
  • 1

SUJET: MySQL error when updating selling price

MySQL error when updating selling price il y a 2 ans, 8 mois #14469

  • cactusman
  • Hors ligne
  • Fresh Boarder
  • Message: 5
  • Karma: 0
Hi,

I got this error when updating selling prices :

 
Dolibarr has detected a technical error.
This is information that can help to diagnose:
Dolibarr: 2.6.0
Date: 20090514164645
Level of features: 0
Server: Apache/2.2.6 (Win32) mod_ssl/2.2.6 OpenSSL/0.9.8e PHP/5.2.5
Referer: http://localhost:81/dolibarr/product/price.php?action=edit_price&id=53
Requested Url: /dolibarr/product/price.php?id=53
MenuManager: eldy_backoffice.php/eldy_backoffice.php
 
Database type manager: mysql
Request for last database access in error: INSERT INTO llx_product_price(price_level,date_price,fk_product,fk_user_author,price,price_ttc,price_base_type,envente,tva_tx, price_min,price_min_ttc) VALUES(1, 20090514164645,53,2,143,150,'HT',1,5*, 0,0)
Return code for last database access in error: DB_ERROR_SYNTAX
Information for last database access in error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 0,0)' at line 1
 


Any idea?

Re:MySQL error when updating selling price il y a 2 ans, 8 mois #14484

  • eldy
  • Hors ligne
  • Administrateur
  • Message: 2904
  • Karma: 92
You probably use a VAT Rate that is a "NPR" VAT rate.
A fix has been done in CVS and a version 2.6.1 will be released soon with this fix.
  • Page:
  • 1
Temps de génération de la page: 0.07 secondes