Re: SQLite 3.8.3 or later is required (found 3.7.17).

2019-11-05 Thread amul justin
Tq so much bro can u send u r contact number pls im from tamilnadu On Saturday, July 20, 2019 at 6:32:21 PM UTC+5:30, Desh Deepak wrote: > > Sorry for the late reply, > > You can try these commands on your terminal:- > > pip uninstall Django > > Then > > pip install Django 2.0 > > and try to run

Re: SQLite 3.8.3 or later is required (found 3.7.17).

2019-07-20 Thread Desh Deepak
Sorry for the late reply, You can try these commands on your terminal:- pip uninstall Django Then pip install Django 2.0 and try to run the server again. Thanks and regards:- Desh Deepak deshdeepak...@gmail.com +917011101001 On Fri, 19 Jul 2019, 18:06 anchal agarwal, wrote: > Hello

Re: SQLite 3.8.3 or later is required (found 3.7.17).

2019-07-20 Thread Joe Reitman
I had the same problem. To fix it I used Python 3.6 and Django 2.1. On Friday, July 19, 2019 at 7:37:06 AM UTC-5, Anchal Agarwal wrote: > > Hello Django users, > i am trying to deploy my django on AWS > I am following this > https://medium.com/@charlesthk/deploy-nginx-django-uwsgi-on-aws-ec2-a

Re: SQLite 3.8.3 or later is required (found 3.7.17).

2019-07-19 Thread Tal
Or, if you prefer, use a slightly older version of Django that doesn't require an sqlite library that's newer than your OS has. Either that, or if you plan on using a database other than sqlite in production, once you modify your settings.py's DATABASES variable to use something other than sqli

Re: SQLite 3.8.3 or later is required (found 3.7.17).

2019-07-19 Thread Tal
This is a known problem - at least on CentOS 7. Not sure what OS you're running on AWS - I don't have much experience with AWS. I literally just ran into this

Re: SQLite 3.8.3 or later is required (found 3.7.17).

2019-07-19 Thread Jani Tiainen
Hi. Error is simple. Python is using too old version of sqlite. There are few options to fix that depending what os your system runs on. Though sqlite is not very suitable for production so you may want to use something better like Postgres. pe 19. heinäk. 2019 klo 22.14 anchal agarwal kirjoit

Re: SQLite 3.8.3 or later is required (found 3.7.17).

2019-07-19 Thread anchal agarwal
This is my whole Traceback Traceback (most recent call last): File "manage.py", line 15, in execute_from_command_line(sys.argv) File "/usr/local/lib/python3.7/site-packages/django/core/management/__init__.py", line 381, in execute_from_command_line utility.execute() File "/usr/local/

Re: SQLite 3.8.3 or later is required (found 3.7.17).

2019-07-19 Thread anchal agarwal
I used default sqlite as my Database DATABASES = { 'default': { 'ENGINE': 'django.db.backends.sqlite3', 'NAME': os.path.join(BASE_DIR, 'db.sqlite3'), } } My python version is python3 and Django version is 2.1.5 On Fri, Jul 19, 2019 at 7:06 PM Desh Deepak wrote: > Hi, show me your database connec

Re: SQLite 3.8.3 or later is required (found 3.7.17).

2019-07-19 Thread Desh Deepak
Hi, show me your database connection, also tell me python and Django version. On Fri, 19 Jul 2019, 18:06 anchal agarwal, wrote: > Hello Django users, > i am trying to deploy my django on AWS > I am following this > https://medium.com/@charlesthk/deploy-nginx-django-uwsgi-on-aws-ec2-amazon-linux

Re: sqlite update on CentOS 7 for latest django version

2019-07-18 Thread Tal
Got it. For anyone also trying this, on a fresh CentOS 7 minimal install, do this as root: - yum groupinstall "Development Tools" - yum install tcl - curl -O https://www.sqlite.org/src/tarball/sqlite.tar.gz - tar -xvf sqlite.tar.gz - cd sqlite/ - ./configure - make - cp -v

Re: sqlite update on CentOS 7 for latest django version

2019-07-18 Thread Tal
Yoo - this is a known problem. It has nothing to do with running "migrate", being in a virtual environment, or settings.py. Jani - I tried compiling the latest Python manually - it was actually super easy - but even with the latest Python, importin

Re: sqlite update on CentOS 7 for latest django version

2019-07-18 Thread Jani Tiainen
Hi. I think Python has built in version so you might need to build custom version of python. Pyenv is pretty neat tool to handle custom python builds. ke 17. heinäk. 2019 klo 21.36 Tal kirjoitti: > Or is Python's sqlite built into Python, not depending on /usr/bin/sqlite3 > at all? > Would I h

