V11.0.0 No buttons on vendor invoice

[iosif.garleanu]

Hello,

I recently updated to V11.0.0 using the zip archive stored on sourceforge.
My issue is that the vendor invoices created after the update lack all the buttons on the invoice card ( delete, validate etc. ). The buttons are present on the older invoices, but not on the vendor invoices created after the update.
I have the Debug Bar module activated. I mention this because the Debug Bar doesn’t show up on the page, so I suspect that the page doesn’t load completely and this is why the buttons are missing.

So far I noticed this issue only for the vendor invoices.

Any suggestion on how could I track this issue to it’s source and maybe solve it?

EDIT: Same thing for Purchase Orders.
I am using the administrator account.

Best regards,
Iosif

[simicar]

Hi Iosif,
Most likely you encounter a php error, you should check its logfile that could provide pointers on the origin of the error.
You could maybe first upgrade to the just released 11.0.1 and check whether it solves the problem or not.
Regards,
Marc

[iosif.garleanu]

Hello Simicar,
I did the update to v11.0.1 and the problem seems to be solved now, both for the Vendor Invoices and the Purchase Orders.
Thank you very much for the answer.

Best regards,
Iosif

[iosif.garleanu]

Hello,

The issue still appears. Can’t tell for sure why and when does it occur. I’ll keep digging.

Best regards,
Iosif

[iosif.garleanu]

Hello,

I found this line in dolibarr.log file:
xxxx-xx-xx xx:xx:xx ERR xxx.xxx.xxx.xxx Your state setup use an old syntax. Reedit it using setup area.

I don’t understand what I have to re-edit. “state setup” ? The country?

[simicar]

This shouldn’t really matter, but if you want to fix it, you have to go in your company detail setup (define the state or province or whatever depending on your country).

[iosif.garleanu]

You are right, it shouldn’t matter. The state/province was already defined. I changed it a few times and now the error is gone.

[iosif.garleanu]

Going back to the main topic, it appears that the products are not fetched on the page.

It is quite weird how for some third-parties it works for a period of time then it doesn’t work anymore. And for other third-parties it doesn’t work at all.

I tried clearing my cache (even though I previously tried to create vendor invoices on another machine). I am now able to create vendor invoices for a third-party that I wasn’t able to before clearing the cache. Don’t know for how long as it’s like I have a limited time-window to create vendor invoices for a certain third-party …

I tried creating a new third-party thinking that maybe a field of the older third-parties has some wrong value in it. I was able to create one vendor invoice for the new third-party, then the same situation appeared: the following invoice for the same third-party lacks all buttons and I can’t select any product.

[ksar]

Hi,

For me it sounds like an external module that is putting the mess.
Do you have installed external module ?
Is it a fresh installation or this is a upgrade ?

Can we have the complete log, and not only the error ?

[iosif.garleanu]

Hello,

Yes, I do have external modules installed. I tried to disable those and try once more to create a vendor invoice, same behaviour.
It is an upgrade. First from 10.0.3(when I had no issue) to 11.0.0 and then from 11.0.0 to 11.0.1, both using the zip archive on sourceforge.

Sure, I’ll reply with a log that I hope contains enought information. I tried to bound the logs by renaming the previous log file before creating the invoice and download the new one just after I created the invoice, again with the same issue.

[iosif.garleanu]

01:26 DEBUG   IP   - This is an already logged session. _SESSION['dol_login']=managerdb _SESSION['dol_entity']=1

01:26 DEBUG   IP   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 = 'managerdb' ORDER BY u.entity ASC

01:26 DEBUG   IP   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

01:26 DEBUG   IP   sql=SELECT rowid, fk_service FROM llx_user_extrafields WHERE fk_object = 1

01:26 DEBUG   IP   sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1

01:26 DEBUG   IP   sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1)

01:26 DEBUG   IP   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

01:26 DEBUG   IP   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

01:26 INFO    IP   --- Access to /htdocs/fourn/facture/card.php - action=create, massaction=

01:26 DEBUG   IP   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

01:26 DEBUG   IP   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

01:26 DEBUG   IP   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 = 'facture_fourn' ORDER BY pos

01:26 DEBUG   IP   sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity IN (1) ORDER BY position

01:26 DEBUG   IP   useLocalTax

01:26 DEBUG   IP   sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'RO' AND t.active = 1 AND t.localtax1_type <> '0'

01:26 DEBUG   IP   useLocalTax

01:26 DEBUG   IP   sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'RO' AND t.active = 1 AND t.localtax2_type <> '0'

01:26 DEBUG   IP   Form::select_thirdparty_list

01:26 DEBUG   IP   sql=SELECT s.rowid, s.nom as name, s.name_alias, s.client, s.fournisseur, s.code_client, s.code_fournisseur FROM llx_societe as s WHERE s.entity IN (1) AND (s.fournisseur=1) ORDER BY nom ASC

01:26 DEBUG   IP   Form::select_conditions_paiements selected=, htmlname=cond_reglement_id

01:26 DEBUG   IP   Form::load_cache_conditions_paiements

01:26 DEBUG   IP   sql=SELECT rowid, code, libelle as label FROM llx_c_payment_term WHERE entity IN (1) AND active > 0 ORDER BY sortorder

