Ensure you are using MySQL 5.6 or higher: https://docs.djangoproject.com/en/2.1/ref/databases/#version-support
To find your version run SELECT VERSION(); On 30 August 2018 at 05:37:52, Sonali Vighne ([email protected]) wrote: MySQL version - 6.0.8-alpha-community On Wednesday, August 29, 2018 at 7:26:09 PM UTC+5:30, Tom Forbes wrote: > > 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 _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) >> >> django.db.utils.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") >> >> >> >> During handling of the above exception, another exception occurred: >> >> >> >> Traceback (most recent call last): >> >> *File "D:\EclipsePython\DjangoMysql\manage.py", line 15, in <module>* >> >> execute_from_command_line(sys.argv) >> >> *File >> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\core\management\__init__.py", >> line 381, in execute_from_command_line* >> >> utility.execute() >> >> *File >> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\core\management\__init__.py", >> line 375, in execute* >> >> self.fetch_command(subcommand).run_from_argv(self.argv) >> >> *File >> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\core\management\base.py", >> line 316, in run_from_argv* >> >> self.execute(*args, **cmd_options) >> >> *File >> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\core\management\base.py", >> line 353, in execute* >> >> output = self.handle(*args, **options) >> >> *File >> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\core\management\base.py", >> line 83, in wrapped* >> >> res = handle_func(*args, **kwargs) >> >> *File >> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\core\management\commands\migrate.py", >> line 203, in handle* >> >> fake_initial=fake_initial, >> >> *File >> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\migrations\executor.py", >> line 91, in migrate* >> >> self.recorder.ensure_schema() >> >> *File >> "C:\Users\sonali_vighne\AppData\Local\Programs\Python\Python36\lib\site-packages\django\db\migrations\recorder.py", >> line 57, in ensure_schema* >> >> raise MigrationSchemaMissing("Unable to create the django_migrations >> table (%s)" % exc) >> >> django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create >> the django_migrations table ((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")) >> >> Finished "*D:\EclipsePython\DjangoMysql\manage.py*migrate" execution. >> >> >> >> >> >> >> >> >> >> >> >> Setting.py >> >> >> >> >> >> INSTALLED_APPS = [ >> >> *'django.contrib.admin'*, >> >> *'django.contrib.auth'*, >> >> *'django.contrib.contenttypes'*, >> >> *'django.contrib.sessions'*, >> >> *'django.contrib.messages'*, >> >> *'django.contrib.staticfiles'*, >> >> *'mysqlApp' #this is app created* >> >> ] >> >> >> >> >> >> DATABASES = { >> >> *'default'*: { >> >> *'ENGINE'*: *'django.db.backends.mysql'*, >> >> *'NAME'*: *'hospital'*, >> >> *'USER'*: *'root'*, >> >> *'PASSWORD'*: *''*, >> >> *'HOST'*: *'localhost'*, >> >> *'PORT'*: *'3306'* >> >> } >> >> } >> >> >> >> >> >> >> >> On Monday, August 27, 2018 at 5:38:28 PM UTC+5:30, Sonali Vighne wrote: >>> >>> Hi, >>> >>> I have tried a lot to change Django back-end as MySQL but not able to >>> achieve this. >>> >>> please help for the same. >>> >>> >>> >>> thanks in advance. :) >>> >> -- You received this message because you are subscribed to a topic in the Google Groups "Django users" group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/django-users/iuspogePH3k/unsubscribe. To unsubscribe from this group and all its topics, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/1c3e465c-ee14-4113-bbc3-accd2e935b39%40googlegroups.com <https://groups.google.com/d/msgid/django-users/1c3e465c-ee14-4113-bbc3-accd2e935b39%40googlegroups.com?utm_medium=email&utm_source=footer> . For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAFNZOJNkAhZ4qreY8-VyJbfBsZ_-TZ5tGjfeOSEsUGWTRT7SCQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
