[web2py:16339] Re: web2py + postgresql = connection limit exceeded for non-superusers

2009-02-15 Thread Fran
On Feb 15, 5:22 am, ionel wrote: > OperationalError: FATAL:  connection limit exceeded for non-superusers > Do I need to close the connection explicitly somewhere? Interesting, someone previously had the same kind of problem with MySQL which they fixed by moving to PostgreSQL: http://groups.goog

[web2py:16340] using nicEdit on mywiki

2009-02-15 Thread murray3
I have been trying out variations of the mywiki app which forms part of the tutorial in web2py book, using the latest web2py. I thought I would try incorporating nicedit into the editing view. Using standard nicedit config in the view does not allow for the nicedit icons to show? I have looked a

[web2py:16341] Re: web2py + postgresql = connection limit exceeded for non-superusers

2009-02-15 Thread mdipierro
Are you using connections pools? db=SQLDB(...,pools=) try increase the max number of connections: http://www.postgresqlforums.com/forums/viewtopic.php?f=15&t=531 web2py closes connections automatically when a thread ends unless you have pools. Massimo On Feb 15, 2:19 am, Fran wrote: > On Fe

[web2py:16342] Re: problems running web2py with GAE locally

2009-02-15 Thread mdipierro
This is fine in stable. Thanks for reporting it. It will be fixed in the next commit. Massimo On Feb 14, 6:29 pm, Miguel Goncalves wrote: > Hi > > I am trying to setup a new project (using web2py version in trunk) and got > the following error when trying to access the application > /welcome/de

[web2py:16343] Re: Web2py requires being run in CWD

2009-02-15 Thread mdipierro
oops. This is a bug. Please check the next commit in one hour. Anyway. Currently this is only a problem when running the widget. It is not a problem when running web2py as a wsgi app. Massimo On Feb 14, 2:57 pm, BigBaaadBob wrote: > Suppose you: > > $ mkdir foo > $ cd foo > $ wgethttp://mdp.ct

[web2py:16344] Re: Possible bug with Auth using postgresql and web2py 1.56.2

2009-02-15 Thread mdipierro
Check if this is now fixed in trunk.. in 5 minutes On Feb 14, 11:25 am, jlegler wrote: > Okay, thanks.  I will see if I can find any side effects from doing > that.  I'll also see if I can figure out why it behaves in sqlite and > if it behaves in mysql.  Perhaps this is a good reason to not use

[web2py:16345] Re: question about t3 session

2009-02-15 Thread mdipierro
That should have worked. Can you tell me more about your setup? Are you using a proxy? wsgi? apache? can you print request.client when the two users login from different IP using the same password within 5 minutes? Massimo On Feb 13, 6:44 pm, drayco wrote: > Hi mdipierro, Thank's for your help

[web2py:16346] Re: SQLRows how to get to pieces?

2009-02-15 Thread mdipierro
Can you explain more? On Feb 13, 5:50 pm, Wes James wrote: > Actually this is the way I would like it to work.  If it is just a > display then no data in the db() query but if they click on a link to > down load a file it does get the data :) > > On Fri, Feb 13, 2009 at 3:43 PM, Wes James wrote

[web2py:16347] Re: Multiple Forms Issue

2009-02-15 Thread mdipierro
Yes this is a bug introduced in one of the recent versions. It prevents multiple forms on the same page. I will fit later today. Massimo On Feb 13, 2:41 pm, vamaq wrote: > Hi everybody, > > I'm having a problem with a multiple form page. When I submit the > first form (called form) I get the "u

[web2py:16348] Re: web2py + postgresql = connection limit exceeded for non-superusers

2009-02-15 Thread ionel
Hello Massimo, I don't use connection pools. I use web2py 1.55.2 with Postgresql 8.3. The max_connections parameter was set at 100 in postgresql.conf. I changed the value to 200. I hope this will fix the problem. My application is not in production. I get this error when I develop and try the re

[web2py:16349] Re: question about t3 session

2009-02-15 Thread drayco
I use a share hosting with wgsi and apache2 in webfaction. Ok, I will try to do the test. Thank's for your help. On Feb 15, 8:46 am, mdipierro wrote: > That should have worked. Can you tell me more about your setup? Are > you using a proxy? wsgi? apache? > > can you print request.client when t

[web2py:16350] Normalized database constraints and validation

2009-02-15 Thread BigBaaadBob
This seems to be a problematic FAQ, but: if I'm making an effort to normalize my database structure how do I do cross-table validation? Example (with extraneous things left out): db.define_table('competitions', SQLField('name','string'), SQLField('chief_ref','string')) db.competitions.na

[web2py:16351] Re: web2py + postgresql = connection limit exceeded for non-superusers

2009-02-15 Thread mdipierro
I suggest you use connection pools. It is designed to reuse connection and will make your application much faster. Just add SQLDB(,pools=20) Massimo On Feb 15, 10:05 am, ionel wrote: > Hello Massimo, > > I don't use connection pools. > I use web2py 1.55.2 with Postgresql 8.3. The max_conne

[web2py:16352] Re: Normalized database constraints and validation

2009-02-15 Thread mdipierro
I think you are looking for this: db.events.name.requires=IS_NOT_IN_DB(db (db.events.competition==request.vars.competition),'events.name') On Feb 15, 2:20 pm, BigBaaadBob wrote: > This seems to be a problematic FAQ, but: if I'm making an effort to > normalize my database structure how do I do

[web2py:16353] Re: using nicEdit on mywiki

2009-02-15 Thread mdipierro
On Feb 15, 7:18 am, murray3 wrote: > I have been trying out variations of the mywiki app which forms > part of the tutorial

[web2py:16354] Re: Multiple Forms Issue

2009-02-15 Thread mdipierro
I believe this is fixed now in trunk but needs to be tested. Can you please try it works with your code? Massimo On Feb 15, 9:15 am, mdipierro wrote: > Yes this is a bug introduced in one of the recent versions. It > prevents multiple forms on the same page. I will fit later today. > > Massimo

[web2py:16355] Re: using nicEdit on mywiki

2009-02-15 Thread murray3
Massimo, does not work at all using this code, the icons where only missing on previous code. Tried to modify and try, but can't get it to do what it say's on the tin? Chrism On Feb 15, 8:35 pm, mdipierro wrote: >