PB avec divers erreurs sur nouvelle install

Installation & configuration Linux
1

Bonjour,

Après une installation propre sur un Ubuntu 19.04 et installation de Diacamma (2.4.1.19082912) avec la procédure ci-après https://www.choukajohn.me/index.php/2018/08/03/installation-de-diacamma-sur-serveur-linux-ubuntu-debian/ , j’ai des erreurs :
Après la connexion sur l’interface web et periodiquement

  • Parameter condominium-old-accounting unknown !
    Clic sur administration\Configuration générale ou Configuration de copropriété ou Configuration comptable ou Configuration du règlement
  • Parameter accounting-system unknown !

Pensant avoir un probleme avec la base de données, je l’ai supprime et recreer. Même message.
J’ai formaté complètement la machine et j’ai refait une install de Linux et de Diacamma.
Même probleme.

Merci d’avance de votre aide

2

Bonjour,

Ce message laisse comprendre qu’il y a un souci sur la BD.
Il vous faut donc forcer le réfraichissement

Deux solutions:

  • En laçant la commande:
/var/lucterios2/launch_lucterios.sh refreshall
  • Via la commande Django:

cd /var/lucterios2/ source virtual_for_lucterios/bin/activate python manage_copro.py migrate

3

Bonjour,

Mon erreur est identique même après application des commandes de corrections.

Exemple dans Administration / Configuration Générale :

Parameter accounting-system unknown!

/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/views/generic/base.py in line 97 in dispatch : return handler(request, *args, **kwargs)
/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/lucterios/framework/xferbasic.py in line 311 in post : return self.get_post(request, *args, **kwargs)
/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/lucterios/framework/xferbasic.py in line 300 in get_post : self.fillresponse(**self._get_params())
/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/lucterios/CORE/views.py in line 287 in fillresponse : signal_and_lock.Signal.call_signal(“config”, self)
/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/lucterios/framework/signal_and_lock.py in line 67 in call_signal : if sign_fct(*args):
/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/lucterios/CORE/views.py in line 260 in config_core : Params.fill(xfer, [‘CORE-connectmode’, ‘CORE-Wizard’, ‘CORE-MessageBefore’], 1, 1)
/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/lucterios/CORE/parameters.py in line 262 in fill : signal_and_lock.Signal.call_signal(‘get_param_titles’, names, titles)
/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/lucterios/framework/signal_and_lock.py in line 67 in call_signal : if sign_fct(*args):
/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/diacamma/condominium/views_classload.py in line 477 in paramtitles_condomium : system_condo = current_system_condo()
/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/diacamma/condominium/system/init.py in line 60 in current_system_condo : setattr(current_module, ‘SYSTEM_CONDO_CACHE’, get_condo_system())
/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/diacamma/condominium/system/init.py in line 40 in get_condo_system : complete_name = Params.getvalue(“accounting-system”)
/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/lucterios/CORE/parameters.py in line 236 in getvalue : return cls._get(name).value
/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/lucterios/CORE/parameters.py in line 227 in _get : raise LucteriosException(GRAVE, “Parameter %s unknown!” % name)

Auriez-vous une idée ?
merci pour votre travail

4

Bonjour,

N’oubliez pas de relancer l’application web après la commande rafraîchissement.
Si vous lancez une commande Gunicorn comme l’explique choukajohn dans son blog, vous devrez tuer le processus et le relancer.

5

Bonjour,

Je reprends le probleme.
Suite à la manip communiqué, le serveur a été rebooté et les instances/services relancés.
Le probleme est toujours là.

