Can't insert product in proposal, order or invoice in develop

[saxa]

Hi, after todays updates I can no longer insert any product in proposal from the producets we have in our stock. I can insert them manually if I select the free product insertion.

Dolibarr git version of develop.

[hregis]

@saxa I can not reproduce your problem, you have errors in dolibarr.log?

[saxa]

Hmm, do you mean the server log ? I got some errors in it: this is the access log from yesterday 187.59.197.60 - - [25/May/2017:22:45:51 -0300] "GET /htdocs/includes/ckeditor/ckeditor/ckeditor.js?version=6.0.0-alpha HTTP/1.1" 304 - 187.59.197.60 - - [25/May/2017:22:45:51 -0300] "GET /htdocs/includes/jstz/jstz.min.js HTTP/1.1" 304 - 187.59.197.60 - - [25/May/2017:22:45:51 -0300] "GET /htdocs/core/js/dst.js HTTP/1.1" 304 - 187.59.197.60 - - [25/May/2017:22:45:51 -0300] "GET /htdocs/core/js/select2_locale.js.php?lang=pt_BR&version=6.0.0-alpha HTTP/1.1" 200 804 187.59.197.60 - - [25/May/2017:22:45:50 -0300] "GET /htdocs/theme/eldy/style.css.php?lang=pt_BR&theme=eldy&userid=0&entity=1&version=6.0.0-alpha HTTP/1.1" 200 111857 187.59.197.60 - - [25/May/2017:22:45:51 -0300] "GET /htdocs/core/js/datepicker.js.php?version=6.0.0-alpha HTTP/1.1" 200 1310 187.59.197.60 - - [25/May/2017:22:45:51 -0300] "GET /htdocs/core/js/lib_head.js.php?version=6.0.0-alpha HTTP/1.1" 200 33811 187.59.197.60 - - [25/May/2017:22:45:53 -0300] "GET /htdocs/theme/eldy/img/object_user.png HTTP/1.1" 304 - 187.59.197.60 - - [25/May/2017:22:45:53 -0300] "GET /htdocs/theme/eldy/img/lock.png HTTP/1.1" 304 - 187.59.197.60 - - [25/May/2017:22:45:53 -0300] "GET /htdocs/viewimage.php?cache=1&modulepart=mycompany&file=thumbs%2Flogo_brastrak_whitespace_small.jpg HTTP/1.1" 200 5464

And here is the error log: [Thu May 25 19:20:28.324561 2017] [:error] [pid 32380:tid 140370142725888] [client 177.42.206.30:39036] PHP Notice: Undefined property: stdClass::$AGENDA_DEFAULT_FILTER_TYPE in /srv/dolibarr/htdocs/core/class/conf.class.php on line 584 [Thu May 25 19:21:35.185514 2017] [:error] [pid 32380:tid 140370318972672] [client 177.42.206.30:39066] PHP Notice: Undefined property: stdClass::$AGENDA_DEFAULT_FILTER_TYPE in /srv/dolibarr/htdocs/core/class/conf.class.php on line 584, referer: http://erp.brastrak.com.br/htdocs/install/upgrade.php?action=upgrade&selectlang=it_IT&versionfrom=5.0.0&versionto=6.0.0&ignoreerrors=1 [Thu May 25 19:21:37.951094 2017] [:error] [pid 32380:tid 140370243438336] [client 177.42.206.30:39066] PHP Notice: Undefined property: stdClass::$AGENDA_DEFAULT_FILTER_TYPE in /srv/dolibarr/htdocs/core/class/conf.class.php on line 584, referer: http://erp.brastrak.com.br/htdocs/install/upgrade2.php?versionfrom=5.0.0&versionto=6.0.0 [Thu May 25 20:31:54.493942 2017] [:error] [pid 32404:tid 140370176296704] [client 93.174.95.47:51444] script '/srv/dolibarr/scripts/setup.php' not found or unable to stat

But to me they do not seem related. Good news is that now by restarting the server, it started to work. Maybe was just a problem on the server side.

I know there should be some other log in the admin tools iirc but i can not find it.

[hregis]

@saxa not the apache logs, can you activate the dolibarr log module and see the dolibarr.log in "documents" directory

[saxa]

Here it is what is from a dolibarr.log file. But the problem is that now it does work as it should so I will close this issue and if it appears again that problem i will reopen it.