Re: sqlite update on CentOS 7 for latest django version

2019-07-17 Thread Yoo
Hm did you first do ./manage.py migrate? Maybe your db.sqlite file doesn't exist... Check! Additionally, if there IS a file that is similar to a db name, like blah.db, make sure in your "database" settings in settings.py points to that file. Sqlite3 isn't old; it's not going away, either. With t

Re: sqlite update on CentOS 7 for latest django version

2019-07-17 Thread Tal
Or is Python's sqlite built into Python, not depending on /usr/bin/sqlite3 at all? Would I have to recompile Python for a newer version of sqlite that django can use? PS. I know I can downgrade django. I'm wondering how complex it is to compile a new version of sqlite for it to use. On Wednesd

Re: sqlite DB missed DEFAULT parameter from table definition

2018-08-06 Thread Christophe Pettus
> On Aug 6, 2018, at 10:27, HEMENDRA SINGH HADA > wrote: > > Than How can I achieve my Goal with sqlite and Django ?? > Do you have any solution for that ?? You'll need to either: 1. Add the default to the database using a migration, either using Django's migration framework and the RunSQL

Re: sqlite DB missed DEFAULT parameter from table definition

2018-08-06 Thread HEMENDRA SINGH HADA
Than How can I achieve my Goal with sqlite and Django ?? Do you have any solution for that ?? On Monday, August 6, 2018 at 10:49:29 PM UTC+5:30, HEMENDRA SINGH HADA wrote: > > Hi Team, > > My application using sqlite DB and in my model table class, I have define > attributes like Below - > >

Re: sqlite DB missed DEFAULT parameter from table definition

2018-08-06 Thread Christophe Pettus
> On Aug 6, 2018, at 10:19, HEMENDRA SINGH HADA > wrote: > > If I am giving is_active field with default value True, Then why its not > showing in "is_active" bool NOT NULL. Django "default=" defaults are implemented in Django, not in the database. Django does not currently set database-l

Re: SQLite database module name???

2013-04-21 Thread yati sagade
Hi Kakar, I can't say what is the problem with your environment with the little info you have provided, but I feel this question can help you: http://stackoverflow.com/questions/3384576/problems-setting-up-django-valueerror-empty-module-name If that does not solve your problem, post the detailed st

Re: sqlite datetime issue with django

2012-10-03 Thread puneet loya
Thank you :) Will check that :) On Wed, Sep 26, 2012 at 12:35 AM, Bill Freeman wrote: > When django reads the data back, does it reconvert it to your > timezone? If so, why is it a problem that it is stored as UTC in the > database? > > On Tue, Sep 25, 2012 at 2:19 PM, puneet loya wrote: > > H

Re: sqlite datetime issue with django

2012-09-25 Thread Bill Freeman
When django reads the data back, does it reconvert it to your timezone? If so, why is it a problem that it is stored as UTC in the database? On Tue, Sep 25, 2012 at 2:19 PM, puneet loya wrote: > Hi, > > I m having problems with sqlite insertion. > > When i enter datetime object using django into

Re: sqlite to mysql loaddata not working (using natural keys)

2012-07-21 Thread Karen Tracey
On Fri, Jul 20, 2012 at 2:57 PM, dack wrote: > I'm trying to move django data from an sqlite database to a mysql > database. I know I need to use natural keys, but it's still failing. Any > ideas? > > Here's my procedure. The default database is sqlite, the mysql database is > called "mysql" in s

Re: sqlite path

2011-02-28 Thread Brian Bouterse
Make sure the directory containing your sqlite database is writable by the user your web server is running as. sqlite occasionally creates some temporary files in the same directory side-by-side your actual sqlite file. Brian On Mon, Feb 28, 2011 at 10:45 AM, Tim wrote: > On Feb 28, 10:05 am,

Re: sqlite path

2011-02-28 Thread Tim
On Feb 28, 10:05 am, Tim wrote: > On Feb 26, 9:25 am, spa...@gmail.com wrote: > > > > > > > > > > > Have you tried updating the DB path in settings.py and creating a new db > > file? > > > On Sat, Feb 26, 2011 at 2:30 AM, Andre Terra wrote: > > > Try appending the custom location to the beginning

Re: sqlite path

