Hallo in die Runde, soweit läuft Dolibarr mittlerweile super und es fehlt nicht mehr viel um es im Betrieb zu implementieren…
Ich habe diverse Extrafelder in meinen Produkt-Modul (dropdown-Felder) die Werte in diesen stimmen auch,wenn ich jetzt jedoch alle Felder fülle und das Produkt speichere sind diese nach dem speichern/erstellen leer.
Das Modul habe ich bereits aus und wieder eingeschaltet, jedoch ohne Erfolg…
Hätte jemand eine Idee?
Hallo @EdelstahlBarr,
kannst du einen Auszug aus den Dolibarr Logs und den Apache Error Logs zum Zeitpunkt des Speicherns hier reinstellen? Nur von deiner kurzen Beschreibung habe ich leider noch keine Idee woran es liegen kann.
Gruß Sven
Folgendes spuckt die Dolibarr Logfile aus, wirklich schlau werde ich daraus leider nicht 
2023-07-31 15:18:54 DEBUG ::1 getURLContent response size=5
2023-07-31 15:18:54 DEBUG ::1 getURLContent http_code=200
2023-07-31 15:18:55 DEBUG ::1 --- End access to /dolibarr/admin/modules.php
2023-07-31 15:18:56 DEBUG ::1 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1
2023-07-31 15:18:56 DEBUG ::1 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, 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_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 as status, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.iplastlogin, u.ippreviouslogin, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, 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, u.national_registration_number, u.ref_employee, 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 = 'admin' ORDER BY u.entity ASC
2023-07-31 15:18:56 DEBUG ::1 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos
2023-07-31 15:18:56 DEBUG ::1 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2023-07-31 15:18:56 DEBUG ::1 DefaultValues::fetchAll
2023-07-31 15:18:56 DEBUG ::1 sql=SELECT rowid,type,user_id,page,param,value FROM llx_default_values as t WHERE 1 = 1 AND (t.user_id IN (0,1) AND entity IN (0,1))
2023-07-31 15:18:56 DEBUG ::1 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 r.entity = 1 AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2023-07-31 15:18:56 DEBUG ::1 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 IN (0,1) AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2023-07-31 15:18:56 DEBUG ::1 --- Access to GET /dolibarr/admin/syslog.php - action=, massaction=
2023-07-31 15:18:56 DEBUG ::1 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='de_DE' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2023-07-31 15:18:56 DEBUG ::1 sql=SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.prefix, 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
2023-07-31 15:18:56 DEBUG ::1 admin.lib::dolibarr_get_const
2023-07-31 15:18:56 DEBUG ::1 sql=SELECT value as value FROM llx_const WHERE name = 'SYSLOG_FACILITY' AND entity = 0
2023-07-31 15:18:56 DEBUG ::1 admin.lib::dolibarr_get_const
2023-07-31 15:18:56 DEBUG ::1 sql=SELECT value as value FROM llx_const WHERE name = 'SYSLOG_FILE' AND entity = 0
2023-07-31 15:18:56 DEBUG ::1 --- End access to /dolibarr/admin/syslog.php
2023-07-31 15:18:58 DEBUG ::1 - This is an already logged session. _SESSION['dol_login']=admin _SESSION['dol_entity']=1
2023-07-31 15:18:58 DEBUG ::1 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, 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_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 as status, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.iplastlogin, u.ippreviouslogin, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, 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, u.national_registration_number, u.ref_employee, 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 = 'admin' ORDER BY u.entity ASC
2023-07-31 15:18:58 DEBUG ::1 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos
2023-07-31 15:18:58 DEBUG ::1 sql=SELECT param, value FROM llx_user_param WHERE fk_user = 1 AND entity = 1
2023-07-31 15:18:58 DEBUG ::1 DefaultValues::fetchAll
2023-07-31 15:18:58 DEBUG ::1 sql=SELECT rowid,type,user_id,page,param,value FROM llx_default_values as t WHERE 1 = 1 AND (t.user_id IN (0,1) AND entity IN (0,1))
2023-07-31 15:18:58 DEBUG ::1 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 r.entity = 1 AND ur.entity = 1 AND ur.fk_user= 1 AND r.perms IS NOT NULL
2023-07-31 15:18:58 DEBUG ::1 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 IN (0,1) AND r.entity = 1 AND gr.fk_usergroup = gu.fk_usergroup AND gu.fk_user = 1 AND r.perms IS NOT NULL
2023-07-31 15:18:58 DEBUG ::1 --- Access to GET /dolibarr/document.php - action=, massaction= NOTOKENRENEWAL=1
2023-07-31 15:18:58 DEBUG ::1 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='de_DE' OR lang IS NULL AND entity IN (0, 1) ORDER BY lang DESC
2023-07-31 15:18:58 DEBUG ::1 dol_check_secure_access_document modulepart=logs original_file=dolibarr.log entity=1
2023-07-31 15:18:58 DEBUG ::1 document.php download c:/dolibarr/dolibarr_documents/dolibarr.log filename=dolibarr.log content-type=text/plain
Hallo @EdelstahlBarr,
ich vermute mal, dass der Logausschnitt der falsche ist. Es gibt dort weder eine SELECT, UPDATE noch eine INSERT sql Message zum Produkt und/oder deren Extrafeldern. D.h. dieser Ausschnitt hilft leider nicht weiter.
Bitte aktuelles Log ziehen und den letzten Zeitstempel aufschreiben, dann in ein Produkt gehen und denn Fall entsprechend nachstellen (d.h. Extrafelder füllen und versuchen zu speichern). Danach nochmals das Dolibarr Log ziehen und entsprechend alles vor dem gemerkten Zeitstempel rauslöschen und den Rest hier posten. Gleiches vorgehen mit den Apache Error Logs.
Gruß Sven
Vielen Dank für die so schnelle Antwort,anbei der Auszug aus dem Log, diesmal mit „insert,update etc“
Das Apache Log muss ich nochmal fix suchen…
2023-07-31 18:35:40 DEBUG ::1 Product::update
2023-07-31 18:35:40 DEBUG ::1 sql=UPDATE llx_product SET label = 'Kessel Typ 30 D', ref = '30_D', ref_ext = null, default_vat_code = null, tva_tx = 19, recuperableonly = 0, localtax1_tx = 0, localtax2_tx = 0, localtax1_type = '0', localtax2_type = '0', barcode = null, fk_barcode_type = null, tosell = 1, tobuy = 1, tobatch = 0, batch_mask = '', finished = null, fk_default_bom = null, net_measure = null, net_measure_units = null, weight = '3', weight_units = '0', length = null, length_units = null, width= null, width_units = null, height = null, height_units = null, surface = null, surface_units = '-2', volume = null, volume_units = null, fk_default_warehouse = null, fk_default_workstation = null, seuil_stock_alerte = 0, description = 'Kessel Typ 30 D', url = null, customcode = '', fk_country = null, fk_state = null, lifetime = null, qc_frequency = null, note = '', note_public = null, duration = '', accountancy_code_buy = '', accountancy_code_buy_intra = '', accountancy_code_buy_export = '', accountancy_code_sell= '', accountancy_code_sell_intra= '', accountancy_code_sell_export= '', desiredstock = 0, cost_price = null, fk_unit= NULL, price_autogen = 0, fk_price_expression = NULL, fk_user_modif = 1, mandatory_period = 0 WHERE rowid = 2
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'product' ORDER BY pos
2023-07-31 18:35:40 DEBUG ::1 Product::insertExtraFields delete then insert
2023-07-31 18:35:40 DEBUG ::1 sql=DELETE FROM llx_product_extrafields WHERE fk_object = 2
2023-07-31 18:35:40 DEBUG ::1 sql=INSERT INTO llx_product_extrafields (fk_object,spannung,badzeit,badmenge,abmessungen,verfahren,kontaktierung,verpackung,qmf,werkstoff) VALUES (2,'7V','25min','5','D = 500 x 350','20','0','1','0','0')
2023-07-31 18:35:40 DEBUG ::1 Trigger 'ActionsAuto' for action 'PRODUCT_MODIFY' launched by C:\dolibarr\www\dolibarr\htdocs\core\triggers\interface_50_modAgenda_ActionsAuto.class.php. id=2
2023-07-31 18:35:40 DEBUG ::1 CActionComm::fetch
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT id, code, type, libelle as label, color, active, picto FROM llx_c_actioncomm WHERE code='AC_OTH_AUTO'
2023-07-31 18:35:40 DEBUG ::1 ActionComm::add
2023-07-31 18:35:40 DEBUG ::1 sql=INSERT INTO llx_actioncomm(ref,datec,datep,datep2,durationp,fk_action,code,ref_ext,fk_soc,fk_project,note,fk_contact,fk_user_author,fk_user_action,fk_user_done,label,percent,priority,fulldayevent,location,transparency,fk_element,elementtype,entity,extraparams,email_msgid,email_from,email_sender,email_to,email_tocc,email_tobcc,email_subject,errors_to,recurid,recurrule,recurdateend,num_vote,event_paid,status,ip) VALUES ('(PROV)', '2023-07-31 18:35:40', '2023-07-31 18:35:40', '2023-07-31 18:35:40', null, 40,'AC_PRODUCT_MODIFY', null, null, null, 'Produkt 30_D geändert', null, 1, 1, null, 'Produkt 30_D geändert', '-1', '0', '0', '', '0', 2, 'product', 1,null, null, null, null, null, null, null, null, null, null, null, null, null, 0, 0, null)
2023-07-31 18:35:40 DEBUG ::1 sql=UPDATE llx_actioncomm SET ref='18' WHERE id=18
2023-07-31 18:35:40 DEBUG ::1 sql=INSERT INTO llx_actioncomm_resources(fk_actioncomm, element_type, fk_element, mandatory, transparency, answer_status) VALUES(18, 'user', 1, 0, 0, 0)
2023-07-31 18:35:40 DEBUG ::1 COMMIT Transaction
2023-07-31 18:35:40 DEBUG ::1 Product::setCategoriesCommon Oject Id:2 type_categ:product nb tag add:1
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT ct.fk_categorie, c.label, c.rowid FROM llx_categorie_product as ct, llx_categorie as c WHERE ct.fk_categorie = c.rowid AND ct.fk_product = 2 AND c.entity IN (1)
2023-07-31 18:35:40 DEBUG ::1 files.lib.php::dol_dir_list path=c:/dolibarr/dolibarr_documents/produit/30_D types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$"
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT COUNT(rowid) as nb FROM llx_links WHERE objecttype = 'product' AND objectid = 2 AND entity = 1
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT * FROM llx_customizeforms as t WHERE t.modulo = '' AND t.submodulo = 'product' AND t.pagina = 'card.php' AND t.entity = '1' order by rowid asc;
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT MAX(te.ref) FROM llx_product as te WHERE te.ref < '30_D' AND fk_product_type = 0 AND te.entity IN (1)
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT MIN(te.ref) FROM llx_product as te WHERE te.ref > '30_D' AND fk_product_type = 0 AND te.entity IN (1)
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT cc.code FROM llx_c_country as cc WHERE cc.eec = 1
2023-07-31 18:35:40 DEBUG ::1 CUnits::fetchAll
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT t.rowid, t.code, t.sortorder, t.label, t.short_label, t.unit_type, t.scale, t.active FROM llx_c_units as t WHERE (t.scale = 0 AND t.unit_type = 'weight' AND t.active = 1)
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT ct.fk_categorie, c.label, c.rowid FROM llx_categorie_product as ct, llx_categorie as c WHERE ct.fk_categorie = c.rowid AND ct.fk_product = 2 AND c.entity IN (1)
2023-07-31 18:35:40 DEBUG ::1 Categorie::fetch
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT rowid, fk_parent, entity, label, description, color, fk_soc, visible, type, ref_ext, date_creation, tms, fk_user_creat, fk_user_modif FROM llx_categorie WHERE rowid = 9
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'categorie' ORDER BY pos
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT fk_parent FROM llx_categorie WHERE rowid = 9
2023-07-31 18:35:40 DEBUG ::1 Categorie::fetch
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT rowid, fk_parent, entity, label, description, color, fk_soc, visible, type, ref_ext, date_creation, tms, fk_user_creat, fk_user_modif FROM llx_categorie WHERE rowid = 6
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT fk_parent FROM llx_categorie WHERE rowid = 6
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT COUNT(*) as nb FROM llx_supplier_proposaldet as c, llx_supplier_proposal as p WHERE c.fk_product = 2 AND c.fk_supplier_proposal = p.rowid
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT COUNT(*) as nb FROM llx_propaldet as c, llx_propal as p WHERE c.fk_product = 2 AND c.fk_propal = p.rowid
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT COUNT(*) as nb FROM llx_commandedet as c, llx_commande as p WHERE c.fk_product = 2 AND c.fk_commande = p.rowid
2023-07-31 18:35:40 DEBUG ::1 files.lib.php::dol_dir_list path=c:/dolibarr/dolibarr_documents/produit/30_D/ types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*\\.png)$"
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, tms as date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE entity = 1 AND filepath = 'produit/30_D'
2023-07-31 18:35:40 DEBUG ::1 Translate::loadCacheCurrencies
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'EUR'
2023-07-31 18:35:40 DEBUG ::1 files.lib.php::dol_dir_list path=c:/dolibarr/dolibarr_documents/produit/30_D types=files recursive=0 filter= excludefilter="(\\.meta|_preview.*.*\\.png)$"
2023-07-31 18:35:40 DEBUG ::1 /core/lib/function2.lib.php::getListOfModels
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT nom as id, nom as doc_template_name, libelle as label, description as description FROM llx_document_model WHERE type = 'product' AND entity IN (0,1) ORDER BY description DESC
2023-07-31 18:35:40 DEBUG ::1 Link::fetchAll
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT rowid, entity, datea, url, label, objecttype, objectid FROM llx_links WHERE objecttype = 'product' AND objectid = 2 AND entity = 1
2023-07-31 18:35:40 DEBUG ::1 Link::fetchAll num=0
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT rowid, label, entity, filename, filepath, fullpath_orig, keywords, cover, gen_or_uploaded, extraparams, date_c, tms as date_m, fk_user_c, fk_user_m, acl, position, share FROM llx_ecm_files WHERE entity = 1 AND filepath = 'produit/30_D'
2023-07-31 18:35:40 DEBUG ::1 ActionComm::getActions
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT a.id FROM llx_actioncomm as a WHERE a.entity IN (1) AND a.fk_element = 2 AND a.elementtype = 'product' ORDER BY a.datep DESC, a.id DESC LIMIT 11
2023-07-31 18:35:40 DEBUG ::1 ActionComm::fetch
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT a.id, a.ref as ref, a.entity, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note as note_private, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.transparency, a.email_msgid, a.email_subject, a.email_from, a.email_sender, a.email_to, a.email_tocc, a.email_tobcc, a.errors_to, c.id as type_id, c.type as type_type, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname, num_vote, event_paid, a.status FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id = 18
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'actioncomm' ORDER BY pos
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 18 AND element_type IN ('user', 'socpeople')
2023-07-31 18:35:40 DEBUG ::1 ActionComm::fetch
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT a.id, a.ref as ref, a.entity, a.ref_ext, a.datep, a.datep2, a.durationp, a.datec, a.tms as datem, a.code, a.label, a.note as note_private, a.fk_soc, a.fk_project, a.fk_user_author, a.fk_user_mod, a.fk_user_action, a.fk_user_done, a.fk_contact, a.percent as percentage, a.fk_element as elementid, a.elementtype, a.priority, a.fulldayevent, a.location, a.transparency, a.email_msgid, a.email_subject, a.email_from, a.email_sender, a.email_to, a.email_tocc, a.email_tobcc, a.errors_to, c.id as type_id, c.type as type_type, c.code as type_code, c.libelle as type_label, c.color as type_color, c.picto as type_picto, s.nom as socname, u.firstname, u.lastname as lastname, num_vote, event_paid, a.status FROM llx_actioncomm as a LEFT JOIN llx_c_actioncomm as c ON a.fk_action=c.id LEFT JOIN llx_user as u on u.rowid = a.fk_user_author LEFT JOIN llx_societe as s on s.rowid = a.fk_soc WHERE a.id = 9
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT fk_actioncomm, element_type, fk_element, answer_status, mandatory, transparency FROM llx_actioncomm_resources WHERE fk_actioncomm = 9 AND element_type IN ('user', 'socpeople')
2023-07-31 18:35:40 DEBUG ::1 CActionComm::liste_array
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT id, code, libelle as label, module, type, color, picto FROM llx_c_actioncomm WHERE 1=1 AND active=1 ORDER BY type, position, module
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, 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_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 as status, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.iplastlogin, u.ippreviouslogin, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, 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, u.national_registration_number, u.ref_employee, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid WHERE u.entity IS NOT NULL AND u.rowid = 1 ORDER BY u.entity ASC
2023-07-31 18:35:40 DEBUG ::1 sql=SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = 'user' ORDER BY pos
2023-07-31 18:35:40 DEBUG ::1 --- End access to /dolibarr/product/card.php
Hallo,
also in den Dolibarr Logs konnte ich leider nichts finden, was einen Hinweis gibt warum es nicht funktioniert. Wie gesagt wären noch die Apache Error Logs interessant im gleichen Zeitraum.
Wie ich sehe, werden externe Module wie Customize Forms verwendet. Hier kann ich auch empfehlen erstmal alle externen zu deaktivieren und zu probieren ob das Problem noch auftritt. Dadurch lässt sich ggf. das ganze Eingrenzen.
Gruß Sven
Vielen Dank nochmal für die Antwort,
ich habe nun mal eine neue Installation aufgesetzt und es mit den selben Feldern versucht (ohne Customize Forms Module) und der Fehler besteht leider nach wie vor.
Man kann ja Dropdown-Felder auch via Database „füttern“ evtl. wäre dies eine Option,dazu habe ich leider nicht viel gefunden im Netz.
Wie genau müsste man den die Datenbank öffnen / bearbeiten und dann verlinken?
Habe es mit OpenOffice versucht, dort gibt es aber einen „classdriver“ Fehler,diesen bekomme ich aber bestimmt gefixt, muss wohl ein Problem von Office sein…
Alles sehr kurios… 
Hallo @EdelstahlBarr,
kannst du bitte Screenshots von deinen bisherigen Einstellungen zu den Extrafeldern im Produkt machen und auch wie es in der Produktansicht aussieht in der normalen Ansicht und beim Editieren? Welche Dolibarr Version verwendest du?
Gruß Sven
Hallo @digitalcentric.de ,
ich konnte das Problem lösen.
Ursache war wohl ein „Typo“ hatte Daten importiert aus der alten Datenbank welche jedoch wie folgt übernommen worden sind :
1 , Dies ist ein Test
2 , Dies ist ein Test
Dolibarr mag wohl die Leerzeichen nicht,habe diese nun entfernt und es funktioniert alles.
Vielen Dank für die super Unterstützung!
