Bienvenue,
Invité
|
SUJET :
PB avec divers erreurs sur nouvelle install il y a 5 ans 2 mois #3674
|
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 5 ans 2 mois #3685
|
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 5 ans 2 mois #3691
|
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 5 ans 2 mois #3695
|
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 5 ans 1 mois #3698
|
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 4 ans 11 mois #3949
|
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.
|
Temps de génération de la page : 0.158 secondes