2011-02-28 Thread Tim
On Feb 26, 9:25 am, spa...@gmail.com wrote: > Have you tried updating the DB path in settings.py and creating a new db > file? > > > > > > > > > > On Sat, Feb 26, 2011 at 2:30 AM, Andre Terra wrote: > > Try appending the custom location to the beginning of your PYTHONPATH. > > > Sincerely, > > And

Re: sqlite path

2011-02-26 Thread spawgi
Have you tried updating the DB path in settings.py and creating a new db file? On Sat, Feb 26, 2011 at 2:30 AM, Andre Terra wrote: > Try appending the custom location to the beginning of your PYTHONPATH. > > Sincerely, > Andre Terra > > > On Fri, Feb 25, 2011 at 5:28 PM, Tim wrote: > >> hi, >>

Re: sqlite path

2011-02-25 Thread Tim
On Feb 25, 4:00 pm, Andre Terra wrote: > On Fri, Feb 25, 2011 at 5:28 PM, Tim wrote: > > hi, > > I'm using Django 1.2.3 and I have a new sqlite (3.7.5) installed in a > > custom location. > > There is an old sqlite (3.6.23.1) installed in /usr/local/bin/. > > > How do I tell Django to use the new

Re: sqlite path

2011-02-25 Thread Andre Terra
Try appending the custom location to the beginning of your PYTHONPATH. Sincerely, Andre Terra On Fri, Feb 25, 2011 at 5:28 PM, Tim wrote: > hi, > I'm using Django 1.2.3 and I have a new sqlite (3.7.5) installed in a > custom location. > There is an old sqlite (3.6.23.1) installed in /usr/local/

Re: Sqlite :memory: database for production?

2010-11-29 Thread Subsume
I'm not really worried about concurrent user handling. I'm more worried about things happening quickly. Basically take 3 objects: Pack, Card, Pick. A user is handed a Pack with many Cards, they make a Pick and hand the Pack to the next user. Eventually the Pack depopulates of Cards and deletes its

Re: Sqlite :memory: database for production?

2010-11-29 Thread Cal Leeming [Simplicity Media Ltd]
Hi, To be honest, if you're that worried about performance and concurrent user handling, then you wouldn't be using SQLite anyway. Please can you explain some details about what you are trying to achieve, and lets see if we can give you a better solution :) Cal On Mon, Nov 29, 2010 at 3:10 PM, S

Re: Sqlite :memory: database for production?

2010-11-29 Thread Subsume
Yeah I gathered that but I found some django code that seemed to deal with that: http://code.djangoproject.com/ticket/2658 I wasn't sure what the implications of this would be in a live situation. On Nov 29, 11:05 am, Javier Guerra Giraldez wrote: > On Mon, Nov 29, 2010 at 10:10 AM, Subsume wr

Re: Sqlite :memory: database for production?

2010-11-29 Thread Javier Guerra Giraldez
On Mon, Nov 29, 2010 at 10:10 AM, Subsume wrote: > Right now I've got the name :memory: but the table always seems to be > empty, despite objects being created. from the docs (http://www.sqlite.org/inmemorydb.html): > Every :memory: database is distinct from every other. So, opening two > datab

Re: sqlite error: Encrypted or Not a Database

2009-07-30 Thread Art
Thanks, that was it. Art On Jul 29, 10:31 pm, Alex Gaynor wrote: > On Wed, Jul 29, 2009 at 9:06 PM, Art wrote: > > > I have created a Django usingsqliteas the database, and everything > > works fine. But when I try to open the database usingsqlitedirectly > > rather than through Django: > >sqlit

Re: sqlite error: Encrypted or Not a Database

2009-07-29 Thread Alex Gaynor
On Wed, Jul 29, 2009 at 9:06 PM, Art wrote: > > I have created a Django using sqlite as the database, and everything > works fine. But when I try to open the database using sqlite directly > rather than through Django: > sqlite mydatabase.db > I receive the message "File encrypted or not a databas

Re: SQLite and Null Character

2009-07-06 Thread Andrew Fong
The SQLite shell doesn't like the null character either. Not sure how to escape it though. For that matter, I'm not sure how to escape anything in SQLite. The only way I could enter in unicode was to pass it in directly (e.g as opposed to some ASCII representation to unicode) or to use a binary bl

Re: SQLite and Null Character

2009-07-06 Thread Alex Gaynor
On Mon, Jul 6, 2009 at 11:52 AM, Andrew Fong wrote: > > I'm using a SQLite3 backend on Python 2.6 and saving a unicode string > with the null character (u'\x00') results in everything after that > character being truncated. > > For example: > > m = MyModel(name=u'abc\x00def') > m.save() > MyModel

