After having updated my Dolibarr 3.1.0 to the last stable release,
when I go to product/services -> list
For most of the services that have been ported to the new version (if I create a brand new service there are no problems), I get this behaviour:
I cannot modify any information and I cannot see either any information. on the second tab I get this message:
Data: 20120803160913
Dolibarr: 3.2.0
Livello di funzionalità: 0
PHP: 5.2.17
Server: Apache/2.2
URL richiesto: /cassa/htdocs/product/price.php?id=
Referer: http://www.xxx.xxx/cassa/htdocs/product/fiche.php?id=4
Gestore dei menu: eldy_backoffice.php
Gestore del tipo di database: mysqli
Richiesta dell’ultimo accesso al database in errore: SELECT p.rowid, p.price, p.price_ttc, p.price_base_type, p.tva_tx, p.recuperableonly, p.price_level, p.price_min, p.price_min_ttc, p.date_price as dp, u.rowid as user_id, u.login FROM llx_product_price as p, llx_user as u WHERE fk_product = AND p.fk_user_author = u.rowid ORDER BY p.date_price DESC, p.price_level ASC
Codice di ritorno per ultimo accesso al database in errore: DB_ERROR_SYNTAX
Informazioni sull’ultimo accesso errato al database: 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 ‘AND p.fk_user_author = u.rowid ORDER BY p.date_price DESC, p.price_level ASC’ at line 1
in the other tabs I cannot neither get in (unknown error).
BUT, if I get in using a working product and then I move through the products using the navigation arrows (top left) I can see everything!
of course on the 3.1.0 I didn’t experience this kind of issue
checking at the code it seems that somehow dolibarr cannot get the correct id ($object->id) to refer for the join query.
I guess that the error in the wuery is here: “… WHERE fk_product = AND …”
it is missing the left part of the search!! fk_product = ??
cheers
davide
