Re: django -mysql

U have try pip install MySql Mahendra Yadav On Tue, 2 Feb 2021, 06:53 Juan Quiroz, wrote: > Trato de usar el pip3 install mysqlclient y me genera este error. > > ERROR: Command errored out with exit status 1: python setup.py egg_info > Check the logs for full command output. > > -- > You receiv

Re: Django Mysql Bulk_Create Ids

Hi do you hire contract based python/django freelancer? We can help you in this and related techincal tasks at fair prices. Reply or send email to divy...@pythonmate.com Best Regards, Divyesh Khamele, Pythonmate On Mon, 28 Sep 2020, 4:44 am Rohan Nahata, wrote: > How can we make this happen? > W

Re: Django Mysql Bulk_Create Ids

Unfortunately MySQL doesn't support an equivalent of the RETURNING clause on PostgreSQL/Oracle. In other words MySQL only allows to retrieve an inserted row auto id one at a time through its non-standard LAST_INSERT_ID function. That prevents any attempts at inserting multiple rows and retrievi

Re: Django MySQL database backup and restore to new server

Thanks a lot! Solved my django.db.utils.IntegrityError: Problem installing fixture ... duplicate key value violates unique constraint problem :) W dniu wtorek, 5 maja 2020 18:24:12 UTC+2 użytkownik marc bellazzini napisał: > > SOLVED > > # after more extensive googling . > > ORIGINAL SE

Re: Django MySQL database backup and restore to new server

SOLVED # after more extensive googling . ORIGINAL SERVER - cd to your web project directory - python manage.py dumpdata > db.json NEW SERVER - sftp db.json file to new server web project directory - python manage.py migrate - python manage.py shell -- >> from django.contrib.contenttypes.mode

Re: Django MySQL database backup and restore to new server

SOLVED # after more extensive googling I found a solution myself. I hope this helps someone else ORIGINAL SERVER - cd to your web project directory - python manage.py dumpdata > db.json - python manage.py migrate - python manage.py shell -- >> from django.contrib.contenttypes.models import

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

Re: DJANGO, MySQL, NGINX stack for a production hosting server in Digital Ocean droplet

Hi, Thank you both of you. Should I assume that both documents would let me configure a production server for a highly dynamic web site? Cheers ~Ram On Tue, Nov 5, 2019 at 6:34 AM lemme smash wrote: > i'm recommend you to consider docker setup like > https://docs.docker.com/machine/examples/ocea

Re: DJANGO, MySQL, NGINX stack for a production hosting server in Digital Ocean droplet

i'm recommend you to consider docker setup like https://docs.docker.com/machine/examples/ocean/ https://testdriven.io/blog/dockerizing-django-with-postgres-gunicorn-and-nginx/#nginx On Tuesday, November 5, 2019 at 1:27:55 AM UTC+3, Ram wrote: > > Hi, > Please let me know if anyone has setup this s

Re: DJANGO, MySQL, NGINX stack for a production hosting server in Digital Ocean droplet

this tuto is the same only replace postgresql to mysql https://www.digitalocean.com/community/tutorials/how-to-set-up-django-with-postgres-nginx-and-gunicorn-on-ubuntu-16-04 in the doc django read https://docs.djangoproject.com/en/2.2/ref/databases/#mysql-notes On Mon, Nov 4, 2019 at 4:27 PM Ram

Re: Django Mysql Error : Unknown system variable 'innodb_strict_mode

you shouldn't need to set the storage engine to innodb https://docs.djangoproject.com/en/2.1/ref/databases/#storage-engines MySQL’s default storage engine is InnoDB . This engine is fully transactional and supports foreign key refe

Re: Django MySql weirdness

https://github.com/django/django/tree/master/django/contrib/admin/migrations The migrations are in here - the code that is failing in 0002_logentry_remove_auto_add.py is operations = [ migrations.AlterField( model_name='logentry', name='action_time', field=models.DateTimeField( verbose_name='

