Ok bro...I'll try and let you know... On Fri, 12 Jul 2019, 15:26 'Amitesh Sahay' via Django users, < [email protected]> wrote:
> Try to use 'UTF-8' instead of 'utf8mb4' and see if that works. > > Regards, > Amitesh Sahay > > > On Friday, 12 July, 2019, 07:56:33 am IST, Jorge Gimeno < > [email protected]> wrote: > > > > On Thu, Jul 11, 2019 at 6:55 PM john samuel <[email protected]> > wrote: > > Hi shreeram, > > But the fact is that i have changed the port number in xampp server for > mySQL as 3307. > > On Thu, Jul 11, 2019 at 9:19 PM SHREERAM KULKARNI < > [email protected]> wrote: > > DATABASES = { > 'default': { > 'ENGINE': 'django.db.backends.mysql', > 'NAME': 'DB_NAME', > 'USER': 'DB_USER', > 'PASSWORD': 'DB_PASSWORD', > 'HOST': 'localhost', # Or an IP Address that your DB is hosted on > 'PORT': '3306', > }} > > > On Fri, 12 Jul 2019, 1:45 am john samuel, <[email protected]> > wrote: > > Hi Guys, > I've done everything from installing sql,setting up of root and password > till xampp server installation and setting the port number correctly with > right installation of sqlclient and editing Database in setting as > > DATABASES = { > 'default': { > 'ENGINE': 'django.db.backends.mysql', > 'NAME': 'Listo', > 'USER':'root', > 'PASSWORD':'', > 'HOST':'localhost', > 'PORT':'3307', > 'OPTIONS':{ > 'init_command':"SET sql_mode='STRICT_TRANS_TABLES'", > 'charset':'utf8mb4', > }, > 'TEST': { > 'CHARSET':'utf8mb4', > 'COLLATION':'utf8mb4_unicode_ci', > } > } > } > > > But i am still getting an error...kindly help me... > Traceback (most recent call last): > File "manage.py", line 21, in <module> > main() > File "manage.py", line 17, in main > execute_from_command_line(sys.argv) > File > "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\__init__.py", > line 381, in execute_from_command_line > utility.execute() > File > "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\__init__.py", > line 357, in execute > django.setup() > File > "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\__init__.py", > line 16, in setup > from django.urls import set_script_prefix > File > "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\urls\__init__.py", > line 1, in <module> > from .base import ( > File > "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\urls\base.py", > line 8, in <module> > from .exceptions import NoReverseMatch, Resolver404 > File > "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\urls\exceptions.py", > line 1, in <module> > from django.http import Http404 > File > "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\http\__init__.py", > line 5, in <module> > from django.http.response import ( > File > "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\http\response.py", > line 15, in <module> > from django.core.serializers.json import DjangoJSONEncoder > File > "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\serializers\__init__.py", > line 23, in <module> > from django.core.serializers.base import SerializerDoesNotExist > File > "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\serializers\base.py", > line 7, in <module> > from django.db import models > File > "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\__init__.py", > line 3, in <module> > from django.db.models.aggregates import * # NOQA > File > "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\aggregates.py", > line 5, in <module> > from django.db.models.expressions import Case, Func, Star, When > File > "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\expressions.py", > line 8, in <module> > from django.db.models import fields > File > "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\fields\__init__.py", > line 11, in <module> > from django import forms > File > "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\forms\__init__.py", > line 6, in <module> > from django.forms.boundfield import * # NOQA > File > "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\forms\boundfield.py", > line 3, in <module> > from django.forms.utils import flatatt, pretty_name > File > "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\forms\utils.py", > line 6, in <module> > from django.utils import timezone > File > "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\utils\timezone.py", > line 11, in <module> > import pytz > ValueError: source code string cannot contain null bytes > > -- > 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/68059107-83c1-4dc8-accd-68ff69145312%40googlegroups.com > <https://groups.google.com/d/msgid/django-users/68059107-83c1-4dc8-accd-68ff69145312%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/CAP-kQennpm5m_Yq2ChVNvps7tY1eF5_9bpi3gwLk5bV4k1QHJg%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CAP-kQennpm5m_Yq2ChVNvps7tY1eF5_9bpi3gwLk5bV4k1QHJg%40mail.gmail.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/CAE45hvOwwXt2YDb652kn4aeNcBa4yG-0Om9tGfb-6N%3DT9Ru3cg%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CAE45hvOwwXt2YDb652kn4aeNcBa4yG-0Om9tGfb-6N%3DT9Ru3cg%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > > > Are you using VS Code by chance? > > -Jorge > > > -- > 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/CANfN%3DK-7%2BKSs16F5xitLd-qe5KLRZ2_RL6QeYvMFp4H0RgMQPw%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CANfN%3DK-7%2BKSs16F5xitLd-qe5KLRZ2_RL6QeYvMFp4H0RgMQPw%40mail.gmail.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/2036646095.341506.1562925353823%40mail.yahoo.com > <https://groups.google.com/d/msgid/django-users/2036646095.341506.1562925353823%40mail.yahoo.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/CAE45hvNnTH3Pt8WnOBDh4NPGN%3D94cs%3DV9gxxCbYpSqYmbDbHfg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
