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 pytzValueError: 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.
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.
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.
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.
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.
For more options, visit https://groups.google.com/d/optout.