Rapport de l’erreur Parameter condominium-old-accounting unknown !
/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/views/generic/base.py in line 97 in dispatch : return handler(request, *args, **kwargs)
/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/framework/xferbasic.py in line 311 in post : return self.get_post(request, *args, **kwargs)
/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/framework/xferbasic.py in line 300 in get_post : self.fillresponse(**self._get_params())
/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/CORE/views.py in line 79 in fillresponse : signal_and_lock.Signal.call_signal(“summary”, self)
/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/framework/signal_and_lock.py in line 67 in call_signal : if sign_fct(*args):
/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/diacamma/condominium/views.py in line 542 in summary_condo : if Params.getvalue(“condominium-old-accounting”):
/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/CORE/parameters.py in line 236 in getvalue : return cls._get(name).value
/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/CORE/parameters.py in line 227 in _get : raise LucteriosException(GRAVE, “Parameter %s unknown!” % name)

Rapport de l erreur Parameter accounting-system unknown!
/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/views/generic/base.py in line 97 in dispatch : return handler(request, *args, **kwargs)
/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/framework/xferbasic.py in line 311 in post : return self.get_post(request, *args, **kwargs)
/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/framework/xferbasic.py in line 300 in get_post : self.fillresponse(**self._get_params())
/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/CORE/views.py in line 285 in fillresponse : signal_and_lock.Signal.call_signal(“config”, self)
/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/framework/signal_and_lock.py in line 67 in call_signal : if sign_fct(*args):
/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/CORE/views.py in line 258 in config_core : Params.fill(xfer, [‘CORE-connectmode’, ‘CORE-Wizard’, ‘CORE-MessageBefore’], 1, 1)
/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/CORE/parameters.py in line 262 in fill : signal_and_lock.Signal.call_signal(‘get_param_titles’, names, titles)
/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/framework/signal_and_lock.py in line 67 in call_signal : if sign_fct(*args):
/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/diacamma/condominium/views_classload.py in line 477 in paramtitles_condomium : system_condo = current_system_condo()
/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/diacamma/condominium/system/init.py in line 60 in current_system_condo : setattr(current_module, ‘SYSTEM_CONDO_CACHE’, get_condo_system())
/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/diacamma/condominium/system/init.py in line 40 in get_condo_system : complete_name = Params.getvalue(“accounting-system”)
/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/CORE/parameters.py in line 236 in getvalue : return cls._get(name).value
/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/CORE/parameters.py in line 227 in _get : raise LucteriosException(GRAVE, “Parameter %s unknown!” % name)

Merci d’avance de votre aide.

6

Bonjour,

Je ne comprend plus le souci, l’erreur “Parameter condominium-old-accounting unknown” surviens lorsque l’initialisation de la base ne s’est pas fait correctement.
Si vous avez bien fait un “launch_lucterios.sh refreshall” (ou un “python manage_copro.py migrate”), je ne comprend pas où peux venir le souci.

7

Bonjour,

Je vais être un peu plus assidu dans la lecture de vos réponses et échanger plus rapidement

Voici le résultat de la commande python manage_copro.py migrate >> probleme identique apres reboot du serveur et relance du service