01:26 DEBUG   IP   Form::select_types_paiements , mode_reglement_id, DBIT, 0

01:26 DEBUG   IP   Form::load_cache_types_paiements

01:26 DEBUG   IP   sql=SELECT id, code, libelle as label, type, active FROM llx_c_paiement WHERE entity IN (1)

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT libelle as label FROM llx_c_paiement WHERE code = 'LCR' AND entity IN (1)

01:26 DEBUG   IP   Form::select_comptes

01:26 DEBUG   IP   sql=SELECT rowid, label, bank, clos as status, currency_code FROM llx_bank_account WHERE entity IN (1) AND clos = 0 ORDER BY label

01:26 DEBUG   IP   Translate::loadCacheCurrencies

01:26 DEBUG   IP   sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'AED'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'AFN'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'ALL'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'ANG'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'ARS'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'AWG'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'AZN'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BAM'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BBD'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BDT'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BGN'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BHD'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BMD'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BND'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BOB'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BRL'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BSD'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BWP'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BYR'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'BZD'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'CLP'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'CNY'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'COP'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'CRC'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'CUP'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'CZK'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'DKK'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'DOP'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'DZD'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'EEK'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'EGP'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'FJD'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'FKP'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'GGP'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'GHC'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'GIP'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'GNF'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'GTQ'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'GYD'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'HKD'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'HNL'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'HRK'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'HUF'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'IDR'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'ILS'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'IMP'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'IRR'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'ISK'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'JEP'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'JMD'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'JPY'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'KES'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'KGS'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'KHR'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'KPW'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'KRW'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'KYD'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'KZT'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'LAK'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'LBP'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'LKR'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'LRD'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'LTL'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'LVL'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'MKD'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'MNT'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'MRO'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'MXN'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'MYR'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'MZN'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'NAD'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'NGN'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'NIO'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'NPR'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'NZD'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'OMR'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'PAB'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'PEN'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'PHP'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'PKR'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'PLN'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'PYG'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'QAR'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'RON'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'RSD'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'RUB'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SAR'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SBD'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SCR'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SEK'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SGD'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SHP'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SOS'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SRD'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SVC'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'SYP'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'THB'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'TRL'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'TRY'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'TTD'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'TVD'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'TWD'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'UYU'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'UZS'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'VEF'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'VND'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'XCD'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'YER'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'ZAR'

01:26 DEBUG   IP   Translate::getLabelFromKey

01:26 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'ZWD'

01:26 DEBUG   IP   sql=SELECT code FROM llx_multicurrency WHERE entity IN ('1')

01:26 DEBUG   IP   sql=SELECT p.rowid, p.ref, p.title, p.fk_soc, p.fk_statut, p.public, s.nom as name, s.name_alias FROM llx_projet as p LEFT JOIN llx_societe as s ON s.rowid = p.fk_soc WHERE p.entity IN (1) ORDER BY p.ref ASC

01:26 DEBUG   IP   Form::select_incoterm

01:26 DEBUG   IP   sql=SELECT rowid, code FROM llx_c_incoterms WHERE active > 0 ORDER BY code ASC

01:26 INFO    IP   DolEditor::DolEditor htmlname=note_public width= height=80 toolbarname=dolibarr_notes

01:26 INFO    IP   DolEditor::DolEditor htmlname=note_private width= height=80 toolbarname=dolibarr_notes

01:26 INFO    IP   --- End access to /htdocs/fourn/facture/card.php

01:35 DEBUG   IP   - This is an already logged session. _SESSION['dol_login']=managerdb _SESSION['dol_entity']=1

01:35 DEBUG   IP   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 = 'managerdb' ORDER BY u.entity ASC

01:35 DEBUG   IP   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

01:35 DEBUG   IP   sql=SELECT rowid, fk_service FROM llx_user_extrafields WHERE fk_object = 1

01:35 DEBUG   IP   sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1

01:35 DEBUG   IP   sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1)

01:35 DEBUG   IP   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

01:35 DEBUG   IP   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

01:35 INFO    IP   --- Access to /htdocs/fourn/facture/card.php - action=add, massaction=

01:35 DEBUG   IP   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

01:35 DEBUG   IP   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

01:35 DEBUG   IP   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 = 'facture_fourn' ORDER BY pos

01:35 DEBUG   IP   BEGIN Transaction

01:35 DEBUG   IP    FactureFournisseur::calculate_date_lim_reglement

01:35 DEBUG   IP    sql=SELECT c.type_cdr, c.nbjour, c.decalage FROM llx_c_payment_term as c WHERE c.rowid=1

01:35 DEBUG   IP    sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, s.mode_reglement, s.cond_reglement, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as label_incoterms, sr.remise_client FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 344

01:35 DEBUG   IP    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 = 'societe' ORDER BY pos

01:35 DEBUG   IP    sql=SELECT rowid, cnp, ci_series, ci_number FROM llx_societe_extrafields WHERE fk_object = 344

01:35 DEBUG   IP    MultiCurrency::getIdAndTxFromCode

