# Problem with Plugin Change Thirdparty Errors **URL:** \ **Category:** DoliStore's external modules\ **Tags:** Third-Parties, Error\ **Created:** [March 31, 2025, 4:16pm UTC](https://www.dolibarr.org/forum/t/problem-with-plugin-change-thirdparty-errors/30181 "2025-03-31T16:16:37Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![geppettvs](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/geppettvs/32/4029_2.png) [@geppettvs](https://www.dolibarr.org/forum/u/geppettvs)\ **Post date:** [March 31, 2025, 4:16pm UTC](https://www.dolibarr.org/forum/t/problem-with-plugin-change-thirdparty-errors/30181/1 "2025-03-31T16:16:38Z")
# Precedents I purchased the Plugin and after installing the **“[Change Third Party Plugin](https://www.dolistore.com/product.php?id=991)”**, I can see the button in the document, but when I click it I get errors on screen as you can see in the **Log Files** section below. I have already tried contacting the developer, but they simply responded _ **“Let me try to contact the guy that developed the module as he left the company an year ago.”** _ The initial support request was on March 2, 2025, and I haven’t received a solution from the developer. If anyone may have some experience with this kind of error, I would appreciate getting your support. # **What I have tried so far?** 1. I tried using a brand-new installation of Version 20.0.4 2. I also tried with a brand-new installation of Version 19.0.3 3. I tried to find the MySQL SELECT sentence, to inspect the actual “bad syntax of search string” but I couldn’t grep it on the Plugin’s files successfully. It seems it has a dependence from another module, which I can’t find. 4. I also tried contacting Dolibarr Support, but they simply sent a reminder to the developers and didn’t respond to my requests for support or refund. # Log files ## From Version 20.0.4 _Dolibarr ha detectado un error técnico. Esta información puede ser útil para fines de diagnóstico (puede establecer la opción $dolibarr\_main\_prod en ‘1’ para ocultar información confidencial): **Fecha:** 20250302153806 **Dolibarr:** 20.0.4 - [https://www.dolibarr.org](https://www.dolibarr.org) **Inicio de sesión:** geppettvs **PHP:** 7.1.33 **Servidor:** LiteSpeed **SO:** Linux [s3413.mex1.stableserver.net](http://s3413.mex1.stableserver.net) 4.18.0-513.9.1.lve.el8.x86\_64 #1 SMP Mon Dec 4 15:01:22 UTC 2023 x86\_64 **Agente de usuario:** Mozilla/5.0 (X11; Linux x86\_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36_ _ **URL solicitada:** /difmadero/htdocs/fourn/commande/card.php?id=13&action=changethirdparty&page\_y=555.5555419921875 **Referer:** [https://erp-services.mx/difmadero/htdocs/fourn/commande/card.php?id=13](https://erp-services.mx/difmadero/htdocs/fourn/commande/card.php?id=13) **Administrar menú:** eldy\_menu.php_ _ **Módulos/Aplicaciones:** user, supplier\_proposal, fckeditor, projet, categorie, cron, fournisseur, societe, import, changethirdparty, gravatar, product, export **Administrador de tipo de base de datos:** mysqli **Último error de solicitud de acceso a la base de datos:** SELECT s.rowid, s.nom as name, s.name\_alias, s.tva\_intra, s.client, s.fournisseur, s.code\_client, s.code\_fournisseur FROM llx\_societe as s WHERE s.entity IN (1) AND (Filter error - Bad syntax of the search string) ORDER BY nom ASC **Código de respuesta para el último error de solicitud de acceso a la base de datos:** DB\_ERROR\_SYNTAX **Información para el último error de solicitud de acceso a la base de datos:** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘error - Bad syntax of the search string) ORDER BY nom ASC’ at line 1_ * * * I also tried with brand-new installation of version 19.0.3, and I yet receive the same errors. Please see the error logs. * * * ## From Version 19.0.3 Dolibarr ha detectado un error técnico. Esta información puede ser útil para fines de diagnóstico (puede establecer la opción $dolibarr\_main\_prod en ‘1’ para ocultar información confidencial): **Fecha:** 20250302160440 **Dolibarr:** 19.0.3 - [https://www.dolibarr.org](https://www.dolibarr.org) **Nivel de características:** 0 **PHP:** 7.1.33 **Server:** LiteSpeed **OS:** Linux [s3413.mex1.stableserver.net](http://s3413.mex1.stableserver.net) 4.18.0-513.9.1.lve.el8.x86\_64 #1 SMP Mon Dec 4 15:01:22 UTC 2023 x86\_64 **Agente de usuario:** Mozilla/5.0 (X11; Linux x86\_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36 **URL solicitada:** /difmadero/htdocs/supplier\_proposal/card.php?id=24&action=changethirdparty&page\_y=195.55555725097656 **Referer:** [https://erp-services.mx/difmadero/htdocs/supplier\_proposal/card.php?id=24&save\_lastsearch\_values=1](https://erp-services.mx/difmadero/htdocs/supplier_proposal/card.php?id=24&save_lastsearch_values=1) **Administrar menú:** eldy\_menu.php **Módulos/Aplicaciones:** user, supplier\_proposal, fckeditor, projet, categorie, cron, fournisseur, societe, import, changethirdparty, gravatar, product, export **Administrador de tipo de base de datos:** mysqli **Último error de solicitud de acceso a la base de datos:** SELECT s.rowid, s.nom as name, s.name\_alias, s.tva\_intra, s.client, s.fournisseur, s.code\_client, s.code\_fournisseur FROM llx\_societe as s WHERE s.entity IN (1) AND (Filter syntax error - Bad syntax of the search string) ORDER BY nom ASC **Código de respuesta para el último error de solicitud de acceso a la base de datos:** DB\_ERROR\_SYNTAX **Información para el último error de solicitud de acceso a la base de datos:** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘syntax error - Bad syntax of the search string) ORDER BY nom ASC’ at line 1 * * * Kindly let me know how to fix. If you need further information, please let me know to update this question. ---
**Author:** ![jonbendtsen](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/977dab/32.png) [@jonbendtsen](https://www.dolibarr.org/forum/u/jonbendtsen)\ **Post date:** [March 31, 2025, 6:53pm UTC](https://www.dolibarr.org/forum/t/problem-with-plugin-change-thirdparty-errors/30181/2 "2025-03-31T18:53:53Z")
Which database version do you use? what other modules do you have installed? ---
**Author:** ![geppettvs](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/geppettvs/32/4029_2.png) [@geppettvs](https://www.dolibarr.org/forum/u/geppettvs)\ **Post date:** [April 1, 2025, 6:21pm UTC](https://www.dolibarr.org/forum/t/problem-with-plugin-change-thirdparty-errors/30181/3 "2025-04-01T18:21:17Z")
Sorry for the delay, I needed to verify with my hosting service provider. Database: MariaDB 10.6.21 PHP: 8.3.19 Kindly let me know if you need more information, and thanks for your support. ---
**Author:** ![jonbendtsen](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/977dab/32.png) [@jonbendtsen](https://www.dolibarr.org/forum/u/jonbendtsen)\ **Post date:** [April 2, 2025, 7:14pm UTC](https://www.dolibarr.org/forum/t/problem-with-plugin-change-thirdparty-errors/30181/4 "2025-04-02T19:14:12Z")
> [@jonbendtsen](#): > > what other modules do you have installed? I’d like to know what other modules, though I don’t think there should be a conflict - but there might ---
**Author:** ![geppettvs](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/geppettvs/32/4029_2.png) [@geppettvs](https://www.dolibarr.org/forum/u/geppettvs)\ **Post date:** [April 2, 2025, 10:01pm UTC](https://www.dolibarr.org/forum/t/problem-with-plugin-change-thirdparty-errors/30181/5 "2025-04-02T22:01:37Z")
Only the core modules. I didn’t install any other third party modules so far. This is the one I am interested in for now. Thanks ---
**Author:** ![jonbendtsen](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/977dab/32.png) [@jonbendtsen](https://www.dolibarr.org/forum/u/jonbendtsen)\ **Post date:** [April 3, 2025, 5:55am UTC](https://www.dolibarr.org/forum/t/problem-with-plugin-change-thirdparty-errors/30181/6 "2025-04-03T05:55:03Z")
Okay. Please read this first, then try it, delete the files in /tmp and do it again for real. The goal is to get JUST relevant log snippets 1. find dolibarr.log 2. find the webserver log 3. run tail dolibarr.log - just to see if it works 4. run tail webserver log - just to see it works 5. open multiple browser windows or multiple browser tabs 6. find the debug logging function and enable it - leave this page open 7. run tail -f dolibarr.log | tee /tmp/new\_short\_doli\_log\_file.txt 8. run tail -f webserver log | tee /tmp/new\_short\_webserver\_log\_file.txt 9. do what ever causes this error while keeping the step 7 and 8 open 10. ctrl+c on step 7 and 8 so you stop adding to the short log files 11. in window nr. 6. reduce the log level 12. check the short log files for explanations 13. if needed clean up the log files from secret information and share it here what is secret informations? Hostnames ip addresses, usernames, hash values, keys, … ---
**Author:** ![geppettvs](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/geppettvs/32/4029_2.png) [@geppettvs](https://www.dolibarr.org/forum/u/geppettvs)\ **Post date:** [April 3, 2025, 9:08pm UTC](https://www.dolibarr.org/forum/t/problem-with-plugin-change-thirdparty-errors/30181/7 "2025-04-03T21:08:53Z")
Thanks for your help and patience. I tried to find the .log files with no success. Is it there a specific folder where I should look for? ![imagen](https://www.dolibarr.org/forum/uploads/dolibarrorg/original/2X/e/e15a365917bc35030b899aefb3fd7cb4106c2f34.jpeg) ---
**Author:** ![jonbendtsen](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/977dab/32.png) [@jonbendtsen](https://www.dolibarr.org/forum/u/jonbendtsen)\ **Post date:** [April 3, 2025, 9:20pm UTC](https://www.dolibarr.org/forum/t/problem-with-plugin-change-thirdparty-errors/30181/8 "2025-04-03T21:20:13Z")
sorry, I should have told you that it is usually stored in the documents folder. Maybe it requires the debug logging module to be enabled to appear? ---
**Author:** ![geppettvs](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/geppettvs/32/4029_2.png) [@geppettvs](https://www.dolibarr.org/forum/u/geppettvs)\ **Post date:** [April 4, 2025, 11:35pm UTC](https://www.dolibarr.org/forum/t/problem-with-plugin-change-thirdparty-errors/30181/11 "2025-04-04T23:35:16Z")
I won’t follow this thread. All the efforts I did to make this Plugin work didn’t succeed. It is worthless to continue working on this and there are alternatives to do the same thing and there are another Plugin which does a similar work. Thanks for your help.