Syntax error in Django Mysql Migration running on Mac


~/devel/project/project$ poetry run python migrate
Operations to perform:
  Apply all migrations: account, admin, alerts, auth, business, chat, contact, contenttypes, critique, curriculum, django_cron, djstripe, gear, guardian, hosted_media, jobs, news, newsletter, promo, registration, robots, seminars, sessions, sites, socialaccount, taggit, thumbnail, users
Running migrations:
  Applying djstripe.0008_auto_20150806_1641_squashed_0031_auto_20170606_1708...Traceback (most recent call last):
  File "/Users/martincho/Library/Caches/pypoetry/virtualenvs/project-FB7eKST1-py3.9/lib/python3.9/site-packages/django/db/backends/", line 82, in _execute
    return self.cursor.execute(sql)
  File "/Users/martincho/Library/Caches/pypoetry/virtualenvs/project-FB7eKST1-py3.9/lib/python3.9/site-packages/django/db/backends/mysql/", line 71, in execute
    return self.cursor.execute(query, args)
  File "/Users/martincho/Library/Caches/pypoetry/virtualenvs/project-FB7eKST1-py3.9/lib/python3.9/site-packages/MySQLdb/", line 206, in execute
    res = self._query(query)
  File "/Users/martincho/Library/Caches/pypoetry/virtualenvs/project-FB7eKST1-py3.9/lib/python3.9/site-packages/MySQLdb/", line 319, in _query
  File "/Users/martincho/Library/Caches/pypoetry/virtualenvs/project-FB7eKST1-py3.9/lib/python3.9/site-packages/MySQLdb/", line 254, in query
    _mysql.connection.query(self, query)
MySQLdb.ProgrammingError: (1064, 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'"djstripe_invoice" SET "attempts" = 0 WHERE "attempts" IS NULL\' at line 1')

This is a djstripe migration which I can't modify.


~/devel/project/project$ poetry show django
 name         : django                                                                                           
 version      : 2.2.28                                                                                           
 description  : A high-level Python Web framework that encourages rapid development and clean, pragmatic design.
~/devel/project/project$ poetry show dj-stripe
 name         : dj-stripe                 
 version      : 1.1.1                     
 description  : Django + Stripe Made Easy
~/devel/project/project$ poetry show mysqlclient
 name         : mysqlclient               
 version      : 2.1.1                     
 description  : Python interface to MySQL 

MySQL version is 5.7.

It seems there is a conflict with the ORM and MySQL. I haven't been able to find another connector.

Back to Top