Error: Not able to create table using models (Backend mysql)

2018-08-28 Thread Sonali Vighne
I am getting this error 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

Re: Error: Not able to create table using models (Backend mysql)

2018-08-28 Thread Jason
sounds like you have some bad syntax in your models. can't diagnose any further without the code. For future reference, when you ask for help, try to give all relevant information in your question. All you give here is the error, but nothing about the code that produces it, (the models). --

Re: Error: Not able to create table using models (Backend mysql)

2018-08-28 Thread Mohammad Aqib
make sure you have installed correct Django and MySQLclient versions. If not try to change the versions. or give permissions to user grant usage on schema public to username;grant create on schema public to username; On Tue, Aug 28, 2018 at 1:20 PM Sonali Vighne wrote: > > I am getting this e

Re: Error: Not able to create table using models (Backend mysql)

2018-08-28 Thread Sonali Vighne
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\Ap

Re: Error: Not able to create table using models (Backend mysql)

2018-08-28 Thread Mohammad Aqib
Set mysql password. Without password how you can access mysql. See DATABASES = { *'default'*: { *'ENGINE'*: *'django.db.backends.mysql'*, *'NAME'*: *'hospital'*, *'USER'*: *'root'*, *'PASSWORD'*: *'password'*, *'HOST'*: *'localhost'*, *'

Re: Error: Not able to create table using models (Backend mysql)

2018-08-28 Thread Sonali Vighne
I have not set password to My MySQL server during installation On Tuesday, August 28, 2018 at 5:42:30 PM UTC+5:30, Mohammad Aqib wrote: > > Set mysql password. > > Without password how you can access mysql. > > See > > DATABASES = { > > *'default'*: { > > *'ENGINE'*: *'django.db.backen

Re: Error: Not able to create table using models (Backend mysql)

2018-08-28 Thread Mohammad Aqib
This password doesn't belong to mysql. This belongs to your database 'hospital'. On Wed, Aug 29, 2018 at 10:07 AM Sonali Vighne wrote: > I have not set password to My MySQL server during installation > > On Tuesday, August 28, 2018 at 5:42:30 PM UTC+5:30, Mohammad Aqib wrote: >> >> Set mysql pas

Re: Error: Not able to create table using models (Backend mysql)

2018-08-28 Thread Sonali Vighne
thank Mohammad :) I will try it. hope so it would solve my issue. On Wednesday, August 29, 2018 at 10:32:32 AM UTC+5:30, Mohammad Aqib wrote: > > This password doesn't belong to mysql. This belongs to your database > 'hospital'. > > On Wed, Aug 29, 2018 at 10:07 AM Sonali Vighne > wrote: > >> I

Re: Error: Not able to create table using models (Backend mysql)

2020-01-26 Thread Drashti_ Learning_ins
On Tuesday, August 28, 2018 at 1:20:16 PM UTC+5:30, Sonali Vighne wrote: > > > I am getting this error > > raise MigrationSchemaMissing("Unable to create the django_migrations table > (%s)" % exc) > django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create > the django_migrations

Re: Error: Not able to create table using models (Backend mysql)

2019-09-03 Thread johnsi rani
i nstalled django2 and mysql 5.0 > I am getting this error while i give python manage.py migrate > > raise MigrationSchemaMissing("Unable to create the django_migrations table > (%s)" % exc) > django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create > the django_migrations table

Re: Error: Not able to create table using models (Backend mysql)

2019-09-03 Thread Simon Charette
Django 2.0 only supports MySQL 5.5+. I suspect you're getting a syntax error when Django tries to create a table mapping a model with a DateTimeField since it resolves to DATETIME(6) which is not supported on MySQL < 5.5. Cheers, Simon Le mardi 3 septembre 2019 09:58:19 UTC-4, johnsi rani a éc

Re: Error: Not able to create table using models (Backend mysql)

2019-09-03 Thread Gabriel Araya Garcia
I believe that Simon says. Get out the date and time fields and see what appen. After you can add the date and time fields directly on DB and put them in your models and forms also luck El mar., 3 sept. 2019 a las 9:57, johnsi rani () escribió: > > > i nstalled django2 and mysql 5.0 >> I am gett