01:35 DEBUG   IP    sql=SELECT m.rowid, mc.rate FROM llx_multicurrency m LEFT JOIN llx_multicurrency_rate mc ON (m.rowid = mc.fk_multicurrency) WHERE m.code = 'RON' AND m.entity IN (1) ORDER BY mc.date_sync DESC LIMIT 1

01:35 DEBUG   IP     FactureFournisseur::create

01:35 DEBUG   IP     sql=INSERT INTO llx_facture_fourn (ref, ref_supplier, entity, type, libelle, fk_soc, datec, datef, fk_projet, fk_cond_reglement, fk_mode_reglement, fk_account, note_private, note_public, fk_user_author, date_lim_reglement, fk_incoterms, location_incoterms, fk_multicurrency, multicurrency_code, multicurrency_tx, fk_facture_source) VALUES ('(PROV)', 'test1234567', 1, '0', '', 344, '01:35', '2020-02-18 12:00:00', null, 1, null, NULL, '', '', 1,'2020-02-19 12:00:00', 0, '', 1, 'RON', 1, NULL)

01:35 DEBUG   IP     FactureFournisseur::create

01:35 DEBUG   IP     sql=UPDATE llx_facture_fourn SET ref='(PROV153)' WHERE rowid=153

01:35 INFO    IP     There is 0 lines that are array lines

01:35 DEBUG   IP     FactureFournisseur::update_price

01:35 DEBUG   IP     sql=SELECT rowid, qty, pu_ht as up, remise_percent, total_ht, tva as total_tva, total_ttc, total_localtax1 as total_localtax1, total_localtax2 as total_localtax2, tva_tx as vatrate, localtax1_tx, localtax2_tx, localtax1_type, localtax2_type, info_bits, product_type, multicurrency_total_ht, multicurrency_total_tva, multicurrency_total_ttc FROM llx_facture_fourn_det WHERE fk_facture_fourn = 153 ORDER by rowid

01:35 DEBUG   IP     FactureFournisseur::update_price

01:35 DEBUG   IP     sql=UPDATE llx_facture_fourn SET total_ht='0', total_tva='0', localtax1='0', localtax2='0', total_ttc='0', multicurrency_total_ht='0', multicurrency_total_tva='0', multicurrency_total_ttc='0' WHERE rowid = 153

01:35 INFO    IP     Trigger 'ContactRoles' for action 'BILL_SUPPLIER_CREATE' launched by /var/www/vhosts/domain_name/httpdocs/htdocs/core/triggers/interface_90_modSociete_ContactRoles.class.php. id=153

01:35 DEBUG   IP     Contact::Contact::getContactRoles

