Linux vps-61133.fhnet.fr 4.9.0-19-amd64 #1 SMP Debian 4.9.320-2 (2022-06-30) x86_64
Apache/2.4.25 (Debian)
Server IP : 93.113.207.21 & Your IP : 216.73.216.35
Domains :
Cant Read [ /etc/named.conf ]
User : www-data
Terminal
Auto Root
Create File
Create Folder
Localroot Suggester
Backdoor Destroyer
Readme
/
var /
www /
html /
speed.bdcloud.fr /
Delete
Unzip
Name
Size
Permission
Date
Action
accountancy
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
accounting
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
adherents
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
admin
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
api
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
asset
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
asterisk
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
bank
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
banque
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
barcode
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
blockedlog
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
bom
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
bookmarks
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
cashdesk
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
categories
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
collab
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
comm
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
commande
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
compta
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
comptabilite
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
conf
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
contact
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
contrat
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
core
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
cron
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
custom
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
datapolicy
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
dav
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
debugbar
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
doctemplates
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
don
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
ecm
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
emailcollector
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
expedition
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
expensereport
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
exports
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
externalsite
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
facture
[ DIR ]
drwxr-xr-x
2025-11-27 12:55
ficheinter
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
fichinter
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
fourn
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
fournisseur
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
ftp
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
holiday
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
hrm
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
imports
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
includes
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
langs
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
livraison
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
loan
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
mailmanspip
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
margin
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
medias
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
modulebuilder
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
mrp
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
multicurrency
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
mycompany
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
opensurvey
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
paybox
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
paypal
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
printing
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
product
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
produit
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
projet
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
propale
[ DIR ]
drwxr-xr-x
2025-12-03 13:50
public
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
reception
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
resource
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
salaries
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
societe
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
speed_db
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
stock
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
stripe
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
supplier_proposal
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
support
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
takepos
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
tax
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
theme
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
ticket
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
user
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
users
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
variants
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
webservices
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
website
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
zapier
[ DIR ]
drwxr-xr-x
2025-11-08 11:17
.htaccess.bak
420
B
-rw-r--r--
2021-05-27 03:04
document.php
9.52
KB
-rw-r--r--
2020-09-02 15:31
dolibarr.log
80.66
KB
-rw-rw-r--
2025-11-25 10:50
favicon.ico
2.19
KB
-rw-r--r--
2020-09-02 15:31
filefunc.inc.php
17.14
KB
-rw-r--r--
2020-09-02 15:31
index.php
45.87
KB
-rw-r--r--
2022-07-02 09:13
main.inc.php
122.27
KB
-rw-r--r--
2020-09-02 15:31
master.inc.php
11.29
KB
-rw-r--r--
2020-09-02 15:31
opcachepreload.php
1.12
KB
-rw-r--r--
2020-09-02 15:31
speed_doc.tar.bz2
2.09
MB
-rw-r--r--
2021-02-23 22:28
viewimage.php
10.76
KB
-rw-r--r--
2020-09-02 15:31
Save
Rename
2025-02-09 10:49:26 INFO 78.197.71.109 --- Access to /index.php - action= - actionlogin= - showing the login form and exit 2025-02-09 10:49:26 DEBUG 78.197.71.109 sql=SELECT transkey, transvalue FROM llxdx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2025-02-09 10:49:26 INFO 78.197.71.109 --- End access to /index.php 2025-02-09 10:49:27 INFO 78.197.71.109 --- Access to /theme/eldy/style.css.php - action=, massaction= 2025-02-09 10:49:27 DEBUG 78.197.71.109 sql=SELECT transkey, transvalue FROM llxdx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2025-02-09 10:49:27 DEBUG 78.197.71.109 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 llxdx_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 2025-02-09 10:49:27 INFO 78.197.71.109 --- End access to /theme/eldy/style.css.php 2025-02-09 10:49:27 INFO 78.197.71.109 --- Access to /core/js/lib_head.js.php - action=, massaction= 2025-02-09 10:49:27 DEBUG 78.197.71.109 sql=SELECT transkey, transvalue FROM llxdx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2025-02-09 10:49:27 INFO 78.197.71.109 --- End access to /core/js/lib_head.js.php 2025-02-09 10:49:27 INFO 78.197.71.109 --- Access to /viewimage.php - action=, massaction= 2025-02-09 10:49:27 INFO 78.197.71.109 modulepart=mycompany original_file=logos/thumbs/logo_speedscooter_small.jpg entity=1 2025-02-09 10:49:27 INFO 78.197.71.109 viewimage.php return file /var/www/html/speed.bdcloud.fr/mycompany/logos/thumbs/logo_speedscooter_small.jpg filename=logo_speedscooter_small.jpg content-type=image/jpeg 2025-02-09 10:49:27 INFO 78.197.71.109 --- End access to /viewimage.php 2025-02-09 10:49:27 INFO 78.197.71.109 --- Access to /viewimage.php - action=, massaction= 2025-02-09 10:49:27 INFO 78.197.71.109 modulepart=mycompany original_file=logos/thumbs/logo_speedscooter_mini.jpg entity=1 2025-02-09 10:49:27 INFO 78.197.71.109 viewimage.php return file /var/www/html/speed.bdcloud.fr/mycompany/logos/thumbs/logo_speedscooter_mini.jpg filename=logo_speedscooter_mini.jpg content-type=image/jpeg 2025-02-09 10:49:27 INFO 78.197.71.109 --- End access to /viewimage.php 2025-02-09 10:49:31 INFO 78.197.71.109 checkLoginPassEntity usertotest=admin entitytotest=1 authmode=dolibarr 2025-02-09 10:49:31 INFO 78.197.71.109 functions_dolibarr::check_user_password_dolibarr usertotest=admin passwordtotest=******** entitytotest=1 2025-02-09 10:49:31 DEBUG 78.197.71.109 sql=SELECT rowid, login, entity, pass, pass_crypted FROM llxdx_user WHERE (login = 'admin') AND entity IN (0,1) AND statut = 1 ORDER BY entity DESC 2025-02-09 10:49:33 NOTICE 78.197.71.109 functions_dolibarr::check_user_password_dolibarr Authentication KO bad password for 'admin', cryptType=md5 2025-02-09 10:49:33 DEBUG 78.197.71.109 sql=SELECT transkey, transvalue FROM llxdx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2025-02-09 10:49:33 DEBUG 78.197.71.109 Bad password, connexion refused 2025-02-09 10:49:33 INFO 78.197.71.109 --- Access to /index.php - action= - actionlogin=login - showing the login form and exit 2025-02-09 10:49:33 INFO 78.197.71.109 --- End access to /index.php 2025-02-09 10:49:33 INFO 78.197.71.109 --- Access to /theme/eldy/style.css.php - action=, massaction= 2025-02-09 10:49:33 DEBUG 78.197.71.109 sql=SELECT transkey, transvalue FROM llxdx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2025-02-09 10:49:33 DEBUG 78.197.71.109 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 llxdx_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 2025-02-09 10:49:33 INFO 78.197.71.109 --- End access to /theme/eldy/style.css.php 2025-02-09 10:49:37 INFO 78.197.71.109 checkLoginPassEntity usertotest=admin entitytotest=1 authmode=dolibarr 2025-02-09 10:49:37 INFO 78.197.71.109 functions_dolibarr::check_user_password_dolibarr usertotest=admin passwordtotest=******** entitytotest=1 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT rowid, login, entity, pass, pass_crypted FROM llxdx_user WHERE (login = 'admin') AND entity IN (0,1) AND statut = 1 ORDER BY entity DESC 2025-02-09 10:49:37 INFO 78.197.71.109 functions_dolibarr::check_user_password_dolibarr Authentification ok - md5 of pass is ok 2025-02-09 10:49:37 DEBUG 78.197.71.109 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_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 llxdx_user as u LEFT JOIN llxdx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxdx_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 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llxdx_extrafields WHERE elementtype = 'user' ORDER BY pos 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT param, value FROM llxdx_user_param WHERE fk_user = 1 AND entity = 1 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT rowid, entity, type, page, param, value FROM llxdx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2025-02-09 10:49:37 INFO 78.197.71.109 This is a new started user session. _SESSION['dol_login']=admin Session id=oacnj8aujd8e4fmi2ejfv8d0g3 2025-02-09 10:49:37 DEBUG 78.197.71.109 BEGIN Transaction 2025-02-09 10:49:37 DEBUG 78.197.71.109 User::update_last_login_date user->id=1 UPDATE llxdx_user SET datepreviouslogin = datelastlogin, datelastlogin = '2025-02-09 10:49:37', tms = tms WHERE rowid = 1 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=UPDATE llxdx_user SET datepreviouslogin = datelastlogin, datelastlogin = '2025-02-09 10:49:37', tms = tms WHERE rowid = 1 2025-02-09 10:49:37 DEBUG 78.197.71.109 COMMIT Transaction 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxdx_user_rights as ur, llxdx_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 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxdx_usergroup_rights as gr, llxdx_usergroup_user as gu, llxdx_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 2025-02-09 10:49:37 INFO 78.197.71.109 --- Access to /index.php - action=, massaction= 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT transkey, transvalue FROM llxdx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2025-02-09 10:49:37 DEBUG 78.197.71.109 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 llxdx_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 2025-02-09 10:49:37 DEBUG 78.197.71.109 InfoBox::listBoxes get default box list for mode=activated userid= 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT b.rowid, b.position, b.box_order, b.fk_user, d.rowid as box_id, d.file, d.note, d.tms FROM llxdx_boxes as b, llxdx_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 2025-02-09 10:49:37 INFO 78.197.71.109 box_lastlogin::showBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.logo, s.email, e.ref, e.tms, e.rowid, e.ref_customer, e.fk_statut, e.fk_user_valid, c.ref as commande_ref, c.rowid as commande_id FROM llxdx_expedition as e LEFT JOIN llxdx_element_element as el ON e.rowid = el.fk_target AND el.targettype = 'shipping' AND el.sourcetype IN ('commande') LEFT JOIN llxdx_commande as c ON el.fk_source = c.rowid AND el.sourcetype IN ('commande') AND el.targettype = 'shipping' LEFT JOIN llxdx_societe as s ON s.rowid = e.fk_soc WHERE e.entity = 1 ORDER BY e.date_delivery, e.ref DESC LIMIT 5 2025-02-09 10:49:37 INFO 78.197.71.109 box_shipments::showBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.logo, s.email, c.ref, c.tms, c.rowid, c.date_commande, c.ref_client, c.fk_statut, c.fk_user_valid, c.facture, c.total_ht, c.tva as total_tva, c.total_ttc FROM llxdx_societe as s, llxdx_commande as c WHERE c.fk_soc = s.rowid AND c.entity = 1 ORDER BY c.tms DESC, c.ref DESC LIMIT 5 2025-02-09 10:49:37 INFO 78.197.71.109 box_commandes::showBox 2025-02-09 10:49:37 INFO 78.197.71.109 CommandeStats::getNbByMonthWithPrevYear cache file /var/www/html/speed.bdcloud.fr/users/temp/CommandeStats_getNbByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1739094577 - 86400) so we can't use it. 2025-02-09 10:49:37 DEBUG 78.197.71.109 CommandeStats::_getNbByMonth 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT date_format(c.date_commande,'%m') as dm, COUNT(*) as nb FROM llxdx_commande as c WHERE c.date_commande BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:59' AND c.fk_statut > 0 AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC 2025-02-09 10:49:37 DEBUG 78.197.71.109 CommandeStats::_getNbByMonth 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT date_format(c.date_commande,'%m') as dm, COUNT(*) as nb FROM llxdx_commande as c WHERE c.date_commande BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59' AND c.fk_statut > 0 AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC 2025-02-09 10:49:37 INFO 78.197.71.109 CommandeStats::getNbByMonthWithPrevYear save cache file /var/www/html/speed.bdcloud.fr/users/temp/CommandeStats_getNbByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache onto disk. 2025-02-09 10:49:37 INFO 78.197.71.109 DolGraph::draw_chart this->type= this->MaxValue=0 2025-02-09 10:49:37 INFO 78.197.71.109 CommandeStats::getAmountByMonthWithPrevYear cache file /var/www/html/speed.bdcloud.fr/users/temp/CommandeStats_getAmountByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1739094577 - 86400) so we can't use it. 2025-02-09 10:49:37 DEBUG 78.197.71.109 CommandeStats::_getAmountByMonth 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT date_format(c.date_commande,'%m') as dm, SUM(c.total_ht) FROM llxdx_commande as c WHERE c.date_commande BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:59' AND c.fk_statut > 0 AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC 2025-02-09 10:49:37 DEBUG 78.197.71.109 CommandeStats::_getAmountByMonth 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT date_format(c.date_commande,'%m') as dm, SUM(c.total_ht) FROM llxdx_commande as c WHERE c.date_commande BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59' AND c.fk_statut > 0 AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC 2025-02-09 10:49:37 INFO 78.197.71.109 CommandeStats::getAmountByMonthWithPrevYear save cache file /var/www/html/speed.bdcloud.fr/users/temp/CommandeStats_getAmountByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache onto disk. 2025-02-09 10:49:37 INFO 78.197.71.109 DolGraph::draw_chart this->type= this->MaxValue=0 2025-02-09 10:49:37 INFO 78.197.71.109 box_graph_orders_permonth::showBox 2025-02-09 10:49:37 INFO 78.197.71.109 FactureStats::getNbByMonthWithPrevYear cache file /var/www/html/speed.bdcloud.fr/users/temp/FactureStats_getNbByMonthWithPrevYear_supplier_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1739094577 - 86400) so we can't use it. 2025-02-09 10:49:37 DEBUG 78.197.71.109 FactureStats::_getNbByMonth 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT date_format(f.datef,'%m') as dm, COUNT(*) as nb FROM llxdx_facture_fourn as f WHERE f.datef BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:59' AND f.fk_statut >= 0 AND f.entity IN (1) AND f.type IN (0,1,2,3,5) GROUP BY dm ORDER BY dm DESC 2025-02-09 10:49:37 DEBUG 78.197.71.109 FactureStats::_getNbByMonth 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT date_format(f.datef,'%m') as dm, COUNT(*) as nb FROM llxdx_facture_fourn as f WHERE f.datef BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59' AND f.fk_statut >= 0 AND f.entity IN (1) AND f.type IN (0,1,2,3,5) GROUP BY dm ORDER BY dm DESC 2025-02-09 10:49:37 INFO 78.197.71.109 FactureStats::getNbByMonthWithPrevYear save cache file /var/www/html/speed.bdcloud.fr/users/temp/FactureStats_getNbByMonthWithPrevYear_supplier_fr_FR_entity.1_user1.cache onto disk. 2025-02-09 10:49:37 INFO 78.197.71.109 DolGraph::draw_chart this->type= this->MaxValue=0 2025-02-09 10:49:37 INFO 78.197.71.109 FactureStats::getAmountByMonthWithPrevYear cache file /var/www/html/speed.bdcloud.fr/users/temp/FactureStats_getAmountByMonthWithPrevYear_supplier_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1739094577 - 86400) so we can't use it. 2025-02-09 10:49:37 DEBUG 78.197.71.109 FactureStats::_getAmountByMonth 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT date_format(datef,'%m') as dm, SUM(f.total_ht) FROM llxdx_facture_fourn as f WHERE f.datef BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:59' AND f.fk_statut >= 0 AND f.entity IN (1) AND f.type IN (0,1,2,3,5) GROUP BY dm ORDER BY dm DESC 2025-02-09 10:49:37 DEBUG 78.197.71.109 FactureStats::_getAmountByMonth 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT date_format(datef,'%m') as dm, SUM(f.total_ht) FROM llxdx_facture_fourn as f WHERE f.datef BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59' AND f.fk_statut >= 0 AND f.entity IN (1) AND f.type IN (0,1,2,3,5) GROUP BY dm ORDER BY dm DESC 2025-02-09 10:49:37 INFO 78.197.71.109 FactureStats::getAmountByMonthWithPrevYear save cache file /var/www/html/speed.bdcloud.fr/users/temp/FactureStats_getAmountByMonthWithPrevYear_supplier_fr_FR_entity.1_user1.cache onto disk. 2025-02-09 10:49:37 INFO 78.197.71.109 DolGraph::draw_chart this->type= this->MaxValue=0 2025-02-09 10:49:37 INFO 78.197.71.109 box_graph_invoices_supplier_permonth::showBox 2025-02-09 10:49:37 INFO 78.197.71.109 CommandeStats::getNbByMonthWithPrevYear cache file /var/www/html/speed.bdcloud.fr/users/temp/CommandeStats_getNbByMonthWithPrevYear_supplier_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1739094577 - 86400) so we can't use it. 2025-02-09 10:49:37 DEBUG 78.197.71.109 CommandeStats::_getNbByMonth 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT date_format(c.date_commande,'%m') as dm, COUNT(*) as nb FROM llxdx_commande_fournisseur as c WHERE c.date_commande BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:59' AND c.fk_statut > 2 AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC 2025-02-09 10:49:37 DEBUG 78.197.71.109 CommandeStats::_getNbByMonth 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT date_format(c.date_commande,'%m') as dm, COUNT(*) as nb FROM llxdx_commande_fournisseur as c WHERE c.date_commande BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59' AND c.fk_statut > 2 AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC 2025-02-09 10:49:37 INFO 78.197.71.109 CommandeStats::getNbByMonthWithPrevYear save cache file /var/www/html/speed.bdcloud.fr/users/temp/CommandeStats_getNbByMonthWithPrevYear_supplier_fr_FR_entity.1_user1.cache onto disk. 2025-02-09 10:49:37 INFO 78.197.71.109 DolGraph::draw_chart this->type= this->MaxValue=0 2025-02-09 10:49:37 INFO 78.197.71.109 CommandeStats::getAmountByMonthWithPrevYear cache file /var/www/html/speed.bdcloud.fr/users/temp/CommandeStats_getAmountByMonthWithPrevYear_supplier_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1739094577 - 86400) so we can't use it. 2025-02-09 10:49:37 DEBUG 78.197.71.109 CommandeStats::_getAmountByMonth 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT date_format(c.date_commande,'%m') as dm, SUM(c.total_ht) FROM llxdx_commande_fournisseur as c WHERE c.date_commande BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:59' AND c.fk_statut > 2 AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC 2025-02-09 10:49:37 DEBUG 78.197.71.109 CommandeStats::_getAmountByMonth 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT date_format(c.date_commande,'%m') as dm, SUM(c.total_ht) FROM llxdx_commande_fournisseur as c WHERE c.date_commande BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59' AND c.fk_statut > 2 AND c.entity IN (1) GROUP BY dm ORDER BY dm DESC 2025-02-09 10:49:37 INFO 78.197.71.109 CommandeStats::getAmountByMonthWithPrevYear save cache file /var/www/html/speed.bdcloud.fr/users/temp/CommandeStats_getAmountByMonthWithPrevYear_supplier_fr_FR_entity.1_user1.cache onto disk. 2025-02-09 10:49:37 INFO 78.197.71.109 DolGraph::draw_chart this->type= this->MaxValue=0 2025-02-09 10:49:37 INFO 78.197.71.109 box_graph_orders_supplier_permonth::showBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT s.nom as name, s.rowid as socid, s.datec, s.tms, s.status, s.code_fournisseur, s.email as semail, s.logo, s.code_compta_fournisseur, s.entity FROM llxdx_societe as s WHERE s.fournisseur = 1 AND s.entity IN (1) ORDER BY s.tms DESC LIMIT 5 2025-02-09 10:49:37 INFO 78.197.71.109 box_fournisseurs::showBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 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.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 llxdx_societe as s,llxdx_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 2025-02-09 10:49:37 INFO 78.197.71.109 box_factures_fourn_imp::showBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT s.nom as name, s.rowid as socid, s.code_fournisseur, s.email, 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 llxdx_societe as s, llxdx_facture_fourn as f WHERE f.fk_soc = s.rowid AND f.entity = 1 ORDER BY f.tms DESC, f.ref DESC LIMIT 5 2025-02-09 10:49:37 INFO 78.197.71.109 box_factures_fourn::showBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.code_fournisseur, s.logo, s.email, c.rowid, c.ref, c.tms, c.date_commande, c.total_ht, c.tva as total_tva, c.total_ttc, c.fk_statut FROM llxdx_societe as s, llxdx_commande_fournisseur as c WHERE c.fk_soc = s.rowid AND c.entity = 1 ORDER BY c.tms DESC, c.ref DESC LIMIT 5 2025-02-09 10:49:37 INFO 78.197.71.109 box_supplier_orders::showBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.code_fournisseur, s.email, s.logo, c.rowid, c.ref, c.tms, c.date_commande, c.date_livraison, c.total_ht, c.tva as total_tva, c.total_ttc, c.fk_statut FROM llxdx_societe as s, llxdx_commande_fournisseur as c WHERE c.fk_soc = s.rowid AND c.entity = 1 AND c.fk_statut = 3 ORDER BY c.date_livraison ASC, c.fk_statut ASC LIMIT 5 2025-02-09 10:49:37 INFO 78.197.71.109 box_supplier_orders_awaiting_reception::showBox 2025-02-09 10:49:37 INFO 78.197.71.109 PropaleStats::getNbByMonthWithPrevYear cache file /var/www/html/speed.bdcloud.fr/users/temp/PropaleStats_getNbByMonthWithPrevYear_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1739094577 - 86400) so we can't use it. 2025-02-09 10:49:37 DEBUG 78.197.71.109 PropaleStats::_getNbByMonth 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT date_format(p.datep,'%m') as dm, COUNT(*) as nb FROM llxdx_propal as p WHERE p.datep BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:59' AND p.fk_statut > 0 AND p.entity IN (1) GROUP BY dm ORDER BY dm DESC 2025-02-09 10:49:37 DEBUG 78.197.71.109 PropaleStats::_getNbByMonth 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT date_format(p.datep,'%m') as dm, COUNT(*) as nb FROM llxdx_propal as p WHERE p.datep BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59' AND p.fk_statut > 0 AND p.entity IN (1) GROUP BY dm ORDER BY dm DESC 2025-02-09 10:49:37 INFO 78.197.71.109 PropaleStats::getNbByMonthWithPrevYear save cache file /var/www/html/speed.bdcloud.fr/users/temp/PropaleStats_getNbByMonthWithPrevYear_fr_FR_entity.1_user1.cache onto disk. 2025-02-09 10:49:37 INFO 78.197.71.109 DolGraph::draw_chart this->type=bars,bars this->MaxValue=2 2025-02-09 10:49:37 INFO 78.197.71.109 PropaleStats::getAmountByMonthWithPrevYear cache file /var/www/html/speed.bdcloud.fr/users/temp/PropaleStats_getAmountByMonthWithPrevYear_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1739094577 - 86400) so we can't use it. 2025-02-09 10:49:37 DEBUG 78.197.71.109 PropaleStats::_getAmountByMonth 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT date_format(p.datep,'%m') as dm, SUM(p.total_ht) FROM llxdx_propal as p WHERE p.datep BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:59' AND p.fk_statut > 0 AND p.entity IN (1) GROUP BY dm ORDER BY dm DESC 2025-02-09 10:49:37 DEBUG 78.197.71.109 PropaleStats::_getAmountByMonth 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT date_format(p.datep,'%m') as dm, SUM(p.total_ht) FROM llxdx_propal as p WHERE p.datep BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59' AND p.fk_statut > 0 AND p.entity IN (1) GROUP BY dm ORDER BY dm DESC 2025-02-09 10:49:37 INFO 78.197.71.109 PropaleStats::getAmountByMonthWithPrevYear save cache file /var/www/html/speed.bdcloud.fr/users/temp/PropaleStats_getAmountByMonthWithPrevYear_fr_FR_entity.1_user1.cache onto disk. 2025-02-09 10:49:37 INFO 78.197.71.109 DolGraph::draw_chart this->type=bars,bars this->MaxValue=3000 2025-02-09 10:49:37 INFO 78.197.71.109 box_graph_propales_permonth::showBox 2025-02-09 10:49:37 INFO 78.197.71.109 FactureStats::getAllByProductEntry cache file /var/www/html/speed.bdcloud.fr/users/temp/FactureStats_getAllByProductEntry_customer_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1739094577 - 86400) so we can't use it. 2025-02-09 10:49:37 DEBUG 78.197.71.109 FactureStats::_getAllByProduct 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT product.ref, COUNT(product.ref) as nb, SUM(tl.total_ht) as total, AVG(tl.total_ht) as avg FROM llxdx_facture as f, llxdx_facturedet as tl, llxdx_product as product WHERE f.fk_statut >= 0 AND f.entity IN (1) AND (f.fk_statut <> 3 OR f.close_code <> 'replaced') AND f.type IN (0,1,2,3,5) AND f.rowid = tl.fk_facture AND tl.fk_product = product.rowid AND f.datef BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59' GROUP BY product.ref ORDER BY nb DESC 2025-02-09 10:49:37 INFO 78.197.71.109 FactureStats::getAllByProductEntry save cache file /var/www/html/speed.bdcloud.fr/users/temp/FactureStats_getAllByProductEntry_customer_fr_FR_entity.1_user1.cache onto disk. 2025-02-09 10:49:37 INFO 78.197.71.109 DolGraph::draw_chart this->type=pie this->MaxValue=2 2025-02-09 10:49:37 INFO 78.197.71.109 PropaleStats::getAllByProductEntry cache file /var/www/html/speed.bdcloud.fr/users/temp/PropaleStats_getAllByProductEntry_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1739094577 - 86400) so we can't use it. 2025-02-09 10:49:37 DEBUG 78.197.71.109 PropaleStats::_getAllByProduct 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT product.ref, COUNT(product.ref) as nb, SUM(tl.total_ht) as total, AVG(tl.total_ht) as avg FROM llxdx_propal as p, llxdx_propaldet as tl, llxdx_product as product WHERE p.fk_statut > 0 AND p.entity IN (1) AND p.rowid = tl.fk_propal AND tl.fk_product = product.rowid AND p.datep BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59' GROUP BY product.ref ORDER BY nb DESC 2025-02-09 10:49:37 INFO 78.197.71.109 PropaleStats::getAllByProductEntry save cache file /var/www/html/speed.bdcloud.fr/users/temp/PropaleStats_getAllByProductEntry_fr_FR_entity.1_user1.cache onto disk. 2025-02-09 10:49:37 INFO 78.197.71.109 DolGraph::draw_chart this->type=pie this->MaxValue=2 2025-02-09 10:49:37 INFO 78.197.71.109 CommandeStats::getAllByProductEntry cache file /var/www/html/speed.bdcloud.fr/users/temp/CommandeStats_getAllByProductEntry_customer_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1739094577 - 86400) so we can't use it. 2025-02-09 10:49:37 DEBUG 78.197.71.109 CommandeStats::_getAllByProduct 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT product.ref, COUNT(product.ref) as nb, SUM(tl.total_ht) as total, AVG(tl.total_ht) as avg FROM llxdx_commande as c, llxdx_commandedet as tl, llxdx_product as product WHERE c.fk_statut > 0 AND c.entity IN (1) AND c.rowid = tl.fk_commande AND tl.fk_product = product.rowid AND c.date_commande BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59' GROUP BY product.ref ORDER BY nb DESC 2025-02-09 10:49:37 INFO 78.197.71.109 CommandeStats::getAllByProductEntry save cache file /var/www/html/speed.bdcloud.fr/users/temp/CommandeStats_getAllByProductEntry_customer_fr_FR_entity.1_user1.cache onto disk. 2025-02-09 10:49:37 INFO 78.197.71.109 DolGraph::draw_chart this->type=pie this->MaxValue=2 2025-02-09 10:49:37 INFO 78.197.71.109 box_graph_product_distribution::showBox 2025-02-09 10:49:37 INFO 78.197.71.109 ModeleBoxes::showBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT p.rowid, p.label, p.price, p.ref, p.price_base_type, p.price_ttc, p.fk_product_type, p.tms, p.tosell, p.tobuy, p.barcode, p.seuil_stock_alerte, p.entity, p.accountancy_code_sell, p.accountancy_code_sell_intra, p.accountancy_code_sell_export, p.accountancy_code_buy, p.accountancy_code_buy_intra, p.accountancy_code_buy_export, SUM(IF(s.reel IS NULL,0,s.reel)) as total_stock FROM llxdx_product as p LEFT JOIN llxdx_product_stock as s on p.rowid = s.fk_product WHERE p.entity IN (1) AND p.tosell = 1 AND p.seuil_stock_alerte > 0 GROUP BY p.rowid, p.ref, p.label, p.price, p.price_base_type, p.price_ttc, p.fk_product_type, p.tms, p.tosell, p.tobuy, p.barcode, p.seuil_stock_alerte, p.entity, p.accountancy_code_sell, p.accountancy_code_sell_intra, p.accountancy_code_sell_export, p.accountancy_code_buy, p.accountancy_code_buy_intra, p.accountancy_code_buy_export HAVING SUM(IF(s.reel IS NULL,0,s.reel)) < p.seuil_stock_alerte ORDER BY p.seuil_stock_alerte DESC LIMIT 5 2025-02-09 10:49:37 INFO 78.197.71.109 box_produits_alerte_stock::showBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 box_birthdays::loadBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT u.rowid, u.firstname, u.lastname, u.birth FROM llxdx_user as u WHERE u.entity IN (0,1) AND date_format( u.birth, '%c') = '2' ORDER BY u.birth ASC LIMIT 5 2025-02-09 10:49:37 INFO 78.197.71.109 box_birthdays::showBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 box_clients::loadBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 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, s.entity FROM llxdx_societe as s WHERE s.client IN (1, 3) AND s.entity IN (1) ORDER BY s.tms DESC LIMIT 5 2025-02-09 10:49:37 INFO 78.197.71.109 box_clients::showBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 box_prospect::loadBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.client, s.email, s.code_fournisseur, s.fournisseur, s.logo, s.fk_stcomm, s.datec, s.tms, s.status FROM llxdx_societe as s WHERE s.client IN (2, 3) AND s.entity IN (1) ORDER BY s.tms DESC LIMIT 5 2025-02-09 10:49:37 INFO 78.197.71.109 box_prospect::showBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 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, sp.email as spemail, s.nom as socname, s.name_alias, s.email as semail, s.client, s.fournisseur, s.code_client, s.code_fournisseur, co.label as country, co.code as country_code FROM llxdx_socpeople as sp LEFT JOIN llxdx_c_country as co ON sp.fk_pays = co.rowid LEFT JOIN llxdx_societe as s ON sp.fk_soc = s.rowid WHERE sp.entity IN (1) ORDER BY sp.tms DESC LIMIT 5 2025-02-09 10:49:37 INFO 78.197.71.109 box_contacts::showBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 box_ficheinter::loadBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT f.rowid, f.ref, f.fk_soc, f.fk_statut, f.datec, f.date_valid as datev, f.tms as datem, s.nom as name, s.rowid as socid, s.client, s.email as semail FROM llxdx_societe as s, llxdx_fichinter as f WHERE f.fk_soc = s.rowid AND f.entity = 1 ORDER BY f.tms DESC LIMIT 5 2025-02-09 10:49:37 INFO 78.197.71.109 box_ficheinter::showBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT s.nom as name, s.rowid as socid, s.email, s.code_client, s.logo, f.ref, f.date_lim_reglement as datelimite, f.type, 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 llxdx_societe as s, llxdx_facture as f LEFT JOIN llxdx_paiement_facture as pf ON f.rowid=pf.fk_facture WHERE f.fk_soc = s.rowid AND f.entity IN (1) AND f.paye = 0 AND fk_statut = 1 GROUP BY s.nom, s.rowid, s.email, s.code_client, s.logo, f.ref, f.date_lim_reglement, f.type, f.datef, f.total, f.tva, f.total_ttc, f.paye, f.fk_statut, f.rowid ORDER BY datelimite ASC, f.ref ASC LIMIT 5 2025-02-09 10:49:37 DEBUG 78.197.71.109 Translate::loadCacheCurrencies 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT code_iso, label, unicode FROM llxdx_c_currencies WHERE active = 1 AND code_iso = 'EUR' 2025-02-09 10:49:37 INFO 78.197.71.109 box_factures_imp::showBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT f.rowid as facid, f.ref, 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 (llxdx_societe as s,llxdx_facture as f) WHERE f.fk_soc = s.rowid AND f.entity IN (1) ORDER BY f.tms DESC, f.ref DESC LIMIT 5 2025-02-09 10:49:37 INFO 78.197.71.109 box_factures::showBox 2025-02-09 10:49:37 INFO 78.197.71.109 FactureStats::getNbByMonthWithPrevYear cache file /var/www/html/speed.bdcloud.fr/users/temp/FactureStats_getNbByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1739094577 - 86400) so we can't use it. 2025-02-09 10:49:37 DEBUG 78.197.71.109 FactureStats::_getNbByMonth 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT date_format(f.datef,'%m') as dm, COUNT(*) as nb FROM llxdx_facture as f WHERE f.datef BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:59' AND f.fk_statut >= 0 AND f.entity IN (1) AND (f.fk_statut <> 3 OR f.close_code <> 'replaced') AND f.type IN (0,1,2,3,5) GROUP BY dm ORDER BY dm DESC 2025-02-09 10:49:37 DEBUG 78.197.71.109 FactureStats::_getNbByMonth 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT date_format(f.datef,'%m') as dm, COUNT(*) as nb FROM llxdx_facture as f WHERE f.datef BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59' AND f.fk_statut >= 0 AND f.entity IN (1) AND (f.fk_statut <> 3 OR f.close_code <> 'replaced') AND f.type IN (0,1,2,3,5) GROUP BY dm ORDER BY dm DESC 2025-02-09 10:49:37 INFO 78.197.71.109 FactureStats::getNbByMonthWithPrevYear save cache file /var/www/html/speed.bdcloud.fr/users/temp/FactureStats_getNbByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache onto disk. 2025-02-09 10:49:37 INFO 78.197.71.109 DolGraph::draw_chart this->type= this->MaxValue=30 2025-02-09 10:49:37 INFO 78.197.71.109 FactureStats::getAmountByMonthWithPrevYear cache file /var/www/html/speed.bdcloud.fr/users/temp/FactureStats_getAmountByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache is not found or older than now - cachedelay (1739094577 - 86400) so we can't use it. 2025-02-09 10:49:37 DEBUG 78.197.71.109 FactureStats::_getAmountByMonth 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT date_format(datef,'%m') as dm, SUM(f.total) FROM llxdx_facture as f WHERE f.datef BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:59' AND f.fk_statut >= 0 AND f.entity IN (1) AND (f.fk_statut <> 3 OR f.close_code <> 'replaced') AND f.type IN (0,1,2,3,5) GROUP BY dm ORDER BY dm DESC 2025-02-09 10:49:37 DEBUG 78.197.71.109 FactureStats::_getAmountByMonth 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT date_format(datef,'%m') as dm, SUM(f.total) FROM llxdx_facture as f WHERE f.datef BETWEEN '2025-01-01 00:00:00' AND '2025-12-31 23:59:59' AND f.fk_statut >= 0 AND f.entity IN (1) AND (f.fk_statut <> 3 OR f.close_code <> 'replaced') AND f.type IN (0,1,2,3,5) GROUP BY dm ORDER BY dm DESC 2025-02-09 10:49:37 INFO 78.197.71.109 FactureStats::getAmountByMonthWithPrevYear save cache file /var/www/html/speed.bdcloud.fr/users/temp/FactureStats_getAmountByMonthWithPrevYear_customer_fr_FR_entity.1_user1.cache onto disk. 2025-02-09 10:49:37 INFO 78.197.71.109 DolGraph::draw_chart this->type= this->MaxValue=4000 2025-02-09 10:49:37 INFO 78.197.71.109 box_graph_invoices_permonth::showBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 box_comptes::loadBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 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 llxdx_bank_account as b LEFT JOIN llxdx_accounting_journal as aj ON aj.rowid=b.fk_accountancy_journal WHERE b.entity = 1 AND clos = 0 ORDER BY label LIMIT 5 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT sum(amount) as amount FROM llxdx_bank WHERE fk_account = 1 2025-02-09 10:49:37 INFO 78.197.71.109 box_comptes::showBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 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 llxdx_product as p WHERE p.entity IN (1) ORDER BY p.datec DESC LIMIT 5 2025-02-09 10:49:37 INFO 78.197.71.109 files.lib.php::dol_dir_list path=/var/www/html/speed.bdcloud.fr/produit/SSP0000124/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llxdx_ecm_files WHERE filepath = 'produit/SSP0000124' AND entity = 1 2025-02-09 10:49:37 INFO 78.197.71.109 files.lib.php::dol_dir_list path=/var/www/html/speed.bdcloud.fr/produit/SSP0000123/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llxdx_ecm_files WHERE filepath = 'produit/SSP0000123' AND entity = 1 2025-02-09 10:49:37 INFO 78.197.71.109 files.lib.php::dol_dir_list path=/var/www/html/speed.bdcloud.fr/produit/SSP0000122/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llxdx_ecm_files WHERE filepath = 'produit/SSP0000122' AND entity = 1 2025-02-09 10:49:37 INFO 78.197.71.109 files.lib.php::dol_dir_list path=/var/www/html/speed.bdcloud.fr/produit/SSP0000121/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llxdx_ecm_files WHERE filepath = 'produit/SSP0000121' AND entity = 1 2025-02-09 10:49:37 INFO 78.197.71.109 files.lib.php::dol_dir_list path=/var/www/html/speed.bdcloud.fr/produit/SSP0000120/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$" 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, date_m, fk_user_c, fk_user_m, acl, position, share FROM llxdx_ecm_files WHERE filepath = 'produit/SSP0000120' AND entity = 1 2025-02-09 10:49:37 INFO 78.197.71.109 box_produits::showBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT s.nom as name, s.rowid as socid, s.code_client, s.logo, s.entity, s.email, p.rowid, p.ref, p.fk_statut, p.datep as dp, p.datec, p.fin_validite, p.date_cloture, p.total_ht, p.tva as total_tva, p.total as total_ttc, p.tms FROM llxdx_societe as s, llxdx_propal as p WHERE p.fk_soc = s.rowid AND p.entity = 1 ORDER BY p.tms DESC, p.ref DESC LIMIT 5 2025-02-09 10:49:37 INFO 78.197.71.109 box_propales::showBox 2025-02-09 10:49:37 INFO 78.197.71.109 ModeleBoxes::showBox 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT count(u.rowid) as nb FROM llxdx_user as u WHERE u.statut > 0 AND u.entity IN (0,1) 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT count(s.rowid) as nb, s.client FROM llxdx_societe as s WHERE s.client IN (1,2,3) AND s.entity IN (1) GROUP BY s.client 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT count(s.rowid) as nb FROM llxdx_societe as s WHERE s.fournisseur = 1 AND s.entity IN (1) 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT count(sp.rowid) as nb FROM llxdx_socpeople as sp WHERE sp.entity IN (1) AND (sp.priv='0' OR (sp.priv='1' AND sp.fk_user_creat=1)) 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT count(p.rowid) as nb, fk_product_type FROM llxdx_product as p WHERE p.entity IN (1) GROUP BY fk_product_type 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT count(p.rowid) as nb, fk_product_type FROM llxdx_product as p WHERE p.entity IN (1) GROUP BY fk_product_type 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT count(p.rowid) as nb FROM llxdx_propal as p LEFT JOIN llxdx_societe as s ON p.fk_soc = s.rowid WHERE p.entity IN (1) 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT count(co.rowid) as nb FROM llxdx_commande as co LEFT JOIN llxdx_societe as s ON co.fk_soc = s.rowid WHERE co.entity IN (1) 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT count(f.rowid) as nb FROM llxdx_facture as f LEFT JOIN llxdx_societe as s ON f.fk_soc = s.rowid WHERE f.entity IN (1) 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT count(co.rowid) as nb FROM llxdx_commande_fournisseur as co LEFT JOIN llxdx_societe as s ON co.fk_soc = s.rowid WHERE co.entity = 1 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT count(f.rowid) as nb FROM llxdx_facture_fourn as f LEFT JOIN llxdx_societe as s ON f.fk_soc = s.rowid WHERE f.entity = 1 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT count(fi.rowid) as nb FROM llxdx_fichinter as fi LEFT JOIN llxdx_societe as s ON fi.fk_soc = s.rowid WHERE fi.entity IN (1) 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT p.rowid, p.ref, p.datec as datec, p.fin_validite as datefin, p.total_ht FROM llxdx_propal as p WHERE p.entity IN (1) AND p.fk_statut = 1 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT p.rowid, p.ref, p.datec as datec, p.fin_validite as datefin, p.total_ht FROM llxdx_propal as p WHERE p.entity IN (1) AND p.fk_statut = 2 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT c.rowid, c.date_creation as datec, c.date_commande, c.date_livraison as delivery_date, c.fk_statut, c.total_ht FROM llxdx_commande as c WHERE c.entity IN (1) AND ((c.fk_statut IN (1,2)) OR (c.fk_statut = 3 AND c.facture = 0)) 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT c.rowid, c.date_creation as datec, c.date_commande, c.fk_statut, c.date_livraison as delivery_date FROM llxdx_commande_fournisseur as c WHERE c.entity = 1 AND c.fk_statut IN (1, 2) 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT c.rowid, c.date_creation as datec, c.date_commande, c.fk_statut, c.date_livraison as delivery_date FROM llxdx_commande_fournisseur as c WHERE c.entity = 1 AND c.fk_statut = 3 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT f.rowid, f.date_lim_reglement as datefin,f.fk_statut, f.total FROM llxdx_facture as f WHERE f.paye=0 AND f.entity IN (1) AND f.fk_statut = 1 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT ff.rowid, ff.date_lim_reglement as datefin, ff.fk_statut FROM llxdx_facture_fourn as ff WHERE ff.paye=0 AND ff.fk_statut > 0 AND ff.entity = 1 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT COUNT(ba.rowid) as nb FROM llxdx_bank_account as ba WHERE ba.rappro > 0 and ba.clos = 0 AND ba.entity IN (1) AND ba.courant != 2 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT b.rowid, b.datev as datefin FROM llxdx_bank as b, llxdx_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 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT b.rowid, b.datev as datefin FROM llxdx_bank as b, llxdx_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 2025-02-09 10:49:37 INFO 78.197.71.109 --- End access to /index.php 2025-02-09 10:49:37 INFO 78.197.71.109 --- Access to /theme/eldy/style.css.php - action=, massaction= 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT transkey, transvalue FROM llxdx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2025-02-09 10:49:37 DEBUG 78.197.71.109 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 llxdx_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 2025-02-09 10:49:37 DEBUG 78.197.71.109 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_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 llxdx_user as u LEFT JOIN llxdx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxdx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.login = 'admin' ORDER BY u.entity ASC 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llxdx_extrafields WHERE elementtype = 'user' ORDER BY pos 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT param, value FROM llxdx_user_param WHERE fk_user = 1 AND entity = 1 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT rowid, entity, type, page, param, value FROM llxdx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxdx_user_rights as ur, llxdx_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 2025-02-09 10:49:37 DEBUG 78.197.71.109 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxdx_usergroup_rights as gr, llxdx_usergroup_user as gu, llxdx_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 2025-02-09 10:49:37 INFO 78.197.71.109 --- End access to /theme/eldy/style.css.php 2025-02-09 10:49:38 INFO 78.197.71.109 --- Access to /core/js/lib_foot.js.php - action=, massaction= 2025-02-09 10:49:38 DEBUG 78.197.71.109 sql=SELECT transkey, transvalue FROM llxdx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2025-02-09 10:49:38 INFO 78.197.71.109 --- End access to /core/js/lib_foot.js.php 2025-02-09 10:49:40 DEBUG 78.197.71.109 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2025-02-09 10:49:40 DEBUG 78.197.71.109 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_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 llxdx_user as u LEFT JOIN llxdx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxdx_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 2025-02-09 10:49:40 DEBUG 78.197.71.109 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llxdx_extrafields WHERE elementtype = 'user' ORDER BY pos 2025-02-09 10:49:40 DEBUG 78.197.71.109 sql=SELECT param, value FROM llxdx_user_param WHERE fk_user = 1 AND entity = 1 2025-02-09 10:49:40 DEBUG 78.197.71.109 sql=SELECT rowid, entity, type, page, param, value FROM llxdx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2025-02-09 10:49:40 DEBUG 78.197.71.109 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxdx_user_rights as ur, llxdx_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 2025-02-09 10:49:40 DEBUG 78.197.71.109 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxdx_usergroup_rights as gr, llxdx_usergroup_user as gu, llxdx_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 2025-02-09 10:49:40 INFO 78.197.71.109 --- Access to /admin/index.php - action=, massaction= 2025-02-09 10:49:40 DEBUG 78.197.71.109 sql=SELECT transkey, transvalue FROM llxdx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2025-02-09 10:49:40 DEBUG 78.197.71.109 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 llxdx_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 2025-02-09 10:49:40 INFO 78.197.71.109 --- End access to /admin/index.php 2025-02-09 10:49:40 INFO 78.197.71.109 --- Access to /theme/eldy/style.css.php - action=, massaction= 2025-02-09 10:49:40 DEBUG 78.197.71.109 sql=SELECT transkey, transvalue FROM llxdx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2025-02-09 10:49:40 DEBUG 78.197.71.109 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 llxdx_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 2025-02-09 10:49:40 DEBUG 78.197.71.109 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_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 llxdx_user as u LEFT JOIN llxdx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxdx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.login = 'admin' ORDER BY u.entity ASC 2025-02-09 10:49:40 DEBUG 78.197.71.109 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llxdx_extrafields WHERE elementtype = 'user' ORDER BY pos 2025-02-09 10:49:40 DEBUG 78.197.71.109 sql=SELECT param, value FROM llxdx_user_param WHERE fk_user = 1 AND entity = 1 2025-02-09 10:49:40 DEBUG 78.197.71.109 sql=SELECT rowid, entity, type, page, param, value FROM llxdx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2025-02-09 10:49:40 DEBUG 78.197.71.109 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxdx_user_rights as ur, llxdx_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 2025-02-09 10:49:40 DEBUG 78.197.71.109 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxdx_usergroup_rights as gr, llxdx_usergroup_user as gu, llxdx_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 2025-02-09 10:49:40 INFO 78.197.71.109 --- End access to /theme/eldy/style.css.php 2025-02-09 10:49:43 DEBUG 78.197.71.109 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2025-02-09 10:49:43 DEBUG 78.197.71.109 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_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 llxdx_user as u LEFT JOIN llxdx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxdx_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 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llxdx_extrafields WHERE elementtype = 'user' ORDER BY pos 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT param, value FROM llxdx_user_param WHERE fk_user = 1 AND entity = 1 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT rowid, entity, type, page, param, value FROM llxdx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxdx_user_rights as ur, llxdx_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 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxdx_usergroup_rights as gr, llxdx_usergroup_user as gu, llxdx_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 2025-02-09 10:49:43 INFO 78.197.71.109 --- Access to /admin/modules.php - action=, massaction= 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT transkey, transvalue FROM llxdx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2025-02-09 10:49:43 DEBUG 78.197.71.109 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 llxdx_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 2025-02-09 10:49:43 INFO 78.197.71.109 Scan directory /var/www/html/speed.bdcloud.fr/core/modules/ for module descriptor files (modXXX.class.php) 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM llxdx_c_type_contact as tc WHERE tc.element='order_supplier' AND tc.source='external' ORDER BY position ASC, code 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM llxdx_c_type_contact as tc WHERE tc.element='order_supplier' AND tc.source='external' ORDER BY position ASC, code 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'reception' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'commande_fournisseur_dispatch' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 INFO 78.197.71.109 Module modReception not qualified 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'fichinter' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'fichinterdet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, fieldrequired FROM llxdx_extrafields WHERE elementtype = 'user' AND entity IN (0,1) 2025-02-09 10:49:43 DEBUG 78.197.71.109 User::loadParentOf 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT fk_user as id_parent, rowid as id_son FROM llxdx_user WHERE fk_user <> 0 AND entity IN (0,1) 2025-02-09 10:49:43 DEBUG 78.197.71.109 User::get_full_tree get user list 2025-02-09 10:49:43 DEBUG 78.197.71.109 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 llxdx_user as u WHERE u.entity IN (0,1) 2025-02-09 10:49:43 DEBUG 78.197.71.109 User::get_full_tree call to build_path_from_id_user 2025-02-09 10:49:43 DEBUG 78.197.71.109 User::build_path_from_id_user id_user=1 protection=0 2025-02-09 10:49:43 DEBUG 78.197.71.109 User::build_path_from_id_user id_user=2 protection=0 2025-02-09 10:49:43 DEBUG 78.197.71.109 User::get_full_tree dol_sort_array 2025-02-09 10:49:43 INFO 78.197.71.109 Build childid for id = 1 2025-02-09 10:49:43 INFO 78.197.71.109 Module modDeplacement not qualified 2025-02-09 10:49:43 INFO 78.197.71.109 Module modHRM not qualified 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'contrat' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'contratdet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'product_lot' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'holiday' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'commande' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'commandedet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'propal' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'propaldet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 INFO 78.197.71.109 Module modCollab not qualified 2025-02-09 10:49:43 INFO 78.197.71.109 Module modWebServicesClient not qualified 2025-02-09 10:49:43 INFO 78.197.71.109 Module modAsset not qualified 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'bom_bom' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'bom_bomline' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 INFO 78.197.71.109 Module modLabel not qualified 2025-02-09 10:49:43 INFO 78.197.71.109 Module modDataPolicy not qualified 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param FROM llxdx_extrafields WHERE elementtype = 'societe' AND entity IN (0, 1) 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param FROM llxdx_extrafields WHERE elementtype = 'socpeople' AND entity IN (0, 1) 2025-02-09 10:49:43 DEBUG 78.197.71.109 useNPR 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT t.rowid FROM llxdx_c_tva as t, llxdx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 useNPR 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT t.rowid FROM llxdx_c_tva as t, llxdx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT t.localtax1, t.localtax2 FROM llxdx_c_tva as t, llxdx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT t.localtax1, t.localtax2 FROM llxdx_c_tva as t, llxdx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, fieldrequired FROM llxdx_extrafields WHERE elementtype = 'product' AND entity IN (0, 1) 2025-02-09 10:49:43 DEBUG 78.197.71.109 useNPR 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT t.rowid FROM llxdx_c_tva as t, llxdx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT t.localtax1, t.localtax2 FROM llxdx_c_tva as t, llxdx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT t.localtax1, t.localtax2 FROM llxdx_c_tva as t, llxdx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2025-02-09 10:49:43 DEBUG 78.197.71.109 useNPR 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT t.rowid FROM llxdx_c_tva as t, llxdx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT t.localtax1, t.localtax2 FROM llxdx_c_tva as t, llxdx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT t.localtax1, t.localtax2 FROM llxdx_c_tva as t, llxdx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2025-02-09 10:49:43 DEBUG 78.197.71.109 useNPR 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT t.rowid FROM llxdx_c_tva as t, llxdx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT t.localtax1, t.localtax2 FROM llxdx_c_tva as t, llxdx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT t.localtax1, t.localtax2 FROM llxdx_c_tva as t, llxdx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'socpeople' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'societe' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, fieldrequired FROM llxdx_extrafields WHERE elementtype = 'societe' AND entity IN (0, 1) 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, fieldrequired FROM llxdx_extrafields WHERE elementtype = 'socpeople' AND entity IN (0, 1) 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT rowid FROM llxdx_blockedlog WHERE entity = 1 AND action not in ('MODULE_SET','MODULE_RESET') LIMIT 1 2025-02-09 10:49:43 INFO 78.197.71.109 Module Blockedlog alreadyUsed with ignoresystem=1 is 1 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM llxdx_c_type_contact as tc WHERE tc.element='commande' AND tc.source='external' ORDER BY position ASC, code 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT DISTINCT tc.rowid, tc.code, tc.libelle, tc.position FROM llxdx_c_type_contact as tc WHERE tc.element='commande' AND tc.source='external' ORDER BY position ASC, code 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'expedition' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'expeditiondet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 INFO 78.197.71.109 Module modPaymentByBankTransfer not qualified 2025-02-09 10:49:43 INFO 78.197.71.109 Module modReceiptPrinter not qualified 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'facturedet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'facture' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 INFO 78.197.71.109 Module modZapier not qualified 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'resource' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, fieldrequired FROM llxdx_extrafields WHERE elementtype = 'resource' AND entity IN (0,1) 2025-02-09 10:49:43 DEBUG 78.197.71.109 useNPR 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT t.rowid FROM llxdx_c_tva as t, llxdx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'product' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 useNPR 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT t.rowid FROM llxdx_c_tva as t, llxdx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT t.localtax1, t.localtax2 FROM llxdx_c_tva as t, llxdx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT t.localtax1, t.localtax2 FROM llxdx_c_tva as t, llxdx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, fieldrequired FROM llxdx_extrafields WHERE elementtype = 'product' AND entity IN (0,1) 2025-02-09 10:49:43 DEBUG 78.197.71.109 useNPR 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT t.rowid FROM llxdx_c_tva as t, llxdx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.recuperableonly = 1 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT t.localtax1, t.localtax2 FROM llxdx_c_tva as t, llxdx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax1_type <> '0' 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT t.localtax1, t.localtax2 FROM llxdx_c_tva as t, llxdx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'FR' AND t.active = 1 AND t.localtax2_type <> '0' 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'adherent' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, fieldrequired FROM llxdx_extrafields WHERE elementtype = 'adherent' AND entity IN (0,1) 2025-02-09 10:49:43 INFO 78.197.71.109 Module modDynamicPrices not qualified 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param FROM llxdx_extrafields WHERE elementtype = 'facture_fourn' AND entity IN (0, 1) 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param FROM llxdx_extrafields WHERE elementtype = 'facture_fourn_det' AND entity IN (0, 1) 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param FROM llxdx_extrafields WHERE elementtype = 'facture_fourn' AND entity IN (0, 1) 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param FROM llxdx_extrafields WHERE elementtype = 'commande_fournisseur' AND entity IN (0, 1) 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param FROM llxdx_extrafields WHERE elementtype = 'commande_fournisseurdet' AND entity IN (0, 1) 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'expensereport' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT code, label, description FROM llxdx_c_action_trigger ORDER by rang 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'projet' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, type, param, fieldcomputed, fielddefault FROM llxdx_extrafields WHERE elementtype = 'projet_task' AND type != 'separate' AND entity IN (0, 1) ORDER BY pos ASC 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT name, label, fieldrequired FROM llxdx_extrafields WHERE elementtype = 'projet_task' AND entity IN (0,1) 2025-02-09 10:49:43 INFO 78.197.71.109 Module modDocumentGeneration not qualified 2025-02-09 10:49:43 DEBUG 78.197.71.109 sql=SELECT rowid FROM llxdx_blockedlog WHERE entity = 1 AND action not in ('MODULE_SET','MODULE_RESET') LIMIT 1 2025-02-09 10:49:43 INFO 78.197.71.109 Module Blockedlog alreadyUsed with ignoresystem=1 is 1 2025-02-09 10:49:43 INFO 78.197.71.109 --- End access to /admin/modules.php 2025-02-09 10:49:47 DEBUG 78.197.71.109 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1 2025-02-09 10:49:47 DEBUG 78.197.71.109 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_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 llxdx_user as u LEFT JOIN llxdx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llxdx_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 2025-02-09 10:49:47 DEBUG 78.197.71.109 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,langs,list,printable,totalizable,fielddefault,fieldcomputed,entity,enabled,help FROM llxdx_extrafields WHERE elementtype = 'user' ORDER BY pos 2025-02-09 10:49:47 DEBUG 78.197.71.109 sql=SELECT param, value FROM llxdx_user_param WHERE fk_user = 1 AND entity = 1 2025-02-09 10:49:47 DEBUG 78.197.71.109 sql=SELECT rowid, entity, type, page, param, value FROM llxdx_default_values WHERE entity IN (1) AND user_id IN (0, 1) 2025-02-09 10:49:47 DEBUG 78.197.71.109 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxdx_user_rights as ur, llxdx_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 2025-02-09 10:49:47 DEBUG 78.197.71.109 sql=SELECT DISTINCT r.module, r.perms, r.subperms FROM llxdx_usergroup_rights as gr, llxdx_usergroup_user as gu, llxdx_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 2025-02-09 10:49:47 INFO 78.197.71.109 --- Access to /admin/modules.php - action=reset, massaction= 2025-02-09 10:49:47 DEBUG 78.197.71.109 sql=SELECT transkey, transvalue FROM llxdx_overwrite_trans where lang='fr_FR' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2025-02-09 10:49:47 DEBUG 78.197.71.109 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 llxdx_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 2025-02-09 10:49:47 DEBUG 78.197.71.109 BEGIN Transaction 2025-02-09 10:49:47 DEBUG 78.197.71.109 modSyslog::_unactive 2025-02-09 10:49:47 DEBUG 78.197.71.109 sql=DELETE FROM llxdx_const WHERE name = 'MAIN_MODULE_SYSLOG' AND entity IN (0, 0) 2025-02-09 10:49:47 DEBUG 78.197.71.109 modSyslog::delete_tabs 2025-02-09 10:49:47 DEBUG 78.197.71.109 sql=DELETE FROM llxdx_const WHERE name like 'MAIN_MODULE_SYSLOG_TABS_%' AND entity = 1 2025-02-09 10:49:47 DEBUG 78.197.71.109 modSyslog::delete_cronjobs 2025-02-09 10:49:47 DEBUG 78.197.71.109 sql=DELETE FROM llxdx_cronjob WHERE module_name = 'syslog' AND entity = 1 AND test = '1' 2025-02-09 10:49:47 DEBUG 78.197.71.109 modSyslog::delete_permissions 2025-02-09 10:49:47 DEBUG 78.197.71.109 sql=DELETE FROM llxdx_rights_def WHERE module = 'syslog' AND entity = 1 2025-02-09 10:49:47 DEBUG 78.197.71.109 modSyslog::delete_menus 2025-02-09 10:49:47 DEBUG 78.197.71.109 sql=DELETE FROM llxdx_menu WHERE module = 'syslog' AND entity = 1 2025-02-09 10:49:47 DEBUG 78.197.71.109 modSyslog::delete_dirs 2025-02-09 10:49:47 DEBUG 78.197.71.109 sql=DELETE FROM llxdx_const WHERE name LIKE 'MAIN_MODULE_SYSLOG_DIR_%' AND entity = 1 2025-02-09 10:49:47 DEBUG 78.197.71.109 COMMIT Transaction 2025-02-09 10:49:47 INFO 78.197.71.109 --- End access to /admin/modules.php 2025-11-25 10:49:09 INFO 78.197.71.109 --- Access to /index.php - action= - actionlogin= - showing the login form and exit 2025-11-25 10:49:09 DEBUG 78.197.71.109 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 2025-11-25 10:49:09 INFO 78.197.71.109 --- End access to /index.php 2025-11-25 10:49:18 INFO 78.197.71.109 checkLoginPassEntity usertotest=admin entitytotest=1 authmode=dolibarr 2025-11-25 10:49:18 INFO 78.197.71.109 functions_dolibarr::check_user_password_dolibarr usertotest=admin passwordtotest=******** entitytotest=1 2025-11-25 10:49:18 DEBUG 78.197.71.109 sql=SELECT rowid, login, entity, pass, pass_crypted FROM llx_user WHERE (login = 'admin') AND entity IN (0,1) AND statut = 1 ORDER BY entity DESC 2025-11-25 10:49:18 NOTICE 78.197.71.109 functions_dolibarr::check_user_password_dolibarr Authentication KO user not found for 'admin' 2025-11-25 10:49:19 DEBUG 78.197.71.109 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 2025-11-25 10:49:19 DEBUG 78.197.71.109 Bad password, connexion refused 2025-11-25 10:49:19 INFO 78.197.71.109 --- Access to /index.php - action= - actionlogin=login - showing the login form and exit 2025-11-25 10:49:19 INFO 78.197.71.109 --- End access to /index.php 2025-11-25 10:50:08 INFO 216.244.66.195 --- Access to /btm2000.apps-dev.fr/user/passwordforgotten.php - action=, massaction= 2025-11-25 10:50:08 DEBUG 216.244.66.195 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='en_US' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2025-11-25 10:50:08 DEBUG 216.244.66.195 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 2025-11-25 10:50:08 INFO 216.244.66.195 --- End access to /btm2000.apps-dev.fr/user/passwordforgotten.php 2025-11-25 10:50:10 INFO 216.244.66.195 --- Access to /btm2000.apps-dev.fr/user/passwordforgotten.php - action=, massaction= 2025-11-25 10:50:10 DEBUG 216.244.66.195 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='en_US' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC 2025-11-25 10:50:10 DEBUG 216.244.66.195 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 2025-11-25 10:50:10 INFO 216.244.66.195 --- End access to /btm2000.apps-dev.fr/user/passwordforgotten.php