Je n’arrive pas à supprimer des tiers et ce depuis un moment. Je viens de regarder les logs et de m’y remettre, et cela vient d’un hook du module pricelist qui génère une mauvaise ligne, je pense qu’il y a du CASCADE et donc si je supprime un tiers, cela doit supprimer les prix spécifiques entrés pour ce client :
2017-06-27 13:04:53 INFO 91.160.90.29 --- Access to /dolibarr/htdocs/societe/soc.php
2017-06-27 13:04:53 DEBUG 91.160.90.29 sql=SELECT transkey, transvalue FROM llx_overwrite_trans where lang='fr_FR'
2017-06-27 13:04:53 DEBUG 91.160.90.29 Menubase::menuLoad mymainmenu=companies myleftmenu= type_user=0 menu_handler=eldy tabMenu size=0
2017-06-27 13:04:53 DEBUG 91.160.90.29 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
2017-06-27 13:04:53 DEBUG 91.160.90.29 ExtraFields::fetch_name_optionals_label
2017-06-27 13:04:53 DEBUG 91.160.90.29 sql=SELECT rowid,name,label,type,size,elementtype,fieldunique,fieldrequired,param,pos,alwayseditable,perms,list,ishidden FROM llx_extrafields WHERE entity IN (0,1) AND elementtype = 'societe' ORDER BY pos
2017-06-27 13:04:53 INFO 91.160.90.29 Loading hook:actions_pricelist.class.php
2017-06-27 13:04:53 DEBUG 91.160.90.29 sql=SELECT rowid, canvas FROM llx_societe WHERE entity IN (1) AND rowid = 251
2017-06-27 13:04:53 INFO 91.160.90.29 HookManager::executeHooks method=doActions action=confirm_delete context=thirdpartycard:globalcard:main
2017-06-27 13:04:53 DEBUG 91.160.90.29 Call method doActions of class ActionsPriceList, module=pricelist, hooktype=addreplace
2017-06-27 13:04:53 DEBUG 91.160.90.29 BEGIN Transaction
2017-06-27 13:04:53 DEBUG 91.160.90.29 sql=DELETE FROM llx_pricelist WHERE fk_soc =
2017-06-27 13:04:53 ERR 91.160.90.29 DoliDBMysqli::query SQL Error message: DB_ERROR_SYNTAX You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
2017-06-27 13:04:53 DEBUG 91.160.90.29 ROLLBACK Transaction
2017-06-27 13:04:53 INFO 91.160.90.29 --- End access to /dolibarr/htdocs/societe/soc.php
Du coup la transaction de passe pas et il y a un rollback, et mon tiers n’est donc pas supprimer.
Merci,