NOM_SERVEUR:/var/lucterios2$ source virtual_for_lucterios/bin/activate
(virtual_for_lucterios) NOM_SERVEUR:/var/lucterios2$ python manage_copro.py migrate
Operations to perform:
Apply all migrations: CORE, accounting, admin, auth, condominium, contacts, contenttypes, documents, framework, mailing, payoff, sessions, syndic
Running migrations:
No migrations to apply.
Your models have changes that are not yet reflected in a migration, and so won’t be applied.
Run ‘manage.py makemigrations’ to make new migrations, and then re-run ‘manage.py migrate’ to apply them.
check parameters
Traceback (most recent call last):
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/utils.py”, line 84, in _execute
return self.cursor.execute(sql, params)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/mysql/base.py”, line 71, in execute
return self.cursor.execute(query, args)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/MySQLdb/cursors.py”, line 209, in execute
res = self._query(query)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/MySQLdb/cursors.py”, line 315, in _query
db.query(q)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/MySQLdb/connections.py”, line 226, in query
_mysql.connection.query(self, query)
MySQLdb._exceptions.OperationalError: (1366, “Incorrect string value: ‘\xE2\x82\xAA)’)…’ for column ‘metaselect’ at row 1”)

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File “manage_copro.py”, line 8, in
execute_from_command_line(sys.argv)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/core/management/init.py”, line 381, in execute_from_command_line
utility.execute()
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/core/management/init.py”, line 375, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/core/management/base.py”, line 323, in run_from_argv
self.execute(*args, **cmd_options)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/core/management/base.py”, line 364, in execute
output = self.handle(*args, **options)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/core/management/base.py”, line 83, in wrapped
res = handle_func(*args, **kwargs)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/core/management/commands/migrate.py”, line 257, in handle
self.verbosity, self.interactive, connection.alias, apps=post_migrate_apps, plan=plan,
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/core/management/sql.py”, line 51, in emit_post_migrate_signal
**kwargs
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/dispatch/dispatcher.py”, line 175, in send
for receiver in self._live_receivers(sender)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/dispatch/dispatcher.py”, line 175, in
for receiver in self._live_receivers(sender)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/CORE/models.py”, line 497, in post_after_migrate
Signal.call_signal(“checkparam”)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/framework/signal_and_lock.py”, line 67, in call_signal
if sign_fct(*args):
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/diacamma/accounting/models.py”, line 1584, in accounting_checkparam
value=‘EUR’, meta=get_meta_currency_iso())
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/CORE/models.py”, line 76, in check_and_create
param.save()
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/models/base.py”, line 741, in save
force_update=force_update, update_fields=update_fields)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/models/base.py”, line 779, in save_base
force_update, using, update_fields,
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/models/base.py”, line 851, in _save_table
forced_update)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/models/base.py”, line 900, in _do_update
return filtered._update(values) > 0
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/models/query.py”, line 760, in _update
return query.get_compiler(self.db).execute_sql(CURSOR)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/models/sql/compiler.py”, line 1429, in execute_sql
cursor = super().execute_sql(result_type)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/models/sql/compiler.py”, line 1100, in execute_sql
cursor.execute(sql, params)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/utils.py”, line 99, in execute
return super().execute(sql, params)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/utils.py”, line 67, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/utils.py”, line 76, in _execute_with_wrappers
return executor(sql, params, many, context)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/utils.py”, line 84, in _execute
return self.cursor.execute(sql, params)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/utils.py”, line 89, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/utils.py”, line 84, in _execute
return self.cursor.execute(sql, params)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/mysql/base.py”, line 71, in execute
return self.cursor.execute(query, args)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/MySQLdb/cursors.py”, line 209, in execute
res = self._query(query)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/MySQLdb/cursors.py”, line 315, in _query
db.query(q)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/MySQLdb/connections.py”, line 226, in query
_mysql.connection.query(self, query)
django.db.utils.OperationalError: (1366, “Incorrect string value: ‘\xE2\x82\xAA)’)…’ for column ‘metaselect’ at row 1”)

Voici le resultat de la commande /var/lucterios2/launch_lucterios.sh refreshall >> probleme identique apres reboot du serveur et relance du service

NOM_SERVEUR:/var/lucterios2$ /var/lucterios2/launch_lucterios.sh refreshall
Operations to perform:
Apply all migrations: CORE, accounting, admin, auth, condominium, contacts, contenttypes, documents, framework, mailing, payoff, sessions, syndic
Running migrations:
No migrations to apply.
Your models have changes that are not yet reflected in a migration, and so won’t be applied.
Run ‘manage.py makemigrations’ to make new migrations, and then re-run ‘manage.py migrate’ to apply them.
check parameters
Traceback (most recent call last):
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/utils.py”, line 84, in _execute
return self.cursor.execute(sql, params)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/mysql/base.py”, line 71, in execute
return self.cursor.execute(query, args)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/MySQLdb/cursors.py”, line 209, in execute
res = self._query(query)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/MySQLdb/cursors.py”, line 315, in _query
db.query(q)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/MySQLdb/connections.py”, line 226, in query
_mysql.connection.query(self, query)
MySQLdb._exceptions.OperationalError: (1366, “Incorrect string value: ‘\xE2\x82\xAA)’)…’ for column ‘metaselect’ at row 1”)

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File “/var/lucterios2/virtual_for_lucterios/bin/lucterios_admin.py”, line 1056, in
main()
File “/var/lucterios2/virtual_for_lucterios/bin/lucterios_admin.py”, line 1015, in main
getattr(luct, args[0])()
File “/var/lucterios2/virtual_for_lucterios/bin/lucterios_admin.py”, line 334, in refreshall
luct.refresh()
File “/var/lucterios2/virtual_for_lucterios/bin/lucterios_admin.py”, line 753, in refresh
call_command(‘migrate’, stdout=sys.stdout)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/core/management/init.py”, line 148, in call_command
return command.execute(*args, **defaults)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/core/management/base.py”, line 364, in execute
output = self.handle(*args, **options)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/core/management/base.py”, line 83, in wrapped
res = handle_func(*args, **kwargs)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/core/management/commands/migrate.py”, line 257, in handle
self.verbosity, self.interactive, connection.alias, apps=post_migrate_apps, plan=plan,
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/core/management/sql.py”, line 51, in emit_post_migrate_signal
**kwargs
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/dispatch/dispatcher.py”, line 175, in send
for receiver in self._live_receivers(sender)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/dispatch/dispatcher.py”, line 175, in
for receiver in self._live_receivers(sender)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/CORE/models.py”, line 497, in post_after_migrate
Signal.call_signal(“checkparam”)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/framework/signal_and_lock.py”, line 67, in call_signal
if sign_fct(*args):
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/diacamma/accounting/models.py”, line 1584, in accounting_checkparam
value=‘EUR’, meta=get_meta_currency_iso())
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/CORE/models.py”, line 76, in check_and_create
param.save()
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/models/base.py”, line 741, in save
force_update=force_update, update_fields=update_fields)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/models/base.py”, line 779, in save_base
force_update, using, update_fields,
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/models/base.py”, line 851, in _save_table
forced_update)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/models/base.py”, line 900, in _do_update
return filtered._update(values) > 0
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/models/query.py”, line 760, in _update
return query.get_compiler(self.db).execute_sql(CURSOR)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/models/sql/compiler.py”, line 1429, in execute_sql
cursor = super().execute_sql(result_type)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/models/sql/compiler.py”, line 1100, in execute_sql
cursor.execute(sql, params)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/utils.py”, line 99, in execute
return super().execute(sql, params)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/utils.py”, line 67, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/utils.py”, line 76, in _execute_with_wrappers
return executor(sql, params, many, context)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/utils.py”, line 84, in _execute
return self.cursor.execute(sql, params)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/utils.py”, line 89, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/utils.py”, line 84, in _execute
return self.cursor.execute(sql, params)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/mysql/base.py”, line 71, in execute
return self.cursor.execute(query, args)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/MySQLdb/cursors.py”, line 209, in execute
res = self._query(query)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/MySQLdb/cursors.py”, line 315, in _query
db.query(q)
File “/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/MySQLdb/connections.py”, line 226, in query
_mysql.connection.query(self, query)
django.db.utils.OperationalError: (1366, “Incorrect string value: ‘\xE2\x82\xAA)’)…’ for column ‘metaselect’ at row 1”)

Merci d’avance de votre aide.

8

Bonjour,

Quelle version de MySQL utilisez vous ?
Visiblement, on est plus sur un souci de l’utilisation conjointe entre Django et MySQL.
Je vous invite également à chercher sur internet des problématiques similaire à ce problème.

9

Bonjour,

La version MSQL en place est 5.7.27

J’ai fait appel à la communanté Diacamma car je n’ai trouvé aucune information sur un probleme similaire.

10

Bonjour,

