Re: Strange Errors when Using MySQL DB

https://code.djangoproject.com/ticket/13906 might give some backgroud on this. tl;dr its django setting the default transaction the errors your seeing are mysql bugs, would it be possible to update to a newer version or at least the latest patch of 5.7? On Friday, August 20, 2021 at 12:05:20 P

Strange Errors when Using MySQL DB

I have a Django (v2.2.23) application connected to a MySQL (v5.7) database. Every now and then, for a few minutes at a time, all my DB queries start to fail with one of the following errors: "Unknown MySQL Error" (error code 2000), "InterfaceError", or "Malformed Packet" (error code 2027). The

RE: Django mysql db issue

Sent from Mail for Windows 10 From: Integr@te System Sent: Saturday, February 22, 2020 4:12 PM To: django-users@googlegroups.com Subject: Re: Django mysql db issue Hi Maturure, Plz look at limitation of char field and option in dj doc: https://docs.djangoproject.com/en/dev/ref/databases

Re: Django mysql db issue

Hi Maturure, Plz look at limitation of char field and option in dj doc: https://docs.djangoproject.com/en/dev/ref/databases/#character-fields On Sat, Feb 22, 2020, 14:52 Perceval Maturure wrote: > Dear all > > Is there anyone experiencing the below with python3.7 Django 2.2 > > django.db.uti

Django mysql db issue

Dear all Is there anyone experiencing the below with python3.7 Django 2.2 django.db.utils.OperationalError: (1074, "Column length too big for column 'url' (max = 16383); use BLOB or TEXT instead") -- You received this message because you are subscribed to the Google Groups "Django users" grou

Unable to fetch data from mysql DB without manually restarting the server

Hello all, I am trying to insert some data in a mysql DB on one tab then trying to fetch the upoaded data on another tab. I have to restart my server manually then I am able to fetch data . kindly help. -- You received this message because you are subscribed to the Google Groups "Django

Re: Unable to access mysql db and apply changes using "python manage.py migrate"

