Bienvenue, Invité
Nom d'utilisateur : Mot de passe : Se souvenir de moi
  • Page :
  • 1
  • 2
  • 3

SUJET :

PB avec divers erreurs sur nouvelle install il y a 3 ans 1 mois #3674

  • Sirhc195
  • Portrait de Sirhc195 Auteur du sujet
  • Hors Ligne
  • COM_KUNENA_SAMPLEDATA_RANK1
  • COM_KUNENA_SAMPLEDATA_RANK1
  • Messages : 5
  • Remerciements reçus 0
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 <module>
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 <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 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 <module>
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 <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 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.

S'il vous plaît Connexion ou Créer un compte à se joindre à la conversation.

PB avec divers erreurs sur nouvelle install il y a 3 ans 1 mois #3685

  • lag
  • Portrait de lag
  • Hors Ligne
  • COM_KUNENA_SAMPLEDATA_RANK_ADMIN
  • COM_KUNENA_SAMPLEDATA_RANK_ADMIN
  • Messages : 1914
  • Karma: 8
  • Remerciements reçus 463
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.

S'il vous plaît Connexion ou Créer un compte à se joindre à la conversation.

Laurent
Principale contributeur (Développeur) à Diacamma
Administrateur de Sleto partenaire officiel de Diacamma : support et hébergement en ligne.

PB avec divers erreurs sur nouvelle install il y a 3 ans 1 mois #3691

  • Sirhc195
  • Portrait de Sirhc195 Auteur du sujet
  • Hors Ligne
  • COM_KUNENA_SAMPLEDATA_RANK1
  • COM_KUNENA_SAMPLEDATA_RANK1
  • Messages : 5
  • Remerciements reçus 0
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.

S'il vous plaît Connexion ou Créer un compte à se joindre à la conversation.

PB avec divers erreurs sur nouvelle install il y a 3 ans 1 mois #3695

  • lag
  • Portrait de lag
  • Hors Ligne
  • COM_KUNENA_SAMPLEDATA_RANK_ADMIN
  • COM_KUNENA_SAMPLEDATA_RANK_ADMIN
  • Messages : 1914
  • Karma: 8
  • Remerciements reçus 463
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.

S'il vous plaît Connexion ou Créer un compte à se joindre à la conversation.

Laurent
Principale contributeur (Développeur) à Diacamma
Administrateur de Sleto partenaire officiel de Diacamma : support et hébergement en ligne.

PB avec divers erreurs sur nouvelle install il y a 3 ans 1 mois #3698

  • Sirhc195
  • Portrait de Sirhc195 Auteur du sujet
  • Hors Ligne
  • COM_KUNENA_SAMPLEDATA_RANK1
  • COM_KUNENA_SAMPLEDATA_RANK1
  • Messages : 5
  • Remerciements reçus 0
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)

S'il vous plaît Connexion ou Créer un compte à se joindre à la conversation.

Dernière édition: par Sirhc195.

PB avec divers erreurs sur nouvelle install il y a 2 ans 10 mois #3949

  • Choukajohn
  • Portrait de Choukajohn
  • Hors Ligne
  • COM_KUNENA_SAMPLEDATA_RANK2
  • COM_KUNENA_SAMPLEDATA_RANK2
  • Messages : 33
  • Remerciements reçus 5
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")

S'il vous plaît Connexion ou Créer un compte à se joindre à la conversation.

Dernière édition: par Choukajohn.
  • Page :
  • 1
  • 2
  • 3
Temps de génération de la page : 0.048 secondes
Propulsé par Kunena

Qui sommes nous?

Le sanglier du Libre

Association éditant le logiciel Diacamma
12 rue Marius Charles
38420 Domène
France

Partenaire

SLETO

Si vous rechercher du support ou une solution d'hébergement pour Diacamma, faite confiance à SLETO, notre partenaire officiel