01:35 DEBUG   IP     sql=SELECT sc.fk_socpeople as id, sc.fk_c_type_contact `OM llx_c_type_contact tc, llx_societe_contacts sc WHERE sc.fk_soc =344 AND sc.fk_c_type_contact=tc.rowid AND tc.element='invoice_supplier' AND tc.active=1

01:35 DEBUG   IP     FactureFournisseur::fetch

01:35 DEBUG   IP     sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle as label, t.paye, t.amount, t.remise, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.fk_projet as fk_project, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as label_incoterms, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llx_facture_fourn as t LEFT JOIN llx_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llx_c_payment_term as cr ON t.fk_cond_reglement = cr.rowid LEFT JOIN llx_c_paiement as p ON t.fk_mode_reglement = p.id LEFT JOIN llx_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid=153

01:35 DEBUG   IP     FactureFournisseur::fetch_lines

[iosif.garleanu]

01:35 DEBUG   IP     sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.date_start, f.date_end, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.localtax1_type, f.localtax2_type, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn , f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, p.rowid as product_id, p.ref as product_ref, p.label as label, p.description as product_desc, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llx_facture_fourn_det as f LEFT JOIN llx_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=153 ORDER BY f.rang, f.rowid

01:35 DEBUG   IP     FactureFournisseur::liste_contact

01:35 DEBUG   IP     sql=SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle FROM llx_c_type_contact tc, llx_element_contact ec LEFT JOIN llx_socpeople t on ec.fk_socpeople = t.rowid WHERE ec.element_id =153 AND ec.fk_c_type_contact=tc.rowid AND tc.element='invoice_supplier' AND tc.source = 'external' AND tc.active=1 ORDER BY t.lastname ASC

01:35 DEBUG   IP     FactureFournisseur::liste_contact

01:35 DEBUG   IP     sql=SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, '-1' as socid, t.statut as statuscontact, t.login, t.photo, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle FROM llx_c_type_contact tc, llx_element_contact ec LEFT JOIN llx_user t on ec.fk_socpeople = t.rowid WHERE ec.element_id =153 AND ec.fk_c_type_contact=tc.rowid AND tc.element='invoice_supplier' AND tc.source = 'internal' AND tc.active=1 ORDER BY t.lastname ASC

01:36 DEBUG   IP   COMMIT Transaction

01:36 INFO    IP   commonGenerateDocument modele=canelle outputlangs->defaultlang=en_US

01:36 INFO    IP   pdf_getFormat Get paper format with mode=setup MAIN_PDF_FORMAT=USLetter outputlangs->defaultlang=null and langs->defaultlang=en_US

01:36 DEBUG   IP   sql=SELECT code, label, width, height, unit FROM llx_c_paper_format WHERE code = 'USLetter'

01:36 DEBUG   IP   sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, s.mode_reglement, s.cond_reglement, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as label_incoterms, sr.remise_client FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 344

01:36 DEBUG   IP   sql=SELECT rowid, cnp, ci_series, ci_number FROM llx_societe_extrafields WHERE fk_object = 344

01:36 DEBUG   IP   FactureFournisseur::getSommePaiement

01:36 DEBUG   IP   sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 153

01:36 DEBUG   IP   DiscountAbsolute::getSumCreditNotesUsed

01:36 DEBUG   IP   sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc, llx_facture_fourn as f WHERE rc.fk_invoice_supplier_source=f.rowid AND rc.fk_invoice_supplier = 153 AND (f.type = 2 OR f.type = 0)

01:36 INFO    IP   functions.lib::dol_mkdir: dir=/var/www/vhosts/domain_name/httpdocs/documents/fournisseur/facture/3/5/(PROV153)

01:36 DEBUG   IP   functions.lib::dol_mkdir: Directory '/var' does not exists or is outside open_basedir PHP setting.

01:36 WARNING IP   functions.lib::dol_mkdir: Fails to create directory '/var' or directory already exists.

01:36 DEBUG   IP   functions.lib::dol_mkdir: Directory '/var/www' does not exists or is outside open_basedir PHP setting.

01:36 WARNING IP   functions.lib::dol_mkdir: Fails to create directory '/var/www' or directory already exists.

01:36 DEBUG   IP   functions.lib::dol_mkdir: Directory '/var/www/vhosts' does not exists or is outside open_basedir PHP setting.

01:36 WARNING IP   functions.lib::dol_mkdir: Fails to create directory '/var/www/vhosts' or directory already exists.

01:36 DEBUG   IP   functions.lib::dol_mkdir: Directory '/var/www/vhosts/domain_name/httpdocs/documents/fournisseur/facture/3/5/(PROV153)' does not exists or is outside open_basedir PHP setting.

01:36 DEBUG   IP   functions.lib::dol_mkdir: Directory '/var/www/vhosts/domain_name/httpdocs/documents/fournisseur/facture/3/5/(PROV153)' created

01:36 DEBUG   IP   FactureFournisseur::getListOfPayments

01:36 DEBUG   IP   sql=SELECT p.ref, pf.amount, pf.multicurrency_amount, p.fk_paiement, p.datep, p.num_paiement as num, t.code FROM llx_paiementfourn_facturefourn as pf, llx_paiementfourn as p, llx_c_paiement as t WHERE pf.fk_facturefourn = 153 AND pf.fk_paiementfourn = p.rowid AND p.fk_paiement = t.id AND p.entity IN (1)

01:36 INFO    IP   functions.lib::dol_mkdir: dir=/var/www/vhosts/domain_name/httpdocs/documents/admin/temp/

01:36 DEBUG   IP   FactureFournisseur::fetchObjectLink

01:36 DEBUG   IP   sql=SELECT rowid, fk_source, sourcetype, fk_target, targettype FROM llx_element_element WHERE (fk_source = 153 AND sourcetype = 'invoice_supplier') OR (fk_target = 153 AND targettype = 'invoice_supplier') ORDER BY sourcetype

01:36 DEBUG   IP   FactureFournisseur::getIdContact

01:36 DEBUG   IP   sql=SELECT ec.fk_socpeople FROM llx_element_contact as ec, llx_user as c, llx_c_type_contact as tc WHERE ec.element_id = 153 AND ec.fk_socpeople = c.rowid AND c.entity IN (0,1) AND ec.fk_c_type_contact = tc.rowid AND tc.element = 'invoice_supplier' AND tc.source = 'internal' AND tc.code = 'SALESREPFOLL' AND tc.active = 1

01:36 DEBUG   IP   FactureFournisseur::getIdContact

01:36 DEBUG   IP   sql=SELECT ec.fk_socpeople FROM llx_element_contact as ec, llx_user as c, llx_c_type_contact as tc WHERE ec.element_id = 153 AND ec.fk_socpeople = c.rowid AND c.entity IN (0,1) AND ec.fk_c_type_contact = tc.rowid AND tc.element = 'invoice_supplier' AND tc.source = 'internal' AND tc.code = 'BILLING' AND tc.active = 1

01:36 DEBUG   IP   sql=SELECT code FROM llx_c_incoterms WHERE rowid = 0

01:36 DEBUG   IP   Translate::getLabelFromKey

01:36 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'RON'

01:36 DEBUG   IP   DiscountAbsolute::getSumCreditNotesUsed

01:36 DEBUG   IP   sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc, llx_facture_fourn as f WHERE rc.fk_invoice_supplier_source=f.rowid AND rc.fk_invoice_supplier = 153 AND (f.type = 2 OR f.type = 0)

01:36 DEBUG   IP   EcmFiles::fetch

01:36 DEBUG   IP   sql=SELECT t.rowid, t.ref, t.label, t.share, t.entity, t.filename, t.filepath, t.fullpath_orig, t.description, t.keywords, t.cover, t.position, t.gen_or_uploaded, t.extraparams, t.date_c, t.date_m, t.fk_user_c, t.fk_user_m, t.acl, t.src_object_type, t.src_object_id FROM llx_ecm_files as t WHERE 1 = 1 AND t.filepath = 'fournisseur/facture/3/5/(PROV153)' AND t.filename = '(PROV153).pdf' AND t.entity = 1

01:36 DEBUG   IP   EcmFiles::create

01:36 DEBUG   IP   sql=SELECT MAX(position) as maxposition FROM llx_ecm_files WHERE filepath ='fournisseur/facture/3/5/(PROV153)'

01:36 DEBUG   IP   BEGIN Transaction

01:36 DEBUG   IP    sql=INSERT INTO llx_ecm_files(ref,label,share,entity,filename,filepath,fullpath_orig,description,keywords,cover,position,gen_or_uploaded,extraparams,date_c,date_m,fk_user_c,fk_user_m,acl,src_object_type,src_object_id) VALUES ( 'c033d82c8c2b743ad330a17cdaeeed68',  '77a4f33e04d70baeba57b875a0927665', NULL, 1, '(PROV153).pdf', 'fournisseur/facture/3/5/(PROV153)', '', '', NULL, NULL, 1, 'generated', NULL, '01:36', '01:36', 1, NULL, NULL, 'facture_fourn', 153)

01:36 DEBUG   IP   COMMIT Transaction

01:36 INFO    IP   --- End access to /htdocs/fourn/facture/card.php

01:36 DEBUG   IP   - This is an already logged session. _SESSION['dol_login']=managerdb _SESSION['dol_entity']=1

01:36 DEBUG   IP   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 = 'managerdb' ORDER BY u.entity ASC

01:36 DEBUG   IP   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

01:36 DEBUG   IP   sql=SELECT rowid, fk_service FROM llx_user_extrafields WHERE fk_object = 1

01:36 DEBUG   IP   sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1

01:36 DEBUG   IP   sql=SELECT rowid, entity, type, page, param, value FROM llx_default_values WHERE entity IN (1) AND user_id IN (0, 1)

01:36 DEBUG   IP   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

01:36 DEBUG   IP   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

01:36 INFO    IP   --- Access to /htdocs/fourn/facture/card.php - action=, massaction=

01:36 DEBUG   IP   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

01:36 DEBUG   IP   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

01:36 DEBUG   IP   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 = 'facture_fourn' ORDER BY pos

01:36 DEBUG   IP   FactureFournisseur::fetch

01:36 DEBUG   IP   sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle as label, t.paye, t.amount, t.remise, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.fk_projet as fk_project, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as label_incoterms, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llx_facture_fourn as t LEFT JOIN llx_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llx_c_payment_term as cr ON t.fk_cond_reglement = cr.rowid LEFT JOIN llx_c_paiement as p ON t.fk_mode_reglement = p.id LEFT JOIN llx_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid=153

01:36 DEBUG   IP   FactureFournisseur::fetch_lines

01:36 DEBUG   IP   sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.date_start, f.date_end, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.localtax1_type, f.localtax2_type, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn , f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, p.rowid as product_id, p.ref as product_ref, p.label as label, p.description as product_desc, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llx_facture_fourn_det as f LEFT JOIN llx_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=153 ORDER BY f.rang, f.rowid

01:36 DEBUG   IP   sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, s.mode_reglement, s.cond_reglement, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as label_incoterms, sr.remise_client FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 344

01:36 DEBUG   IP   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 = 'societe' ORDER BY pos

01:36 DEBUG   IP   sql=SELECT rowid, cnp, ci_series, ci_number FROM llx_societe_extrafields WHERE fk_object = 344

01:36 DEBUG   IP   sql=SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity IN (1) ORDER BY position

01:36 DEBUG   IP   useLocalTax

01:36 DEBUG   IP   sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'RO' AND t.active = 1 AND t.localtax1_type <> '0'

01:36 DEBUG   IP   useLocalTax

01:36 DEBUG   IP   sql=SELECT t.localtax1, t.localtax2 FROM llx_c_tva as t, llx_c_country as c WHERE t.fk_pays = c.rowid AND c.code = 'RO' AND t.active = 1 AND t.localtax2_type <> '0'

01:36 DEBUG   IP   FactureFournisseur::fetch

01:36 DEBUG   IP   sql=SELECT t.rowid, t.ref, t.ref_supplier, t.entity, t.type, t.fk_soc, t.datec, t.datef, t.tms, t.libelle as label, t.paye, t.amount, t.remise, t.close_code, t.close_note, t.tva, t.localtax1, t.localtax2, t.total_ht, t.total_tva, t.total_ttc, t.fk_statut, t.fk_user_author, t.fk_user_valid, t.fk_facture_source, t.fk_projet as fk_project, t.fk_cond_reglement, t.fk_account, t.fk_mode_reglement, t.date_lim_reglement, t.note_private, t.note_public, t.model_pdf, t.import_key, t.extraparams, cr.code as cond_reglement_code, cr.libelle as cond_reglement_libelle, p.code as mode_reglement_code, p.libelle as mode_reglement_libelle, s.nom as socnom, s.rowid as socid, t.fk_incoterms, t.location_incoterms, i.libelle as label_incoterms, t.fk_multicurrency, t.multicurrency_code, t.multicurrency_tx, t.multicurrency_total_ht, t.multicurrency_total_tva, t.multicurrency_total_ttc FROM llx_facture_fourn as t LEFT JOIN llx_societe as s ON (t.fk_soc = s.rowid) LEFT JOIN llx_c_payment_term as cr ON t.fk_cond_reglement = cr.rowid LEFT JOIN llx_c_paiement as p ON t.fk_mode_reglement = p.id LEFT JOIN llx_c_incoterms as i ON t.fk_incoterms = i.rowid WHERE t.rowid=153

01:36 DEBUG   IP   FactureFournisseur::fetch_lines

01:36 DEBUG   IP   sql=SELECT f.rowid, f.ref as ref_supplier, f.description, f.date_start, f.date_end, f.pu_ht, f.pu_ttc, f.qty, f.remise_percent, f.vat_src_code, f.tva_tx, f.localtax1_tx, f.localtax2_tx, f.localtax1_type, f.localtax2_type, f.total_localtax1, f.total_localtax2, f.fk_facture_fourn , f.total_ht, f.tva as total_tva, f.total_ttc, f.fk_product, f.product_type, f.info_bits, f.rang, f.special_code, f.fk_parent_line, f.fk_unit, p.rowid as product_id, p.ref as product_ref, p.label as label, p.description as product_desc, f.fk_multicurrency, f.multicurrency_code, f.multicurrency_subprice, f.multicurrency_total_ht, f.multicurrency_total_tva, f.multicurrency_total_ttc FROM llx_facture_fourn_det as f LEFT JOIN llx_product as p ON f.fk_product = p.rowid WHERE fk_facture_fourn=153 ORDER BY f.rang, f.rowid

01:36 DEBUG   IP   sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, s.mode_reglement, s.cond_reglement, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as label_incoterms, sr.remise_client FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 344

01:36 DEBUG   IP   sql=SELECT rowid, cnp, ci_series, ci_number FROM llx_societe_extrafields WHERE fk_object = 344

01:36 DEBUG   IP   sql=SELECT s.rowid, s.nom as name, s.name_alias, s.entity, s.ref_ext, s.ref_int, s.address, s.datec as date_creation, s.prefix_comm, s.status, s.price_level, s.tms as date_modification, s.fk_user_creat, s.fk_user_modif, s.phone, s.fax, s.email, s.socialnetworks, s.url, s.zip, s.town, s.note_private, s.note_public, s.model_pdf, s.client, s.fournisseur, s.siren as idprof1, s.siret as idprof2, s.ape as idprof3, s.idprof4, s.idprof5, s.idprof6, s.capital, s.tva_intra, s.fk_typent as typent_id, s.fk_effectif as effectif_id, s.fk_forme_juridique as forme_juridique_code, s.webservices_url, s.webservices_key, s.code_client, s.code_fournisseur, s.code_compta, s.code_compta_fournisseur, s.parent, s.barcode, s.fk_departement as state_id, s.fk_pays as country_id, s.fk_stcomm, s.remise_supplier, s.mode_reglement, s.cond_reglement, s.fk_account, s.tva_assuj, s.mode_reglement_supplier, s.cond_reglement_supplier, s.localtax1_assuj, s.localtax1_value, s.localtax2_assuj, s.localtax2_value, s.fk_prospectlevel, s.default_lang, s.logo, s.logo_squarred, s.fk_shipping_method, s.outstanding_limit, s.import_key, s.canvas, s.fk_incoterms, s.location_incoterms, s.order_min_amount, s.supplier_order_min_amount, s.fk_multicurrency, s.multicurrency_code, fj.libelle as forme_juridique, e.libelle as effectif, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, st.libelle as stcomm, te.code as typent_code, i.libelle as label_incoterms, sr.remise_client FROM llx_societe as s LEFT JOIN llx_c_effectif as e ON s.fk_effectif = e.id LEFT JOIN llx_c_country as c ON s.fk_pays = c.rowid LEFT JOIN llx_c_stcomm as st ON s.fk_stcomm = st.id LEFT JOIN llx_c_forme_juridique as fj ON s.fk_forme_juridique = fj.code LEFT JOIN llx_c_departements as d ON s.fk_departement = d.rowid LEFT JOIN llx_c_typent as te ON s.fk_typent = te.id LEFT JOIN llx_c_incoterms as i ON s.fk_incoterms = i.rowid LEFT JOIN llx_societe_remise as sr ON sr.rowid = (SELECT MAX(rowid) FROM llx_societe_remise WHERE fk_soc = s.rowid AND entity IN (1)) WHERE s.entity IN (1) AND s.rowid = 344

01:36 DEBUG   IP   sql=SELECT rowid, cnp, ci_series, ci_number FROM llx_societe_extrafields WHERE fk_object = 344

01:36 DEBUG   IP   FactureFournisseur::getSommePaiement

01:36 DEBUG   IP   sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 153

01:36 DEBUG   IP   DiscountAbsolute::getSumCreditNotesUsed

01:36 DEBUG   IP   sql=SELECT sum(rc.amount_ttc) as amount, sum(rc.multicurrency_amount_ttc) as multicurrency_amount FROM llx_societe_remise_except as rc, llx_facture_fourn as f WHERE rc.fk_invoice_supplier_source=f.rowid AND rc.fk_invoice_supplier = 153 AND (f.type = 2 OR f.type = 0)

01:36 DEBUG   IP   DiscountAbsolute::getAvailableDiscounts discount_type=1

01:36 DEBUG   IP   sql=SELECT SUM(rc.amount_ttc) as amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=1 AND (rc.fk_invoice_supplier IS NULL AND rc.fk_invoice_supplier_line IS NULL) AND rc.fk_soc = 344 AND (fk_invoice_supplier_source IS NULL OR (description LIKE '(DEPOSIT)%' AND description NOT LIKE '(EXCESS PAID)%'))

01:36 DEBUG   IP   DiscountAbsolute::getAvailableDiscounts discount_type=1

01:36 DEBUG   IP   sql=SELECT SUM(rc.amount_ttc) as amount FROM llx_societe_remise_except as rc WHERE rc.entity = 1 AND rc.discount_type=1 AND (rc.fk_invoice_supplier IS NULL AND rc.fk_invoice_supplier_line IS NULL) AND rc.fk_soc = 344 AND (fk_invoice_supplier_source IS NOT NULL AND (description NOT LIKE '(DEPOSIT)%' OR description LIKE '(EXCESS PAID)%'))

01:36 DEBUG   IP   FactureFournisseur::liste_contact

01:36 DEBUG   IP   sql=SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, '-1' as socid, t.statut as statuscontact, t.login, t.photo, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle FROM llx_c_type_contact tc, llx_element_contact ec LEFT JOIN llx_user t on ec.fk_socpeople = t.rowid WHERE ec.element_id =153 AND ec.fk_c_type_contact=tc.rowid AND tc.element='invoice_supplier' AND tc.source = 'internal' AND tc.active=1 ORDER BY t.lastname ASC

01:36 DEBUG   IP   FactureFournisseur::liste_contact

01:36 DEBUG   IP   sql=SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle FROM llx_c_type_contact tc, llx_element_contact ec LEFT JOIN llx_socpeople t on ec.fk_socpeople = t.rowid WHERE ec.element_id =153 AND ec.fk_c_type_contact=tc.rowid AND tc.element='invoice_supplier' AND tc.source = 'external' AND tc.active=1 ORDER BY t.lastname ASC

01:36 INFO    IP   files.lib.php::dol_dir_list path=/var/www/vhosts/domain_name/httpdocs/documents/fournisseur/facture/3/5/(PROV153) types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$"

01:36 DEBUG   IP   sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'invoice_supplier' AND objectid = 153 AND entity = 1

01:36 WARNING IP   Failed to read image using Imagick (Try to install package 'apt-get install php-imagick ghostscript' and check there is no policy to disable pdf convertion in /etc/ImageMagick*/policy.xml): not authorized `/var/www/vhosts/domain_name/httpdocs/documents/fournisseur/facture/3/5/(PROV153)/(PROV153).pdf' @ error/constitute.c/ReadImage/454

