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

Django Mysql Error : Unknown system variable 'innodb_strict_mode

Models.py from django.db import models #from django_mysql.models import Model class Category(models.Model): name = models.CharField(max_length=128, unique=True) def __unicode__(self): return self.name class Page(models.Model): category = models

Re: MySQL error when trying to run tests with utf8mb4 charset

I think you may be barking up the wrong tree, see https://code.djangoproject.com/ticket/21196 On Friday, October 18, 2013 7:30:10 PM UTC-4, fle...@fletchowns.net wrote: > > Looks like this comes from custom_user.py in django.contrib.auth.tests: > > class CustomUser(AbstractBaseUser): > email

Re: MySQL error when trying to run tests with utf8mb4 charset

Looks like this comes from custom_user.py in django.contrib.auth.tests: class CustomUser(AbstractBaseUser): email = models.EmailField(verbose_name='email address', max_length=255, unique=True) is_active = models.BooleanField(default=True) is_admin = models.BooleanField(default=False)

MySQL error when trying to run tests with utf8mb4 charset

Hello! I tried to run *./manage.py test *for the first time and I got the following error: *DatabaseError: (1071, 'Specified key was too long; max key length is 767 bytes')* Looking at the log in MySQL, it appears to be caused by this statement: CREATE TABLE `auth_customuser` ( `id` integ

Re: MySQL error

On Wed, Dec 1, 2010 at 3:24 PM, wrote: > Thanks Tom, which one should I download for my django project? > There are about 9 files. > > Kindly revert. > > Regards. > Sent from my BlackBerry wireless device from MTN > I don't know; haven't used windows for ~10 years. Google for 'python mysql wind

Re: MySQL error

: django-users@googlegroups.com Subject: Re: MySQL error On Wed, Dec 1, 2010 at 10:09 AM, wrote: > I am starting out to learn django and I am using the book: Beginning Django > E-Commerce by Jim McGaw. > I was able to create the database using mysql console but when I ran the > command

Re: MySQL error

On Wed, Dec 1, 2010 at 10:09 AM, wrote: > I am starting out to learn django and I am using the book: Beginning Django > E-Commerce by Jim McGaw. > I was able to create the database using mysql console but when I ran the > command: > $ python manager.py dbshell > > I got the following error: > >

MySQL error

I am starting out to learn django and I am using the book: Beginning Django E-Commerce by Jim McGaw. I was able to create the database using mysql console but when I ran the command: $ python manager.py dbshell I got the following error: ow...@dipo /c/python26/djangojobs/ecomstore $ python ma

Re: MySQL error -1

On Jul 29, 10:03 am, Dennis Kaarsemaker wrote: > If you do 'select @@tmpdir', it'll probably say /tmp as that is the > default. You can change this in /etc/my.cnf if you want. Yep, that was the fix I applied (see above). So far everything's working fine. Thanks for all the responses. ./s -- Y

Re: MySQL error -1

On wo, 2010-07-28 at 22:25 -0700, shacker wrote: > Well, I think I've got a culprit on this one. I was seeing occasional > "/tmp is out of space" messages from the server lately as well, That is more than likely as mysql will store temporary tables there and your error is one that can be seen if

Re: MySQL error -1

Well, I think I've got a culprit on this one. I was seeing occasional "/tmp is out of space" messages from the server lately as well, and wondered whether these two things might be connected. It's a VPS and the /tmp partition is locked at 100MBs - can't be made larger. So I reconfigured mysql to us

Re: MySQL error -1

On wo, 2010-07-28 at 00:18 -0700, shacker wrote: > On Jul 27, 2:49 pm, Dennis Kaarsemaker wrote: > > Are the tracebacks all the same? Can you share a traceback? > > Sure, here's one (search/replaced to make it generic): > > http://dpaste.com/222645/ > > It's happening on various (and unrelated)

Re: MySQL error -1

On Wed, Jul 28, 2010 at 3:18 AM, shacker wrote: > On Jul 27, 2:49 pm, Dennis Kaarsemaker wrote: > > Are the tracebacks all the same? Can you share a traceback? > > Sure, here's one (search/replaced to make it generic): > > http://dpaste.com/222645/ > > It's happening on various (and unrelated) p

Re: MySQL error -1

On Jul 27, 2:49 pm, Dennis Kaarsemaker wrote: > Are the tracebacks all the same? Can you share a traceback? Sure, here's one (search/replaced to make it generic): http://dpaste.com/222645/ It's happening on various (and unrelated) pages, but the tracebacks are all equally uninformative. Thanks

Re: MySQL error -1

On di, 2010-07-27 at 13:49 -0700, shacker wrote: > On Jul 27, 3:10 am, Dennis Kaarsemaker wrote: > > > > > Start with checking/repairing the table that causes this error to be > > thrown. > > All tables analyzed, optimized, and repaired. No errors found. But the > " error -1 from storage engine"

Re: MySQL error -1

On Jul 27, 3:10 am, Dennis Kaarsemaker wrote: > > Start with checking/repairing the table that causes this error to be > thrown. All tables analyzed, optimized, and repaired. No errors found. But the " error -1 from storage engine" reports continue a few minutes later (not for every page request

Re: MySQL error -1

On di, 2010-07-27 at 00:14 -0700, shacker wrote: > One of my Django sites has been throwing occasional 500 errors, I > believe related to mysql: > > OperationalError: (1030, 'Got error -1 from storage engine') > > I'm never able to catch it in the act - I just see the 500 email > reports. This is

MySQL error -1

One of my Django sites has been throwing occasional 500 errors, I believe related to mysql: OperationalError: (1030, 'Got error -1 from storage engine') I'm never able to catch it in the act - I just see the 500 email reports. This is not connected to any particular page - it seems to happen to r

Re: MySQL error 1406 while running syncdb

Exactly. So people need to be aware of the varchar limits of django_ tables and also the contrib.auth tables. On Dec 2, 5:11 pm, Jarek Zgoda wrote: > Wiadomo¶æ napisana w dniu 2009-12-02, o godz. 11:30, przez chefsmart: > > > > > Hi, I'm am getting MySQL error 1406 whi

Re: MySQL error 1406 while running syncdb

Wiadomość napisana w dniu 2009-12-02, o godz. 11:30, przez chefsmart: > Hi, I'm am getting MySQL error 1406 while running syncdb. (See link > http://pastebin.org/59605) > > This happens after I create the superuser. > > The error says _mysql_exceptions.DataError: (1

MySQL error 1406 while running syncdb

Hi, I'm am getting MySQL error 1406 while running syncdb. (See link http://pastebin.org/59605) This happens after I create the superuser. The error says _mysql_exceptions.DataError: (1406, "Data too long for column 'name' at row 1") I am not doing any pre-population

Re: MySQL error subquery returns more than 1 row

On Tue, Nov 17, 2009 at 9:03 AM, Ilya Polosuhin wrote: > I don't fully understood your question. Of course I have more than one row > at test_mymodel2 > SQL query was formed by django-ORM. I just call > print (MyModel.objects.filter(key_to_mymodel2 = > MyModel2.objects.all()))._as_sql()) > and wri

Re: MySQL error subquery returns more than 1 row

I don't fully understood your question. Of course I have more than one row at test_mymodel2 SQL query was formed by django-ORM. I just call print (MyModel.objects.filter(key_to_mymodel2 = MyModel2.objects.all()))._as_sql()) and write here output. And I also googled for this MySQL error and

Re: MySQL error subquery returns more than 1 row

On Tue, Nov 17, 2009 at 7:17 AM, Ilya wrote: > I just developed some code like: > MyModel.objects.filter(key_to_mymodel2 = MyModel2.objects.all())) > This query produce SQL: > SELECT * FROM `test_mymodel` WHERE key_to_mymodel2_id =(select `id` > from `test_mymodel2`) > > It works fine on SQLLite

Re: MySQL error subquery returns more than 1 row

M, thanks. But should I create ticket on django trac about this issue? On 17 ноя, 17:29, Tom Evans wrote: > On Tue, Nov 17, 2009 at 3:17 PM, Ilya wrote: > > I just developed some code like: > >  MyModel.objects.filter(key_to_mymodel2 = MyModel2.objects.all())) > > This query produce SQL: > > SEL

