API tools faq
paste
msrao

Dolibarr error

msrao
Apr 12th, 2019
197
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 113.44 KB | None | 0 0
raw download clone embed print report
  1. 2019-04-12 10:32:26 DEBUG 125.17.82.22 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1
  2. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, 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.dateemploymentend, u.ref_int, 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 erp_user as u LEFT JOIN erp_c_country as c ON u.fk_country = c.rowid LEFT JOIN erp_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC
  3. 2019-04-12 10:32:26 INFO 125.17.82.22 fetch_name_optionals_label elementtype=user
  4. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM erp_extrafields WHERE elementtype = 'user' ORDER BY pos
  5. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT param, value FROM erp_user_param WHERE fk_user = 1 AND entity = 1
  6. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT rowid, entity, type, page, param, value FROM erp_default_values WHERE entity IN (1) AND user_id IN (0, 1)
  7. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_user_rights as ur, erp_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
  8. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_usergroup_rights as gr, erp_usergroup_user as gu, erp_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
  9. 2019-04-12 10:32:26 INFO 125.17.82.22 --- Access to /erp/admin/modules.php - action=, massaction=
  10. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT transkey, transvalue FROM erp_overwrite_trans where lang='en_US'
  11. 2019-04-12 10:32:26 DEBUG 125.17.82.22 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0
  12. 2019-04-12 10:32:26 DEBUG 125.17.82.22 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 erp_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
  13. 2019-04-12 10:32:26 INFO 125.17.82.22 Scan directory /home/prakrush/public_html/erp/core/modules/ for module descriptor files (modXXX.class.php)
  14. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'adherent' AND type != 'separate' AND entity IN (0, 1)
  15. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, fieldrequired FROM erp_extrafields WHERE elementtype = 'adherent' AND entity IN (0,1)
  16. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT code, label, description FROM erp_c_action_trigger ORDER by rang
  17. 2019-04-12 10:32:26 INFO 125.17.82.22 Module modAsset not qualified
  18. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param FROM erp_extrafields WHERE elementtype = 'societe'
  19. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param FROM erp_extrafields WHERE elementtype = 'socpeople'
  20. 2019-04-12 10:32:26 INFO 125.17.82.22 Module modCollab not qualified
  21. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'commande' AND type != 'separate' AND entity IN (0, 1)
  22. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'commandedet' AND type != 'separate' AND entity IN (0, 1)
  23. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1)
  24. 2019-04-12 10:32:26 INFO 125.17.82.22 Module modDataPolicy not qualified
  25. 2019-04-12 10:32:26 DEBUG 125.17.82.22 User::loadParentOf
  26. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT fk_user as id_parent, rowid as id_son FROM erp_user WHERE fk_user <> 0 AND entity IN (0,1)
  27. 2019-04-12 10:32:26 DEBUG 125.17.82.22 User::get_full_tree get user list
  28. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT DISTINCT u.rowid, u.firstname, u.lastname, u.fk_user, u.fk_soc, u.login, u.email, u.gender, u.admin, u.statut, u.photo, u.entity FROM erp_user as u WHERE u.entity IN (0,1)
  29. 2019-04-12 10:32:26 DEBUG 125.17.82.22 User::get_full_tree call to build_path_from_id_user
  30. 2019-04-12 10:32:26 DEBUG 125.17.82.22 User::build_path_from_id_user id_user=1 protection=0
  31. 2019-04-12 10:32:26 DEBUG 125.17.82.22 User::build_path_from_id_user id_user=2 protection=0
  32. 2019-04-12 10:32:26 DEBUG 125.17.82.22 User::get_full_tree dol_sort_array
  33. 2019-04-12 10:32:26 INFO 125.17.82.22 Build childid for id = 1
  34. 2019-04-12 10:32:26 INFO 125.17.82.22 Module modDeplacement not qualified
  35. 2019-04-12 10:32:26 INFO 125.17.82.22 Module modDocumentGeneration not qualified
  36. 2019-04-12 10:32:26 INFO 125.17.82.22 Module modDynamicPrices not qualified
  37. 2019-04-12 10:32:26 INFO 125.17.82.22 Module modEmailCollector not qualified
  38. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM erp_c_type_contact as tc WHERE tc.element='commande' AND tc.source='external' ORDER BY position ASC, code
  39. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM erp_c_type_contact as tc WHERE tc.element='commande' AND tc.source='external' ORDER BY position ASC, code
  40. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'expedition' AND type != 'separate' AND entity IN (0, 1)
  41. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'expeditiondet' AND type != 'separate' AND entity IN (0, 1)
  42. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1)
  43. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'facturedet' AND type != 'separate' AND entity IN (0, 1)
  44. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1)
  45. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1)
  46. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param FROM erp_extrafields WHERE elementtype = 'facture_fourn'
  47. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param FROM erp_extrafields WHERE elementtype = 'facture_fourn_det'
  48. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param FROM erp_extrafields WHERE elementtype = 'facture_fourn'
  49. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param FROM erp_extrafields WHERE elementtype = 'commande_fournisseur'
  50. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param FROM erp_extrafields WHERE elementtype = 'commande_fournisseurdet'
  51. 2019-04-12 10:32:26 INFO 125.17.82.22 Module modHRM not qualified
  52. 2019-04-12 10:32:26 INFO 125.17.82.22 Module modLabel not qualified
  53. 2019-04-12 10:32:26 DEBUG 125.17.82.22 useNPR
  54. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT t.rowid FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.recuperableonly = 1
  55. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1)
  56. 2019-04-12 10:32:26 DEBUG 125.17.82.22 useNPR
  57. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT t.rowid FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.recuperableonly = 1
  58. 2019-04-12 10:32:26 DEBUG 125.17.82.22 useLocalTax
  59. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT t.localtax1, t.localtax2 FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.localtax1_type <> '0'
  60. 2019-04-12 10:32:26 DEBUG 125.17.82.22 useLocalTax
  61. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT t.localtax1, t.localtax2 FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.localtax2_type <> '0'
  62. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, fieldrequired FROM erp_extrafields WHERE elementtype = 'product' AND entity IN (0, 1)
  63. 2019-04-12 10:32:26 DEBUG 125.17.82.22 useNPR
  64. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT t.rowid FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.recuperableonly = 1
  65. 2019-04-12 10:32:26 DEBUG 125.17.82.22 useLocalTax
  66. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT t.localtax1, t.localtax2 FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.localtax1_type <> '0'
  67. 2019-04-12 10:32:26 DEBUG 125.17.82.22 useLocalTax
  68. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT t.localtax1, t.localtax2 FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.localtax2_type <> '0'
  69. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'projet' AND type != 'separate' AND entity IN (0, 1)
  70. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'projet_task' AND type != 'separate' AND entity IN (0, 1)
  71. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, fieldrequired FROM erp_extrafields WHERE elementtype = 'projet_task' AND entity IN (0,1)
  72. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'propal' AND type != 'separate' AND entity IN (0, 1)
  73. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'propaldet' AND type != 'separate' AND entity IN (0, 1)
  74. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1)
  75. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1)
  76. 2019-04-12 10:32:26 INFO 125.17.82.22 Module modReceiptPrinter not qualified
  77. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'resource' AND type != 'separate' AND entity IN (0, 1)
  78. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, fieldrequired FROM erp_extrafields WHERE elementtype = 'resource' AND entity IN (0,1)
  79. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type FROM erp_extrafields WHERE elementtype = 'product'
  80. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, fieldrequired FROM erp_extrafields WHERE elementtype = 'product' AND entity IN (0,1)
  81. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1)
  82. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'socpeople' AND type != 'separate' AND entity IN (0, 1)
  83. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1)
  84. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, fieldrequired FROM erp_extrafields WHERE elementtype = 'societe' AND entity IN (0,1)
  85. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, fieldrequired FROM erp_extrafields WHERE elementtype = 'socpeople' AND entity IN (0,1)
  86. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1)
  87. 2019-04-12 10:32:26 INFO 125.17.82.22 Module modTakePos not qualified
  88. 2019-04-12 10:32:26 INFO 125.17.82.22 Module modTicket not qualified
  89. 2019-04-12 10:32:26 DEBUG 125.17.82.22 sql=SELECT name, label, fieldrequired FROM erp_extrafields WHERE elementtype = 'user' AND entity IN (0,1)
  90. 2019-04-12 10:32:26 INFO 125.17.82.22 Module modWebServicesClient not qualified
  91. 2019-04-12 10:32:26 INFO 125.17.82.22 --- End access to /erp/admin/modules.php
  92. 2019-04-12 10:32:34 DEBUG 125.17.82.22 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1
  93. 2019-04-12 10:32:34 DEBUG 125.17.82.22 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, 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.dateemploymentend, u.ref_int, 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 erp_user as u LEFT JOIN erp_c_country as c ON u.fk_country = c.rowid LEFT JOIN erp_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC
  94. 2019-04-12 10:32:34 INFO 125.17.82.22 fetch_name_optionals_label elementtype=user
  95. 2019-04-12 10:32:34 DEBUG 125.17.82.22 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM erp_extrafields WHERE elementtype = 'user' ORDER BY pos
  96. 2019-04-12 10:32:34 DEBUG 125.17.82.22 sql=SELECT param, value FROM erp_user_param WHERE fk_user = 1 AND entity = 1
  97. 2019-04-12 10:32:34 DEBUG 125.17.82.22 sql=SELECT rowid, entity, type, page, param, value FROM erp_default_values WHERE entity IN (1) AND user_id IN (0, 1)
  98. 2019-04-12 10:32:34 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_user_rights as ur, erp_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
  99. 2019-04-12 10:32:34 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_usergroup_rights as gr, erp_usergroup_user as gu, erp_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
  100. 2019-04-12 10:32:34 INFO 125.17.82.22 --- Access to /erp/admin/syslog.php - action=, massaction=
  101. 2019-04-12 10:32:34 DEBUG 125.17.82.22 sql=SELECT transkey, transvalue FROM erp_overwrite_trans where lang='en_US'
  102. 2019-04-12 10:32:34 DEBUG 125.17.82.22 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0
  103. 2019-04-12 10:32:34 DEBUG 125.17.82.22 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 erp_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
  104. 2019-04-12 10:32:34 DEBUG 125.17.82.22 admin.lib::dolibarr_get_const
  105. 2019-04-12 10:32:34 DEBUG 125.17.82.22 sql=SELECT value as value FROM erp_const WHERE name = 'SYSLOG_FACILITY' AND entity = 0
  106. 2019-04-12 10:32:34 DEBUG 125.17.82.22 admin.lib::dolibarr_get_const
  107. 2019-04-12 10:32:34 DEBUG 125.17.82.22 sql=SELECT value as value FROM erp_const WHERE name = 'SYSLOG_FILE' AND entity = 0
  108. 2019-04-12 10:32:34 INFO 125.17.82.22 --- End access to /erp/admin/syslog.php
  109. 2019-04-12 10:32:46 DEBUG 125.17.82.22 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1
  110. 2019-04-12 10:32:46 DEBUG 125.17.82.22 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, 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.dateemploymentend, u.ref_int, 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 erp_user as u LEFT JOIN erp_c_country as c ON u.fk_country = c.rowid LEFT JOIN erp_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC
  111. 2019-04-12 10:32:46 INFO 125.17.82.22 fetch_name_optionals_label elementtype=user
  112. 2019-04-12 10:32:46 DEBUG 125.17.82.22 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM erp_extrafields WHERE elementtype = 'user' ORDER BY pos
  113. 2019-04-12 10:32:46 DEBUG 125.17.82.22 sql=SELECT param, value FROM erp_user_param WHERE fk_user = 1 AND entity = 1
  114. 2019-04-12 10:32:46 DEBUG 125.17.82.22 sql=SELECT rowid, entity, type, page, param, value FROM erp_default_values WHERE entity IN (1) AND user_id IN (0, 1)
  115. 2019-04-12 10:32:46 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_user_rights as ur, erp_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
  116. 2019-04-12 10:32:46 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_usergroup_rights as gr, erp_usergroup_user as gu, erp_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
  117. 2019-04-12 10:32:46 INFO 125.17.82.22 --- Access to /erp/document.php - action=, massaction=
  118. 2019-04-12 10:32:46 DEBUG 125.17.82.22 sql=SELECT transkey, transvalue FROM erp_overwrite_trans where lang='en_US'
  119. 2019-04-12 10:32:46 INFO 125.17.82.22 modulepart=logs original_file=dolibarr.log entity=1
  120. 2019-04-12 10:32:46 INFO 125.17.82.22 document.php download /home/prakrush/public_html/erp/documents/dolibarr.log filename=dolibarr.log content-type=text/plain
  121. 2019-04-12 10:32:46 INFO 125.17.82.22 --- End access to /erp/document.php
  122. 2019-04-12 10:33:00 DEBUG 125.17.82.22 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1
  123. 2019-04-12 10:33:00 DEBUG 125.17.82.22 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, 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.dateemploymentend, u.ref_int, 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 erp_user as u LEFT JOIN erp_c_country as c ON u.fk_country = c.rowid LEFT JOIN erp_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC
  124. 2019-04-12 10:33:00 INFO 125.17.82.22 fetch_name_optionals_label elementtype=user
  125. 2019-04-12 10:33:00 DEBUG 125.17.82.22 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM erp_extrafields WHERE elementtype = 'user' ORDER BY pos
  126. 2019-04-12 10:33:00 DEBUG 125.17.82.22 sql=SELECT param, value FROM erp_user_param WHERE fk_user = 1 AND entity = 1
  127. 2019-04-12 10:33:00 DEBUG 125.17.82.22 sql=SELECT rowid, entity, type, page, param, value FROM erp_default_values WHERE entity IN (1) AND user_id IN (0, 1)
  128. 2019-04-12 10:33:00 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_user_rights as ur, erp_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
  129. 2019-04-12 10:33:00 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_usergroup_rights as gr, erp_usergroup_user as gu, erp_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
  130. 2019-04-12 10:33:00 INFO 125.17.82.22 --- Access to /erp/compta/bank/list.php - action=, massaction=
  131. 2019-04-12 10:33:00 DEBUG 125.17.82.22 sql=SELECT transkey, transvalue FROM erp_overwrite_trans where lang='en_US'
  132. 2019-04-12 10:33:00 DEBUG 125.17.82.22 Menubase::menuLoad mymainmenu=bank myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0
  133. 2019-04-12 10:33:00 DEBUG 125.17.82.22 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 erp_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
  134. 2019-04-12 10:33:00 INFO 125.17.82.22 fetch_name_optionals_label elementtype=bank_account
  135. 2019-04-12 10:33:00 DEBUG 125.17.82.22 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM erp_extrafields WHERE elementtype = 'bank_account' ORDER BY pos
  136. 2019-04-12 10:33:00 DEBUG 125.17.82.22 sql=SELECT b.rowid, b.label, b.courant, b.rappro, b.account_number, b.fk_accountancy_journal, b.currency_code, b.datec as date_creation, b.tms as date_update FROM erp_bank_account as b WHERE b.entity IN (1) AND clos = 0 ORDER BY b.label ASC
  137. 2019-04-12 10:33:00 DEBUG 125.17.82.22 sql=SELECT b.rowid, b.label, b.courant, b.rappro, b.account_number, b.fk_accountancy_journal, b.currency_code, b.datec as date_creation, b.tms as date_update FROM erp_bank_account as b WHERE b.entity IN (1) AND clos = 0 ORDER BY b.label ASC LIMIT 26
  138. 2019-04-12 10:33:00 DEBUG 125.17.82.22 sql=SELECT rowid, label, courant, rappro FROM erp_bank_account WHERE entity = 1 AND clos = 0 ORDER BY label
  139. 2019-04-12 10:33:00 DEBUG 125.17.82.22 Account::fetch
  140. 2019-04-12 10:33:00 DEBUG 125.17.82.22 sql=SELECT ba.rowid, ba.ref, ba.label, ba.bank, ba.number, ba.courant, ba.clos, ba.rappro, ba.url, ba.code_banque, ba.code_guichet, ba.cle_rib, ba.bic, ba.iban_prefix as iban, ba.domiciliation, ba.proprio, ba.owner_address, ba.state_id, ba.fk_pays as country_id, ba.account_number, ba.fk_accountancy_journal, ba.currency_code, ba.min_allowed, ba.min_desired, ba.comment, ba.datec as date_creation, ba.tms as date_update, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state , aj.code as accountancy_journal FROM erp_bank_account as ba LEFT JOIN erp_c_country as c ON ba.fk_pays = c.rowid LEFT JOIN erp_c_departements as d ON ba.state_id = d.rowid LEFT JOIN erp_accounting_journal as aj ON aj.rowid=ba.fk_accountancy_journal WHERE ba.entity IN (1) AND ba.rowid = 1
  141. 2019-04-12 10:33:00 INFO 125.17.82.22 fetch_name_optionals_label elementtype=bank_account
  142. 2019-04-12 10:33:00 DEBUG 125.17.82.22 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM erp_extrafields WHERE elementtype = 'bank_account' ORDER BY pos
  143. 2019-04-12 10:33:00 DEBUG 125.17.82.22 sql=SELECT sum(amount) as amount FROM erp_bank WHERE fk_account = 1 AND dateo <= '2019-04-12 10:33:00'
  144. 2019-04-12 10:33:00 DEBUG 125.17.82.22 AccountingAccount::fetch sql=SELECT a.rowid as rowid, a.datec, a.tms, a.fk_pcg_version, a.pcg_type, a.pcg_subtype, a.account_number, a.account_parent, a.label, a.fk_accounting_category, a.fk_user_author, a.fk_user_modif, a.active, ca.label as category_label FROM erp_accounting_account as a LEFT JOIN erp_c_accounting_category as ca ON a.fk_accounting_category = ca.rowid WHERE a.account_number = '101' AND a.fk_pcg_version IN (SELECT pcg_version FROM erp_accounting_system WHERE rowid=1)
  145. 2019-04-12 10:33:00 DEBUG 125.17.82.22 sql=SELECT a.rowid as rowid, a.datec, a.tms, a.fk_pcg_version, a.pcg_type, a.pcg_subtype, a.account_number, a.account_parent, a.label, a.fk_accounting_category, a.fk_user_author, a.fk_user_modif, a.active, ca.label as category_label FROM erp_accounting_account as a LEFT JOIN erp_c_accounting_category as ca ON a.fk_accounting_category = ca.rowid WHERE a.account_number = '101' AND a.fk_pcg_version IN (SELECT pcg_version FROM erp_accounting_system WHERE rowid=1)
  146. 2019-04-12 10:33:00 DEBUG 125.17.82.22 AccountingJournal::fetch sql=SELECT rowid, code, label, nature, active FROM erp_accounting_journal WHERE rowid = 2
  147. 2019-04-12 10:33:00 DEBUG 125.17.82.22 sql=SELECT rowid, code, label, nature, active FROM erp_accounting_journal WHERE rowid = 2
  148. 2019-04-12 10:33:00 DEBUG 125.17.82.22 sql=SELECT b.rowid, b.datev as datefin FROM erp_bank as b, erp_bank_account as ba WHERE b.rappro=0 AND b.fk_account = ba.rowid AND ba.entity IN (1) AND (ba.rappro = 1 AND ba.courant != 2) AND clos = 0 AND ba.rowid = 1
  149. 2019-04-12 10:33:00 DEBUG 125.17.82.22 Translate::loadCacheCurrencies
  150. 2019-04-12 10:33:00 DEBUG 125.17.82.22 sql=SELECT code_iso, label, unicode FROM erp_c_currencies WHERE active = 1 AND code_iso = 'INR'
  151. 2019-04-12 10:33:00 DEBUG 125.17.82.22 Account::fetch
  152. 2019-04-12 10:33:00 DEBUG 125.17.82.22 sql=SELECT ba.rowid, ba.ref, ba.label, ba.bank, ba.number, ba.courant, ba.clos, ba.rappro, ba.url, ba.code_banque, ba.code_guichet, ba.cle_rib, ba.bic, ba.iban_prefix as iban, ba.domiciliation, ba.proprio, ba.owner_address, ba.state_id, ba.fk_pays as country_id, ba.account_number, ba.fk_accountancy_journal, ba.currency_code, ba.min_allowed, ba.min_desired, ba.comment, ba.datec as date_creation, ba.tms as date_update, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state , aj.code as accountancy_journal FROM erp_bank_account as ba LEFT JOIN erp_c_country as c ON ba.fk_pays = c.rowid LEFT JOIN erp_c_departements as d ON ba.state_id = d.rowid LEFT JOIN erp_accounting_journal as aj ON aj.rowid=ba.fk_accountancy_journal WHERE ba.entity IN (1) AND ba.rowid = 2
  153. 2019-04-12 10:33:00 INFO 125.17.82.22 fetch_name_optionals_label elementtype=bank_account
  154. 2019-04-12 10:33:00 DEBUG 125.17.82.22 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM erp_extrafields WHERE elementtype = 'bank_account' ORDER BY pos
  155. 2019-04-12 10:33:00 DEBUG 125.17.82.22 sql=SELECT sum(amount) as amount FROM erp_bank WHERE fk_account = 2 AND dateo <= '2019-04-12 10:33:00'
  156. 2019-04-12 10:33:00 DEBUG 125.17.82.22 AccountingAccount::fetch sql=SELECT a.rowid as rowid, a.datec, a.tms, a.fk_pcg_version, a.pcg_type, a.pcg_subtype, a.account_number, a.account_parent, a.label, a.fk_accounting_category, a.fk_user_author, a.fk_user_modif, a.active, ca.label as category_label FROM erp_accounting_account as a LEFT JOIN erp_c_accounting_category as ca ON a.fk_accounting_category = ca.rowid WHERE a.account_number = '101' AND a.fk_pcg_version IN (SELECT pcg_version FROM erp_accounting_system WHERE rowid=1)
  157. 2019-04-12 10:33:00 DEBUG 125.17.82.22 sql=SELECT a.rowid as rowid, a.datec, a.tms, a.fk_pcg_version, a.pcg_type, a.pcg_subtype, a.account_number, a.account_parent, a.label, a.fk_accounting_category, a.fk_user_author, a.fk_user_modif, a.active, ca.label as category_label FROM erp_accounting_account as a LEFT JOIN erp_c_accounting_category as ca ON a.fk_accounting_category = ca.rowid WHERE a.account_number = '101' AND a.fk_pcg_version IN (SELECT pcg_version FROM erp_accounting_system WHERE rowid=1)
  158. 2019-04-12 10:33:00 DEBUG 125.17.82.22 sql=SELECT b.rowid, b.datev as datefin FROM erp_bank as b, erp_bank_account as ba WHERE b.rappro=0 AND b.fk_account = ba.rowid AND ba.entity IN (1) AND (ba.rappro = 1 AND ba.courant != 2) AND clos = 0 AND ba.rowid = 2
  159. 2019-04-12 10:33:00 INFO 125.17.82.22 --- End access to /erp/compta/bank/list.php
  160. 2019-04-12 10:33:03 DEBUG 125.17.82.22 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1
  161. 2019-04-12 10:33:03 DEBUG 125.17.82.22 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, 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.dateemploymentend, u.ref_int, 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 erp_user as u LEFT JOIN erp_c_country as c ON u.fk_country = c.rowid LEFT JOIN erp_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC
  162. 2019-04-12 10:33:03 INFO 125.17.82.22 fetch_name_optionals_label elementtype=user
  163. 2019-04-12 10:33:03 DEBUG 125.17.82.22 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM erp_extrafields WHERE elementtype = 'user' ORDER BY pos
  164. 2019-04-12 10:33:03 DEBUG 125.17.82.22 sql=SELECT param, value FROM erp_user_param WHERE fk_user = 1 AND entity = 1
  165. 2019-04-12 10:33:03 DEBUG 125.17.82.22 sql=SELECT rowid, entity, type, page, param, value FROM erp_default_values WHERE entity IN (1) AND user_id IN (0, 1)
  166. 2019-04-12 10:33:03 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_user_rights as ur, erp_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
  167. 2019-04-12 10:33:03 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_usergroup_rights as gr, erp_usergroup_user as gu, erp_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
  168. 2019-04-12 10:33:03 INFO 125.17.82.22 --- Access to /erp/compta/index.php - action=, massaction=
  169. 2019-04-12 10:33:03 DEBUG 125.17.82.22 sql=SELECT transkey, transvalue FROM erp_overwrite_trans where lang='en_US'
  170. 2019-04-12 10:33:03 DEBUG 125.17.82.22 Menubase::menuLoad mymainmenu=billing myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0
  171. 2019-04-12 10:33:03 DEBUG 125.17.82.22 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 erp_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
  172. 2019-04-12 10:33:03 DEBUG 125.17.82.22 useLocalTax
  173. 2019-04-12 10:33:03 DEBUG 125.17.82.22 sql=SELECT t.localtax1, t.localtax2 FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.localtax1_type <> '0'
  174. 2019-04-12 10:33:03 DEBUG 125.17.82.22 useLocalTax
  175. 2019-04-12 10:33:03 DEBUG 125.17.82.22 sql=SELECT t.localtax1, t.localtax2 FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.localtax2_type <> '0'
  176. 2019-04-12 10:33:03 DEBUG 125.17.82.22 sql=SELECT f.facnumber, f.rowid, f.total as total_ht, f.tva as total_tva, f.total_ttc, f.ref_client, f.type, s.nom as name, s.rowid as socid, s.email, s.code_client, s.code_compta, s.code_fournisseur, s.code_compta_fournisseur FROM erp_facture as f, erp_societe as s WHERE s.rowid = f.fk_soc AND f.fk_statut = 0 AND f.entity = 1
  177. 2019-04-12 10:33:03 DEBUG 125.17.82.22 sql=SELECT f.ref, f.rowid, f.total_ht, f.total_tva, f.total_ttc, f.type, f.ref_supplier, s.nom as name, s.rowid as socid, s.email, s.code_fournisseur, s.code_compta_fournisseur, cc.rowid as country_id, cc.code as country_code FROM erp_facture_fourn as f, erp_societe as s LEFT JOIN erp_c_country as cc ON cc.rowid = s.fk_pays WHERE s.rowid = f.fk_soc AND f.fk_statut = 0 AND f.entity = 1
  178. 2019-04-12 10:33:03 DEBUG 125.17.82.22 sql=SELECT f.rowid, f.facnumber, f.fk_statut, f.type, f.total as total_ht, f.tva as total_tva, f.total_ttc, f.paye, f.tms, f.date_lim_reglement as datelimite, s.nom as name, s.rowid as socid, s.code_client, s.code_compta, s.email, cc.rowid as country_id, cc.code as country_code, sum(pf.amount) as am FROM erp_societe as s LEFT JOIN erp_c_country as cc ON cc.rowid = s.fk_pays, erp_facture as f LEFT JOIN erp_paiement_facture as pf on f.rowid=pf.fk_facture WHERE s.rowid = f.fk_soc AND f.entity = 1 GROUP BY f.rowid, f.facnumber, f.fk_statut, f.type, f.total, f.tva, f.total_ttc, f.paye, f.tms, f.date_lim_reglement, s.nom, s.rowid, s.code_client, s.code_compta, s.email, cc.rowid, cc.code ORDER BY f.tms DESC LIMIT 3
  179. 2019-04-12 10:33:03 DEBUG 125.17.82.22 sql=SELECT ff.rowid, ff.ref, ff.fk_statut, ff.libelle, ff.total_ht, ff.total_tva, ff.total_ttc, ff.tms, ff.paye, s.nom as name, s.rowid as socid, s.code_fournisseur, s.code_compta_fournisseur, SUM(pf.amount) as am FROM erp_societe as s, erp_facture_fourn as ff LEFT JOIN erp_paiementfourn_facturefourn as pf on ff.rowid=pf.fk_facturefourn WHERE s.rowid = ff.fk_soc AND ff.entity = 1 GROUP BY ff.rowid, ff.ref, ff.fk_statut, ff.libelle, ff.total_ht, ff.tva, ff.total_tva, ff.total_ttc, ff.tms, ff.paye, s.nom, s.rowid, s.code_fournisseur, s.code_compta_fournisseur ORDER BY ff.tms DESC LIMIT 3
  180. 2019-04-12 10:33:03 DEBUG 125.17.82.22 sql=SELECT c.rowid, c.amount, c.date_ech, c.paye, cc.libelle, SUM(pc.amount) as sumpaid FROM (erp_c_chargesociales as cc, erp_chargesociales as c) LEFT JOIN erp_paiementcharge as pc ON pc.fk_charge = c.rowid WHERE c.fk_type = cc.id AND c.entity = 1 AND c.paye = 0 GROUP BY c.rowid, c.amount, c.date_ech, c.paye, cc.libelle
  181. 2019-04-12 10:33:03 DEBUG 125.17.82.22 sql=SELECT f.rowid, f.facnumber, f.fk_statut, f.datef, f.type, f.total as total_ht, f.tva as total_tva, f.total_ttc, f.paye, f.tms, f.date_lim_reglement as datelimite, s.nom as name, s.rowid as socid, s.email, s.code_client, s.code_compta, cc.rowid as country_id, cc.code as country_code, sum(pf.amount) as am FROM erp_societe as s LEFT JOIN erp_c_country as cc ON cc.rowid = s.fk_pays,erp_facture as f LEFT JOIN erp_paiement_facture as pf on f.rowid=pf.fk_facture WHERE s.rowid = f.fk_soc AND f.paye = 0 AND f.fk_statut = 1 AND f.entity = 1 GROUP BY f.rowid, f.facnumber, f.fk_statut, f.datef, f.type, f.total, f.tva, f.total_ttc, f.paye, f.tms, f.date_lim_reglement, s.nom, s.rowid, s.email, s.code_client, s.code_compta, cc.rowid, cc.code ORDER BY f.datef ASC, f.facnumber ASC
  182. 2019-04-12 10:33:03 DEBUG 125.17.82.22 sql=SELECT ff.rowid, ff.ref, ff.fk_statut, ff.libelle, ff.total_ht, ff.total_tva, ff.total_ttc, ff.paye, ff.date_lim_reglement, s.nom as name, s.rowid as socid, s.email, s.code_client, s.code_compta, s.code_fournisseur, s.code_compta_fournisseur, sum(pf.amount) as am FROM erp_societe as s, erp_facture_fourn as ff LEFT JOIN erp_paiementfourn_facturefourn as pf on ff.rowid=pf.fk_facturefourn WHERE s.rowid = ff.fk_soc AND ff.entity = 1 AND ff.paye = 0 AND ff.fk_statut = 1 GROUP BY ff.rowid, ff.ref, ff.fk_statut, ff.libelle, ff.total_ht, ff.tva, ff.total_tva, ff.total_ttc, ff.paye, ff.date_lim_reglement, s.nom, s.rowid, s.email, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur ORDER BY ff.date_lim_reglement ASC
  183. 2019-04-12 10:33:03 INFO 125.17.82.22 --- End access to /erp/compta/index.php
  184. 2019-04-12 10:33:09 DEBUG 125.17.82.22 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1
  185. 2019-04-12 10:33:09 DEBUG 125.17.82.22 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, 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.dateemploymentend, u.ref_int, 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 erp_user as u LEFT JOIN erp_c_country as c ON u.fk_country = c.rowid LEFT JOIN erp_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC
  186. 2019-04-12 10:33:09 INFO 125.17.82.22 fetch_name_optionals_label elementtype=user
  187. 2019-04-12 10:33:09 DEBUG 125.17.82.22 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM erp_extrafields WHERE elementtype = 'user' ORDER BY pos
  188. 2019-04-12 10:33:09 DEBUG 125.17.82.22 sql=SELECT param, value FROM erp_user_param WHERE fk_user = 1 AND entity = 1
  189. 2019-04-12 10:33:09 DEBUG 125.17.82.22 sql=SELECT rowid, entity, type, page, param, value FROM erp_default_values WHERE entity IN (1) AND user_id IN (0, 1)
  190. 2019-04-12 10:33:09 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_user_rights as ur, erp_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
  191. 2019-04-12 10:33:09 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_usergroup_rights as gr, erp_usergroup_user as gu, erp_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
  192. 2019-04-12 10:33:09 INFO 125.17.82.22 --- Access to /erp/compta/salaries/list.php - action=, massaction=
  193. 2019-04-12 10:33:09 DEBUG 125.17.82.22 sql=SELECT transkey, transvalue FROM erp_overwrite_trans where lang='en_US'
  194. 2019-04-12 10:33:09 DEBUG 125.17.82.22 Menubase::menuLoad mymainmenu=billing myleftmenu=tax_salary type_user=0 menu_handler=eldy tabMenu size=0
  195. 2019-04-12 10:33:09 DEBUG 125.17.82.22 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 erp_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
  196. 2019-04-12 10:33:10 DEBUG 125.17.82.22 useLocalTax
  197. 2019-04-12 10:33:10 DEBUG 125.17.82.22 sql=SELECT t.localtax1, t.localtax2 FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.localtax1_type <> '0'
  198. 2019-04-12 10:33:10 DEBUG 125.17.82.22 useLocalTax
  199. 2019-04-12 10:33:10 DEBUG 125.17.82.22 sql=SELECT t.localtax1, t.localtax2 FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.localtax2_type <> '0'
  200. 2019-04-12 10:33:10 DEBUG 125.17.82.22 sql=SELECT u.rowid as uid, u.lastname, u.firstname, u.login, u.email, u.admin, u.salary as current_salary, u.fk_soc as fk_soc, u.statut as status, s.rowid, s.fk_user, s.amount, s.salary, s.label, s.datep as datep, s.datev as datev, s.fk_typepayment as type, s.num_payment, s.fk_bank, ba.rowid as bid, ba.ref as bref, ba.number as bnumber, ba.account_number, ba.fk_accountancy_journal, ba.label as blabel, pst.code as payment_code FROM erp_payment_salary as s LEFT JOIN erp_c_paiement as pst ON s.fk_typepayment = pst.id LEFT JOIN erp_bank as b ON s.fk_bank = b.rowid LEFT JOIN erp_bank_account as ba ON b.fk_account = ba.rowid, erp_user as u WHERE u.rowid = s.fk_user AND s.entity = 1 ORDER BY s.datep DESC, s.rowid DESC
  201. 2019-04-12 10:33:10 DEBUG 125.17.82.22 sql=SELECT u.rowid as uid, u.lastname, u.firstname, u.login, u.email, u.admin, u.salary as current_salary, u.fk_soc as fk_soc, u.statut as status, s.rowid, s.fk_user, s.amount, s.salary, s.label, s.datep as datep, s.datev as datev, s.fk_typepayment as type, s.num_payment, s.fk_bank, ba.rowid as bid, ba.ref as bref, ba.number as bnumber, ba.account_number, ba.fk_accountancy_journal, ba.label as blabel, pst.code as payment_code FROM erp_payment_salary as s LEFT JOIN erp_c_paiement as pst ON s.fk_typepayment = pst.id LEFT JOIN erp_bank as b ON s.fk_bank = b.rowid LEFT JOIN erp_bank_account as ba ON b.fk_account = ba.rowid, erp_user as u WHERE u.rowid = s.fk_user AND s.entity = 1 ORDER BY s.datep DESC, s.rowid DESC LIMIT 26
  202. 2019-04-12 10:33:10 DEBUG 125.17.82.22 Form::select_types_paiements , typeid, , 0
  203. 2019-04-12 10:33:10 DEBUG 125.17.82.22 Form::load_cache_types_paiements
  204. 2019-04-12 10:33:10 DEBUG 125.17.82.22 sql=SELECT id, code, libelle as label, type, active FROM erp_c_paiement WHERE entity IN (1)
  205. 2019-04-12 10:33:10 DEBUG 125.17.82.22 Translate::getLabelFromKey
  206. 2019-04-12 10:33:10 DEBUG 125.17.82.22 sql=SELECT libelle as label FROM erp_c_paiement WHERE code = 'LCR' AND entity IN (1)
  207. 2019-04-12 10:33:10 DEBUG 125.17.82.22 Form::select_comptes
  208. 2019-04-12 10:33:10 DEBUG 125.17.82.22 sql=SELECT rowid, label, bank, clos as status, currency_code FROM erp_bank_account WHERE entity IN (1) AND clos = '0' ORDER BY label
  209. 2019-04-12 10:33:10 INFO 125.17.82.22 --- End access to /erp/compta/salaries/list.php
  210. 2019-04-12 10:33:12 DEBUG 125.17.82.22 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1
  211. 2019-04-12 10:33:12 DEBUG 125.17.82.22 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, 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.dateemploymentend, u.ref_int, 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 erp_user as u LEFT JOIN erp_c_country as c ON u.fk_country = c.rowid LEFT JOIN erp_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC
  212. 2019-04-12 10:33:12 INFO 125.17.82.22 fetch_name_optionals_label elementtype=user
  213. 2019-04-12 10:33:12 DEBUG 125.17.82.22 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM erp_extrafields WHERE elementtype = 'user' ORDER BY pos
  214. 2019-04-12 10:33:12 DEBUG 125.17.82.22 sql=SELECT param, value FROM erp_user_param WHERE fk_user = 1 AND entity = 1
  215. 2019-04-12 10:33:12 DEBUG 125.17.82.22 sql=SELECT rowid, entity, type, page, param, value FROM erp_default_values WHERE entity IN (1) AND user_id IN (0, 1)
  216. 2019-04-12 10:33:12 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_user_rights as ur, erp_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
  217. 2019-04-12 10:33:12 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_usergroup_rights as gr, erp_usergroup_user as gu, erp_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
  218. 2019-04-12 10:33:12 INFO 125.17.82.22 --- Access to /erp/compta/salaries/card.php - action=create, massaction=
  219. 2019-04-12 10:33:12 DEBUG 125.17.82.22 sql=SELECT transkey, transvalue FROM erp_overwrite_trans where lang='en_US'
  220. 2019-04-12 10:33:12 DEBUG 125.17.82.22 Menubase::menuLoad mymainmenu=billing myleftmenu=tax_salary type_user=0 menu_handler=eldy tabMenu size=0
  221. 2019-04-12 10:33:12 DEBUG 125.17.82.22 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 erp_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
  222. 2019-04-12 10:33:12 DEBUG 125.17.82.22 useLocalTax
  223. 2019-04-12 10:33:12 DEBUG 125.17.82.22 sql=SELECT t.localtax1, t.localtax2 FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.localtax1_type <> '0'
  224. 2019-04-12 10:33:12 DEBUG 125.17.82.22 useLocalTax
  225. 2019-04-12 10:33:12 DEBUG 125.17.82.22 sql=SELECT t.localtax1, t.localtax2 FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.localtax2_type <> '0'
  226. 2019-04-12 10:33:12 DEBUG 125.17.82.22 Form::select_dolusers
  227. 2019-04-12 10:33:12 DEBUG 125.17.82.22 sql=SELECT DISTINCT u.rowid, u.lastname as lastname, u.firstname, u.statut, u.login, u.admin, u.entity FROM erp_user as u WHERE u.entity IN (0,1) AND employee=1 ORDER BY u.firstname ASC
  228. 2019-04-12 10:33:12 DEBUG 125.17.82.22 Form::select_comptes
  229. 2019-04-12 10:33:12 DEBUG 125.17.82.22 sql=SELECT rowid, label, bank, clos as status, currency_code FROM erp_bank_account WHERE entity IN (1) AND clos = '0' ORDER BY label
  230. 2019-04-12 10:33:12 DEBUG 125.17.82.22 Form::select_types_paiements , paymenttype, , 2
  231. 2019-04-12 10:33:12 DEBUG 125.17.82.22 Form::load_cache_types_paiements
  232. 2019-04-12 10:33:12 DEBUG 125.17.82.22 sql=SELECT id, code, libelle as label, type, active FROM erp_c_paiement WHERE entity IN (1)
  233. 2019-04-12 10:33:12 DEBUG 125.17.82.22 Translate::getLabelFromKey
  234. 2019-04-12 10:33:12 DEBUG 125.17.82.22 sql=SELECT libelle as label FROM erp_c_paiement WHERE code = 'LCR' AND entity IN (1)
  235. 2019-04-12 10:33:12 INFO 125.17.82.22 --- End access to /erp/compta/salaries/card.php
  236. 2019-04-12 10:33:28 DEBUG 125.17.82.22 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1
  237. 2019-04-12 10:33:28 DEBUG 125.17.82.22 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, 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.dateemploymentend, u.ref_int, 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 erp_user as u LEFT JOIN erp_c_country as c ON u.fk_country = c.rowid LEFT JOIN erp_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC
  238. 2019-04-12 10:33:28 INFO 125.17.82.22 fetch_name_optionals_label elementtype=user
  239. 2019-04-12 10:33:28 DEBUG 125.17.82.22 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM erp_extrafields WHERE elementtype = 'user' ORDER BY pos
  240. 2019-04-12 10:33:28 DEBUG 125.17.82.22 sql=SELECT param, value FROM erp_user_param WHERE fk_user = 1 AND entity = 1
  241. 2019-04-12 10:33:28 DEBUG 125.17.82.22 sql=SELECT rowid, entity, type, page, param, value FROM erp_default_values WHERE entity IN (1) AND user_id IN (0, 1)
  242. 2019-04-12 10:33:28 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_user_rights as ur, erp_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
  243. 2019-04-12 10:33:28 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_usergroup_rights as gr, erp_usergroup_user as gu, erp_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
  244. 2019-04-12 10:33:28 INFO 125.17.82.22 --- Access to /erp/compta/salaries/card.php - action=add, massaction=
  245. 2019-04-12 10:33:28 DEBUG 125.17.82.22 sql=SELECT transkey, transvalue FROM erp_overwrite_trans where lang='en_US'
  246. 2019-04-12 10:33:28 DEBUG 125.17.82.22 Menubase::menuLoad mymainmenu=billing myleftmenu=tax_salary type_user=0 menu_handler=eldy tabMenu size=0
  247. 2019-04-12 10:33:28 DEBUG 125.17.82.22 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 erp_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
  248. 2019-04-12 10:33:28 DEBUG 125.17.82.22 dol_getIdFromCode (value not found into cache)
  249. 2019-04-12 10:33:28 DEBUG 125.17.82.22 sql=SELECT id as valuetoget FROM erp_c_paiement WHERE code = 'LIQ' AND entity IN (1)
  250. 2019-04-12 10:33:28 DEBUG 125.17.82.22 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, 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.dateemploymentend, u.ref_int, 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 erp_user as u LEFT JOIN erp_c_country as c ON u.fk_country = c.rowid LEFT JOIN erp_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.rowid = 1 ORDER BY u.entity ASC
  251. 2019-04-12 10:33:28 INFO 125.17.82.22 fetch_name_optionals_label elementtype=user
  252. 2019-04-12 10:33:28 DEBUG 125.17.82.22 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM erp_extrafields WHERE elementtype = 'user' ORDER BY pos
  253. 2019-04-12 10:33:28 DEBUG 125.17.82.22 BEGIN Transaction
  254. 2019-04-12 10:33:28 DEBUG 125.17.82.22 PaymentSalary::create
  255. 2019-04-12 10:33:28 DEBUG 125.17.82.22 sql=INSERT INTO erp_payment_salary (fk_user, datep, datev, amount, fk_projet, salary, fk_typepayment, num_payment, label, datesp, dateep, fk_user_author, datec, fk_bank, entity) VALUES ('1', '2019-04-10 12:00:00', '2019-04-10 12:00:00', 500, 0, null, 4, '', 'Salary payment', '2019-03-01 12:00:00', '2019-03-31 12:00:00', '1', '2019-04-12 10:33:28', NULL, 1)
  256. 2019-04-12 10:33:28 ERR 125.17.82.22 DoliDBMysqli::query SQL Error message: DB_ERROR_1364 Field 'ref' doesn't have a default value
  257. 2019-04-12 10:33:28 DEBUG 125.17.82.22 ROLLBACK Transaction
  258. 2019-04-12 10:33:28 DEBUG 125.17.82.22 useLocalTax
  259. 2019-04-12 10:33:28 DEBUG 125.17.82.22 sql=SELECT t.localtax1, t.localtax2 FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.localtax1_type <> '0'
  260. 2019-04-12 10:33:28 DEBUG 125.17.82.22 useLocalTax
  261. 2019-04-12 10:33:28 DEBUG 125.17.82.22 sql=SELECT t.localtax1, t.localtax2 FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.localtax2_type <> '0'
  262. 2019-04-12 10:33:28 DEBUG 125.17.82.22 Form::select_dolusers
  263. 2019-04-12 10:33:28 DEBUG 125.17.82.22 sql=SELECT DISTINCT u.rowid, u.lastname as lastname, u.firstname, u.statut, u.login, u.admin, u.entity FROM erp_user as u WHERE u.entity IN (0,1) AND employee=1 ORDER BY u.firstname ASC
  264. 2019-04-12 10:33:28 DEBUG 125.17.82.22 Form::select_comptes
  265. 2019-04-12 10:33:28 DEBUG 125.17.82.22 sql=SELECT rowid, label, bank, clos as status, currency_code FROM erp_bank_account WHERE entity IN (1) AND clos = '0' ORDER BY label
  266. 2019-04-12 10:33:28 DEBUG 125.17.82.22 Form::select_types_paiements LIQ, paymenttype, , 2
  267. 2019-04-12 10:33:28 DEBUG 125.17.82.22 Form::load_cache_types_paiements
  268. 2019-04-12 10:33:28 DEBUG 125.17.82.22 sql=SELECT id, code, libelle as label, type, active FROM erp_c_paiement WHERE entity IN (1)
  269. 2019-04-12 10:33:28 DEBUG 125.17.82.22 Translate::getLabelFromKey
  270. 2019-04-12 10:33:28 DEBUG 125.17.82.22 sql=SELECT libelle as label FROM erp_c_paiement WHERE code = 'LCR' AND entity IN (1)
  271. 2019-04-12 10:33:28 INFO 125.17.82.22 --- End access to /erp/compta/salaries/card.php
  272. 2019-04-12 10:33:33 DEBUG 125.17.82.22 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1
  273. 2019-04-12 10:33:33 DEBUG 125.17.82.22 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, 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.dateemploymentend, u.ref_int, 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 erp_user as u LEFT JOIN erp_c_country as c ON u.fk_country = c.rowid LEFT JOIN erp_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC
  274. 2019-04-12 10:33:33 INFO 125.17.82.22 fetch_name_optionals_label elementtype=user
  275. 2019-04-12 10:33:33 DEBUG 125.17.82.22 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM erp_extrafields WHERE elementtype = 'user' ORDER BY pos
  276. 2019-04-12 10:33:33 DEBUG 125.17.82.22 sql=SELECT param, value FROM erp_user_param WHERE fk_user = 1 AND entity = 1
  277. 2019-04-12 10:33:33 DEBUG 125.17.82.22 sql=SELECT rowid, entity, type, page, param, value FROM erp_default_values WHERE entity IN (1) AND user_id IN (0, 1)
  278. 2019-04-12 10:33:33 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_user_rights as ur, erp_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
  279. 2019-04-12 10:33:33 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_usergroup_rights as gr, erp_usergroup_user as gu, erp_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
  280. 2019-04-12 10:33:33 INFO 125.17.82.22 --- Access to /erp/compta/bank/various_payment/list.php - action=, massaction=
  281. 2019-04-12 10:33:33 DEBUG 125.17.82.22 sql=SELECT transkey, transvalue FROM erp_overwrite_trans where lang='en_US'
  282. 2019-04-12 10:33:33 DEBUG 125.17.82.22 Menubase::menuLoad mymainmenu=billing myleftmenu=tax_various type_user=0 menu_handler=eldy tabMenu size=0
  283. 2019-04-12 10:33:33 DEBUG 125.17.82.22 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 erp_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
  284. 2019-04-12 10:33:33 DEBUG 125.17.82.22 useLocalTax
  285. 2019-04-12 10:33:33 DEBUG 125.17.82.22 sql=SELECT t.localtax1, t.localtax2 FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.localtax1_type <> '0'
  286. 2019-04-12 10:33:33 DEBUG 125.17.82.22 useLocalTax
  287. 2019-04-12 10:33:33 DEBUG 125.17.82.22 sql=SELECT t.localtax1, t.localtax2 FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.localtax2_type <> '0'
  288. 2019-04-12 10:33:33 DEBUG 125.17.82.22 sql=SELECT v.rowid, v.sens, v.amount, v.label, v.datep as datep, v.datev as datev, v.fk_typepayment as type, v.num_payment, v.fk_bank, v.accountancy_code, ba.rowid as bid, ba.ref as bref, ba.number as bnumber, ba.account_number as bank_account_number, ba.fk_accountancy_journal as accountancy_journal, ba.label as blabel, pst.code as payment_code FROM erp_payment_various as v LEFT JOIN erp_c_paiement as pst ON v.fk_typepayment = pst.id LEFT JOIN erp_bank as b ON v.fk_bank = b.rowid LEFT JOIN erp_bank_account as ba ON b.fk_account = ba.rowid WHERE v.entity IN (1) ORDER BY v.datep DESC
  289. 2019-04-12 10:33:33 DEBUG 125.17.82.22 sql=SELECT v.rowid, v.sens, v.amount, v.label, v.datep as datep, v.datev as datev, v.fk_typepayment as type, v.num_payment, v.fk_bank, v.accountancy_code, ba.rowid as bid, ba.ref as bref, ba.number as bnumber, ba.account_number as bank_account_number, ba.fk_accountancy_journal as accountancy_journal, ba.label as blabel, pst.code as payment_code FROM erp_payment_various as v LEFT JOIN erp_c_paiement as pst ON v.fk_typepayment = pst.id LEFT JOIN erp_bank as b ON v.fk_bank = b.rowid LEFT JOIN erp_bank_account as ba ON b.fk_account = ba.rowid WHERE v.entity IN (1) ORDER BY v.datep DESC LIMIT 26
  290. 2019-04-12 10:33:33 DEBUG 125.17.82.22 Form::select_types_paiements , typeid, , 0
  291. 2019-04-12 10:33:33 DEBUG 125.17.82.22 Form::load_cache_types_paiements
  292. 2019-04-12 10:33:33 DEBUG 125.17.82.22 sql=SELECT id, code, libelle as label, type, active FROM erp_c_paiement WHERE entity IN (1)
  293. 2019-04-12 10:33:33 DEBUG 125.17.82.22 Translate::getLabelFromKey
  294. 2019-04-12 10:33:33 DEBUG 125.17.82.22 sql=SELECT libelle as label FROM erp_c_paiement WHERE code = 'LCR' AND entity IN (1)
  295. 2019-04-12 10:33:33 DEBUG 125.17.82.22 Form::select_comptes
  296. 2019-04-12 10:33:33 DEBUG 125.17.82.22 sql=SELECT rowid, label, bank, clos as status, currency_code FROM erp_bank_account WHERE entity IN (1) AND clos = '0' ORDER BY label
  297. 2019-04-12 10:33:33 DEBUG 125.17.82.22 FormAccounting::select_account
  298. 2019-04-12 10:33:33 DEBUG 125.17.82.22 sql=SELECT DISTINCT aa.account_number, aa.label, aa.rowid, aa.fk_pcg_version FROM erp_accounting_account as aa INNER JOIN erp_accounting_system as asy ON aa.fk_pcg_version = asy.pcg_version AND asy.rowid = 1 AND aa.active = 1 AND aa.entity=1 ORDER BY aa.account_number
  299. 2019-04-12 10:33:33 INFO 125.17.82.22 --- End access to /erp/compta/bank/various_payment/list.php
  300. 2019-04-12 10:33:35 DEBUG 125.17.82.22 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1
  301. 2019-04-12 10:33:35 DEBUG 125.17.82.22 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, 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.dateemploymentend, u.ref_int, 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 erp_user as u LEFT JOIN erp_c_country as c ON u.fk_country = c.rowid LEFT JOIN erp_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC
  302. 2019-04-12 10:33:35 INFO 125.17.82.22 fetch_name_optionals_label elementtype=user
  303. 2019-04-12 10:33:35 DEBUG 125.17.82.22 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM erp_extrafields WHERE elementtype = 'user' ORDER BY pos
  304. 2019-04-12 10:33:35 DEBUG 125.17.82.22 sql=SELECT param, value FROM erp_user_param WHERE fk_user = 1 AND entity = 1
  305. 2019-04-12 10:33:35 DEBUG 125.17.82.22 sql=SELECT rowid, entity, type, page, param, value FROM erp_default_values WHERE entity IN (1) AND user_id IN (0, 1)
  306. 2019-04-12 10:33:35 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_user_rights as ur, erp_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
  307. 2019-04-12 10:33:35 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_usergroup_rights as gr, erp_usergroup_user as gu, erp_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
  308. 2019-04-12 10:33:35 INFO 125.17.82.22 --- Access to /erp/compta/bank/various_payment/card.php - action=create, massaction=
  309. 2019-04-12 10:33:35 DEBUG 125.17.82.22 sql=SELECT transkey, transvalue FROM erp_overwrite_trans where lang='en_US'
  310. 2019-04-12 10:33:35 DEBUG 125.17.82.22 Menubase::menuLoad mymainmenu=billing myleftmenu=tax_various type_user=0 menu_handler=eldy tabMenu size=0
  311. 2019-04-12 10:33:35 DEBUG 125.17.82.22 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 erp_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
  312. 2019-04-12 10:33:35 DEBUG 125.17.82.22 useLocalTax
  313. 2019-04-12 10:33:35 DEBUG 125.17.82.22 sql=SELECT t.localtax1, t.localtax2 FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.localtax1_type <> '0'
  314. 2019-04-12 10:33:35 DEBUG 125.17.82.22 useLocalTax
  315. 2019-04-12 10:33:35 DEBUG 125.17.82.22 sql=SELECT t.localtax1, t.localtax2 FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.localtax2_type <> '0'
  316. 2019-04-12 10:33:35 DEBUG 125.17.82.22 Form::select_comptes
  317. 2019-04-12 10:33:35 DEBUG 125.17.82.22 sql=SELECT rowid, label, bank, clos as status, currency_code FROM erp_bank_account WHERE entity IN (1) AND clos = '0' ORDER BY label
  318. 2019-04-12 10:33:35 DEBUG 125.17.82.22 Form::select_types_paiements , paymenttype, , 0
  319. 2019-04-12 10:33:35 DEBUG 125.17.82.22 Form::load_cache_types_paiements
  320. 2019-04-12 10:33:35 DEBUG 125.17.82.22 sql=SELECT id, code, libelle as label, type, active FROM erp_c_paiement WHERE entity IN (1)
  321. 2019-04-12 10:33:35 DEBUG 125.17.82.22 Translate::getLabelFromKey
  322. 2019-04-12 10:33:35 DEBUG 125.17.82.22 sql=SELECT libelle as label FROM erp_c_paiement WHERE code = 'LCR' AND entity IN (1)
  323. 2019-04-12 10:33:35 DEBUG 125.17.82.22 FormAccounting::select_account
  324. 2019-04-12 10:33:35 DEBUG 125.17.82.22 sql=SELECT DISTINCT aa.account_number, aa.label, aa.rowid, aa.fk_pcg_version FROM erp_accounting_account as aa INNER JOIN erp_accounting_system as asy ON aa.fk_pcg_version = asy.pcg_version AND asy.rowid = 1 AND aa.active = 1 AND aa.entity=1 ORDER BY aa.account_number
  325. 2019-04-12 10:33:35 INFO 125.17.82.22 --- End access to /erp/compta/bank/various_payment/card.php
  326. 2019-04-12 10:33:48 DEBUG 125.17.82.22 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1
  327. 2019-04-12 10:33:48 DEBUG 125.17.82.22 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, 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.dateemploymentend, u.ref_int, 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 erp_user as u LEFT JOIN erp_c_country as c ON u.fk_country = c.rowid LEFT JOIN erp_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC
  328. 2019-04-12 10:33:48 INFO 125.17.82.22 fetch_name_optionals_label elementtype=user
  329. 2019-04-12 10:33:48 DEBUG 125.17.82.22 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM erp_extrafields WHERE elementtype = 'user' ORDER BY pos
  330. 2019-04-12 10:33:48 DEBUG 125.17.82.22 sql=SELECT param, value FROM erp_user_param WHERE fk_user = 1 AND entity = 1
  331. 2019-04-12 10:33:48 DEBUG 125.17.82.22 sql=SELECT rowid, entity, type, page, param, value FROM erp_default_values WHERE entity IN (1) AND user_id IN (0, 1)
  332. 2019-04-12 10:33:48 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_user_rights as ur, erp_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
  333. 2019-04-12 10:33:48 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_usergroup_rights as gr, erp_usergroup_user as gu, erp_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
  334. 2019-04-12 10:33:48 INFO 125.17.82.22 --- Access to /erp/compta/bank/various_payment/card.php - action=add, massaction=
  335. 2019-04-12 10:33:48 DEBUG 125.17.82.22 sql=SELECT transkey, transvalue FROM erp_overwrite_trans where lang='en_US'
  336. 2019-04-12 10:33:48 DEBUG 125.17.82.22 Menubase::menuLoad mymainmenu=billing myleftmenu=tax_various type_user=0 menu_handler=eldy tabMenu size=0
  337. 2019-04-12 10:33:48 DEBUG 125.17.82.22 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 erp_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
  338. 2019-04-12 10:33:48 DEBUG 125.17.82.22 BEGIN Transaction
  339. 2019-04-12 10:33:48 DEBUG 125.17.82.22 PaymentVarious::create
  340. 2019-04-12 10:33:48 DEBUG 125.17.82.22 sql=INSERT INTO erp_payment_various ( datep, datev, sens, amount, fk_typepayment, num_payment, label, accountancy_code, fk_projet, fk_user_author, datec, fk_bank, entity) VALUES ('2019-04-11 12:00:00', '2019-04-11 12:00:00', '0', 500, '4', '', 'Miscellaneous payments', '101', 0, 1, '2019-04-12 10:33:48', NULL, 1)
  341. 2019-04-12 10:33:48 ERR 125.17.82.22 DoliDBMysqli::query SQL Error message: DB_ERROR_1364 Field 'ref' doesn't have a default value
  342. 2019-04-12 10:33:48 DEBUG 125.17.82.22 ROLLBACK Transaction
  343. 2019-04-12 10:33:48 DEBUG 125.17.82.22 useLocalTax
  344. 2019-04-12 10:33:48 DEBUG 125.17.82.22 sql=SELECT t.localtax1, t.localtax2 FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.localtax1_type <> '0'
  345. 2019-04-12 10:33:48 DEBUG 125.17.82.22 useLocalTax
  346. 2019-04-12 10:33:48 DEBUG 125.17.82.22 sql=SELECT t.localtax1, t.localtax2 FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.localtax2_type <> '0'
  347. 2019-04-12 10:33:48 DEBUG 125.17.82.22 Form::select_comptes
  348. 2019-04-12 10:33:48 DEBUG 125.17.82.22 sql=SELECT rowid, label, bank, clos as status, currency_code FROM erp_bank_account WHERE entity IN (1) AND clos = '0' ORDER BY label
  349. 2019-04-12 10:33:48 DEBUG 125.17.82.22 Form::select_types_paiements 4, paymenttype, , 0
  350. 2019-04-12 10:33:48 DEBUG 125.17.82.22 Form::load_cache_types_paiements
  351. 2019-04-12 10:33:48 DEBUG 125.17.82.22 sql=SELECT id, code, libelle as label, type, active FROM erp_c_paiement WHERE entity IN (1)
  352. 2019-04-12 10:33:48 DEBUG 125.17.82.22 Translate::getLabelFromKey
  353. 2019-04-12 10:33:48 DEBUG 125.17.82.22 sql=SELECT libelle as label FROM erp_c_paiement WHERE code = 'LCR' AND entity IN (1)
  354. 2019-04-12 10:33:48 DEBUG 125.17.82.22 FormAccounting::select_account
  355. 2019-04-12 10:33:48 DEBUG 125.17.82.22 sql=SELECT DISTINCT aa.account_number, aa.label, aa.rowid, aa.fk_pcg_version FROM erp_accounting_account as aa INNER JOIN erp_accounting_system as asy ON aa.fk_pcg_version = asy.pcg_version AND asy.rowid = 1 AND aa.active = 1 AND aa.entity=1 ORDER BY aa.account_number
  356. 2019-04-12 10:33:48 INFO 125.17.82.22 --- End access to /erp/compta/bank/various_payment/card.php
  357. 2019-04-12 10:33:51 DEBUG 125.17.82.22 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1
  358. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, 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.dateemploymentend, u.ref_int, 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 erp_user as u LEFT JOIN erp_c_country as c ON u.fk_country = c.rowid LEFT JOIN erp_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC
  359. 2019-04-12 10:33:51 INFO 125.17.82.22 fetch_name_optionals_label elementtype=user
  360. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM erp_extrafields WHERE elementtype = 'user' ORDER BY pos
  361. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT param, value FROM erp_user_param WHERE fk_user = 1 AND entity = 1
  362. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT rowid, entity, type, page, param, value FROM erp_default_values WHERE entity IN (1) AND user_id IN (0, 1)
  363. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_user_rights as ur, erp_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
  364. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_usergroup_rights as gr, erp_usergroup_user as gu, erp_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
  365. 2019-04-12 10:33:51 INFO 125.17.82.22 --- Access to /erp/index.php - action=, massaction=
  366. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT transkey, transvalue FROM erp_overwrite_trans where lang='en_US'
  367. 2019-04-12 10:33:51 DEBUG 125.17.82.22 Menubase::menuLoad mymainmenu=home myleftmenu=home type_user=0 menu_handler=eldy tabMenu size=0
  368. 2019-04-12 10:33:51 DEBUG 125.17.82.22 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 erp_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
  369. 2019-04-12 10:33:51 DEBUG 125.17.82.22 InfoBox::listBoxes get default box list for mode=activated userid=
  370. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT b.rowid, b.position, b.box_order, b.fk_user, d.rowid as box_id, d.file, d.note, d.tms FROM erp_boxes as b, erp_boxes_def as d WHERE b.box_id = d.rowid AND b.entity IN (0,1) AND b.position = 0 AND b.fk_user = 0 ORDER BY b.box_order
  371. 2019-04-12 10:33:51 DEBUG 125.17.82.22 box_comptes::loadBox
  372. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT b.rowid, b.ref, b.label, b.bank,b.number, b.courant, b.clos, b.rappro, b.url, b.code_banque, b.code_guichet, b.cle_rib, b.bic, b.iban_prefix as iban, b.domiciliation, b.proprio, b.owner_address, b.account_number, b.currency_code, b.min_allowed, b.min_desired, comment, b.fk_accountancy_journal, aj.code as accountancy_journal FROM erp_bank_account as b LEFT JOIN erp_accounting_journal as aj ON aj.rowid=b.fk_accountancy_journal WHERE b.entity = 1 AND clos = 0 ORDER BY label LIMIT 5
  373. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT sum(amount) as amount FROM erp_bank WHERE fk_account = 1
  374. 2019-04-12 10:33:51 DEBUG 125.17.82.22 Translate::loadCacheCurrencies
  375. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT code_iso, label, unicode FROM erp_c_currencies WHERE active = 1 AND code_iso = 'INR'
  376. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT sum(amount) as amount FROM erp_bank WHERE fk_account = 2
  377. 2019-04-12 10:33:51 INFO 125.17.82.22 box_comptes::showBox
  378. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT s.nom as name, s.rowid as socid, s.datec, s.tms, s.status, s.code_fournisseur, s.logo FROM erp_societe as s WHERE s.fournisseur = 1 AND s.entity IN (1) ORDER BY s.tms DESC LIMIT 5
  379. 2019-04-12 10:33:51 INFO 125.17.82.22 box_fournisseurs::showBox
  380. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT s.nom as name, s.rowid as socid, f.rowid as facid, f.ref, f.ref_supplier, f.date_lim_reglement as datelimite, f.amount, f.datef as df, f.total_ht as total_ht, f.tva as total_tva, f.total_ttc, f.paye, f.fk_statut, f.type FROM erp_societe as s,erp_facture_fourn as f WHERE f.fk_soc = s.rowid AND f.entity = 1 AND f.paye=0 AND fk_statut = 1 ORDER BY datelimite DESC, f.ref_supplier DESC LIMIT 5
  381. 2019-04-12 10:33:51 INFO 125.17.82.22 box_factures_fourn_imp::showBox
  382. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT s.nom as name, s.rowid as socid, s.code_fournisseur, s.logo, f.rowid as facid, f.ref, f.ref_supplier, f.total_ht, f.total_tva, f.total_ttc, f.paye, f.fk_statut, f.datef as df, f.datec as datec, f.date_lim_reglement as datelimite, f.tms, f.type FROM erp_societe as s, erp_facture_fourn as f WHERE f.fk_soc = s.rowid AND f.entity = 1 ORDER BY f.tms DESC, f.ref DESC LIMIT 5
  383. 2019-04-12 10:33:51 INFO 125.17.82.22 box_factures_fourn::showBox
  384. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.code_fournisseur, s.logo, c.rowid, c.ref, c.tms, c.date_commande, c.total_ht, c.tva as total_tva, c.total_ttc, c.fk_statut FROM erp_societe as s, erp_commande_fournisseur as c WHERE c.fk_soc = s.rowid AND c.entity = 1 ORDER BY c.tms DESC, c.ref DESC LIMIT 5
  385. 2019-04-12 10:33:51 INFO 125.17.82.22 box_supplier_orders::showBox
  386. 2019-04-12 10:33:51 DEBUG 125.17.82.22 Box_actions::loadBox
  387. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT a.id, a.label, a.datep as dp, a.percent as percentage, ta.code, ta.libelle as type_label, s.nom as name, s.rowid as socid, s.code_client FROM erp_c_actioncomm AS ta, erp_actioncomm AS a LEFT JOIN erp_societe as s ON a.fk_soc = s.rowid WHERE a.fk_action = ta.id AND a.entity = 1 AND a.percent >= 0 AND a.percent < 100 ORDER BY a.datec DESC LIMIT 5
  388. 2019-04-12 10:33:51 INFO 125.17.82.22 box_actions::showBox
  389. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT p.rowid, p.label, p.ref, p.price, p.price_base_type, p.price_ttc, p.fk_product_type, p.tms, p.tosell, p.tobuy, p.fk_price_expression, p.entity FROM erp_product as p WHERE p.entity IN (1) AND p.fk_product_type != 1 ORDER BY p.datec DESC LIMIT 5
  390. 2019-04-12 10:33:51 INFO 125.17.82.22 box_produits::showBox
  391. 2019-04-12 10:33:51 INFO 125.17.82.22 FactureStats::getAllByProductEntry read data from cache file /home/prakrush/public_html/erp/documents/users/temp/FactureStats_getAllByProductEntry_customer_en_US_entity.1_user1.cache 1555052836.
  392. 2019-04-12 10:33:51 INFO 125.17.82.22 DolGraph::draw_jflot this->type=pie this->MaxValue=2
  393. 2019-04-12 10:33:51 INFO 125.17.82.22 box_graph_product_distribution::showBox
  394. 2019-04-12 10:33:51 INFO 125.17.82.22 CommandeStats::getNbByMonthWithPrevYear read data from cache file /home/prakrush/public_html/erp/documents/users/temp/CommandeStats_getNbByMonthWithPrevYear_supplier_en_US_entity.1_user1.cache 1555044490.
  395. 2019-04-12 10:33:51 INFO 125.17.82.22 DolGraph::draw_jflot this->type= this->MaxValue=0
  396. 2019-04-12 10:33:51 INFO 125.17.82.22 CommandeStats::getAmountByMonthWithPrevYear read data from cache file /home/prakrush/public_html/erp/documents/users/temp/CommandeStats_getAmountByMonthWithPrevYear_supplier_en_US_entity.1_user1.cache 1555044490.
  397. 2019-04-12 10:33:51 INFO 125.17.82.22 DolGraph::draw_jflot this->type= this->MaxValue=0
  398. 2019-04-12 10:33:51 INFO 125.17.82.22 box_graph_orders_supplier_permonth::showBox
  399. 2019-04-12 10:33:51 INFO 125.17.82.22 box_lastlogin::showBox
  400. 2019-04-12 10:33:51 DEBUG 125.17.82.22 box_prospect::loadBox
  401. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.client, s.code_fournisseur, s.fournisseur, s.logo, s.fk_stcomm, s.datec, s.tms, s.status FROM erp_societe as s WHERE s.client IN (2, 3) AND s.entity IN (1) ORDER BY s.tms DESC LIMIT 5
  402. 2019-04-12 10:33:51 INFO 125.17.82.22 box_prospect::showBox
  403. 2019-04-12 10:33:51 INFO 125.17.82.22 FactureStats::getNbByMonthWithPrevYear read data from cache file /home/prakrush/public_html/erp/documents/users/temp/FactureStats_getNbByMonthWithPrevYear_customer_en_US_entity.1_user1.cache 1555065123.
  404. 2019-04-12 10:33:51 INFO 125.17.82.22 DolGraph::draw_jflot this->type= this->MaxValue=0
  405. 2019-04-12 10:33:51 INFO 125.17.82.22 FactureStats::getAmountByMonthWithPrevYear read data from cache file /home/prakrush/public_html/erp/documents/users/temp/FactureStats_getAmountByMonthWithPrevYear_customer_en_US_entity.1_user1.cache 1555065123.
  406. 2019-04-12 10:33:51 INFO 125.17.82.22 DolGraph::draw_jflot this->type= this->MaxValue=0
  407. 2019-04-12 10:33:51 INFO 125.17.82.22 box_graph_invoices_permonth::showBox
  408. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT s.nom as name, s.rowid as socid, s.email, s.code_client, s.logo, f.facnumber, f.date_lim_reglement as datelimite, f.type, f.amount, f.datef as df, f.total as total_ht, f.tva as total_tva, f.total_ttc, f.paye, f.fk_statut, f.rowid as facid, sum(pf.amount) as am FROM erp_societe as s, erp_facture as f LEFT JOIN erp_paiement_facture as pf ON f.rowid=pf.fk_facture WHERE f.fk_soc = s.rowid AND f.entity = 1 AND f.paye = 0 AND fk_statut = 1 GROUP BY s.nom, s.rowid, s.code_client, s.logo, f.facnumber, f.date_lim_reglement, f.type, f.amount, f.datef, f.total, f.tva, f.total_ttc, f.paye, f.fk_statut, f.rowid ORDER BY datelimite ASC, f.facnumber ASC LIMIT 5
  409. 2019-04-12 10:33:51 INFO 125.17.82.22 box_factures_imp::showBox
  410. 2019-04-12 10:33:51 INFO 125.17.82.22 ModeleBoxes::showBox
  411. 2019-04-12 10:33:51 INFO 125.17.82.22 FactureStats::getNbByMonthWithPrevYear read data from cache file /home/prakrush/public_html/erp/documents/users/temp/FactureStats_getNbByMonthWithPrevYear_supplier_en_US_entity.1_user1.cache 1555044490.
  412. 2019-04-12 10:33:51 INFO 125.17.82.22 DolGraph::draw_jflot this->type= this->MaxValue=0
  413. 2019-04-12 10:33:51 INFO 125.17.82.22 FactureStats::getAmountByMonthWithPrevYear read data from cache file /home/prakrush/public_html/erp/documents/users/temp/FactureStats_getAmountByMonthWithPrevYear_supplier_en_US_entity.1_user1.cache 1555044490.
  414. 2019-04-12 10:33:51 INFO 125.17.82.22 DolGraph::draw_jflot this->type= this->MaxValue=0
  415. 2019-04-12 10:33:51 INFO 125.17.82.22 box_graph_invoices_supplier_permonth::showBox
  416. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT sp.rowid as id, sp.lastname, sp.firstname, sp.civility as civility_id, sp.datec, sp.tms, sp.fk_soc, sp.statut as status, sp.address, sp.zip, sp.town, sp.phone, sp.phone_perso, sp.phone_mobile, s.nom as socname, s.name_alias, s.client, s.fournisseur, s.code_client, s.code_fournisseur FROM erp_socpeople as sp LEFT JOIN erp_societe as s ON sp.fk_soc = s.rowid WHERE sp.entity IN (1) ORDER BY sp.tms DESC LIMIT 5
  417. 2019-04-12 10:33:51 INFO 125.17.82.22 box_contacts::showBox
  418. 2019-04-12 10:33:51 DEBUG 125.17.82.22 box_clients::loadBox
  419. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.client, s.code_fournisseur, s.fournisseur, s.code_compta, s.code_compta_fournisseur, s.logo, s.email, s.datec, s.tms, s.status FROM erp_societe as s WHERE s.client IN (1, 3) AND s.entity IN (1) ORDER BY s.tms DESC LIMIT 5
  420. 2019-04-12 10:33:51 INFO 125.17.82.22 box_clients::showBox
  421. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT f.rowid as facid, f.facnumber, f.type, f.total as total_ht, f.tva as total_tva, f.total_ttc, f.datef as df, f.paye, f.fk_statut, f.datec, f.tms, s.rowid as socid, s.nom as name, s.code_client, s.email, s.tva_intra, s.code_compta, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, f.date_lim_reglement as datelimite FROM (erp_societe as s,erp_facture as f) WHERE f.fk_soc = s.rowid AND f.entity = 1 ORDER BY f.tms DESC, f.facnumber DESC LIMIT 5
  422. 2019-04-12 10:33:51 INFO 125.17.82.22 box_factures::showBox
  423. 2019-04-12 10:33:51 INFO 125.17.82.22 ModeleBoxes::showBox
  424. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT count(u.rowid) as nb FROM erp_user as u WHERE u.statut > 0 AND u.entity IN (0,1)
  425. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT count(s.rowid) as nb, s.client FROM erp_societe as s WHERE s.client IN (1,2,3) AND s.entity IN (1) GROUP BY s.client
  426. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT count(s.rowid) as nb FROM erp_societe as s WHERE s.fournisseur = 1 AND s.entity IN (1)
  427. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT count(sp.rowid) as nb FROM erp_socpeople as sp WHERE sp.entity IN (1) AND (sp.priv='0' OR (sp.priv='1' AND sp.fk_user_creat=1))
  428. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT count(p.rowid) as nb, fk_product_type FROM erp_product as p WHERE p.entity IN (1) GROUP BY fk_product_type
  429. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT count(f.rowid) as nb FROM erp_facture as f LEFT JOIN erp_societe as s ON f.fk_soc = s.rowid WHERE f.entity = 1
  430. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT count(co.rowid) as nb FROM erp_commande_fournisseur as co LEFT JOIN erp_societe as s ON co.fk_soc = s.rowid WHERE co.entity = 1
  431. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT count(f.rowid) as nb FROM erp_facture_fourn as f LEFT JOIN erp_societe as s ON f.fk_soc = s.rowid WHERE f.entity = 1
  432. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT count(ex.rowid) as nb FROM erp_expensereport as ex WHERE ex.fk_statut > 0 AND ex.entity IN (1)
  433. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT a.id, a.datep as dp FROM erp_actioncomm as a LEFT JOIN erp_societe as s ON a.fk_soc = s.rowid WHERE 1 = 1 AND a.percent >= 0 AND a.percent < 100 AND a.entity IN (1)
  434. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT c.rowid, c.date_creation as datec, c.date_commande, c.fk_statut, c.date_livraison as delivery_date FROM erp_commande_fournisseur as c WHERE c.entity = 1 AND c.fk_statut IN (1, 2)
  435. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT f.rowid, f.date_lim_reglement as datefin,f.fk_statut, f.total FROM erp_facture as f WHERE f.paye=0 AND f.entity = 1 AND f.fk_statut = 1
  436. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT ff.rowid, ff.date_lim_reglement as datefin, ff.fk_statut FROM erp_facture_fourn as ff WHERE ff.paye=0 AND ff.fk_statut > 0 AND ff.entity = 1
  437. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT COUNT(ba.rowid) as nb FROM erp_bank_account as ba WHERE ba.rappro > 0 and ba.clos = 0 AND ba.entity IN (1) AND ba.courant != 2
  438. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT b.rowid, b.datev as datefin FROM erp_bank as b, erp_bank_account as ba WHERE b.rappro=0 AND b.fk_account = ba.rowid AND ba.entity IN (1) AND (ba.rappro = 1 AND ba.courant != 2) AND clos = 0
  439. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT b.rowid, b.datev as datefin FROM erp_bank as b, erp_bank_account as ba WHERE b.fk_account = ba.rowid AND ba.entity IN (1) AND b.fk_type = 'CHQ' AND b.fk_bordereau = 0 AND b.amount > 0
  440. 2019-04-12 10:33:51 DEBUG 125.17.82.22 User::loadParentOf
  441. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT fk_user as id_parent, rowid as id_son FROM erp_user WHERE fk_user <> 0 AND entity IN (0,1)
  442. 2019-04-12 10:33:51 DEBUG 125.17.82.22 User::get_full_tree get user list
  443. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT DISTINCT u.rowid, u.firstname, u.lastname, u.fk_user, u.fk_soc, u.login, u.email, u.gender, u.admin, u.statut, u.photo, u.entity FROM erp_user as u WHERE u.entity IN (0,1)
  444. 2019-04-12 10:33:51 DEBUG 125.17.82.22 User::get_full_tree call to build_path_from_id_user
  445. 2019-04-12 10:33:51 DEBUG 125.17.82.22 User::build_path_from_id_user id_user=1 protection=0
  446. 2019-04-12 10:33:51 DEBUG 125.17.82.22 User::build_path_from_id_user id_user=2 protection=0
  447. 2019-04-12 10:33:51 DEBUG 125.17.82.22 User::get_full_tree dol_sort_array
  448. 2019-04-12 10:33:51 INFO 125.17.82.22 Build childid for id = 1
  449. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT ex.rowid, ex.date_valid FROM erp_expensereport as ex WHERE ex.fk_statut = 2 AND ex.entity IN (1) AND (ex.fk_user_author IN (1) OR ex.fk_user_validator IN (1))
  450. 2019-04-12 10:33:51 DEBUG 125.17.82.22 sql=SELECT ex.rowid, ex.date_valid FROM erp_expensereport as ex WHERE ex.fk_statut = 5 AND ex.entity IN (1) AND (ex.fk_user_author IN (1) OR ex.fk_user_validator IN (1))
  451. 2019-04-12 10:33:51 INFO 125.17.82.22 --- End access to /erp/index.php
  452. 2019-04-12 10:33:52 DEBUG 125.17.82.22 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1
  453. 2019-04-12 10:33:52 DEBUG 125.17.82.22 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, 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.dateemploymentend, u.ref_int, 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 erp_user as u LEFT JOIN erp_c_country as c ON u.fk_country = c.rowid LEFT JOIN erp_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC
  454. 2019-04-12 10:33:52 INFO 125.17.82.22 fetch_name_optionals_label elementtype=user
  455. 2019-04-12 10:33:52 DEBUG 125.17.82.22 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM erp_extrafields WHERE elementtype = 'user' ORDER BY pos
  456. 2019-04-12 10:33:52 DEBUG 125.17.82.22 sql=SELECT param, value FROM erp_user_param WHERE fk_user = 1 AND entity = 1
  457. 2019-04-12 10:33:52 DEBUG 125.17.82.22 sql=SELECT rowid, entity, type, page, param, value FROM erp_default_values WHERE entity IN (1) AND user_id IN (0, 1)
  458. 2019-04-12 10:33:52 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_user_rights as ur, erp_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
  459. 2019-04-12 10:33:52 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_usergroup_rights as gr, erp_usergroup_user as gu, erp_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
  460. 2019-04-12 10:33:52 INFO 125.17.82.22 --- Access to /erp/admin/index.php - action=, massaction=
  461. 2019-04-12 10:33:52 DEBUG 125.17.82.22 sql=SELECT transkey, transvalue FROM erp_overwrite_trans where lang='en_US'
  462. 2019-04-12 10:33:52 DEBUG 125.17.82.22 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0
  463. 2019-04-12 10:33:52 DEBUG 125.17.82.22 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 erp_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
  464. 2019-04-12 10:33:52 INFO 125.17.82.22 --- End access to /erp/admin/index.php
  465. 2019-04-12 10:33:56 DEBUG 125.17.82.22 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1
  466. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, 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.dateemploymentend, u.ref_int, 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 erp_user as u LEFT JOIN erp_c_country as c ON u.fk_country = c.rowid LEFT JOIN erp_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC
  467. 2019-04-12 10:33:56 INFO 125.17.82.22 fetch_name_optionals_label elementtype=user
  468. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM erp_extrafields WHERE elementtype = 'user' ORDER BY pos
  469. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT param, value FROM erp_user_param WHERE fk_user = 1 AND entity = 1
  470. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT rowid, entity, type, page, param, value FROM erp_default_values WHERE entity IN (1) AND user_id IN (0, 1)
  471. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_user_rights as ur, erp_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
  472. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_usergroup_rights as gr, erp_usergroup_user as gu, erp_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
  473. 2019-04-12 10:33:56 INFO 125.17.82.22 --- Access to /erp/admin/modules.php - action=, massaction=
  474. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT transkey, transvalue FROM erp_overwrite_trans where lang='en_US'
  475. 2019-04-12 10:33:56 DEBUG 125.17.82.22 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0
  476. 2019-04-12 10:33:56 DEBUG 125.17.82.22 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 erp_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
  477. 2019-04-12 10:33:56 INFO 125.17.82.22 Scan directory /home/prakrush/public_html/erp/core/modules/ for module descriptor files (modXXX.class.php)
  478. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'adherent' AND type != 'separate' AND entity IN (0, 1)
  479. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, fieldrequired FROM erp_extrafields WHERE elementtype = 'adherent' AND entity IN (0,1)
  480. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT code, label, description FROM erp_c_action_trigger ORDER by rang
  481. 2019-04-12 10:33:56 INFO 125.17.82.22 Module modAsset not qualified
  482. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param FROM erp_extrafields WHERE elementtype = 'societe'
  483. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param FROM erp_extrafields WHERE elementtype = 'socpeople'
  484. 2019-04-12 10:33:56 INFO 125.17.82.22 Module modCollab not qualified
  485. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'commande' AND type != 'separate' AND entity IN (0, 1)
  486. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'commandedet' AND type != 'separate' AND entity IN (0, 1)
  487. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1)
  488. 2019-04-12 10:33:56 INFO 125.17.82.22 Module modDataPolicy not qualified
  489. 2019-04-12 10:33:56 DEBUG 125.17.82.22 User::loadParentOf
  490. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT fk_user as id_parent, rowid as id_son FROM erp_user WHERE fk_user <> 0 AND entity IN (0,1)
  491. 2019-04-12 10:33:56 DEBUG 125.17.82.22 User::get_full_tree get user list
  492. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT DISTINCT u.rowid, u.firstname, u.lastname, u.fk_user, u.fk_soc, u.login, u.email, u.gender, u.admin, u.statut, u.photo, u.entity FROM erp_user as u WHERE u.entity IN (0,1)
  493. 2019-04-12 10:33:56 DEBUG 125.17.82.22 User::get_full_tree call to build_path_from_id_user
  494. 2019-04-12 10:33:56 DEBUG 125.17.82.22 User::build_path_from_id_user id_user=1 protection=0
  495. 2019-04-12 10:33:56 DEBUG 125.17.82.22 User::build_path_from_id_user id_user=2 protection=0
  496. 2019-04-12 10:33:56 DEBUG 125.17.82.22 User::get_full_tree dol_sort_array
  497. 2019-04-12 10:33:56 INFO 125.17.82.22 Build childid for id = 1
  498. 2019-04-12 10:33:56 INFO 125.17.82.22 Module modDeplacement not qualified
  499. 2019-04-12 10:33:56 INFO 125.17.82.22 Module modDocumentGeneration not qualified
  500. 2019-04-12 10:33:56 INFO 125.17.82.22 Module modDynamicPrices not qualified
  501. 2019-04-12 10:33:56 INFO 125.17.82.22 Module modEmailCollector not qualified
  502. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM erp_c_type_contact as tc WHERE tc.element='commande' AND tc.source='external' ORDER BY position ASC, code
  503. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM erp_c_type_contact as tc WHERE tc.element='commande' AND tc.source='external' ORDER BY position ASC, code
  504. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'expedition' AND type != 'separate' AND entity IN (0, 1)
  505. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'expeditiondet' AND type != 'separate' AND entity IN (0, 1)
  506. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1)
  507. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'facturedet' AND type != 'separate' AND entity IN (0, 1)
  508. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1)
  509. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1)
  510. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param FROM erp_extrafields WHERE elementtype = 'facture_fourn'
  511. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param FROM erp_extrafields WHERE elementtype = 'facture_fourn_det'
  512. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param FROM erp_extrafields WHERE elementtype = 'facture_fourn'
  513. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param FROM erp_extrafields WHERE elementtype = 'commande_fournisseur'
  514. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param FROM erp_extrafields WHERE elementtype = 'commande_fournisseurdet'
  515. 2019-04-12 10:33:56 INFO 125.17.82.22 Module modHRM not qualified
  516. 2019-04-12 10:33:56 INFO 125.17.82.22 Module modLabel not qualified
  517. 2019-04-12 10:33:56 DEBUG 125.17.82.22 useNPR
  518. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT t.rowid FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.recuperableonly = 1
  519. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1)
  520. 2019-04-12 10:33:56 DEBUG 125.17.82.22 useNPR
  521. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT t.rowid FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.recuperableonly = 1
  522. 2019-04-12 10:33:56 DEBUG 125.17.82.22 useLocalTax
  523. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT t.localtax1, t.localtax2 FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.localtax1_type <> '0'
  524. 2019-04-12 10:33:56 DEBUG 125.17.82.22 useLocalTax
  525. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT t.localtax1, t.localtax2 FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.localtax2_type <> '0'
  526. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, fieldrequired FROM erp_extrafields WHERE elementtype = 'product' AND entity IN (0, 1)
  527. 2019-04-12 10:33:56 DEBUG 125.17.82.22 useNPR
  528. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT t.rowid FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.recuperableonly = 1
  529. 2019-04-12 10:33:56 DEBUG 125.17.82.22 useLocalTax
  530. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT t.localtax1, t.localtax2 FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.localtax1_type <> '0'
  531. 2019-04-12 10:33:56 DEBUG 125.17.82.22 useLocalTax
  532. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT t.localtax1, t.localtax2 FROM erp_c_tva as t, erp_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'IN' AND t.active = 1 AND t.localtax2_type <> '0'
  533. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'projet' AND type != 'separate' AND entity IN (0, 1)
  534. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'projet_task' AND type != 'separate' AND entity IN (0, 1)
  535. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, fieldrequired FROM erp_extrafields WHERE elementtype = 'projet_task' AND entity IN (0,1)
  536. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'propal' AND type != 'separate' AND entity IN (0, 1)
  537. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'propaldet' AND type != 'separate' AND entity IN (0, 1)
  538. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1)
  539. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1)
  540. 2019-04-12 10:33:56 INFO 125.17.82.22 Module modReceiptPrinter not qualified
  541. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'resource' AND type != 'separate' AND entity IN (0, 1)
  542. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, fieldrequired FROM erp_extrafields WHERE elementtype = 'resource' AND entity IN (0,1)
  543. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type FROM erp_extrafields WHERE elementtype = 'product'
  544. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, fieldrequired FROM erp_extrafields WHERE elementtype = 'product' AND entity IN (0,1)
  545. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1)
  546. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'socpeople' AND type != 'separate' AND entity IN (0, 1)
  547. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1)
  548. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, fieldrequired FROM erp_extrafields WHERE elementtype = 'societe' AND entity IN (0,1)
  549. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, fieldrequired FROM erp_extrafields WHERE elementtype = 'socpeople' AND entity IN (0,1)
  550. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM erp_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1)
  551. 2019-04-12 10:33:56 INFO 125.17.82.22 Module modTakePos not qualified
  552. 2019-04-12 10:33:56 INFO 125.17.82.22 Module modTicket not qualified
  553. 2019-04-12 10:33:56 DEBUG 125.17.82.22 sql=SELECT name, label, fieldrequired FROM erp_extrafields WHERE elementtype = 'user' AND entity IN (0,1)
  554. 2019-04-12 10:33:56 INFO 125.17.82.22 Module modWebServicesClient not qualified
  555. 2019-04-12 10:33:56 INFO 125.17.82.22 --- End access to /erp/admin/modules.php
  556. 2019-04-12 10:33:59 DEBUG 125.17.82.22 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1
  557. 2019-04-12 10:33:59 DEBUG 125.17.82.22 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, 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.dateemploymentend, u.ref_int, 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 erp_user as u LEFT JOIN erp_c_country as c ON u.fk_country = c.rowid LEFT JOIN erp_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC
  558. 2019-04-12 10:33:59 INFO 125.17.82.22 fetch_name_optionals_label elementtype=user
  559. 2019-04-12 10:33:59 DEBUG 125.17.82.22 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM erp_extrafields WHERE elementtype = 'user' ORDER BY pos
  560. 2019-04-12 10:33:59 DEBUG 125.17.82.22 sql=SELECT param, value FROM erp_user_param WHERE fk_user = 1 AND entity = 1
  561. 2019-04-12 10:33:59 DEBUG 125.17.82.22 sql=SELECT rowid, entity, type, page, param, value FROM erp_default_values WHERE entity IN (1) AND user_id IN (0, 1)
  562. 2019-04-12 10:33:59 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_user_rights as ur, erp_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
  563. 2019-04-12 10:33:59 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_usergroup_rights as gr, erp_usergroup_user as gu, erp_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
  564. 2019-04-12 10:33:59 INFO 125.17.82.22 --- Access to /erp/admin/syslog.php - action=, massaction=
  565. 2019-04-12 10:33:59 DEBUG 125.17.82.22 sql=SELECT transkey, transvalue FROM erp_overwrite_trans where lang='en_US'
  566. 2019-04-12 10:33:59 DEBUG 125.17.82.22 Menubase::menuLoad mymainmenu=home myleftmenu=setup type_user=0 menu_handler=eldy tabMenu size=0
  567. 2019-04-12 10:33:59 DEBUG 125.17.82.22 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 erp_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
  568. 2019-04-12 10:33:59 DEBUG 125.17.82.22 admin.lib::dolibarr_get_const
  569. 2019-04-12 10:33:59 DEBUG 125.17.82.22 sql=SELECT value as value FROM erp_const WHERE name = 'SYSLOG_FACILITY' AND entity = 0
  570. 2019-04-12 10:33:59 DEBUG 125.17.82.22 admin.lib::dolibarr_get_const
  571. 2019-04-12 10:33:59 DEBUG 125.17.82.22 sql=SELECT value as value FROM erp_const WHERE name = 'SYSLOG_FILE' AND entity = 0
  572. 2019-04-12 10:33:59 INFO 125.17.82.22 --- End access to /erp/admin/syslog.php
  573. 2019-04-12 10:34:01 DEBUG 125.17.82.22 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1
  574. 2019-04-12 10:34:01 DEBUG 125.17.82.22 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.job, u.skype, u.twitter, u.facebook, 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.dateemploymentend, u.ref_int, 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 erp_user as u LEFT JOIN erp_c_country as c ON u.fk_country = c.rowid LEFT JOIN erp_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'admin' ORDER BY u.entity ASC
  575. 2019-04-12 10:34:01 INFO 125.17.82.22 fetch_name_optionals_label elementtype=user
  576. 2019-04-12 10:34:01 DEBUG 125.17.82.22 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM erp_extrafields WHERE elementtype = 'user' ORDER BY pos
  577. 2019-04-12 10:34:01 DEBUG 125.17.82.22 sql=SELECT param, value FROM erp_user_param WHERE fk_user = 1 AND entity = 1
  578. 2019-04-12 10:34:01 DEBUG 125.17.82.22 sql=SELECT rowid, entity, type, page, param, value FROM erp_default_values WHERE entity IN (1) AND user_id IN (0, 1)
  579. 2019-04-12 10:34:01 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_user_rights as ur, erp_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
  580. 2019-04-12 10:34:01 DEBUG 125.17.82.22 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM erp_usergroup_rights as gr, erp_usergroup_user as gu, erp_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
  581. 2019-04-12 10:34:01 INFO 125.17.82.22 --- Access to /erp/document.php - action=, massaction=
  582. 2019-04-12 10:34:01 DEBUG 125.17.82.22 sql=SELECT transkey, transvalue FROM erp_overwrite_trans where lang='en_US'
  583. 2019-04-12 10:34:01 INFO 125.17.82.22 modulepart=logs original_file=dolibarr.log entity=1
  584. 2019-04-12 10:34:01 INFO 125.17.82.22 document.php download /home/prakrush/public_html/erp/documents/dolibarr.log filename=dolibarr.log content-type=text/plain
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!