01:36 DEBUG   IP   sql=SELECT MAX(te.ref) FROM llx_facture_fourn as te WHERE te.ref < '(PROV153)' AND te.entity IN (1)

01:36 DEBUG   IP   sql=SELECT MIN(te.ref) FROM llx_facture_fourn as te WHERE te.ref > '(PROV153)' AND te.entity IN (1)

01:36 DEBUG   IP   sql=SELECT rowid FROM llx_facture_fourn WHERE fk_facture_source = 153 AND type = 2

01:36 DEBUG   IP   FactureFournisseur::getSommePaiement

01:36 DEBUG   IP   sql=SELECT sum(amount) as amount, sum(multicurrency_amount) as multicurrency_amount FROM llx_paiementfourn_facturefourn WHERE fk_facturefourn = 153

01:36 DEBUG   IP   Form::load_cache_conditions_paiements

01:36 DEBUG   IP   sql=SELECT rowid, code, libelle as label FROM llx_c_payment_term WHERE entity IN (1) AND active > 0 ORDER BY sortorder

01:36 DEBUG   IP   Translate::getLabelFromKey

01:36 DEBUG   IP   sql=SELECT label as label FROM llx_c_currencies WHERE code_iso = 'RON'

01:36 DEBUG   IP   Translate::loadCacheCurrencies