En cherchant rapidement sur Google avec “django python mysql Incorrect string value” je trouve des forums de développement qui évoque des souci avec l’UTF8 et l’encodage.
Vérifiez donc la configuration de votre MySQL sur le sujet.

11

Bonjour,

Mysql est déjà en UTF8

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 104
Server version: 5.7.27-0ubuntu0.19.04.1 (Ubuntu)

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> SHOW VARIABLES WHERE Variable_name LIKE ‘character_set_%’ OR Variable_name LIKE ‘collation%’;

±-------------------------±-------------------+
| Variable_name | Value |
±-------------------------±-------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| collation_connection | utf8mb4_unicode_ci |
| collation_database | utf8mb4_unicode_ci |
| collation_server | utf8mb4_unicode_ci |
±-------------------------±-------------------+
10 rows in set (0.01 sec)

12

Bonjour,

En essayant d’installer Diacamma sur un nouveau serveur, je rencontre la même erreur à la création de l’instance ou au lancement de la commande ‘python manage_copro.py migrate’ :

Operations to perform:
  Apply all migrations: CORE, accounting, admin, auth, condominium, contacts, contenttypes, documents, framework, mailing, payoff, sessions, syndic
Running migrations:
  No migrations to apply.
  Your models have changes that are not yet reflected in a migration, and so won't be applied.
  Run 'manage.py makemigrations' to make new migrations, and then re-run 'manage.py migrate' to apply them.
check parameters
Traceback (most recent call last):
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 71, in execute
    return self.cursor.execute(query, args)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/MySQLdb/cursors.py", line 209, in execute
    res = self._query(query)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/MySQLdb/cursors.py", line 315, in _query
    db.query(q)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/MySQLdb/connections.py", line 239, in query
    _mysql.connection.query(self, query)
MySQLdb._exceptions.OperationalError: (1366, "Incorrect string value: '\\xE2\\x82\\xAA)')...' for column 'metaselect' at row 1")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "manage_copro.py", line 8, in <module>
    execute_from_command_line(sys.argv)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/core/management/__init__.py", line 381, in execute_from_command_line
    utility.execute()
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/core/management/__init__.py", line 375, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/core/management/base.py", line 323, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/core/management/base.py", line 364, in execute
    output = self.handle(*args, **options)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/core/management/base.py", line 83, in wrapped
    res = handle_func(*args, **kwargs)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/core/management/commands/migrate.py", line 257, in handle
    self.verbosity, self.interactive, connection.alias, apps=post_migrate_apps, plan=plan,
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/core/management/sql.py", line 51, in emit_post_migrate_signal
    **kwargs
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/dispatch/dispatcher.py", line 175, in send
    for receiver in self._live_receivers(sender)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/dispatch/dispatcher.py", line 175, in <listcomp>
    for receiver in self._live_receivers(sender)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/lucterios/CORE/models.py", line 497, in post_after_migrate
    Signal.call_signal("checkparam")
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/lucterios/framework/signal_and_lock.py", line 67, in call_signal
    if sign_fct(*args):
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/diacamma/accounting/models.py", line 1758, in accounting_checkparam
    value='EUR', meta=get_meta_currency_iso())
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/lucterios/CORE/models.py", line 76, in check_and_create
    param.save()
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/models/base.py", line 741, in save
    force_update=force_update, update_fields=update_fields)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/models/base.py", line 779, in save_base
    force_update, using, update_fields,
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/models/base.py", line 851, in _save_table
    forced_update)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/models/base.py", line 900, in _do_update
    return filtered._update(values) > 0
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/models/query.py", line 760, in _update
    return query.get_compiler(self.db).execute_sql(CURSOR)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1462, in execute_sql
    cursor = super().execute_sql(result_type)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1133, in execute_sql
    cursor.execute(sql, params)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/backends/utils.py", line 99, in execute
    return super().execute(sql, params)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/backends/utils.py", line 67, in execute
    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/utils.py", line 89, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 71, in execute
    return self.cursor.execute(query, args)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/MySQLdb/cursors.py", line 209, in execute
    res = self._query(query)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/MySQLdb/cursors.py", line 315, in _query
    db.query(q)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/MySQLdb/connections.py", line 239, in query
    _mysql.connection.query(self, query)
