# \#MySQL **URL:** https://www.dolibarr.org/forum/tag/mysql/129.md [Latest](https://www.dolibarr.org/forum/latest.md) · [Categories](https://www.dolibarr.org/forum/categories.md) · [Tags](https://www.dolibarr.org/forum/tags.md) --- ## [Unable to make backup from mySQL](https://www.dolibarr.org/forum/t/unable-to-make-backup-from-mysql/31047)
**Author:** [@Antonomasia](https://www.dolibarr.org/forum/u/Antonomasia)\ **Replies:** 7\ **Last updated:** [March 17, 2026, 6:10pm UTC](https://www.dolibarr.org/forum/t/unable-to-make-backup-from-mysql/31047 "2026-03-17T18:10:08Z")
I have dolibarr 22.0.3 installed with docker on my machine. I am having some problems with the MySQL mysqldump backup that, when trying to make a new backup sends the message: “ERROR: unable to write in the directory”. … --- ## [Perplexity SPACE to FIX-IMPROVE SQL sentences for third party modules :-)](https://www.dolibarr.org/forum/t/perplexity-space-to-fix-improve-sql-sentences-for-third-party-modules/30749)
**Author:** [@caos30](https://www.dolibarr.org/forum/u/caos30)\ **Replies:** 1\ **Last updated:** [December 6, 2025, 2:59am UTC](https://www.dolibarr.org/forum/t/perplexity-space-to-fix-improve-sql-sentences-for-third-party-modules/30749 "2025-12-06T02:59:42Z")
Hello, i have created a SPACE on Perplexity (AI) to FIX/IMPROVE my SQL sentences for my third party modules for Dolibarr. And i share here the URL to be used by anyone: https://www.perplexity.ai/spaces/fix-sql-for-dolib… --- ## [Default character set and collation](https://www.dolibarr.org/forum/t/default-character-set-and-collation/20196)
**Author:** [@PILAFTSIS](https://www.dolibarr.org/forum/u/PILAFTSIS)\ **Replies:** 9\ **Last updated:** [April 14, 2025, 1:03pm UTC](https://www.dolibarr.org/forum/t/default-character-set-and-collation/20196 "2025-04-14T13:03:45Z")
Dear all, I have some trables with installation related to char set. So I would like to ensure: Utf8 is the character set. Can we use utf32? collation is utf8\_general\_ci. Am i correct can we use \_universal\_ci on what… --- ## [Using Module Builder to show SQL query results](https://www.dolibarr.org/forum/t/using-module-builder-to-show-sql-query-results/25670)
**Author:** [@ahau](https://www.dolibarr.org/forum/u/ahau)\ **Replies:** 1\ **Last updated:** [August 6, 2024, 8:15am UTC](https://www.dolibarr.org/forum/t/using-module-builder-to-show-sql-query-results/25670 "2024-08-06T08:15:35Z")
Hi folks, I’m a huge fan of Dolibarr and I’m currently trying to tailor it to my specific needs using the module builder. I want to show two tabs in my module. A “to call” list with third parties with a specific tag an… --- ## [Dollibarr Installation on hosted server](https://www.dolibarr.org/forum/t/dollibarr-installation-on-hosted-server/21242)
**Author:** [@dannyzia](https://www.dolibarr.org/forum/u/dannyzia)\ **Replies:** 15\ **Last updated:** [July 8, 2024, 4:59pm UTC](https://www.dolibarr.org/forum/t/dollibarr-installation-on-hosted-server/21242 "2024-07-08T16:59:17Z")
Hi, I am trying to install Dollibarr on my hosting server with Dreamhost. Followed the instructions from: Dolibarr ERP - CRM - Browse Files at SourceForge.net Here is what I get when I go to the page: erp.indigobangla… --- ## [Another "Illegal mix of collations (utf8\_general\_ci,IMPLICIT) and (utf8\_unicode\_ci,IMPLICIT) for operation '='"](https://www.dolibarr.org/forum/t/another-illegal-mix-of-collations-utf8-general-ci-implicit-and-utf8-unicode-ci-implicit-for-operation/21573)
**Author:** [@garn222](https://www.dolibarr.org/forum/u/garn222)\ **Replies:** 7\ **Last updated:** [March 1, 2024, 8:50am UTC](https://www.dolibarr.org/forum/t/another-illegal-mix-of-collations-utf8-general-ci-implicit-and-utf8-unicode-ci-implicit-for-operation/21573 "2024-03-01T08:50:34Z")
Hi there, There have been a lot of posts of this topic and I even made a post myself, the fix back then was the force update: Illegal mix of collations Fix: Error when checking Latest movement - Full List But now I … --- ## [Is there sql injection in DoliDBMysqli](https://www.dolibarr.org/forum/t/is-there-sql-injection-in-dolidbmysqli/24841)
**Author:** [@g.levoux](https://www.dolibarr.org/forum/u/g.levoux)\ **Replies:** 1\ **Last updated:** [January 23, 2024, 10:26am UTC](https://www.dolibarr.org/forum/t/is-there-sql-injection-in-dolidbmysqli/24841 "2024-01-23T10:26:34Z")
Hi everyone, I am creating a new PDF template and need to access the database to retrieve a value. Here’s my code: $propal\_extrafields = $this-\>db-\>query("SELECT \* FROM \`llx\_propal\_extrafields\` WHERE \`fk\_object\`=".$obj… --- ## [Deleting duplicate third party files](https://www.dolibarr.org/forum/t/deleting-duplicate-third-party-files/17067)
**Author:** [@RonGreen](https://www.dolibarr.org/forum/u/RonGreen)\ **Replies:** 3\ **Last updated:** [November 3, 2018, 10:04am UTC](https://www.dolibarr.org/forum/t/deleting-duplicate-third-party-files/17067 "2018-11-03T10:04:46Z")
In setting up imports of third parties I inadvertently made three copies of over 6,000 entries. So I now have duplicates (three exact copies) of the same entry. I know how to delete files one by one, but that is horrib… --- ## [Uninstalling Caused Unable to login](https://www.dolibarr.org/forum/t/uninstalling-caused-unable-to-login/21445)
**Author:** [@diesiraeilla](https://www.dolibarr.org/forum/u/diesiraeilla)\ **Replies:** 1\ **Last updated:** [November 18, 2021, 1:06pm UTC](https://www.dolibarr.org/forum/t/uninstalling-caused-unable-to-login/21445 "2021-11-18T13:06:46Z")
I have commun problem I think. I Uninstalled some unuseful programs on my computer with a local installation of Dolibarr (Windows 10) on it , and I don’t know by which I’ve done this but when I tried to reconnect nothin…