Re: Django MySql weirdness

Hi Steve, Can you please provide code snippet here for 'action_time' field? Regards, On Mon, Jul 25, 2016 at 9:11 PM, Steve Bischoff wrote: > > > http://stackoverflow.com/questions/38534734/django-42000-invalid-default-value-for-action-time > > I have been trying to figure this one out for a b

Re: django + Mysql connector

Check this thread: https://groups.google.com/forum/#!topic/django-users/cb_IGZXVuVQ François On Jul 21, 2014, at 4:23 PM, Henrique Oliveira wrote: > Hi there, > > I am getting this error after hours: > > File "/opt/d/lib/python3.4/site-packages/django/contrib/sites/models.py", > l

Re: Django mysql over ssl (2026, 'SSL connection error: Failed to set ciphers to use')

On Thu, Oct 31, 2013 at 9:25 AM, wrote: > Hi, > > Summary: > I'm getting this error "(2026, 'SSL connection error: Failed to set > ciphers to use')", on the django error page and I don't know what i > happening!!! > > > I'm using apache / wsgi and my aplication it's on a virtualenv. > > The m

Re: DJango MySQL database connection problem

On Thu, May 9, 2013 at 4:33 PM, wrote: > yum install MySQL-python > Loaded plugins: fastestmirror, kmod > Loading mirror speeds from cached hostfile > * base: mirror.hmc.edu > * extras: mirror.sanctuaryhost.com > * rpmforge: mirror.hmc.edu > * updates: mirror.veracruz.co > Setting up Install

Re: Django-Mysql

Thanks to everyone that replied. I got an friend that knows more about these stuff and he fixed it. Not sure how -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe f

RE: Django-Mysql

# Set to empty string for default. Not used with sqlite3. } } I did create the database manually; no big deal. -Original Message- From: django-users@googlegroups.com [mailto:django-us...@googlegroups.com] On Behalf Of euan.godd...@googlemail.com Sent: Tuesday, June 22,

Re: Django-Mysql

Do you absolutely need to use MySQL? I've found for development that sqlite is the most hassle-free. I use OS X for development at home and it is the easiest option. The only drawback is that if you have multiple clients accessing the DB you can get locking issues. If it's just you, then you're sor

Re: Django/MySQL trailing spaces bug?

Thanks Karen, Tom, I thought I understood collations and rechecking the MySQL docs I think that is still the case. I'm more than happy with __exact using the DB collation even when it is case insensitive. What I certainly didn't grasp until now was the SQL standard's (SQL-92, specifically) compar

Re: Django/MySQL trailing spaces bug?

On Tue, Jun 8, 2010 at 10:00 AM, Tom Evans wrote: > This may have other unintended side effects, certainly it will make > the match case sensitive, I'm not sure if __exact is supposed to be > case sensitive. > Yes, it will have side-effects, bad enough that it's not worth doing. It was once done

Re: Django/MySQL trailing spaces bug?

On Tue, Jun 8, 2010 at 2:34 PM, steven314 wrote: > Thanks Dimitry, > >> If you want space to take part in comparison, use char fields instead of >> varchar. See:http://dev.mysql.com/doc/refman/5.0/en/char.html > > The below quote from the reference link you sent would seem to > indicate that trail

Re: Django/MySQL trailing spaces bug?

Thanks Dimitry, > If you want space to take part in comparison, use char fields instead of > varchar. See:http://dev.mysql.com/doc/refman/5.0/en/char.html The below quote from the reference link you sent would seem to indicate that trailing spaces *do not* take part in the comparison in char fiel

Re: Django/MySQL trailing spaces bug?

Hi! Steven Davidson wrote: > I understand that the /exact/ operator is relying on the (case > insensitive by default) MySQL DB collation and I'm happy with this. It > also seems to be relying on the DB's comparison engine (which IMHO > appears broken in MySQL). I would say the behaviour of > /iexa

