Re: OperationalError at /admin/login database or disk is full

2022-05-28 Thread Paul Kudla (SCOM.CA Internet Services Inc.)
ok i will assume you are running a flavor of unix aka linux, freebsd etc /admin/login is a mount point but it depends on your hdd layout for example depending on your hdd initalization # df Filesystem SizeUsed Avail Capacity Mounted on zroot/RO

Re: OperationalError at /admin/login database or disk is full

2022-05-27 Thread Clive Bruton
On 27 May 2022, at 22:37, Andrew Rea wrote: OperationalError at /admin/login/ database or disk is full Is this because my SQLite database is full from other projects? Or possibly because I have too many virtual envs from those same other projects? Or is it due to my personal computer's di

Re: OperationalError: foreign key mismatch

2021-07-28 Thread Wai Yeung
Yes. Thank you. On Tue., Jul. 27, 2021, 9:16 p.m. DJANGO DEVELOPER, wrote: > so issue resolved now? > > On Tue, Jul 27, 2021 at 9:09 PM Wai Yeung wrote: > >> Hello, >> >> Thanks for the suggestion. I actually changed it to the following to as >> to not have the "_id" suffix: >> >> filename_nu

Re: OperationalError: foreign key mismatch

2021-07-27 Thread DJANGO DEVELOPER
so issue resolved now? On Tue, Jul 27, 2021 at 9:09 PM Wai Yeung wrote: > Hello, > > Thanks for the suggestion. I actually changed it to the following to as > to not have the "_id" suffix: > > filename_number = > models.ForeignKey(FilenameTbl,db_column='filename_number', > to_field='rowid',null

Re: OperationalError: foreign key mismatch

2021-07-27 Thread Wai Yeung
Hello, Thanks for the suggestion. I actually changed it to the following to as to not have the "_id" suffix: filename_number = models.ForeignKey(FilenameTbl,db_column='filename_number', to_field='rowid',null=True,blank=True,on_delete=models.SET_NULL) This is what eventually worked for me: https

Re: OperationalError: foreign key mismatch

2021-07-26 Thread DJANGO DEVELOPER
can you please change your object from this: filename_id = models.ForeignKey(FilenameTbl,db_column='filename_id', to_field='rowid',null=True,blank=True,on_delete=models.SET_NULL) to : filename_id = models.ForeignKey(FilenameTbl,db_column='filename', to_field='rowid',null=True,blank=True,on_delete=

Re: OperationalError at /admin/products/product/add/

2021-05-24 Thread Kasper Laudrup
Learn how to ask a question. This could be a good start: https://betterprogramming.pub/how-to-ask-questions-about-programming-dcd948fcd2bd Kind regards, Kasper Laudrup -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this g

Re: OperationalError at /admin/login/attempt to write a readonly database

2020-05-03 Thread ramadhan ngallen
In short, it happens when the application which writes to the sqlite database does not have write permission. You have to add writing rights to the directory in which your sqlite database is stored. So running chmod 664 /srv/mysite should help. This is a security risk, so better solution is to c

Re: OperationalError at /admin/login/attempt to write a readonly database

2020-05-03 Thread Amina Anna Mahamane.O
I changed the permissions,but nothing changed 😢. Envoyé de mon iPhone > Le 3 mai 2020 à 15:25, Jorge Gimeno a écrit : > >  > > >> On Sun, May 3, 2020 at 3:46 AM Amina Anna Mahamane.O >> wrote: >> I read , but I didn’t help me , I don’t really know hiw to process . Can you >> explain me ?

Re: OperationalError at /admin/login/attempt to write a readonly database

2020-05-03 Thread Jorge Gimeno
On Sun, May 3, 2020 at 3:46 AM Amina Anna Mahamane.O wrote: > I read , but I didn’t help me , I don’t really know hiw to process . Can > you explain me ? > I'm not a linux expert, so other folks can feel free to correct me. In linux, the user that creates the file in a directory they have acces

Re: OperationalError at /admin/login/attempt to write a readonly database

2020-05-03 Thread Amina Anna Mahamane.O
I read , but I didn’t help me , I don’t really know hiw to process . Can you explain me ? Envoyé de mon iPhone > Le 3 mai 2020 à 05:21, Jorge Gimeno a écrit : > >  > > >> On Sat, May 2, 2020 at 8:09 PM Amina Anna Mahamane.O >> wrote: >> Hello , I started learning how to use django . I ma

Re: OperationalError at /admin/login/attempt to write a readonly database

2020-05-02 Thread Jorge Gimeno
On Sat, May 2, 2020 at 8:09 PM Amina Anna Mahamane.O wrote: > Hello , I started learning how to use django . I made a project without a > virtual environnement and without apach2 andn mod wsgi . > Now am I trying to do a project with those ones . I am a beginner .When I > try to log in to the adm

Re: OperationalError

2018-05-03 Thread Gerald Brown
Thanks for the reply.  Will check it out.  Just printed the documentation. On Friday, 04 May, 2018 03:08 AM, 'Anthony Flury' via Django users wrote: Django 2.0 docs suggest using reportlab : https://docs.djangoproject.com/en/2.0/howto/outputting-pdf/ I had some success with : pupeteer - http

Re: OperationalError

2018-05-03 Thread 'Anthony Flury' via Django users
Django 2.0 docs suggest using reportlab : https://docs.djangoproject.com/en/2.0/howto/outputting-pdf/ I had some success with : pupeteer - http://django-puppeteer-pdf.readthedocs.io/en/latest/ - which works by having a CBV type framework - so you subclass a PDF template view - and that will a

RE: OperationalError

2018-05-03 Thread Matthew Pava
, “Does anyone know of an easy way to print in Django?” It’s not easy, but it can be done in an appropriate environment. From: django-users@googlegroups.com [mailto:django-users@googlegroups.com] On Behalf Of Gerald Brown Sent: Thursday, May 3, 2018 7:22 AM To: Django users Subject: Re

Re: OperationalError

2018-05-03 Thread Gerald Brown
FINALLY. SUCCESS!!! What I ended up doing to correct the problem was to drop the whole database (NO RECORDS YET). When I tried to run migrations it said there were no changes. I then had to run makemigrations and migrate so I am now back in business!!! Now does anyone know of an *easy* way

Re: OperationalError

2018-05-03 Thread Gerald Brown
I finally discovered what I think is the cause of my problem. *DJANGO MIGRATIONS ARE NOT WORKING.*On the system that has the problem is where I made migration to change some of the field names.  The fields that were not found where the ones that did get changed but the old unchanged names were

Re: OperationalError

2018-05-02 Thread Gerald Brown
sers@googlegroups.com [mailto:django-users@googlegroups.com] *On Behalf Of *Gerald Brown *Sent:* Wednesday, May 2, 2018 4:08 AM *To:* Anthony Flury; django-users@googlegroups.com *Subject:* Re: OperationalError Thanks for the reply. I have done the makemigrations/migrate numerous times.  Each time

RE: OperationalError

2018-05-02 Thread Matthew Pava
important to you. From: django-users@googlegroups.com [mailto:django-users@googlegroups.com] On Behalf Of Gerald Brown Sent: Wednesday, May 2, 2018 4:08 AM To: Anthony Flury; django-users@googlegroups.com Subject: Re: OperationalError Thanks for the reply. I have done the makemigrations/migrat

Re: OperationalError

2018-05-02 Thread Gerald Brown
Thanks for the reply. I have done the makemigrations/migrate numerous times.  Each time it says there is an error in the previous migration file so I have to comment out most of the file.  I then just deleted all of the self generated migration files and started fresh. I was also getting som

Re: OperationalError

2018-05-02 Thread 'Anthony Flury' via Django users
At first glance it looks like you haven't applied a migration to this computer. at the command line on this computer  - in the man project directory : If you have not copied the migration scripts from your development machine do this first : $ python manage.py makemigrations and then do

Re: OperationalError at /checkout/ table orders_order has no column named order_id

2016-08-07 Thread M Hashmi
This is strange in Django 1.8.5 that it is not creating all DB fields. I've just commented out order_id field and 1. manage.py makemigrations, 2. manage.py migrate. Then again removed comment sign and it got added in db. Anyone knows why this happened? If I delete all my db with migrations there

Re: OperationalError: ORA-03114: not connected to ORACLE.

2015-02-25 Thread Andreas Kuhne
Hi Alex, Correct. There seems to be something wrong with the configuration of mod_wsgi, because you are able to connect via dbshell (which loads all of your environment variables and is able to connect). The same thing with runserver. Check for a good tutorial on how to configure apache + mod_wsg

Re: OperationalError: ORA-03114: not connected to ORACLE.

2015-02-25 Thread alexandrosstylianou88
Hi Andreas, I did the following test... i used "python manage.py runserver" and i was able to use the admin page (http://127.0.0.1:8000/admin/) of Django and log into the DB. So that means the apache and the mod_wsgi as you said have a problem, correct ??? Regars, Alex On Tuesday, Februa

Re: OperationalError: ORA-03114: not connected to ORACLE.

2015-02-24 Thread Andreas Kuhne
The file you wrote connects to the database itself, it doesn't use djangos connection, so the only thing you are testing is if you can connect to the database. And that we know (because you are able to do it with ./manage.py dbshell). What you need to check is if the settings.py file used by django

Re: OperationalError: ORA-03114: not connected to ORACLE.

2015-02-24 Thread alexandrosstylianou88
Well i have created the below test script to check if i am able to connect to the DB using mod_wsgi and i get back the sysdate from the DB.. I have configured mod_wsgi under the alias /test to execute the below script and i always get the time.. So it seems that the configuration in mod_wsgi is

Re: OperationalError: ORA-03114: not connected to ORACLE.

2015-02-24 Thread Andreas Kuhne
Hmmm You can use ./manage.py dbshell, so your configuration is correct in THAT case, however, have you set all the variables correctly for django when running apache + mod_wsgi? Has the connection ever worked there? What do the config files for mod_wsgi look like and are all of the paths correctl

Re: OperationalError: ORA-03114: not connected to ORACLE.

2015-02-24 Thread alexandrosstylianou88
Is there any way to find out where the problem occurs ?? Is there a way to enable some debugging or trace in order to see which python scripts are called in Django and find out where the whole process is failing ?? In the last lines of the stack trace it tries to close the connection and for s

Re: OperationalError: ORA-03114: not connected to ORACLE.

2015-02-24 Thread Andreas Kuhne
The reason I asked this is because that means that your connection parameters are correct, so it should work? Sorry I don't know what to do to help you more. Regards, Andréas 2015-02-24 12:49 GMT+01:00 : > Hi Andreas, > > I can connect using "python manage.py dbshell" it connects without any >

Re: OperationalError: ORA-03114: not connected to ORACLE.

2015-02-24 Thread alexandrosstylianou88
Hi Andreas, I can connect using "python manage.py dbshell" it connects without any error. Is there a difference, if i am not mistaken the dbshell test shows that the configuration of the DB is correct and that i can connect from the machine, correct ?? From the stack trace it seems that the

Re: OperationalError: ORA-03114: not connected to ORACLE.

2015-02-20 Thread Andreas Kuhne
2015-02-20 17:18 GMT+01:00 : > Hi, > > I migrated my project to a new infrastructure but i kept the same versions > Apache 2.2 + mod_wsgi + python 2.6.1 + Django 1.2.1 > > I am trying to run my project and i am getting the below exception that > seems to be from Django and i need help pin pointing

Re: OperationalError happening after giving authorization to the class based view

2014-06-08 Thread yutaka kobayashi
I made two models on models.py they are Contacts and Address along with this http://effectivedjango.com/tutorial/related.html page I tried to use the both of this models. Which means Address model under the Contact model. The authentication stuff that I had problem with went well after I comm

Re: OperationalError happening after giving authorization to the class based view

2014-06-06 Thread carlos
Hi, 2 choice 1. erase de database y create again the migration: $rm database && rm -r addressbook/migrations $./manage.py schemamigration addressbook --initial $./manage.py migrate 2. create manually fields owner_id enter terminal or console i see you use sqlite3 i recomended install this addon

Re: OperationalError: unable to open database file

2013-08-30 Thread Dan Gentry
When using sqlite3, one has to provide a full path to the database file. For my projects I use something like this on my development machines (for a database file named 'db'): import os PROJECT_DIR = os.path.dirname(__file__) DATABASES = { 'default': { 'ENGINE': 'django.db.backen

Re: OperationalError: unable to open database file

2013-08-30 Thread jumpmanlane
make sure you don't have another instance of django running already. -J On Monday, July 22, 2013 1:48:43 PM UTC-4, Stian Sjøli wrote: > > i get this error while going throught the tutorial from the django > website. I am a mac user, and have modified my settings-file to use sqlite3 > and the na

Re: OperationalError: (1040, 'Too many connections')

2013-05-19 Thread frocco
Thank you, I finally got this working by doing one app at a time. Then I had to deal with sequence errors. I tried and reset them all, now I am hoping I will have no issues when users start using my website on Monday. On Sunday, May 19, 2013 2:55:47 AM UTC-4, Artem Zinoviev wrote: > > > http://

Re: OperationalError: (1040, 'Too many connections')

2013-05-18 Thread Artem Zinoviev
http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL суббота, 18 мая 2013 г., 20:00:15 UTC+3 пользователь frocco написал: > > I have been looking for an easy way to convert, but nothing works for me. > I tried dumpdata, loaddata, but get duplicate key, when I look at the

Re: OperationalError: (1040, 'Too many connections')

2013-05-18 Thread frocco
I have been looking for an easy way to convert, but nothing works for me. I tried dumpdata, loaddata, but get duplicate key, when I look at the file, I see no duplicates. I am open to suggestions on converting. Thanks On Saturday, May 18, 2013 12:51:28 PM UTC-4, Artem Zinoviev wrote: > > use po

Re: OperationalError: (1040, 'Too many connections')

2013-05-18 Thread Artem Zinoviev
use postgreSQL пятница, 17 мая 2013 г., 21:24:10 UTC+3 пользователь frocco написал: > > Hello, > > How can I resolve this in django 1.5? > > webfaction allows max 90 connections. > > Thanks > -- You received this message because you are subscribed to the Google Groups "Django users" group. To u

Re: OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (10061)")

2013-04-28 Thread Arturo Paul Castro Calvo
try to define the parameters so 'ENGINE': 'django.db.backends.mysql', 'NAME': 'yourdbname', 'USER': 'root', 'PASSWORD': 'your password', 'HOST': '127.0.0.1', 'PORT': '3306', El domingo, 6 de enero de 2013

Re: OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (10061)")

2013-01-08 Thread Javier Guerra Giraldez
On Tue, Jan 8, 2013 at 4:04 AM, Diederik van der Boor wrote: > When you ask the mysql driver to connect to localhost, it will use the > socket. > To avoid this issue, better use 127.0.0.1. which issue? what's wrong with using socket? -- Javier -- You received this message because you are sub

Re: OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (10061)")

2013-01-08 Thread Diederik van der Boor
The hostname "localhost" has a special meaning for MySQL, at least on Linux it has. When you ask the mysql driver to connect to localhost, it will use the socket. To avoid this issue, better use 127.0.0.1. Also check whether the MySQL server is running on that port (netstat -a ?), whether the ser

Re: OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (10061)")

2013-01-06 Thread Александр Соколов
Hi! Recently I had the same problem and this site has helped me: http://stackoverflow.com/questions/11121819/mysqldb-in-python-cant-connect-to-mysql-server-on-localhost I've set the next properties: 'ENGINE': 'django.db.backends.mysql', 'NAME': 'yourdbname', 'US

Re: OperationalError: no connection to the server using Django and gunicorn

2011-07-08 Thread Adrian Ribao
I still have the same problem using gevent with gunicorn, but it works with synchronous workers. Did you find a solution? 2011/7/1 Андрей Махнач > I'm getting this error randomly > and it throws 500error to nginx (I'm using nginx+gunicorn) > > and it appears really randomly ;) > > On Jul 1, 10:

Re: OperationalError: no connection to the server using Django and gunicorn

2011-07-01 Thread Андрей Махнач
I'm getting this error randomly and it throws 500error to nginx (I'm using nginx+gunicorn) and it appears really randomly ;) On Jul 1, 10:16 am, Adrián Ribao Martínez wrote: > I think that the error comes only when starting the server. > > Reload the page about 10 times and check if you still ge

Re: OperationalError: no connection to the server using Django and gunicorn

2011-07-01 Thread Adrián Ribao Martínez
I think that the error comes only when starting the server. Reload the page about 10 times and check if you still get the error. Regards, Adrián > Hi Adrian, > > Have you solved this weird issue? > > if yes, please tell me how. > > Best regards, > Andrey Makhnach > > On May 27, 12:53 pm, Ad

Re: OperationalError: no connection to the server using Django and gunicorn

2011-06-30 Thread Андрей Махнач
Hi Adrian, Have you solved this weird issue? if yes, please tell me how. Best regards, Andrey Makhnach On May 27, 12:53 pm, Adrián Ribao wrote: > I'm doing it manually because I'm just testing: > > ./manage.py run_gunicorn -c gunicorn.conf.py > > where gunicorn.conf.py > > # -*- coding: utf-8

Re: OperationalError: no connection to the server using Django and gunicorn

2011-05-27 Thread Adrián Ribao
I'm doing it manually because I'm just testing: ./manage.py run_gunicorn -c gunicorn.conf.py where gunicorn.conf.py # -*- coding: utf-8 -*- import multiprocessing bind = "127.0.0.1:8000" workers = multiprocessing.cpu_count() * 2 + 1 worker_class = 'gevent' On 27 mayo, 02:23, Shawn Milochik w

Re: OperationalError: no connection to the server using Django and gunicorn

2011-05-26 Thread Shawn Milochik
What's the command you're using to run it? Are you in screen? Are you using supervisor or anything like that? -- 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 fr

Re: OperationalError server closed the connection unexpectedly

2009-11-20 Thread james...@gmail.com
On 11 nov, 14:17, Janusz Harkot wrote: > Request Method: GET > Request URL:    http://localhost/ > Exception Type: OperationalError > Exception Value: > server closed the connection unexpectedly >         This probably means the server terminated abnormally >         before or while processing t

Re: OperationalError: unable to open database file, when saving existing object

2009-10-04 Thread pigmalione
For what it's worth, I found some kind of solution. Apparently, running under a user administrator account in Windows causes this kind of permissioning issue. If I enable the windows hidden administrator and work under that account, this issue disappears. A bit annoying. --~--~-~--~~-

Re: OperationalError: unable to open database file, when saving existing object

2009-10-01 Thread pigmalione
Hi, Wim - Thanks a lot for the reply. I'm doing everything through code, since accessing the admin interface is itself plagued with issues. And as far as I can tell, I am the same user as the owner of the db-file (since I can also change privileges on the file at will). These are some more sympt

Re: OperationalError: unable to open database file, when saving existing object

2009-09-27 Thread Wim Feijen
So, if I understand correctly, creating new objects and saving them to the database works correctly, and updating objects fails. Is that correct? Is it an update from the admin interface or from code written by you? If the former, it might have something to do with db privileges. Which back-end a

Re: OperationalError 1366 Incorrect string value ... for column 'message'

2009-02-23 Thread SeanB
Bingo, that was precisely the problem: altering the message field to use utf8_general_ci solved it. Thanks, i was really pulling my hair out over this one! Sean On Feb 20, 5:18 pm, Karen Tracey wrote: > On Fri, Feb 20, 2009 at 8:00 PM, SeanB wrote: > > > I have an application that include Unic

Re: OperationalError 1366 Incorrect string value ... for column 'message'

2009-02-20 Thread Karen Tracey
On Fri, Feb 20, 2009 at 8:00 PM, SeanB wrote: > > I have an application that include Unicode strings (Greek and Hebrew), > running on a dev machine and an (inside the firewall) release machine > configured (to the best of my ability) with the same Python, Django, > MySql and connector. > > When e

Re: OperationalError at /swenglish/ , no such table: swenglish_entry

2009-01-06 Thread Malcolm Tredinnick
On Tue, 2009-01-06 at 16:07 -0800, rabbi wrote: > i was actually already reading that page... but it's 1:00am and maybe > i glazed over it without registering :) > > i've now temporarily fixed my admin page problem by just copying all > files to the apache document root, but later i will need to

Re: OperationalError at /swenglish/ , no such table: swenglish_entry

2009-01-06 Thread rabbi
i was actually already reading that page... but it's 1:00am and maybe i glazed over it without registering :) i've now temporarily fixed my admin page problem by just copying all files to the apache document root, but later i will need to learn what a "symbolic link" is as it sounds like a nicer

Re: OperationalError at /swenglish/ , no such table: swenglish_entry

2009-01-06 Thread Malcolm Tredinnick
On Tue, 2009-01-06 at 15:33 -0800, rabbi wrote: > thanks a lot malcom, that's great advice. > for the record, initially i had "DATABASE_NAME = 'vocab'" > > i have another question; after changing from runserver to apache the > django admin page now looks very ugly... it's lost all formatting etc

Re: OperationalError at /swenglish/ , no such table: swenglish_entry

2009-01-06 Thread rabbi
thanks a lot malcom, that's great advice. for the record, initially i had "DATABASE_NAME = 'vocab'" i have another question; after changing from runserver to apache the django admin page now looks very ugly... it's lost all formatting etc is this normal or is it a problem i can repair. maybe the

Re: OperationalError at /swenglish/ , no such table: swenglish_entry

2009-01-06 Thread Malcolm Tredinnick
On Tue, 2009-01-06 at 15:12 -0800, rabbi wrote: [...] > i've now got it running on apache/mod_python too, but i had to > hardcode the entire path to the db file in settings.py: >"DATABASE_NAME = 'C:/Documents and Settings/Rabbi/Desktop/Django > Code/mysite/vocab'" > > is this really necessar

Re: OperationalError at /swenglish/ , no such table: swenglish_entry

2009-01-06 Thread rabbi
>>I've gone through the Django tutorial and it worked fine when using >>the default development server that is provided with Django (python >>manage.py runserver) yeh, like I said. it works fine with the django-provided development server i've now got it running on apache/mod_python too, but i h

Re: OperationalError at /swenglish/ , no such table: swenglish_entry

2009-01-06 Thread Malcolm Tredinnick
On Tue, 2009-01-06 at 11:59 -0800, rabbi wrote: [...] > I want to deploy my little test site though, so I've been trying to > get it running on Apache and I keep getting this error: > "OperationalError at /swenglish/ > no such table: swenglish_entry" > > The error seems to be happening on this li

Re: OperationalError at /swenglish/ , no such table: swenglish_entry

2009-01-06 Thread Daniel Roseman
On Jan 6, 2:59 pm, rabbi wrote: > Hi everyone, > I've gone through the Django tutorial and it worked fine when using > the default development server that is provided with Django (python > manage.py runserver) > > I want to deploy my little test site though, so I've been trying to > get it runnin

Re: OperationalError at /swenglish/ , no such table: swenglish_entry

2009-01-06 Thread rabbi
I forgot to mention, I'm using SQLite3 On Jan 6, 8:59 pm, rabbi wrote: > Hi everyone, > I've gone through the Django tutorial and it worked fine when using > the default development server that is provided with Django (python > manage.py runserver) > > I want to deploy my little test site though

Re: OperationalError -- Table has no column named ..

2008-12-09 Thread djan
Thanks so much for the help! I deleted the database, made the changes you suggested and ran syncdb again. I have two lingering issues. 1) At the django admin interface, I still only see a place to enter data for 'Artist', and none of the tables that follow it in models.py appear (the updated vers

Re: OperationalError -- Table has no column named ..

2008-12-09 Thread Daniel Roseman
On Dec 9, 5:02 am, djan <[EMAIL PROTECTED]> wrote: > Hello, > > I'm running OpenSuSE-11.0 with the lastest version of django and > sqlite3. > When I enter the admin interface to enter data into my database, I got > the error: > > OperationalError at /admin/archive/artist/add/ > > table archive_art

Re: OperationalError: (1054, "Unknown,column ' ...) for ForeignKey

2008-08-20 Thread Marc Vinyes
Thanks a lot for your help Malcom. Malcolm Tredinnick escribió, El 18/08/2008 0:03: > > On Sun, 2008-08-17 at 23:51 +0200, MarC wrote: >> Hi again, >> I'm still fighting against it and reading related posts in the mailing list >> archive with no >> success... Now I just found it won't work eit

Re: OperationalError (1267, "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='") Why

2008-05-19 Thread [EMAIL PROTECTED]
Make sure the columns themselves are set to UTF-8. On May 18, 4:13 am, coco <[EMAIL PROTECTED]> wrote: > Hi List, > > Django show this message to me: > > OperationalError at /champselysees/services/ > (1267, "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and > (utf8_general_ci,COERCIBLE)

Re: OperationalError

2007-08-18 Thread Doug B
> I tried that, but I get the same error, the traceback displays that > line as the "buggy" one: for item in self.orderitem_set.all(): def count_items(self): items = 0 for item in self.fielddef_set.all(): items += item.id return items I added that to one o

Re: OperationalError

2007-08-18 Thread Alvaro Mouriño
On 8/18/07, Doug B <[EMAIL PROTECTED]> wrote: > > > [PYTHON] > > class Order(models.Model): > > def count_items(self): > > items = 0 > > for item in self.orderitem_set.filter(order=self): > > items += item.quantity > > return items > > count = property(c

Re: OperationalError

2007-08-18 Thread Doug B
> q="select SUM(quantity) as item_count from %s where order=%s" % > (self.orderitem_set.model._meta.db_table,self._get_pk_val()) Sorry, that first one is wrong. q="select SUM(quantity) as item_count from %s where order_id=%s" % (self.orderitem_set.model._meta.db_table,self._get_pk_val()) I wish

Re: OperationalError

2007-08-18 Thread Doug B
> [PYTHON] > class Order(models.Model): > def count_items(self): > items = 0 > for item in self.orderitem_set.filter(order=self): > items += item.quantity > return items > count = property(count_items) > [/PYTHON] For the instance.othermodel_set object

Re: OperationalError 1054 Unknown column

2007-08-10 Thread AnaReis
Hum... I thought that to be an AutoField it was mandatory that "_id" would have to be added to the name of the field... Apparently not! :) Thanks. Ana On Aug 9, 6:57 pm, Collin Grady <[EMAIL PROTECTED]> wrote: > Why did you add _id to your model definition for levelID ? The column > does not hav

Re: OperationalError 1054 Unknown column

2007-08-10 Thread AnaReis
Hum... I thought that to be an AutoField it was mandatory that "_id" would have to be added to the name of the field... Apparently not! :) Thanks. Ana On Aug 9, 6:57 pm, Collin Grady <[EMAIL PROTECTED]> wrote: > Why did you add _id to your model definition for levelID ? The column > does not hav

Re: OperationalError 1054 Unknown column

2007-08-09 Thread Collin Grady
Why did you add _id to your model definition for levelID ? The column does not have that. --~--~-~--~~~---~--~~ 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@googl

Re: operationalError 2002, mysql on osx 10.9

2007-05-02 Thread Mark Phillips
On May 2, 2007, at 12:26 PM, Michael K wrote: > > On May 2, 3:25 pm, Michael K <[EMAIL PROTECTED]> wrote: >> >> Try setting DATABASE_HOST to 'localhost' instead of blank. What OS >> are you running this on? > > This will teach me to read the subject closely. I should have went > with my gut fee

Re: operationalError 2002, mysql on osx 10.9

2007-05-02 Thread Mark Phillips
On May 2, 2007, at 12:25 PM, Michael K wrote: > > On May 2, 10:09 am, Mark Phillips <[EMAIL PROTECTED]> wrote: >> Being a newbie has its challenges... > > I know exactly what you mean. > >> The server is running mysql, I use phpMyAdmin and a couple of other >> applications successfully with it. >

Re: operationalError 2002, mysql on osx 10.9

2007-05-02 Thread Michael K
On May 2, 3:25 pm, Michael K <[EMAIL PROTECTED]> wrote: > > Try setting DATABASE_HOST to 'localhost' instead of blank. What OS > are you running this on? This will teach me to read the subject closely. I should have went with my gut feeling that it was Mac OS X :) Michael --~--~-~--

Re: operationalError 2002, mysql on osx 10.9

2007-05-02 Thread Michael K
On May 2, 10:09 am, Mark Phillips <[EMAIL PROTECTED]> wrote: > Being a newbie has its challenges... I know exactly what you mean. > The server is running mysql, I use phpMyAdmin and a couple of other > applications successfully with it. > There is an existing database of the same name as the new

Re: OperationalError: Unable to close due to unfinalised statements

2007-03-10 Thread James Bennett
On 3/10/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Ok, thanks. Now it solved. I am moving the database file to a > directory that writable to others and change the database file > permission to be writable by others. But I think it will be a security > issue. What do you suggest? If you'

Re: OperationalError: Unable to close due to unfinalised statements

2007-03-10 Thread [EMAIL PROTECTED]
Ok, thanks. Now it solved. I am moving the database file to a directory that writable to others and change the database file permission to be writable by others. But I think it will be a security issue. What do you suggest? regards, On Mar 11, 8:22 am, "James Bennett" <[EMAIL PROTECTED]> wrote:

Re: OperationalError: Unable to close due to unfinalised statements

2007-03-10 Thread James Bennett
On 3/10/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > do you mean that the directory and file of SQLite database file shall > be able to be written by Apache? Yes. TO use SQLite under Apache/mod_python, the SQLite database must be readable and writable by the user Apache is running as. Wheth

Re: OperationalError: Unable to close due to unfinalised statements

2007-03-10 Thread [EMAIL PROTECTED]
Hi James, do you mean that the directory and file of SQLite database file shall be able to be written by Apache? IMHO it is not safe to let Apache write database file specially if the file is inside users' home directory. Does it mean I have to move the database file to a 'writable by all' direct

Re: OperationalError: Unable to close due to unfinalised statements

2007-03-10 Thread James Bennett
On 3/10/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > OperationalError: Unable to close due to unfinalised statements Usually this means that there's a permissions issue with SQLite. This often pops up when switching from the development server to Apache, because on hosting services Apache a

Re: OperationalError after inpectdb

2006-08-16 Thread [EMAIL PROTECTED]
Thank you. I was looking through the ForeignKey class for clues, but did not find any. I find it amazing how much of a working model you get from inspectdb, but obviously, it cannot account for old crusty schemas. david --~--~-~--~~~---~--~~ You received this mes

Re: OperationalError after inpectdb

2006-08-15 Thread James Bennett
On 8/15/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > OperationalError at /admin/ghsite/inventory/ > (1054, "Unknown column 'inventory.keyfgallid_id' in 'field list'") ...snip... > How can I fix this without renaming all of the keys? Assuming that 'keyfgallid' is the name of the actual c

Re: OperationalError after inpectdb

2006-08-15 Thread Malcolm Tredinnick
On Tue, 2006-08-15 at 20:38 -0700, [EMAIL PROTECTED] wrote: > I have an existing mysql db. I reverse engineered the models.py with > inspectdb... > > My foreign key names seem to be messing up the query that django > generates: > > OperationalError at /admin/ghsite/inventory/ > (1054, "Unknown