01:36 DEBUG   IP   sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'RON'

01:36 DEBUG   IP   sql=SELECT COUNT(ab.rowid) as nb FROM llx_accounting_bookkeeping as ab WHERE ab.doc_type='supplier_invoice' AND ab.fk_doc = 153

01:36 DEBUG   IP   sql=SELECT p.datep as dp, p.ref, p.num_paiement, p.rowid, p.fk_bank, c.id as paiement_type, pf.amount, ba.rowid as baid, ba.ref as baref, ba.label, ba.number as banumber, ba.account_number, ba.fk_accountancy_journal FROM llx_paiementfourn as p LEFT JOIN llx_bank as b ON p.fk_bank = b.rowid LEFT JOIN llx_bank_account as ba ON b.fk_account = ba.rowid LEFT JOIN llx_c_paiement as c ON p.fk_paiement = c.id LEFT JOIN llx_paiementfourn_facturefourn as pf ON pf.fk_paiementfourn = p.rowid WHERE pf.fk_facturefourn = 153 ORDER BY p.datep, p.tms

01:36 DEBUG   IP   sql=SELECT re.rowid, re.amount_ht, re.amount_tva, re.amount_ttc, re.description, re.fk_invoice_supplier_source FROM llx_societe_remise_except as re WHERE fk_invoice_supplier = 153