Re: SQLite, swedish signs

2009-02-10 Thread Karen Tracey
On Tue, Feb 10, 2009 at 2:55 PM, DaSa wrote: > > The traceback: > > Environment: > > Request Method: POST > Request URL: http://127.0.0.1:8000/admin/polls/poll/add/ > Django Version: 1.0.2 final > Python Version: 2.5.3 > [snip] > File "C:\Python25\Lib\site-packages\django\utils\encoding.py" in >

Re: SQLite, swedish signs

2009-02-10 Thread Karen Tracey
On Tue, Feb 10, 2009 at 2:55 PM, DaSa wrote: > > The traceback: > > Environment: > > Request Method: POST > Request URL: http://127.0.0.1:8000/admin/polls/poll/add/ > Django Version: 1.0.2 final > Python Version: 2.5.3 > [snip] > File "C:\Python25\Lib\site-packages\django\utils\encoding.py" in >

Re: SQLite, swedish signs

2009-02-10 Thread DaSa
The traceback: Environment: Request Method: POST Request URL: http://127.0.0.1:8000/admin/polls/poll/add/ Django Version: 1.0.2 final Python Version: 2.5.3 Installed Applications: ['django.contrib.admin', 'django.contrib.admindocs', 'django.contrib.auth', 'django.contrib.contenttypes', 'djan

Re: SQLite, swedish signs

2009-02-07 Thread Karen Tracey
On Sat, Feb 7, 2009 at 6:28 AM, Daniel Sandberg wrote: > > I,am getting the following error message when I,am trying to add a swedish > sign: > "'ascii' codec can't encode character u'\xe4' in position 4: ordinal not > in range(128)" > Please include the full traceback that comes with the error.

Re: SQLite iexact problem with non-latin symbols

2008-12-19 Thread Eugene Mirotin
Thank you for the detailed answer. I'll investigate the question about pysqlite (http:// oss.itsystementwicklung.de/trac/pysqlite/changeset/361 looks promosing), but switching to other DB is OK, though SQLite is much more convenient for development and debugging as I work on the project from seve

Re: SQLite iexact problem with non-latin symbols

2008-12-18 Thread Karen Tracey
On Thu, Dec 18, 2008 at 4:53 PM, Eugene Mirotin wrote: > > Hello. > Consider I have a simple model > > class Team(models.Model): >name = models.CharField(max_length=200) > > Then I create some team and try to look for it with iexact match: > tt = Team(name='English') > tt.save() > Team.object

Re: Sqlite permissions problem - Help :(

2008-02-21 Thread Shadow
:O Well that was stupid of me... I think I assumed it worked since the testing server worked. :P Thanks! All fixed --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, sen

Re: SQLite + float vs MySQL + Decimal

2007-08-09 Thread Russell Keith-Magee
On 8/9/07, Vincent Foley <[EMAIL PROTECTED]> wrote: > > Hello, > > I found a curious problem in my application when I put it into > production this week: when a models.FloatField is "extracted" from the > database, its type changes depending on the database. With SQLite in > development, I got ba

Re: SQLite - unsupported file format

2007-05-16 Thread Panos Laganakos
For reference purposes: http://jtauber.com/blog/2006/11/25/incompatible_sqlite_in_os_x_and_python On May 15, 9:17 pm, Panos Laganakos <[EMAIL PROTECTED]> wrote: > I haven't installed any pysqlite versions since I moved to 2.5 (from > OS X's default 2.3) Python, as sqlite3 is included in the lib

Re: SQLite - unsupported file format

2007-05-15 Thread Panos Laganakos
I haven't installed any pysqlite versions since I moved to 2.5 (from OS X's default 2.3) Python, as sqlite3 is included in the lib module by default. I uploaded the db on the production server though, and sqlite3 client: 3.3.5 seems to open the file just fine. So as you mentioned it must be a typ

Re: SQLite - unsupported file format

2007-05-15 Thread Lars Stavholm
Panos Laganakos wrote: > OS: Mac OS X - 10.4 > SQLite: 3.1.3 > Django: 0.96 > Python: 2.5 > > I've set the DATABASE_ENGINE to 'sqlite3', and the db gets created > when I call > > $manage.py syncdb > > And the project/apps all work fine. > > When I try to connect to it from the commandline 'sql

Re: sqlite problems