2017-05-26 09:12:23 INFO 192.168.0.102 --- Access to /htdocs/theme/eldy/style.css.php - action=, massaction= 2017-05-26 09:12:23 DEBUG 192.168.0.102 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='pt_BR' 2017-05-26 09:12:23 DEBUG 192.168.0.102 Menubase::menuLoad mymainmenu=home myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0 2017-05-26 09:12:23 DEBUG 192.168.0.102 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2017-05-26 09:12:23 DEBUG 192.168.0.102 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.ref_int, u.ref_ext, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.login = 'sasa' 2017-05-26 09:12:23 DEBUG 192.168.0.102 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2017-05-26 09:12:23 INFO 192.168.0.102 --- End access to /htdocs/theme/eldy/style.css.php 2017-05-26 09:12:23 INFO 192.168.0.102 --- Access to /htdocs/core/js/lib_head.js.php - action=, massaction= 2017-05-26 09:12:23 DEBUG 192.168.0.102 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='pt_BR' 2017-05-26 09:12:23 INFO 192.168.0.102 --- End access to /htdocs/core/js/lib_head.js.php 2017-05-26 09:12:23 INFO 192.168.0.102 --- Access to /htdocs/core/js/datepicker.js.php - action=, massaction= 2017-05-26 09:12:23 DEBUG 192.168.0.102 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='pt_BR' 2017-05-26 09:12:23 INFO 192.168.0.102 --- End access to /htdocs/core/js/datepicker.js.php 2017-05-26 09:12:25 INFO 192.168.0.102 --- Access to /htdocs/viewimage.php - action=, massaction= 2017-05-26 09:12:25 INFO 192.168.0.102 modulepart=mycompany original_file=thumbs/logo_brastrak_whitespace_mini.jpg 2017-05-26 09:12:25 INFO 192.168.0.102 viewimage.php return file /srv/dolibarr/documents/mycompany/logos/thumbs/logo_brastrak_whitespace_mini.jpg content-type=image/jpeg 2017-05-26 09:12:25 INFO 192.168.0.102 --- End access to /htdocs/viewimage.php 2017-05-26 09:12:56 DEBUG 192.168.0.102 This is an already logged session. _SESSION['dol_login']=sasa _SESSION['dol_entity']=1 2017-05-26 09:12:56 DEBUG 192.168.0.102 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.email, u.job, u.skype, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.ref_int, u.ref_ext, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'sasa' 2017-05-26 09:12:56 DEBUG 192.168.0.102 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden,fielddefault,fieldcomputed FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos 2017-05-26 09:12:56 DEBUG 192.168.0.102 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 2 AND entity = 1 2017-05-26 09:12:56 DEBUG 192.168.0.102 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1,1) AND user_id IN (0, 2) 2017-05-26 09:12:56 DEBUG 192.168.0.102 sql=SELECT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND r.entity IN (0,1) AND ur.fk_user= 2 AND r.perms IS NOT NULL 2017-05-26 09:12:56 DEBUG 192.168.0.102 sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 2 AND r.perms IS NOT NULL 2017-05-26 09:12:56 INFO 192.168.0.102 --- Access to /htdocs/product/ajax/products.php - action=, massaction= 2017-05-26 09:12:56 DEBUG 192.168.0.102 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='pt_BR' 2017-05-26 09:12:56 INFO 192.168.0.102 idprod,1,1,,1,1,2,,bc 2017-05-26 09:12:56 DEBUG 192.168.0.102 Form::select_produits_list search product 2017-05-26 09:12:56 DEBUG 192.168.0.102 sql=SELECT p.rowid, p.label, p.ref, p.description, p.barcode, p.fk_product_type, p.price, p.price_ttc, p.price_base_type, p.tva_tx, p.duration, p.fk_price_expression, p.stock, pl.label as label_translated FROM llx_product as p LEFT JOIN llx_product_lang as pl ON pl.fk_product = p.rowid AND pl.lang='pt_BR' WHERE p.entity IN (1) AND p.tosell = 1 AND ((p.ref LIKE '%bc%' OR p.label LIKE '%bc%' OR pl.label LIKE '%bc%') OR p.barcode LIKE '%bc%') ORDER BY p.ref 2017-05-26 09:12:56 DEBUG 192.168.0.102 Form::constructProductListOption search price for level 1 2017-05-26 09:12:56 DEBUG 192.168.0.102 sql=SELECT price, price_ttc, price_base_type, tva_tx FROM llx_product_price WHERE fk_product='731' AND entity IN (1) AND price_level=1 ORDER BY date_price DESC, rowid DESC LIMIT 1 2017-05-26 09:12:56 DEBUG 192.168.0.102 Translate::loadCacheCurrencies 2017-05-26 09:12:56 DEBUG 192.168.0.102 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'BRL' 2017-05-26 09:12:56 DEBUG 192.168.0.102 Translate::getLabelFromKey 2017-05-26 09:12:56 DEBUG 192.168.0.102 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BRL' 2017-05-26 09:12:56 DEBUG 192.168.0.102 Form::constructProductListOption search price for level 1 2017-05-26 09:12:56 DEBUG 192.168.0.102 sql=SELECT price, price_ttc, price_base_type, tva_tx FROM llx_product_price WHERE fk_product='637' AND entity IN (1) AND price_level=1 ORDER BY date_price DESC, rowid DESC LIMIT 1 2017-05-26 09:12:56 INFO 192.168.0.102 --- End access to /htdocs/product/ajax/products.php