django.db.utils.OperationalError: (1366, "Incorrect string value: '\\xE2\\x82\\xAA)')...' for column 'metaselect' at row 1")

Comme suggéré au début de l’erreur, je lance la commande ‘python manage_copro.py makemigrations’ :

You are trying to add a non-nullable field 'supporting_ptr' to callfundssupporting without a default; we can't do that (the database needs something to populate existing rows).
Please select a fix:
 1) Provide a one-off default now (will be set on all existing rows with a null value for this column)
 2) Quit, and let me add a default in models.py
Select an option: 1
Please enter the default value now, as valid Python
The datetime and django.utils.timezone modules are available, so you can do e.g. timezone.now
Type 'exit' to exit this prompt
>>> None
Migrations for 'framework':
  virtual_for_lucterios/lib/python3.6/site-packages/lucterios/framework/migrations/0003_auto_20200107_1240.py    - Alter field action on lucterioslogentry
    - Alter field timestamp on lucterioslogentry
Migrations for 'condominium':
  virtual_for_lucterios/lib/python3.6/site-packages/diacamma/condominium/migrations/0017_callfundssupporting_supporting_ptr.py
    - Add field supporting_ptr to callfundssupporting

La migration se passe bien, je relance donc la commande ‘python manage_copro.py migrate’ et la l’erreur est différente (plus de valeur incohérente mais un nom de colonne en double) :

Operations to perform:
  Apply all migrations: CORE, accounting, admin, auth, condominium, contacts, contenttypes, documents, framework, mailing, payoff, sessions, syndic
Running migrations:
  Applying condominium.0017_callfundssupporting_supporting_ptr...Traceback (most recent call last):
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 71, in execute
    return self.cursor.execute(query, args)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/MySQLdb/cursors.py", line 209, in execute
    res = self._query(query)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/MySQLdb/cursors.py", line 315, in _query
    db.query(q)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/MySQLdb/connections.py", line 239, in query
    _mysql.connection.query(self, query)
MySQLdb._exceptions.OperationalError: (1060, "Duplicate column name 'supporting_ptr_id'")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "manage_copro.py", line 8, in <module>
    execute_from_command_line(sys.argv)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/core/management/__init__.py", line 381, in execute_from_command_line
    utility.execute()
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/core/management/__init__.py", line 375, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/core/management/base.py", line 323, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/core/management/base.py", line 364, in execute
    output = self.handle(*args, **options)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/core/management/base.py", line 83, in wrapped
    res = handle_func(*args, **kwargs)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/core/management/commands/migrate.py", line 234, in handle
    fake_initial=fake_initial,
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/migrations/executor.py", line 117, in migrate
    state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/migrations/executor.py", line 147, in _migrate_all_forwards
    state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/migrations/executor.py", line 245, in apply_migration
    state = migration.apply(state, schema_editor)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/migrations/migration.py", line 124, in apply
    operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/migrations/operations/fields.py", line 112, in database_forwards
    field,
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/backends/mysql/schema.py", line 44, in add_field
    super().add_field(model, field)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/backends/base/schema.py", line 447, in add_field
    self.execute(sql, params)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/backends/base/schema.py", line 137, in execute
    cursor.execute(sql, params)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/backends/utils.py", line 99, in execute
    return super().execute(sql, params)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/backends/utils.py", line 67, in execute
    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/utils.py", line 89, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 71, in execute
    return self.cursor.execute(query, args)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/MySQLdb/cursors.py", line 209, in execute
    res = self._query(query)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/MySQLdb/cursors.py", line 315, in _query
    db.query(q)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/MySQLdb/connections.py", line 239, in query
    _mysql.connection.query(self, query)
django.db.utils.OperationalError: (1060, "Duplicate column name 'supporting_ptr_id'")