2007-02-14 Thread Guillermo Fernandez Castellanos
Hi, Try this (http://code.djangoproject.com/wiki/NewbieMistakes): Django says "Unable to Open Database File" when using SQLite3 ¶ Problem ¶ You're using SQLite3, your DATABASE_NAME is set to the database file's full path, the database file is writeable by Apache, but you still get the above erro

Re: sqlite

2006-09-14 Thread Malcolm Tredinnick
On Thu, 2006-09-14 at 19:59 -0500, James Bennett wrote: > On 9/14/06, Picio <[EMAIL PROTECTED]> wrote: > > Which version of sqlite django support? > > The Python module used by Django to connect to SQLite databases does > not support versions of SQLite older than 3.0. You are going to see aone p

Re: sqlite

2006-09-14 Thread James Bennett
On 9/14/06, Picio <[EMAIL PROTECTED]> wrote: > Which version of sqlite django support? The Python module used by Django to connect to SQLite databases does not support versions of SQLite older than 3.0. -- "May the forces of evil become confused on the way to your house." -- George Carlin --

Re: SQLite concurrent access to database

2006-05-26 Thread Joseph Heck
ip6.fr (8.13.3/jtpda-5.4+CB) with ESMTP id k4M8Q2cd006328  ; Mon, 22 May 2006 10:26:02 +0200From: Kilian CAVALOTTI <[EMAIL PROTECTED]> Organization: LIP6To: django-users@googlegroups.comSubject: Re: SQLite concurrent access to databaseDate: Mon, 22 May 2006 10:26:07 +0200User-Agent: K

Re: SQLite concurrent access to database

2006-05-22 Thread Kilian CAVALOTTI
sis.lip6.fr Received: from spip.lip6.fr (mailia [127.0.0.1]) by poleia.lip6.fr (8.13.3/jtpda-5.4+CB) with ESMTP id k4M8Q2cd006328 ; Mon, 22 May 2006 10:26:02 +0200 From: Kilian CAVALOTTI <[EMAIL PROTECTED]> Organization: LIP6 To: django-users@googlegroups.com Subject: Re:

Re: SQLite concurrent access to database

2006-05-21 Thread Graham King
Kilian, I does indeed say here that SQLite can handle concurrent transaction, by queuing them up: http://www.sqlite.org/faq.html#q7 You're not using an NFS share are you ? Apparently that would break it. Are you running the app / script on each users machine, or on a web server the

Re: SQLite thread access

2006-04-06 Thread David Pratt
Hi John. I wanted a bit more flexibility in a development server so adapted the cherrypy wsgi server to work with Django. In order to use SQLite, I modified my cherrypy config to use a single thread. Also I had to be sure that if I was calling the connection to execute raw SQL, I made sure to

Re: SQLite threading

2006-01-11 Thread Maniac
Eugene Lazutkin wrote: It looks pretty much like the patch #463, which fixed multi-threading problem for MySQL. AFAIR, somebody ported it to PostGres. That was me: http://code.djangoproject.com/ticket/900 However the patch there wasn't included (yet?). Now sqlite has similar problem. Maybe w

Re: SQLite threading

2006-01-10 Thread Eugene Lazutkin
David S. wrote: No, trac for example uses sqlite, too and it runs fine. I don't know about this particular behaviour, but maybe the sqlite faq will give you some answers about that. Are you creating a thread in your app that makes changes on your database ? I am just using the Django ORM.

Re: SQLite threading

2006-01-10 Thread David S .
> No, trac for example uses sqlite, too and it runs fine. I don't know > about this particular behaviour, but maybe the sqlite faq will give you > some answers about that. > Are you creating a thread in your app that makes changes on your database ? I am just using the Django ORM. But I did fi

Re: SQLite threading

2006-01-10 Thread Daniel Poelzleithner
David S. wrote: > So anyway, is it a reasonable assertion that if the app is actually to have > more > than 1 user--and in fact if it is going to run with Apache--then SQLite is > right > out? No, trac for example uses sqlite, too and it runs fine. I don't know about this particular behaviour,

Re: SQLite threading

2006-01-10 Thread David S .
> The restriction is due to a bug found in many versions of Linux > (ex: Redhat 9) which prevents a fcntl lock created in one thread > from being removed or modified in a different thread. Since > SQLite uses fcntl-locks for concurrency control, running SQLite > on a system that has the bug would

Re: SQLite threading

2006-01-10 Thread drh
David S. wrote: > Anyone familiar with this error running Apache and SQLite? > > SQLite objects created in a thread can only be used in that same thread The restriction is due to a bug found in many versions of Linux (ex: Redhat 9) which prevents a fcntl lock created in one thread from being re