Re: MySQL error subquery returns more than 1 row

On Tue, Nov 17, 2009 at 3:17 PM, Ilya wrote: > I just developed some code like: > MyModel.objects.filter(key_to_mymodel2 = MyModel2.objects.all())) > This query produce SQL: > SELECT * FROM `test_mymodel` WHERE key_to_mymodel2_id =(select `id` > from `test_mymodel2`) > > It works fine on SQLLite

MySQL error subquery returns more than 1 row

I just developed some code like: MyModel.objects.filter(key_to_mymodel2 = MyModel2.objects.all())) This query produce SQL: SELECT * FROM `test_mymodel` WHERE key_to_mymodel2_id =(select `id` from `test_mymodel2`) It works fine on SQLLite, but in MySQL it produce error: OperationalError: (1242, 'S

Re: Help needed debugging a weird MySQL error!

On 8 déc, 14:28, taleinat <[EMAIL PROTECTED]> wrote: > I have a Django application, and I wrote an external script which > reads and writes to the Django database. I've started getting the > following exception consistently: > > Exception _mysql_exceptions.ProgrammingError: (2014, "Commands out

Help needed debugging a weird MySQL error!

I have a Django application, and I wrote an external script which reads and writes to the Django database. I've started getting the following exception consistently: Exception _mysql_exceptions.ProgrammingError: (2014, "Commands out of sync; you can't run this command now") in > ignored Has any

Re: mysql error

On 9/30/07, Jan Stavel <[EMAIL PROTECTED]> wrote: > InternalError at /admin/store/storeitem/ > (1, "Can't create/write to file > '/var/lib/mysql/tmp/#sql_2182_0.MYI' (Errcode: 2)") This is an error occurring internally in the MySQL database server, not an error in Django or in your code. -- "Bu

Re: mysql error

Hi Jan I think you need a comma after the ('VHS','VHS') line in the ITEM_TYPE Like this ITEM_TYPES = ( ('VHS','VHS'), ('CD','CD'), ('VHS','VHS'), ) It might not fix all your problems, but it's a start On 30/09/2007, Jan Stavel <[EMAIL

mysql error

Hello, I tried to fill this Item with data (non english texts): (Django version 0.97-pre-SVN-unknown) class StoreItem(models.Model): ITEM_TYPES = ( ('VHS','VHS'), ('CD','CD'), ('VHS','VHS') ) class Admin: list_display = ('na

Re: Pagination causing mySQL error

hm... you can check amount of the records before output... why not? 2007/5/4, Merric Mercer <[EMAIL PROTECTED]>: > > I have a template that has 3 non-contiguous areas. I need to display > the results of a query set across these three areas. > My initial solution was to split up the query set i

Pagination causing mySQL error

I have a template that has 3 non-contiguous areas. I need to display the results of a query set across these three areas. My initial solution was to split up the query set in the template using "slice". For example: {% for object in object_list|slice:"1:6" %}area one {% endfor %} {% for objec

Re: MySQL error when running manage.py init on Mac OS X with Fink installed

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 common problem, try upgrading your mysql libraries (mysql client itself) or @server set password for your user like : SET PASSWORD FOR some_user '@' some_host ' = OLD_PASSWORD(' newpwd '); Ian wrote: > I am trying to run django from svn under Mac

MySQL error when running manage.py init on Mac OS X with Fink installed

I am trying to run django from svn under Mac OS X 10.4.5 using packages provided by Fink's unstable branch, namely python24, mysql and mysql-client 5.0.16-1, and mysql-python-py24 1.0.1-2. I have followed directions found at http://cavedoni.com/2005/django-osx and am currently attempting the exam