Re: Django, MySQL, unicode

I have recently faced the same thing while developing a Django app that processes emails too. But I found a quick fix, unicode() accepts argument, that tells it what to do when it stumbles upon non-valid character: email.mail_from = unicode(email['From'], errors = 'ignore') Possible values for "

Re: Django, MySQL, unicode

On Mon, Sep 7, 2009 at 5:03 AM, Tracy Reed wrote: > I have a Django app which processes emails. It is often handed emails > with unicode characters in them. My understanding is that Python and > Django handle unicode just fine and somewhat transparently. I was, > however, told that I need to set

Re: Django, MySQL, unicode

Hi Tracy, less than two months ago, we were trying to use MySQL in our Django project (because we were not successful with installation of PostgreSQL adapter for Python psycopg2 on Mac OS X). We had similar problems as you have, and ugly, but only found, solution was to add encode (or decode? I

Re: Django, MySQL, unicode

On Mon, Sep 07, 2009 at 02:33:44AM -0700, ray spake thusly: > We were constantly getting decoding errors so we now use BeautifulSoup > to tidy the xml up before any processing. Wish I could implement a solution like that but I am just pulling times out of emails, not processing (X)HTML. I am amaze

Re: Django, MySQL, unicode

Hi there We have a app that processes xml from a third party web service. We were constantly getting decoding errors so we now use BeautifulSoup to tidy the xml up before any processing. best wishes Ray On 7 Sep, 10:03, Tracy Reed wrote: > I have a Django app which processes emails. It is of

Re: Django, MySQL - bug?

I tried this: import MySQLdb db = MySQLdb.connect(...) c = db.cursor() c.execute("create table mtest (pk int not null auto_increment primary key, s varchar(5)) type=InnoDB") print c.execute("insert into mtest values (null,'12345')") print c.messages print c.lastrowid print c.execute("insert int

Re: Django, MySQL - bug?

On 19 Lip, 18:32, Alex Gaynor wrote: > 2009/7/19 Tomasz Zieliński : > > > > > > > On 19 Lip, 16:29, Joshua Russo wrote: > >> 2009/7/19 Tomasz Zieliński > > >> > So, should m.save() set m.id to some other value than None > >> > or this is relaxed when Warning exception is thrown? > > >> It's the

Re: Django, MySQL - bug?

2009/7/19 Tomasz Zieliński : > > > > On 19 Lip, 16:29, Joshua Russo wrote: >> 2009/7/19 Tomasz Zieliński >> >> > So, should m.save() set m.id to some other value than None >> > or this is relaxed when Warning exception is thrown? >> >> It's the database that gives m.id a value upon a valid save.

Re: Django, MySQL - bug?

On 19 Lip, 16:29, Joshua Russo wrote: > 2009/7/19 Tomasz Zieliński > > > So, should m.save() set m.id to some other value than None > > or this is relaxed when Warning exception is thrown? > > It's the database that gives m.id a value upon a valid save. So because the > record couldn't be save

Re: Django, MySQL - bug?

2009/7/19 Tomasz Zieliński > So, should m.save() set m.id to some other value than None > or this is relaxed when Warning exception is thrown? It's the database that gives m.id a value upon a valid save. So because the record couldn't be saved it never received a value. --~--~-~--~

Re: Django, MySQL - bug?

On 19 Lip, 10:35, Daniel Roseman wrote: > > I don't know why you think it's a bug. Django's models are - by design > - not an instantaneous reflection of the database. Rather, they only > interact with the DB when you load and save them. So this is the > expected behaviour. So, should m.save() s

Re: Django, MySQL - bug?

On Jul 18, 10:39 pm, Tomasz Zieliński wrote: > I prepared following repro case, just paste to models.py to an empty > project: > > --- > from MySQLdb import Warning as Warning > from django.db import models > import unittest > > class TestMo