Thx a lot I will look into it n revert On Sat, 2 Feb 2019 at 10:33 AM, Carsten Fuchs wrote: > Am 02.02.19 um 11:10 schrieb Emmanuel klutse: > > yes im talking about using "python manage.py migrate" command to create > tables in the db(djangoproject) i have already created in mysql server > > `ma

Re: Unable to access mysql db and apply changes using "python manage.py migrate"

Am 02.02.19 um 11:10 schrieb Emmanuel klutse: > yes im talking about using "python manage.py migrate" command to create > tables in the db(djangoproject) i have already created in mysql server `manage.py migrate` is trying to access your MySQL database, but the database denies the access to the

Re: Unable to access mysql db and apply changes using "python manage.py migrate"

yes im talking about using "python manage.py migrate" command to create tables in the db(djangoproject) i have already created in mysql server On Saturday, February 2, 2019 at 2:09:53 AM UTC-8, Emmanuel klutse wrote: > > > > On Saturday, February 2, 2019 at 1:47:39 AM UTC-8, Carsten Fuchs wrote:

Re: Unable to access mysql db and apply changes using "python manage.py migrate"

On Saturday, February 2, 2019 at 1:47:39 AM UTC-8, Carsten Fuchs wrote: > > Am 02.02.19 um 10:33 schrieb Emmanuel klutse: > > [...] creat a db for me in mysql instead of sqlite and the error is > talking about authentication. > > these are the changes made in my djangoproject/settings file: >

Re: Unable to access mysql db and apply changes using "python manage.py migrate"

Am 02.02.19 um 10:33 schrieb Emmanuel klutse: > [...] creat a db for me in mysql instead of sqlite and the error is talking > about authentication. > these are the changes made in my djangoproject/settings file: > DATABASES = { >     'default': { >     'ENGINE': 'django.db.backends.mysql', Yo

Re: Unable to access mysql db and apply changes using "python manage.py migrate"

hello Carsten Fuchs, thanks for your feedback. yes, i agree. but what i dont understand is that the command used "python manage.py migrate" is to creat a db for me in mysql instead of sqlite and the error is talking about authentication. these are the changes made in my djangoproject/settings fil

Re: Unable to access mysql db and apply changes using "python manage.py migrate"

Hi Emmanuel, the error message is clear, isn't it? (1045, "Access denied for user 'root'@'localhost' (using password: YES)") Check your password. Use the mysql client to check. Best regards, Carsten Am 02.02.19 um 10:07 schrieb Emmanuel klutse: > hello team, > Can someone help me with the prob

Unable to access mysql db and apply changes using "python manage.py migrate"

hello team, Can someone help me with the problem below please. (py1) C:\djangoproject>python manage.py migrate Traceback (most recent call last): File "C:\Users\Success\Envs\py1\lib\site-packages\django\db\backends\base\base.py", line 216, in ensure_connection self.connect() File "C:\Us

Been having problems getting things running correctly on my Vps doing the blog tutorial. having problems loading mysql db

I'm following your tutorial here https://docs.djangoproject.com/en/2.0/intro/tutorial02/ I had to goto a different post to find out how to do the mysql and got stuck the other tutorial told me this is how you connect. my vps has the following db made since thats what the django polls tutorial to

bulk_create method works wrong for mysql db

I wrote a small test application for the company's list of employees. I wrote the custom migration to create the initial data and got problem with *python manage.py migrate* Traceback (most recent call last): File "/home/mykola/.virtualenvs/employees/lib/python3.5/site-packages/django/db/back

Re: I can't see my models in MySQL db

First check if Django is installed Try Python manage.py makemigrations ython manage.py migrate On Tue, 17 Jul 2018, 08:32 A. Azimzadeh, wrote: > Greetings! > > Dears, please help me. > > Thanks a lot > > On Sun, Jul 15, 2018, 21:09 A. Azimzadeh > wrote: > >> Any help !? >> >> >> On Sat, Jul

Re: I can't see my models in MySQL db

Greetings! Dears, please help me. Thanks a lot On Sun, Jul 15, 2018, 21:09 A. Azimzadeh wrote: > Any help !? > > > On Sat, Jul 14, 2018, 15:23 ali reza wrote: > >> Hi all, >> >> I attached my Django project as a ZIP file. >> please help me to find and fix the root cause of issue. >> Link: >>

Re: I can't see my models in MySQL db

Any help !? On Sat, Jul 14, 2018, 15:23 ali reza wrote: > Hi all, > > I attached my Django project as a ZIP file. > please help me to find and fix the root cause of issue. > Link: > https://ufile.io/ycmut > > Thanks in advance > > On Wednesday, 4 July 2018 17:50:49 UTC+4:30, ali reza wrote: >>

Re: I can't see my models in MySQL db

Hi all, I attached my Django project as a ZIP file. please help me to find and fix the root cause of issue. Link: https://ufile.io/ycmut Thanks in advance On Wednesday, 4 July 2018 17:50:49 UTC+4:30, ali reza wrote: > > Greetings! > > *Note:* > mysite is the name of project. > django_sb_admin a

Re: I can't see my models in MySQL db

Hi Azimzadeh, I’m also new in Django but I notice you referred to app as django-sb-admin and you added in settings as django_sb_admin Just want to point the mismatch in name, your app is with ‘-‘ whereas installed apps has ‘_’, issue could be this mismatch? As python itself is key sensitive R

Re: I can't see my models in MySQL db

Hi Julio, Thanks for reply to my question. I created models for django-sb-admin (As default, models.py of djangosbadmin is empty + there isn't the name of app in INSTALLED APPS +). *are you sure the INSTALLED_APPS shouldn't be simply 'django_sb_admin' instead of 'django_sb_admin.apps.DjangoS

Re: I can't see my models in MySQL db

Hi Azimzadeh, Just wondering, is django_db_admin this one https://github.com/bluszcz/django-sb-admin ? 'Cause that app doesn't have any models (it's empty https://github.com/bluszcz/django-sb-admin/blob/master/django_sb_admin/models.py), so it shouldn't create any tables. Also, are you sure the I

Re: I can't see my models in MySQL db

Hi again, Any help !?? Please help me to find and fix the root cause of problem. Thanks On Wed, Jul 4, 2018, 22:57 A. Azimzadeh wrote: > Polls app is empty. > > The problem is in django_sb_admin > > How i can find the root cause of problem and fix that? > > On Wed, Jul 4, 2018, 18:26 Jason wr

Re: I can't see my models in MySQL db

Polls app is empty. The problem is in django_sb_admin How i can find the root cause of problem and fix that? On Wed, Jul 4, 2018, 18:26 Jason wrote: > You told it to make migration for the app django_sb_admin, but that > apparently doesn't include polls. > > try making another migration withou

Re: I can't see my models in MySQL db

You told it to make migration for the app django_sb_admin, but that apparently doesn't include polls. try making another migration without the app name qualifier and running it. On Wednesday, July 4, 2018 at 9:20:49 AM UTC-4, ali reza wrote: > > Greetings! > > *Note:* > mysite is the name of

I can't see my models in MySQL db

Greetings! *Note:* mysite is the name of project. django_sb_admin and polls are my apps. python version: 3.6.6 I used *inspectdb* for creating *models.py* for *django_sb_admin* application. *pyhton3 manage.py inspectdb > models.py* # Here inspectdb worked fine. then is moved models.py into djang

Re: Unable to connect django to Mysql db

Please provide the steps to reproduce the issue, including the traceback. On Monday, February 6, 2017 at 7:24:49 AM UTC-5, Pooja Pawani wrote: > > I am getting error installing mysqlclient in virtual env. > django version - 1.10 > python - 3.4 > -- You received this message because you are subs

Unable to connect django to Mysql db

I am getting error installing mysqlclient in virtual env. django version - 1.10 python - 3.4 -- 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 django-users+unsubs

Re: Django with MySQL DB for multitenancy

You are right, you may do the routing with nginx but will you have many isntances of django this way. You are also right that you should need to create a database router yourself taking in account whatever is needed to decide which database to use. You could for example use the domain from the req

Re: Django with MySQL DB for multitenancy

Hi, I'm not the expert on that, but since no-one else is replying I'll throw my ideas anyway. One solution that does get rid of the docker containers but doesn't otherwise achieve very much is to continue routing from nginx. For one client nginx can be connecting to the :8001 backend, for another

Re: Django with MySQL DB for multitenancy

I basically want to get rid of all the docker containers for each client, and just have a single application with many client (as the tenant) and mysql databases for each tenant. Just like the way django_tenant_schemas is wor

Re: Django with MySQL DB for multitenancy

Hi, I don't understand what the problem is. You have a setup that works. What exactly do you want? You want to run many distinct instances of the application on the same server? And you want to get rid of docker? Antonis Christofides http://djangodeployment.com On 2016-12-09 17:13, Peter Edache

Django with MySQL DB for multitenancy

Hello guys, we are currently looking for a way to migrate our previous django application to a full multi-tenant application, currently the way we are handling our client is by giving each client a docker container and using nginx to do the routing, through sub-domain mapping. But after resea

Re: How do I create a simple user view web page to create/add mysql db entries?

ecommended: class Hardwareid(models.Model): hardwareid_text = models.CharField(max_length=200) pub_date = models.DateField('default=timezone.now) def __unicode__(self): return self.hardwareid_text and now it works! I can enter data to submit from that page and it ended up in my mysql

Re: How do I create a simple user view web page to create/add mysql db entries?

On Thursday, October 16, 2014 2:28:38 PM UTC-7, Collin Anderson wrote: > > Hi Bovine, > > Your pub_date field needs a value. Maybe try this: > > from django.utils import timezone > > class MyModel(models.Model): > pub_date = models.DateField(default=timezone.now) > > Collin > > Thanks Collin

Re: How do I create a simple user view web page to create/add mysql db entries?

Hi Bovine, Your pub_date field needs a value. Maybe try this: from django.utils import timezone class MyModel(models.Model): pub_date = models.DateField(default=timezone.now) Collin -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsu

Re: How do I create a simple user view web page to create/add mysql db entries?

Okay I figured that part out now by editing the correct URLS.py file as I was using the one in the app package as opposed to the root level sute url.py, When I go to submit the text info in the form now I receive the following error. IntegrityError at /get_barcode.html (1048, "Column 'pub_da

Re: How do I create a simple user view web page to create/add mysql db entries?

On Tuesday, October 7, 2014 6:42:39 PM UTC-7, Collin Anderson wrote: > > My bad. Put your add_view in views.py (cause it's a view :) > > Then, you'll need to import your form into your view: > from oneidentry.forms import HardwareidForm > > Thanks Collin I made the switch but now cannot access t

Re: How do I create a simple user view web page to create/add mysql db entries?

On Tuesday, October 7, 2014 5:20:26 PM UTC-4, Bovine Devine wrote: > > Thanks for the help Collin...I need to read through more of the > documentation it seems! Going through the chapter am I correct in > understanding that using ModelForm example you listed as a view does not > need to be add

Re: How do I create a simple user view web page to create/add mysql db entries?

My bad. Put your add_view in views.py (cause it's a view :) Then, you'll need to import your form into your view: from oneidentry.forms import HardwareidForm -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and sto

Re: How do I create a simple user view web page to create/add mysql db entries?

On Tuesday, October 7, 2014 4:49:04 PM UTC-7, Collin Anderson wrote: > > > Am I correct in understanding that using ModelForm example you listed as > a view does not need to be added to urls then? What is the user access page > then? > The add_view would need to be added to your urls. > > I add

Re: How do I create a simple user view web page to create/add mysql db entries?

> Am I correct in understanding that using ModelForm example you listed as a view does not need to be added to urls then? What is the user access page then? The add_view would need to be added to your urls. > So is this two different ways to do the same thing? The main difference is that it's a

Re: How do I create a simple user view web page to create/add mysql db entries?

Thanks for the help Collin...I need to read through more of the documentation it seems! Going through the chapter am I correct in understanding that using ModelForm example you listed as a view does not need to be added to urls then? What is the user access page then? Sorry this is all really s

Re: How do I create a simple user view web page to create/add mysql db entries?

Using a plan ModelForm in a few to create objects is surprisingly not well documented :) https://docs.djangoproject.com/en/1.7/topics/forms/modelforms/ Basically you do something like this: from django import forms class MyForm(forms.ModelForm): class Meta: model = MyModel f

How do I create a simple user view web page to create/add mysql db entries?

I have gone through the django tutorial but seem to be lost on how to create a simple user view page that allows me to add/post/create data directly to the connected mysql database. I have the models view working and can access and add items in admin view but not sure how/what is the best way o

Re: Mysql DB local socket access errors with mod_wsgi

On Wed, May 28, 2014 at 3:18 PM, wrote: > It's very likely a permissions problem. Webserver processes tend to run under > a special username (e.g. www-data) with very limited permissions - it's > likely that this user does not have access to the socket file. Yeah, that was the thing, thanks!

Re: Mysql DB local socket access errors with mod_wsgi

er: django-users@googlegroups.com Date: Wed, 28 May 2014 11:28:00 To: Reply-To: django-users@googlegroups.com Subject: Mysql DB local socket access errors with mod_wsgi Hi, I'm trying to setup a django production environment with mod_wsgi, and a local mysql which I want to connect via

Mysql DB local socket access errors with mod_wsgi

Hi, I'm trying to setup a django production environment with mod_wsgi, and a local mysql which I want to connect via the socket file. Without wsgi the app runs and connects to the database. When running it via wsgi, I get: OperationalError (2002, "Can't connect to local MySQL server through s

MYSQL DB

{% for d in datas %} Games Best Player :{{ d }} {% endfor %} I am taking d for displaying the value of the table but it showing the all the column values in single statement how to get sepa

Re: Newbie question - if I add "on delete cascade" to a foreign key on my MySQL db

Many thanks Jacob! On Dec 13, 8:57 pm, Jacob Kaplan-Moss wrote: > On Tue, Dec 13, 2011 at 7:22 PM, Mike wrote: > > will I still be able to use Django's ORM? > > Yes, please > seehttps://docs.djangoproject.com/en/dev/ref/models/fields/#django.db.mo... > and in particular DO_NOTHING. > > Jacob -

Re: Newbie question - if I add "on delete cascade" to a foreign key on my MySQL db

On Tue, Dec 13, 2011 at 7:22 PM, Mike wrote: > will I still be able to use Django's ORM? Yes, please see https://docs.djangoproject.com/en/dev/ref/models/fields/#django.db.models.ForeignKey.on_delete and in particular DO_NOTHING. Jacob -- You received this message because you are subscribed to

Newbie question - if I add "on delete cascade" to a foreign key on my MySQL db

will I still be able to use Django's ORM? TIA -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegrou