What version of MySQL are you running?
On Tuesday, 28 August 2018 07:00:52 UTC+1, Sonali Vighne wrote:
>
> I will paste full error and stack trace here.
>
> This is occurred when I am giving “python manage.py migrate” command
>
>
>
> Operations to perform:
>
> Apply all migrations: admin, auth, contenttypes, sessions
>
> Running migrations:
>
> Traceback (most recent call last):
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\backends\utils.py",
>
> line 83, in _execute*
>
> return self.cursor.execute(sql)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\backends\mysql\base.py",
>
> line 71, in execute*
>
> return self.cursor.execute(query, args)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\cursors.py",
>
> line 250, in execute*
>
> self.errorhandler(self, exc, value)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\connections.py",
>
> line 50, in defaulterrorhandler*
>
> raise errorvalue
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\cursors.py",
>
> line 247, in execute*
>
> res = self._query(query)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\cursors.py",
>
> line 411, in _query*
>
> rowcount = self._do_query(q)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\cursors.py",
>
> line 374, in _do_query*
>
> db.query(q)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\connections.py",
>
> line 277, in query*
>
> _mysql.connection.query(self, query)
>
> _mysql_exceptions.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 '(6) NOT NULL)' at line 1")
>
>
>
> The above exception was the direct cause of the following exception:
>
>
>
> Traceback (most recent call last):
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\migrations\recorder.py",
>
> line 55, in ensure_schema*
>
> editor.create_model(self.Migration)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\backends\base\schema.py",
>
> line 312, in create_model*
>
> self.execute(sql, params or None)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\backends\base\schema.py",
>
> line 133, in execute*
>
> cursor.execute(sql, params)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\backends\utils.py",
>
> line 100, in execute*
>
> return super().execute(sql, params)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\backends\utils.py",
>
> line 68, in execute*
>
> return self._execute_with_wrappers(sql, params, many=False,
> executor=self._execute)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\backends\utils.py",
>
> line 77, in _execute_with_wrappers*
>
> return executor(sql, params, many, context)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\backends\utils.py",
>
> line 85, in _execute*
>
> return self.cursor.execute(sql, params)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\utils.py",
>
> line 89, in __exit__*
>
> raise dj_exc_value.with_traceback(traceback) from exc_value
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\backends\utils.py",
>
> line 83, in _execute*
>
> return self.cursor.execute(sql)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\backends\mysql\base.py",
>
> line 71, in execute*
>
> return self.cursor.execute(query, args)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\cursors.py",
>
> line 250, in execute*
>
> self.errorhandler(self, exc, value)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\connections.py",
>
> line 50, in defaulterrorhandler*
>
> raise errorvalue
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\cursors.py",
>
> line 247, in execute*
>
> res = self._query(query)
>
> *File
> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\MySQLdb\cursors.py",
>
> line 411, in