Je relance gunicorn et j’ai toujours l’avertissement ‘Parameter condominium-old-accounting unknown!’ à la connexion :

/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/django/views/generic/base.py in line 97 in dispatch : return handler(request, *args, **kwargs)
/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/lucterios/framework/xferbasic.py in line 312 in post : return self.get_post(request, *args, **kwargs)
/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/lucterios/framework/xferbasic.py in line 301 in get_post : self.fillresponse(**self._get_params())
/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/lucterios/CORE/views.py in line 81 in fillresponse : signal_and_lock.Signal.call_signal("summary", self)
/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/lucterios/framework/signal_and_lock.py in line 67 in call_signal : if sign_fct(*args):
/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/diacamma/condominium/views.py in line 542 in summary_condo : if Params.getvalue("condominium-old-accounting"):
/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/lucterios/CORE/parameters.py in line 246 in getvalue : return cls._get(name).value
/var/lucterios2/virtual_for_lucterios/lib/python3.6/site-packages/lucterios/CORE/parameters.py in line 237 in _get : raise LucteriosException(GRAVE, "Parameter %s unknown!" % name)

Merci pour votre aide.

Edit :
Lors de la mise à jour d’un autre serveur fonctionnel vers la dernière version de Diacamma, la même erreur apparaît lors de la mise à jour ou d’un ‘refreshall’.
Cependant, pas d’erreur à la connexion et toutes les données semblent être là et l’application fonctionnelle.

Operations to perform:
  Apply all migrations: CORE, accounting, admin, auth, condominium, contacts, contenttypes, documents, framework, mailing, payoff, sessions, syndic
Running migrations:
  No migrations to apply.
  Your models have changes that are not yet reflected in a migration, and so won't be applied.
  Run 'manage.py makemigrations' to make new migrations, and then re-run 'manage.py migrate' to apply them.
check parameters
Traceback (most recent call last):
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/mysql/base.py", line 71, in execute
    return self.cursor.execute(query, args)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/MySQLdb/cursors.py", line 209, in execute
    res = self._query(query)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/MySQLdb/cursors.py", line 315, in _query
    db.query(q)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/MySQLdb/connections.py", line 239, in query
    _mysql.connection.query(self, query)
MySQLdb._exceptions.OperationalError: (1366, "Incorrect string value: '\\xE2\\x82\\xAA)')...' for column 'metaselect' at row 1")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/var/lucterios2/virtual_for_lucterios/bin/lucterios_admin.py", line 1070, in <module>
    main()
  File "/var/lucterios2/virtual_for_lucterios/bin/lucterios_admin.py", line 1027, in main
    getattr(luct, args[0])()
  File "/var/lucterios2/virtual_for_lucterios/bin/lucterios_admin.py", line 333, in refreshall
    luct.refresh()
  File "/var/lucterios2/virtual_for_lucterios/bin/lucterios_admin.py", line 765, in refresh
    call_command('migrate', stdout=sys.stdout)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/core/management/__init__.py", line 148, in call_command
    return command.execute(*args, **defaults)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/core/management/base.py", line 364, in execute
    output = self.handle(*args, **options)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/core/management/base.py", line 83, in wrapped
    res = handle_func(*args, **kwargs)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/core/management/commands/migrate.py", line 257, in handle
    self.verbosity, self.interactive, connection.alias, apps=post_migrate_apps, plan=plan,
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/core/management/sql.py", line 51, in emit_post_migrate_signal
    **kwargs
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/dispatch/dispatcher.py", line 175, in send
    for receiver in self._live_receivers(sender)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/dispatch/dispatcher.py", line 175, in <listcomp>
    for receiver in self._live_receivers(sender)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/CORE/models.py", line 497, in post_after_migrate
    Signal.call_signal("checkparam")
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/framework/signal_and_lock.py", line 67, in call_signal
    if sign_fct(*args):
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/diacamma/accounting/models.py", line 1758, in accounting_checkparam
    value='EUR', meta=get_meta_currency_iso())
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/lucterios/CORE/models.py", line 76, in check_and_create
    param.save()
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/models/base.py", line 741, in save
    force_update=force_update, update_fields=update_fields)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/models/base.py", line 779, in save_base
    force_update, using, update_fields,
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/models/base.py", line 851, in _save_table
    forced_update)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/models/base.py", line 900, in _do_update
    return filtered._update(values) > 0
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/models/query.py", line 760, in _update
    return query.get_compiler(self.db).execute_sql(CURSOR)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/models/sql/compiler.py", line 1462, in execute_sql
    cursor = super().execute_sql(result_type)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/models/sql/compiler.py", line 1133, in execute_sql
    cursor.execute(sql, params)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/utils.py", line 99, in execute
    return super().execute(sql, params)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/utils.py", line 67, in execute
    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/utils.py", line 89, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/utils.py", line 84, in _execute
    return self.cursor.execute(sql, params)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/django/db/backends/mysql/base.py", line 71, in execute
    return self.cursor.execute(query, args)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/MySQLdb/cursors.py", line 209, in execute
    res = self._query(query)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/MySQLdb/cursors.py", line 315, in _query
    db.query(q)
  File "/var/lucterios2/virtual_for_lucterios/lib/python3.7/site-packages/MySQLdb/connections.py", line 239, in query
    _mysql.connection.query(self, query)
