I just installed Dolibarr on my server. It installed without problems.
But I can’t create anything. Users, groups, bank accounts…
It doesn’t give me any error. When I press “save” it just refreshes the site and stays on the same window.
Welcome @abachtold !
Are you able to tail the dolibarr log and does that share any information?
tail -f documents/dolibarr.log
There’s no log. I did search for it before. But it wasn’t created. So I manually created it, put the permissions, but it doesn’t write anything on the file.
Sorry, I didn’t know that
Here the log. I tried 2 times to create a User Group
2022-03-10 11:14:40 DEBUG 189.60.214.45 sql=SELECT DISTINCT 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 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
2022-03-10 11:14:40 NOTICE 189.60.214.45 — Access to POST - action=create, massaction=
2022-03-10 11:14:40 DEBUG 189.60.214.45 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‘pt_BR’ OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2022-03-10 11:14:40 DEBUG 189.60.214.45 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 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
2022-03-10 11:14:40 DEBUG 189.60.214.45 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help FROM llx_extrafields WHERE elementtype = ‘usergroup’ ORDER BY pos
2022-03-10 11:14:40 DEBUG 189.60.214.45 UserGroup::getrights
2022-03-10 11:14:40 DEBUG 189.60.214.45 sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as u, llx_rights_def as r WHERE r.id = u.fk_id AND r.entity = 1 AND u.entity = 1 AND u.fk_usergroup = 0 AND r.perms IS NOT NULL
2022-03-10 11:14:40 DEBUG 189.60.214.45 sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity IN (1) ORDER BY position
2022-03-10 11:14:40 INFO 189.60.214.45 DolEditor::DolEditor htmlname=note width= height=200 toolbarname=dolibarr_notes
2022-03-10 11:14:40 INFO 189.60.214.45 — End access to
2022-03-10 11:15:02 DEBUG 189.60.214.45 - This is an already logged session. _SESSION[‘dol_login’]=andre _SESSION[‘dol_entity’]=1
2022-03-10 11:15:02 DEBUG 189.60.214.45 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 as 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, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, 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, 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 = ‘andre’ ORDER BY u.entity ASC
2022-03-10 11:15:02 DEBUG 189.60.214.45 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help FROM llx_extrafields WHERE elementtype = ‘user’ ORDER BY pos
2022-03-10 11:15:02 DEBUG 189.60.214.45 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2022-03-10 11:15:02 DEBUG 189.60.214.45 DefaultValues::fetchAll
2022-03-10 11:15:02 DEBUG 189.60.214.45 sql=SELECT rowid,type,user_id,page,param,value FROM llx_default_values as t WHERE 1 = 1 AND (t.user_id IN (0,1) AND entity IN (0,1))
2022-03-10 11:15:02 DEBUG 189.60.214.45 sql=SELECT DISTINCT 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 = 1 AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2022-03-10 11:15:02 DEBUG 189.60.214.45 sql=SELECT DISTINCT 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 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
2022-03-10 11:15:02 NOTICE 189.60.214.45 — Access to POST - action=create, massaction=
2022-03-10 11:15:02 DEBUG 189.60.214.45 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang=‘pt_BR’ OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2022-03-10 11:15:02 DEBUG 189.60.214.45 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 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
2022-03-10 11:15:02 DEBUG 189.60.214.45 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help FROM llx_extrafields WHERE elementtype = ‘usergroup’ ORDER BY pos
2022-03-10 11:15:02 DEBUG 189.60.214.45 UserGroup::getrights
2022-03-10 11:15:02 DEBUG 189.60.214.45 sql=SELECT r.module, r.perms, r.subperms FROM llx_usergroup_rights as u, llx_rights_def as r WHERE r.id = u.fk_id AND r.entity = 1 AND u.entity = 1 AND u.fk_usergroup = 0 AND r.perms IS NOT NULL
2022-03-10 11:15:02 DEBUG 189.60.214.45 sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity IN (1) ORDER BY position
2022-03-10 11:15:02 INFO 189.60.214.45 DolEditor::DolEditor htmlname=note width= height=200 toolbarname=dolibarr_notes
2022-03-10 11:15:02 INFO 189.60.214.45 — End access to
Hi, did you solve your problem?, i am having exactly the same problem, can not create anything.
What is you web server, version and OS ?
We can see in your log that after receiving the action to create a group, no insert is done in your database like if the information of the group to create were not received of cleared during the post.
Do you have a proxy or some plugins on you browser that modify your http requests ?
