2020-06-06 18:43:16 INFO 91.170.225.90 --- Access to /public/members/new.php - action=, massaction= 2020-06-06 18:43:16 DEBUG 91.170.225.90 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-06-06 18:43:16 DEBUG 91.170.225.90 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2020-06-06 18:43:16 DEBUG 91.170.225.90 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0) 2020-06-06 18:43:16 DEBUG 91.170.225.90 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'adherent' ORDER BY pos 2020-06-06 18:43:16 DEBUG 91.170.225.90 Adherent_type::fetch 2020-06-06 18:43:16 DEBUG 91.170.225.90 sql=SELECT d.rowid, d.libelle as label, d.morphy, d.statut as status, d.duration, d.subscription, d.mail_valid, d.note, d.vote FROM llx_adherent_type as d WHERE d.rowid = 1 2020-06-06 18:43:16 DEBUG 91.170.225.90 Form::select_civility 2020-06-06 18:43:16 DEBUG 91.170.225.90 sql=SELECT rowid, code, label, active FROM llx_c_civility WHERE active = 1 2020-06-06 18:43:16 DEBUG 91.170.225.90 Form::select_country 2020-06-06 18:43:16 DEBUG 91.170.225.90 sql=SELECT rowid, code as code_iso, code_iso as code_iso3, label, favorite FROM llx_c_country WHERE active > 0 2020-06-06 18:43:16 INFO 91.170.225.90 DolEditor::DolEditor htmlname=options_sm width= height=200 toolbarname=dolibarr_notes 2020-06-06 18:43:16 INFO 91.170.225.90 --- End access to /public/members/new.php 2020-06-06 18:43:16 INFO 91.170.225.90 --- Access to /theme/eldy/style.css.php - action=, massaction= 2020-06-06 18:43:16 DEBUG 91.170.225.90 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-06-06 18:43:16 DEBUG 91.170.225.90 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2020-06-06 18:43:16 DEBUG 91.170.225.90 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_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 llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.login = 'gnikolic' ORDER BY u.entity ASC 2020-06-06 18:43:16 DEBUG 91.170.225.90 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-06-06 18:43:16 DEBUG 91.170.225.90 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-06-06 18:43:16 DEBUG 91.170.225.90 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-06-06 18:43:16 DEBUG 91.170.225.90 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2020-06-06 18:43:16 DEBUG 91.170.225.90 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-06-06 18:43:16 INFO 91.170.225.90 --- End access to /theme/eldy/style.css.php 2020-06-06 18:43:16 INFO 91.170.225.90 --- Access to /core/js/lib_head.js.php - action=, massaction= 2020-06-06 18:43:16 DEBUG 91.170.225.90 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-06-06 18:43:16 INFO 91.170.225.90 --- End access to /core/js/lib_head.js.php 2020-06-06 18:43:16 INFO 91.170.225.90 --- Access to /viewimage.php - action=, massaction= 2020-06-06 18:43:16 INFO 91.170.225.90 modulepart=mycompany original_file=logos/thumbs/logo_size_blue red_small.jpg entity=1 2020-06-06 18:43:16 INFO 91.170.225.90 viewimage.php return file /home/roadfmfrwb/dolibarr/documents/mycompany/logos/thumbs/logo_size_blue red_small.jpg filename=logo_size_blue red_small.jpg content-type=image/jpeg 2020-06-06 18:43:16 INFO 91.170.225.90 --- End access to /viewimage.php 2020-06-06 18:43:35 INFO 91.170.225.90 --- Access to /public/members/new.php - action=create, massaction= 2020-06-06 18:43:35 DEBUG 91.170.225.90 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-06-06 18:43:35 DEBUG 91.170.225.90 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2020-06-06 18:43:35 DEBUG 91.170.225.90 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0) 2020-06-06 18:43:35 DEBUG 91.170.225.90 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'adherent' ORDER BY pos 2020-06-06 18:43:35 DEBUG 91.170.225.90 Adherent_type::fetch 2020-06-06 18:43:35 DEBUG 91.170.225.90 sql=SELECT d.rowid, d.libelle as label, d.morphy, d.statut as status, d.duration, d.subscription, d.mail_valid, d.note, d.vote FROM llx_adherent_type as d WHERE d.rowid = 1 2020-06-06 18:43:35 DEBUG 91.170.225.90 Form::select_civility 2020-06-06 18:43:35 DEBUG 91.170.225.90 sql=SELECT rowid, code, label, active FROM llx_c_civility WHERE active = 1 2020-06-06 18:43:35 DEBUG 91.170.225.90 sql=SELECT rowid, code, label FROM llx_c_country WHERE rowid=1 2020-06-06 18:43:35 DEBUG 91.170.225.90 Form::select_country 2020-06-06 18:43:35 DEBUG 91.170.225.90 sql=SELECT rowid, code as code_iso, code_iso as code_iso3, label, favorite FROM llx_c_country WHERE active > 0 2020-06-06 18:43:35 DEBUG 91.170.225.90 FormCompany::select_departement selected=, country_codeid=FR 2020-06-06 18:43:35 DEBUG 91.170.225.90 sql=SELECT d.rowid, d.code_departement as code, d.nom as name, d.active, c.label as country, c.code as country_code, r.nom as region_name FROM llx_c_departements as d, llx_c_regions as r,llx_c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid AND d.active = 1 AND r.active = 1 AND c.active = 1 AND c.code = 'FR' ORDER BY c.code, d.code_departement 2020-06-06 18:43:35 DEBUG 91.170.225.90 FormCompany::select_departement num=101 2020-06-06 18:43:35 INFO 91.170.225.90 DolEditor::DolEditor htmlname=options_sm width= height=200 toolbarname=dolibarr_notes 2020-06-06 18:43:35 INFO 91.170.225.90 --- End access to /public/members/new.php 2020-06-06 18:43:54 INFO 91.170.225.90 --- Access to /public/members/new.php - action=add, massaction= 2020-06-06 18:43:54 DEBUG 91.170.225.90 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-06-06 18:43:54 DEBUG 91.170.225.90 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,1) AND m.menu_handler IN ('eldy','all') AND m.usertype IN (0,2) ORDER BY m.position, m.rowid 2020-06-06 18:43:54 DEBUG 91.170.225.90 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0) 2020-06-06 18:43:54 DEBUG 91.170.225.90 BEGIN Transaction 2020-06-06 18:43:54 DEBUG 91.170.225.90 sql=SELECT login FROM llx_adherent WHERE login='321321' 2020-06-06 18:43:54 DEBUG 91.170.225.90 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'adherent' ORDER BY pos 2020-06-06 18:43:54 DEBUG 91.170.225.90 Adherent::create 2020-06-06 18:43:54 DEBUG 91.170.225.90 sql=INSERT INTO llx_adherent (datec,login,fk_user_author,fk_user_mod,fk_user_valid,morphy,fk_adherent_type,entity,import_key) VALUES ( '2020-06-06 18:43:54', '321321', null, null, null, 'phy', 1, 1, null) 2020-06-06 18:43:54 INFO 91.170.225.90 Adherent::update notrigger=1, nosyncuser=1, nosyncuserpass=0 nosyncthirdparty=0, email=321321321321@gmail.com 2020-06-06 18:43:54 DEBUG 91.170.225.90 Adherent::update update member 2020-06-06 18:43:54 DEBUG 91.170.225.90 sql=UPDATE llx_adherent SET civility = 'MME', firstname = '987654321', lastname = '123456789', gender = 'man', login = '321321', societe = null, fk_soc = null, address = '1231231231231231231', zip = '21231231', town = '23123123123', country = 1, state_id = null, email = '321321321321@gmail.com', socialnetworks = 'null', phone = null, phone_perso = null, phone_mobile = null, note_private = null, note_public = null, photo = null, public = '0', statut = -1, fk_adherent_type = 1, morphy = 'phy', birth = null, fk_user_mod = null WHERE rowid = 9 2020-06-06 18:43:54 DEBUG 91.170.225.90 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'adherent' ORDER BY pos 2020-06-06 18:43:54 DEBUG 91.170.225.90 Adherent::insertExtraFields delete then insert 2020-06-06 18:43:54 DEBUG 91.170.225.90 sql=DELETE FROM llx_adherent_extrafields WHERE fk_object = 9 2020-06-06 18:43:54 DEBUG 91.170.225.90 sql=INSERT INTO llx_adherent_extrafields (fk_object,sm) VALUES (9,null) 2020-06-06 18:43:54 INFO 91.170.225.90 Adherent::update update password 2020-06-06 18:43:54 INFO 91.170.225.90 Adherent::setPassword user=0 password=****** isencrypted=0 2020-06-06 18:43:54 DEBUG 91.170.225.90 Adherent::setPassword 2020-06-06 18:43:54 DEBUG 91.170.225.90 sql=UPDATE llx_adherent SET pass_crypted = '3d186804534370c3c817db0563f0e461', pass = '321321' WHERE rowid = 9 2020-06-06 18:43:54 INFO 91.170.225.90 Adherent::update update link to user 2020-06-06 18:43:54 DEBUG 91.170.225.90 Adherent::update 2020-06-06 18:43:54 DEBUG 91.170.225.90 sql=UPDATE llx_user SET fk_member = NULL WHERE fk_member = 9 2020-06-06 18:43:54 DEBUG 91.170.225.90 Adherent_type::fetch 2020-06-06 18:43:54 DEBUG 91.170.225.90 sql=SELECT d.rowid, d.libelle as label, d.morphy, d.statut as status, d.duration, d.subscription, d.mail_valid, d.note, d.vote FROM llx_adherent_type as d WHERE d.rowid = 1 2020-06-06 18:43:54 DEBUG 91.170.225.90 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-06-06 18:43:54 DEBUG 91.170.225.90 sql=SELECT rowid, label, topic, joinfiles, content, content_lines, lang FROM llx_c_email_templates WHERE (type_template='member' OR type_template='all') AND entity IN (0,1) AND (private = 0 OR fk_user = 0) AND active = 1 AND label ='(SendingEmailOnAutoSubscription)' AND (lang = 'fr_FR' OR lang IS NULL OR lang = '') ORDER BY position ASC, lang DESC, label ASC LIMIT 1 2020-06-06 18:43:54 DEBUG 91.170.225.90 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'adherent' ORDER BY pos 2020-06-06 18:43:54 DEBUG 91.170.225.90 sql=SELECT rowid, sm FROM llx_adherent_extrafields WHERE fk_object = 9 2020-06-06 18:43:54 INFO 91.170.225.90 send_an_email msgishtml=1 2020-06-06 18:43:54 DEBUG 91.170.225.90 CMailFile::CMailfile: sendmode=mail charset=UTF-8 from=contact@roadfm.fr, to=321321321321@gmail.com, addr_cc=, addr_bcc=, errors_to=, trackid=mem9 sendcontext=standard 2020-06-06 18:43:54 DEBUG 91.170.225.90 CMailFile::CMailfile: subject=[Road FM] Votre demande d'adhésion a été reçue., deliveryreceipt=0, msgishtml=1 2020-06-06 18:43:54 INFO 91.170.225.90 CMailFile::write_smtpheaders smtp_header= From: Return-Path: Reply-To: contact@roadfm.fr Date: Sat, 06 Jun 2020 18:43:54 +0200 Message-ID: <1591461834.phpmail-dolibarr-mem9@53c9bda0c7281097f93cd40ae7ff9dac> References: <1591461834.phpmail-dolibarr-mem9@53c9bda0c7281097f93cd40ae7ff9dac> X-Dolibarr-TRACKID: mem9@53c9bda0c7281097f93cd40ae7ff9dac X-RemoteAddr: 91.170.225.90 X-Mailer: Dolibarr version 11.0.4 (using php mail) Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="multipart_x.1591461834.x_boundary" Content-Transfer-Encoding: 8bit 2020-06-06 18:43:54 DEBUG 91.170.225.90 CMailFile::write_mimeheaders mime_header= 2020-06-06 18:43:54 DEBUG 91.170.225.90 CMailFile::sendfile addr_to=321321321321@gmail.com, subject=[Road FM] Votre demande d'adhésion a été reçue. 2020-06-06 18:43:54 DEBUG 91.170.225.90 CMailFile::sendfile header= From: Return-Path: Reply-To: contact@roadfm.fr Date: Sat, 06 Jun 2020 18:43:54 +0200 Message-ID: <1591461834.phpmail-dolibarr-mem9@53c9bda0c7281097f93cd40ae7ff9dac> References: <1591461834.phpmail-dolibarr-mem9@53c9bda0c7281097f93cd40ae7ff9dac> X-Dolibarr-TRACKID: mem9@53c9bda0c7281097f93cd40ae7ff9dac X-RemoteAddr: 91.170.225.90 X-Mailer: Dolibarr version 11.0.4 (using php mail) Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="multipart_x.1591461834.x_boundary" Content-Transfer-Encoding: 8bit X-Dolibarr-Info: send_an_email by public/members/new.php 2020-06-06 18:43:54 DEBUG 91.170.225.90 CMailFile::sendfile: mail start HOST=localhost, PORT=25, additionnal_parameters= 2020-06-06 18:43:54 DEBUG 91.170.225.90 CMailFile::sendfile: mail end success 2020-06-06 18:43:54 INFO 91.170.225.90 member 9 was created, we redirect to https://dolibarr.roadfm.fr/public/stripe/newpayment.php?from=membernewform&source=membersubscription&ref=9&email=321321321321%40gmail.com&securekey=42d3741d81214934a7fb52097906c8ff61672596&entity=1 2020-06-06 18:43:54 DEBUG 91.170.225.90 COMMIT Transaction 2020-06-06 18:43:54 INFO 91.170.225.90 --- End access to /public/members/new.php 2020-06-06 18:44:16 DEBUG 91.170.225.90 - This is an already logged session. _SESSION['dol_login']=gnikolic _SESSION['dol_entity']=1 2020-06-06 18:44:16 DEBUG 91.170.225.90 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.birth, u.email, u.personal_email, u.job, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note as note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.photo as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_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 llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IN (0, 1) AND u.login = 'gnikolic' ORDER BY u.entity ASC 2020-06-06 18:44:16 DEBUG 91.170.225.90 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos 2020-06-06 18:44:16 DEBUG 91.170.225.90 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1 2020-06-06 18:44:16 DEBUG 91.170.225.90 sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2020-06-06 18:44:16 DEBUG 91.170.225.90 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_user_rights as ur, llx_rights_def as r WHERE r.id = ur.fk_id AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL 2020-06-06 18:44:16 DEBUG 91.170.225.90 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llx_usergroup_rights as gr, llx_usergroup_user as gu, llx_rights_def as r WHERE r.id = gr.fk_id AND gr.entity = 1 AND gu.entity = 1 AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL 2020-06-06 18:44:16 INFO 91.170.225.90 --- Access to /document.php - action=, massaction= 2020-06-06 18:44:16 DEBUG 91.170.225.90 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2020-06-06 18:44:16 INFO 91.170.225.90 modulepart=logs original_file=dolibarr.log entity=1 2020-06-06 18:44:16 INFO 91.170.225.90 document.php download /home/roadfmfrwb/dolibarr/documents/dolibarr.log filename=dolibarr.log content-type=text/plain