django.db.utils.OperationalError: (1366, "Incorrect string value: '\\xE2\\x82\\xAA)')...' for column 'metaselect' at row 1")
13

N’y aurait-il pas tout simplement un problème dans le code UTF-8 ?
Erreur : (1366, "Incorrect string value: ‘\xE2\x82\xAA)’)…’ => celui-ci ne correspond à rien, il semble y avoir une parenthèse de trop.

Table UTF-8 :
₪ = \xe2\x82\xaa

14

Bonsoir,

Je n’ai pas de solution à votre souci.
De plus, cela me semble plus un problème lié à MySQL qu’à Diacamma en lui-même.

15

Bonsoir,

Je pense avoir trouvé la solution.
Par défaut à la création d’une base de données dans MySQL l’encodage est en latin9.

Pour afficher l’encodage actuel de la DB :

SELECT default_character_set_name FROM information_schema.SCHEMATA S WHERE schema_name = "DBNAME";

La mienne était bien en latin9.

Je l’ai donc convertie en utf8mb4 afin de supporter tous les caractères Unicode en suivant ce tuto :
https://mathiasbynens.be/notes/mysql-utf8mb4

Le plus simple est de créer une base vierge et de la convertir directement puis de réinstaller une instance pour restaurer une sauvegarde.

J’ai eu une erreur à la fin de la création des tables dans la DB mais tout semble fonctionnel :

django.db.utils.OperationalError: (1139, "Got error 'empty (sub)expression' from regexp")

J’essaye de restaurer une sauvegarde plus tard et je posterai le résultat.

Edit :
J’ai essayé de restaurer ma sauvegarde mais j’obtiens la même erreur que ci-dessus et la restauration ne se fait pas.
Pourtant quand je me connecte à Diacamma, tout semble fonctionner, l’assistant se lance, toute les fonctionnalités sont accessibles et aucune erreur n’apparaît.

Une idée ?

16

Bonjour,

J’ai abandonné avec MySQL et je suis passé à PostgreSQL, je crois que c’est ce qu’il y a de mieux à faire, d’autant plus que Postgre est open source.
J’ai réinstallé une instance propre configurée avec Postgre et j’ai rétabli ma sauvegarde sans encombre, tout est parfaitement fonctionnel.

J’ai mis à jour le tuto avec l’installation de PostgreSQL, création d’une DB et utilisation avec Diacamma sur :
https://www.choukajohn.me/index.php/2018/08/03/installation-de-diacamma-sur-serveur-linux-ubuntu-debian/