01:36 DEBUG   IP   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 = 'facture_fourn_det' ORDER BY pos

01:36 DEBUG   IP   Form::select_produits_fournisseurs_list

01:36 DEBUG   IP   sql=SELECT p.rowid, p.ref, p.label, p.price, p.duration, p.fk_product_type, pfp.ref_fourn, pfp.rowid as idprodfournprice, pfp.price as fprice, pfp.quantity, pfp.remise_percent, pfp.remise, pfp.unitprice, pfp.fk_supplier_price_expression, pfp.fk_product, pfp.tva_tx, pfp.fk_soc, s.nom as name, pfp.supplier_reputation, u.label as unit_long, u.short_label as unit_short, p.weight, p.weight_units, p.length, p.length_units, p.width, p.width_units, p.height, p.height_units, p.surface, p.surface_units, p.volume, p.volume_units FROM llx_product as p LEFT JOIN llx_product_fournisseur_price as pfp ON p.rowid = pfp.fk_product AND pfp.fk_soc = 344 LEFT JOIN llx_societe as s ON pfp.fk_soc = s.rowid LEFT JOIN llx_c_units u ON u.rowid = p.fk_unit WHERE p.entity IN (1) AND p.tobuy = 1 ORDER BY pfp.ref_fourn DESC, pfp.quantity ASC

