Hello, Dolibarr!
I tried to setup an Absolute Discount for my client. But, I got 5XX error as a feedback from dolibarr after I filled all fields.
I thought the problem caused from “Reason” field. It’s only my feeling. LOL
This is the error message from Chrome.
After I looked at the log, I found this report.
I paste the debug message bellow:
2023-12-25 15:03:05 DEBUG 114.142.171.2, 172.70.147.99 -> 114.142.171.2 - This is an already logged session. _SESSION['dol_login']=****** _SESSION['dol_entity']=1
2023-12-25 15:03:05 DEBUG 114.142.171.2, 172.70.147.99 -> 114.142.171.2 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_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_private, u.note_public, 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.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut as status, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.flagdelsessionsbefore, u.iplastlogin, u.ippreviouslogin, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, 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.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, u.national_registration_number, u.ref_employee, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llxeg_user as u LEFT JOIN llxeg_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxeg_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = '******' ORDER BY u.entity ASC
2023-12-25 15:03:05 DEBUG 114.142.171.2, 172.70.147.99 -> 114.142.171.2 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llxeg_extrafields WHERE elementtype = 'user' ORDER BY pos
2023-12-25 15:03:05 DEBUG 114.142.171.2, 172.70.147.99 -> 114.142.171.2 sql=SELECT param, value FROM llxeg_user_param WHERE fk_user = 1 AND entity = 1
2023-12-25 15:03:05 DEBUG 114.142.171.2, 172.70.147.99 -> 114.142.171.2 DefaultValues::fetchAll
2023-12-25 15:03:05 DEBUG 114.142.171.2, 172.70.147.99 -> 114.142.171.2 sql=SELECT rowid,type,user_id,page,param,value FROM llxeg_default_values as t WHERE 1 = 1 AND (t.user_id IN (0,1) AND entity IN (0,1))
2023-12-25 15:03:05 DEBUG 114.142.171.2, 172.70.147.99 -> 114.142.171.2 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxeg_user_rights as ur, llxeg_rights_def as r WHERE r.id = ur.fk_id AND r.entity = 1 AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL AND r.perms NOT LIKE '%_advance'
2023-12-25 15:03:05 DEBUG 114.142.171.2, 172.70.147.99 -> 114.142.171.2 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxeg_usergroup_rights as gr, llxeg_usergroup_user as gu, llxeg_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity IN (0,1) AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2023-12-25 15:03:05 NOTICE 114.142.171.2, 172.70.147.99 -> 114.142.171.2 --- Access to POST /dol/comm/remx.php - action=setremise, massaction=
2023-12-25 15:03:05 DEBUG 114.142.171.2, 172.70.147.99 -> 114.142.171.2 sql=SELECT transkey, transvalue FROM llxeg_overwrite_trans where (lang='en_US' OR lang IS NULL) AND entity IN (0, 0,1) ORDER BY lang DESC
2023-12-25 15:03:05 DEBUG 114.142.171.2, 172.70.147.99 -> 114.142.171.2 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.prefix, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llxeg_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
2023-12-25 15:03:05 DEBUG 114.142.171.2, 172.70.147.99 -> 114.142.171.2 sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.fk_warehouse, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.model_pdf, s.last_main_doc, s.code_compta, s.code_compta_fournisseur, s.accountancy_code_buy, s.accountancy_code_sell, s.vat_reverse_charge as soc_vat_reverse_charge, s.code_client, s.code_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.mode_reglement, s.cond_reglement, s.deposit_percent, s.transport_mode, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.transport_mode_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, r.rowid as region_id, r.code_region as region_code, st.libelle as stcomm, st.picto as stcomm_picto, te.code as typent_code, i.libelle as label_incoterms, s.remise_client, s.remise_supplier FROM llxeg_societe as s LEFT JOIN llxeg_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llxeg_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llxeg_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llxeg_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llxeg_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llxeg_c_regions as r ON d.fk_region = r.code_region LEFT JOIN llxeg_c_typent as te ON s.fk_typent = te.id LEFT JOIN llxeg_c_incoterms as i ON s.fk_incoterms = i.rowid WHERE s.entity IN (1) AND s.rowid = 12
2023-12-25 15:03:05 DEBUG 114.142.171.2, 172.70.147.99 -> 114.142.171.2 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llxeg_extrafields WHERE elementtype = 'societe' ORDER BY pos
2023-12-25 15:03:05 INFO 114.142.171.2, 172.70.147.99 -> 114.142.171.2 --- End access to /dol/comm/remx.php
I wish that anybody here can help me to overcome this problem since I am a dolibarr new implementor in Indonesia.
Thank you and happy super long holidays.
Best regards,
F
