Salut,
j’utilise Debian Jessie avec dolibarr 4.0.0 ; l’installation se passe impec ; mais après dans « Settings », impossible de mette la langue en français.
Quand je vais pour mettre les infos de mon entreprise, pareil, rien ne s’enregistre. Je peux par contre activer les modules, dont celle de logg.
Voilà ce que j’ai dans /srv/dolibarr/documents/dolibarr.log quand je « selectionne le pays france » pour mon entreprise ; côté navigateur ça selectionne FR… Et ça me remets une page avec rien de sélectionné
root@rpiB:/var/log# tail -f /srv/dolibarr/documents/dolibarr.log
2016-09-28 23:05:52 DEBUG 192.168.1.200 This is an already logged session. _SESSION['dol_login']=root
2016-09-28 23:05:52 DEBUG 192.168.1.200 User::fetch
2016-09-28 23:05:52 DEBUG 192.168.1.200 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.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 = 'root'
2016-09-28 23:05:52 DEBUG 192.168.1.200 ExtraFields::fetch_name_optionals_label
2016-09-28 23:05:52 DEBUG 192.168.1.200 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos
2016-09-28 23:05:52 DEBUG 192.168.1.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2016-09-28 23:05:52 DEBUG 192.168.1.200 User::getrights
2016-09-28 23:05:52 DEBUG 192.168.1.200 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= 1 AND r.perms IS NOT NULL
2016-09-28 23:05:52 DEBUG 192.168.1.200 User::getrights
2016-09-28 23:05:52 DEBUG 192.168.1.200 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 = 1 AND r.perms IS NOT NULL
2016-09-28 23:05:52 INFO 192.168.1.200 --- Access to
2016-09-28 23:05:52 DEBUG 192.168.1.200 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='en_US'
2016-09-28 23:05:52 DEBUG 192.168.1.200 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0
2016-09-28 23:05:52 DEBUG 192.168.1.200 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
2016-09-28 23:05:53 DEBUG 192.168.1.200 Form::select_country
2016-09-28 23:05:53 DEBUG 192.168.1.200 sql=SELECT rowid, code as code_iso, code_iso as code_iso3, label, favorite FROM llx_c_country WHERE active > 0
2016-09-28 23:05:53 DEBUG 192.168.1.200 FormCompany::select_departement selected=, country_codeid=
2016-09-28 23:05:53 DEBUG 192.168.1.200 FormCompany::select_departement
2016-09-28 23:05:53 DEBUG 192.168.1.200 sql=SELECT d.rowid, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2016-09-28 23:05:53 DEBUG 192.168.1.200 FormCompany::select_departement num=1389
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::loadCacheCurrencies
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'AED'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'AFN'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'ALL'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'ANG'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'ARS'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'AWG'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'AZN'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BAM'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BBD'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BGN'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BMD'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BND'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BOB'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BRL'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BSD'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BWP'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BYR'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BZD'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'CLP'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'CNY'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'COP'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'CRC'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'CUP'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'CZK'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'DKK'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'DOP'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'DZD'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'EEK'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'EGP'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'FJD'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'FKP'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'GGP'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'GHC'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'GIP'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'GNF'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'GTQ'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'GYD'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'HKD'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'HNL'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'HRK'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'HUF'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'IDR'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'ILS'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'IMP'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'IRR'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'ISK'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'JEP'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'JMD'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'JPY'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'KES'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'KGS'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'KHR'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'KPW'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'KRW'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'KYD'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'KZT'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'LAK'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'LBP'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'LKR'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'LRD'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'LTL'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'LVL'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'MKD'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'MNT'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'MRO'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'MXN'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'MYR'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'MZN'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'NAD'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'NGN'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'NIO'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'NPR'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'NZD'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'OMR'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'PAB'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'PEN'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'PHP'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'PKR'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'PLN'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'PYG'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'QAR'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'RON'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'RSD'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'RUB'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SAR'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:54 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SBD'
2016-09-28 23:05:54 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SCR'
2016-09-28 23:05:55 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SEK'
2016-09-28 23:05:55 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SGD'
2016-09-28 23:05:55 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SHP'
2016-09-28 23:05:55 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SOS'
2016-09-28 23:05:55 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SRD'
2016-09-28 23:05:55 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SVC'
2016-09-28 23:05:55 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SYP'
2016-09-28 23:05:55 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'THB'
2016-09-28 23:05:55 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'TRL'
2016-09-28 23:05:55 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'TRY'
2016-09-28 23:05:55 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'TTD'
2016-09-28 23:05:55 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'TVD'
2016-09-28 23:05:55 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'TWD'
2016-09-28 23:05:55 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'UYU'
2016-09-28 23:05:55 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'UZS'
2016-09-28 23:05:55 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'VEF'
2016-09-28 23:05:55 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'VND'
2016-09-28 23:05:55 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'XCD'
2016-09-28 23:05:55 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'YER'
2016-09-28 23:05:55 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'ZAR'
2016-09-28 23:05:55 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'ZWD'
2016-09-28 23:05:55 DEBUG 192.168.1.200 useLocalTax
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = '' AND t.active = 1 AND t.localtax1_type <> '0'
2016-09-28 23:05:55 DEBUG 192.168.1.200 useLocalTax
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = '' AND t.active = 1 AND t.localtax2_type <> '0'
2016-09-28 23:05:55 INFO 192.168.1.200 --- End access to
2016-09-28 23:05:55 INFO 192.168.1.200 --- Access to
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='en_US'
2016-09-28 23:05:55 INFO 192.168.1.200 --- End access to
2016-09-28 23:05:55 INFO 192.168.1.200 --- Access to
2016-09-28 23:05:55 DEBUG 192.168.1.200 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='en_US'
2016-09-28 23:05:56 DEBUG 192.168.1.200 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0
2016-09-28 23:05:56 DEBUG 192.168.1.200 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
2016-09-28 23:05:56 DEBUG 192.168.1.200 User::fetch
2016-09-28 23:05:56 DEBUG 192.168.1.200 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.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 = 'root'
2016-09-28 23:05:56 DEBUG 192.168.1.200 ExtraFields::fetch_name_optionals_label
2016-09-28 23:05:56 DEBUG 192.168.1.200 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos
2016-09-28 23:05:56 DEBUG 192.168.1.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2016-09-28 23:05:56 INFO 192.168.1.200 --- End access to
2016-09-28 23:05:56 INFO 192.168.1.200 --- Access to
2016-09-28 23:05:56 DEBUG 192.168.1.200 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='en_US'
2016-09-28 23:05:56 INFO 192.168.1.200 --- End access to
2016-09-28 23:05:56 INFO 192.168.1.200 --- Access to
2016-09-28 23:05:56 DEBUG 192.168.1.200 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='en_US'
2016-09-28 23:05:56 INFO 192.168.1.200 --- End access to
^C
root@rpiB:/var/log# echo "" > /srv/dolibarr/documents/dolibarr.log
root@rpiB:/var/log# tail -f /srv/dolibarr/documents/dolibarr.log
2016-09-28 23:06:22 DEBUG 192.168.1.200 This is an already logged session. _SESSION['dol_login']=root
2016-09-28 23:06:22 DEBUG 192.168.1.200 User::fetch
2016-09-28 23:06:22 DEBUG 192.168.1.200 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.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 = 'root'
2016-09-28 23:06:22 DEBUG 192.168.1.200 ExtraFields::fetch_name_optionals_label
2016-09-28 23:06:22 DEBUG 192.168.1.200 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos
2016-09-28 23:06:22 DEBUG 192.168.1.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2016-09-28 23:06:22 DEBUG 192.168.1.200 User::getrights
2016-09-28 23:06:22 DEBUG 192.168.1.200 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= 1 AND r.perms IS NOT NULL
2016-09-28 23:06:22 DEBUG 192.168.1.200 User::getrights
2016-09-28 23:06:22 DEBUG 192.168.1.200 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 = 1 AND r.perms IS NOT NULL
2016-09-28 23:06:22 INFO 192.168.1.200 --- Access to
2016-09-28 23:06:22 DEBUG 192.168.1.200 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='en_US'
2016-09-28 23:06:23 DEBUG 192.168.1.200 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0
2016-09-28 23:06:23 DEBUG 192.168.1.200 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
2016-09-28 23:06:23 DEBUG 192.168.1.200 Form::select_country
2016-09-28 23:06:23 DEBUG 192.168.1.200 sql=SELECT rowid, code as code_iso, code_iso as code_iso3, label, favorite FROM llx_c_country WHERE active > 0
2016-09-28 23:06:23 DEBUG 192.168.1.200 FormCompany::select_departement selected=, country_codeid=
2016-09-28 23:06:23 DEBUG 192.168.1.200 FormCompany::select_departement
2016-09-28 23:06:23 DEBUG 192.168.1.200 sql=SELECT d.rowid, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid AND d.active = 1 AND r.active = 1 AND c.active = 1 ORDER BY c.code, d.code_departement
2016-09-28 23:06:23 DEBUG 192.168.1.200 FormCompany::select_departement num=1389
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::loadCacheCurrencies
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'AED'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'AFN'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'ALL'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'ANG'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'ARS'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'AWG'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'AZN'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BAM'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BBD'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BGN'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BMD'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BND'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BOB'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BRL'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BSD'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BWP'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BYR'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BZD'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'CLP'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'CNY'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'COP'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'CRC'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'CUP'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'CZK'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'DKK'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'DOP'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'DZD'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'EEK'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:24 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'EGP'
2016-09-28 23:06:24 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'FJD'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'FKP'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'GGP'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'GHC'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'GIP'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'GNF'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'GTQ'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'GYD'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'HKD'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'HNL'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'HRK'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'HUF'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'IDR'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'ILS'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'IMP'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'IRR'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'ISK'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'JEP'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'JMD'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'JPY'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'KES'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'KGS'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'KHR'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'KPW'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'KRW'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'KYD'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'KZT'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'LAK'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'LBP'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'LKR'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'LRD'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'LTL'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'LVL'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'MKD'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'MNT'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'MRO'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'MXN'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'MYR'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'MZN'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'NAD'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'NGN'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'NIO'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'NPR'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'NZD'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'OMR'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'PAB'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'PEN'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'PHP'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'PKR'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'PLN'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'PYG'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'QAR'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'RON'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'RSD'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'RUB'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SAR'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SBD'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SCR'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SEK'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SGD'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SHP'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SOS'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SRD'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SVC'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SYP'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'THB'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'TRL'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'TRY'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'TTD'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'TVD'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'TWD'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'UYU'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'UZS'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'VEF'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'VND'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'XCD'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'YER'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'ZAR'
2016-09-28 23:06:25 DEBUG 192.168.1.200 Translate::getLabelFromKey
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'ZWD'
2016-09-28 23:06:25 DEBUG 192.168.1.200 useLocalTax
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = '' AND t.active = 1 AND t.localtax1_type <> '0'
2016-09-28 23:06:25 DEBUG 192.168.1.200 useLocalTax
2016-09-28 23:06:25 DEBUG 192.168.1.200 sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = '' AND t.active = 1 AND t.localtax2_type <> '0'
2016-09-28 23:06:25 INFO 192.168.1.200 --- End access to
2016-09-28 23:06:26 INFO 192.168.1.200 --- Access to
2016-09-28 23:06:26 DEBUG 192.168.1.200 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='en_US'
2016-09-28 23:06:26 INFO 192.168.1.200 --- End access to
2016-09-28 23:06:26 INFO 192.168.1.200 --- Access to
2016-09-28 23:06:26 DEBUG 192.168.1.200 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='en_US'
2016-09-28 23:06:26 DEBUG 192.168.1.200 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0
2016-09-28 23:06:26 DEBUG 192.168.1.200 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
2016-09-28 23:06:26 DEBUG 192.168.1.200 User::fetch
2016-09-28 23:06:26 DEBUG 192.168.1.200 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.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 = 'root'
2016-09-28 23:06:26 DEBUG 192.168.1.200 ExtraFields::fetch_name_optionals_label
2016-09-28 23:06:26 DEBUG 192.168.1.200 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'user' ORDER BY pos
2016-09-28 23:06:26 DEBUG 192.168.1.200 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2016-09-28 23:06:26 INFO 192.168.1.200 --- End access to
2016-09-28 23:06:26 INFO 192.168.1.200 --- Access to
2016-09-28 23:06:26 DEBUG 192.168.1.200 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='en_US'
2016-09-28 23:06:27 INFO 192.168.1.200 --- End access to
2016-09-28 23:06:27 INFO 192.168.1.200 --- Access to
2016-09-28 23:06:27 DEBUG 192.168.1.200 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='en_US'
2016-09-28 23:06:27 INFO 192.168.1.200 --- End access to