re migration avec les log activés
je suis bien reconnu…
sql=SELECT rowid, login, entity, pass, pass_crypted FROM llx_user WHERE (login = 'eric') AND entity IN (0,1) AND statut = 1 ORDER BY entity DESC
functions_dolibarr::check_user_password_dolibarr Authentification ok - md5 of pass is ok
C’est là que ça cloche
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_mob
ile, 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_soc
people, 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.pho
to as photo, u.openid as openid, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, c
.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid W
HERE u.entity IN (0, 1) AND u.login = 'eric' ORDER BY u.entity ASC
C’est donc ici que on fait appel à >> u.note_public
DoliDBMysqli::query SQL Error message: DB_ERROR_NOSUCHFIELD Unknown column 'u.note_public' in 'field list'
User not found, connexion refused