01:36 INFO    IP   --- End access to /htdocs/fourn/facture/card.php

[ksar]

Hi,

Disable is sometimes not enough, the php files are still loaded.
If possible try to remove all the folders inside /custom/ directory

[ksar]

Hi,

For the logs :

1. I do not see any error on it, but you mention that you found one ?
2. There is warnings on your setup that needs to be fixed, dolibarr can not access or create directories :

01:36 DEBUG   IP   functions.lib::dol_mkdir: Directory '/var' does not exists or is outside open_basedir PHP setting.
01:36 WARNING IP   functions.lib::dol_mkdir: Fails to create directory '/var' or directory already exists.
01:36 DEBUG   IP   functions.lib::dol_mkdir: Directory '/var/www' does not exists or is outside open_basedir PHP setting.
01:36 WARNING IP   functions.lib::dol_mkdir: Fails to create directory '/var/www' or directory already exists.
01:36 DEBUG   IP   functions.lib::dol_mkdir: Directory '/var/www/vhosts' does not exists or is outside open_basedir PHP setting.
01:36 WARNING IP   functions.lib::dol_mkdir: Fails to create directory '/var/www/vhosts' or directory already exists.

3. One php extension is missing :

01:36 WARNING IP   Failed to read image using Imagick (Try to install package 'apt-get install php-imagick ghostscript' and check there is no policy to disable pdf convertion in /etc/ImageMagick*/policy.xml): not authorized `/var/www/vhosts/domain_name/httpdocs/documents/fournisseur/facture/3/5/(PROV153)/(PROV153).pdf' @ error/constitute.c/ReadImage/454

[iosif.garleanu]

Hello,

1. The logs contained the error “Your state setup use an old syntax. Reedit it using setup area.”.
   @simicar suggested that I go to the company details and define the state or province. The State/Province parameter was already set!! Nevertheless, I changed it to something else, then to the correct value and now the error is gone from the logs.
2. Dolibarr runs, in my case, on a server with Plesk. I set the open_basedir to none from the PHP Settings menu in Plesk ( which from my understanding overwrittes settings done in php.ini ), still the DEBUG - WARNING messages appear in the logs.
   Edit: No disrespect intended, but after the lines you quoted, the next line says

01:36 DEBUG   IP   functions.lib::dol_mkdir: Directory '/var/www/vhosts/domain_name/httpdocs/documents/fournisseur/facture/3/5/(PROV153)' created

3. As the “About PHP” section in Dolibarr states, I have Imagick installed.
   
   

My mind goes in another direction. No offence intended, but as the issue with the State/Province raised even if the value was already set, maybe some fields need such a refresh and maybe because of this the vendor invoice card page doesn’t fully load all the time. (1)

To me it seems really weird that on an invoice on which yesterday I was able to add products, today I can’t anymore… (2)

But if (2) is true, then (1) is false as fields don’t lose their value in a matter of minutes/hours/days, right?

[iosif.garleanu]

Hello,

I ended up doing a manual rollback to V10.0.3.

Best regards