[web2py] Re: Application not OK after upgrade from 2.5.1 to any posterior release...

2013-10-23 Thread pkomor
I think I have found when this occurs... The first code executed in a controller during the initial setup is create two users, roles, memberships and other configs: import datetime import obies def index(): """ example action using the internationalization operator T and flash render

[web2py] web2py DAL tables reference values not shown as drop downs

2013-10-23 Thread ranjith
Hi, I have defined some tables as below, db.define_table('subject_class', Field('class_id', 'reference class_tbl'), Field('subject_id', 'reference subject_bs') ) db.define_table('subjectgroup_tbl', Field('class_id', 'reference class_tbl'), Field('subgroup_name', 'string') )

[web2py] Re: change_password and logout redirects to user/profile and leads to too many redirects

2013-10-23 Thread Andreas Wienes
Thank you Massimo, I've sent you an email. Am Mittwoch, 23. Oktober 2013 00:36:37 UTC+2 schrieb Massimo Di Pierro: > > Please make a minimalist app to reproduce and post it or email it to me. > > On Saturday, 19 October 2013 11:25:34 UTC-5, Andreas Wienes wrote: >> >> >> Hey guys, >> >> I'm using

Re: [web2py] Re: schema database support for the DAL

2013-10-23 Thread Johann Spies
Thanks. I have tried the following: db.define_table("tmp_uts", Field ('ut', length=15), rname='isi.tmp_uts') Which resulted correctly in CREATE TABLE isi.tmp_uts( id BIGSERIAL PRIMARY KEY, ut VARCHAR(15) ); But then: In [1]: db.tmp_uts[0] = dict(ut = '1

[web2py] Re: Unable to join more than one table in SQLForm.grid

2013-10-23 Thread Jayakumar Bellie
When you send the query as you defined to SQLForm, it creates the list. When you click on add it takes to auth_user add, but it should take to auth_group add. On Tuesday, October 22, 2013 4:11:17 PM UTC+5:30, Cliff Kachinske wrote: > > This defines a set of Row objects. > query = db((db.auth_gr

Re: [web2py] Re: schema database support for the DAL

2013-10-23 Thread Niphlod
first of all, rname holds the QUOTED string of the table. so start adopting the mindset that your code should do rname='"isi"."tmp_uts"' As for the sequence name, the algo can't figure out (or at least it doesn't right now) every combination as you can see in the traceback, web2py does "

[web2py] Re: Help with production deployment on virtual server

2013-10-23 Thread curiouslearn
Thank you, Ricardo. That works great now if I go directly to http://xxx.xxx.xxx.xx:9001 (where xxx.xxx.xxx.xx is the ip address of the server). However, if I go to http://test.mysite.org then I get a 504 Gateway Timeout Error. It appears that nginx is not forwarding the request to uwsgi. Ca

[web2py] Re: form.custom usage

2013-10-23 Thread Diogo Munaro
Now it's working only with form.element(_name="first_name"). The controller is the same for 2 types. Tomorrow I'll post everything, but now I can post the controller simple structure: def register(): form = SQLFORM.factory(db.person, db.auth_user,db.researcher) if form.process().accepted

Re: [web2py] Re: MySQL problem

2013-10-23 Thread Alfonso de la Guarda
Hi, The problem is in the auth custom fields because they are created before any other table and the extra fields add some relations. At first time, i need create the basic auth table and after that just add the extra fields, then for the deployment is a 2 step process. Maybe the extra fileds shou

Re: [web2py] Re: Combining rows

2013-10-23 Thread Richard Vézina
Great! Thanks Anthony Richard On Tue, Oct 22, 2013 at 9:24 PM, Anthony wrote: > On Tuesday, October 22, 2013 3:48:26 PM UTC-4, Richard wrote: > >> Ok, wasn't know if it was direct Python operator or web2py >> implementation, the documentation is not clear about that : >> http://web2py.com/boo

[web2py] Re: web2py DAL tables reference values not shown as drop downs

2013-10-23 Thread Massimo Di Pierro
Because the referenced tables do not have a format = '%()s' representation. On Wednesday, 23 October 2013 02:45:15 UTC-5, ranjith wrote: > > Hi, > > I have defined some tables as below, > db.define_table('subject_class', > Field('class_id', 'reference class_tbl'), > Field('subject_id'

[web2py] Re: GAE: Running test. issue with exec_environment()

2013-10-23 Thread Quint
I ended up using this web2py testrunner: http://pythonhosted.org/web2py_utils/test_runner.html This runs each test in it's own local environment. Most things now work. But there are still some things that do not work. I'm not getting any of the already mentioned exceptions but just an except

[web2py] Best way to learn web2py

2013-10-23 Thread Andreas Wienes
Hey guys, I think it would be great to start a website similar to http://astonj.com/tech/best-way-to-learn-ruby-rails/ but only for web2py. So what do you think about my idea and what is your opinion about the "best way" to learn web2py? I'm excited for your suggestions. - Andreas -- Resou

Re: [web2py] Best way to learn web2py

2013-10-23 Thread Richard Vézina
You can reference this : http://killer-web-development.com/section/1/0 There is many post on the google group about ressource to get a grip on web2py We could also, make a up to date list of existing book here : ... :) Richard On Wed, Oct 23, 2013 at 10:55 AM, Andreas Wienes wrote: > Hey g

[web2py] web2py 2.7.4 mysterious lock-ups necessitating a service restart

2013-10-23 Thread Rob Paire
Hello all, I have been running web2py for about 6 months, and I am on the latest version 2.7.4 - I have a small in-house app developed which was just put into production this month. Things had been very stable until I released the app and people begin using it. Now this morning, for the third

[web2py] Re: web2py DAL tables reference values not shown as drop downs

2013-10-23 Thread ranjith
Oh good. Thanks for the response. I added the format and it worked. But, here I have one problem. In the table(subject_class) I am only having a combination of two foreign keys and no other columns. So, adding the format to any/both of those values will only show an integer in the dropdown whic

Re: [web2py] web2py 2.7.4 mysterious lock-ups necessitating a service restart

2013-10-23 Thread Richard Vézina
Have a look at the 2.7.4 and there both seems fine... It must come from somewhere else... :( Richard On Wed, Oct 23, 2013 at 1:33 PM, Richard Vézina wrote: > I guess there is a hardcoded thing introduced for testing purpose that > stay there... It seems that you will find the mistake line in

Re: [web2py] web2py 2.7.4 mysterious lock-ups necessitating a service restart

2013-10-23 Thread Richard Vézina
I guess there is a hardcoded thing introduced for testing purpose that stay there... It seems that you will find the mistake line in gluon/widget.py at line 1273 https://github.com/web2py/web2py/blob/master/gluon/widget.py look in the master on github if you have the same line in your gluon/widget

Re: [web2py] web2py 2.7.4 mysterious lock-ups necessitating a service restart

2013-10-23 Thread Richard Vézina
You said you were using bytecompiled app?? Maybe it has something to do with the bytecompile process... Richard On Wed, Oct 23, 2013 at 1:37 PM, Richard Vézina wrote: > Have a look at the 2.7.4 and there both seems fine... > > It must come from somewhere else... > > :( > > Richard > > > On Wed

[web2py] Re: web2py_component() works LOAD does not

2013-10-23 Thread Annet
Hi Simone, I'll post a minimal app that reproduces the problem ASAP, I have a deadline this Friday on another app, so I won't post it before Saturday. Best, Annet -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https

Re: [web2py] Re: MySQL problem

2013-10-23 Thread Cliff Kachinske
You can always define other tables before the call to auth.define_tables(). Unless they have dependencies on other auth_* tables, that is. On Wednesday, October 23, 2013 8:50:39 AM UTC-4, Alfonso de la Guarda Reyes wrote: > > Hi, > > The problem is in the auth custom fields because they are cre

Re: [web2py] Re: MySQL problem

2013-10-23 Thread Alfonso de la Guarda
Hi, Yes, i know howver auth_user has previous dependencies from another tables and those tables also between them, the solution will be simply define extra fields at the final of table definitions inside db.py Saludos, Alfonso de la Guarda Twitter: @alfonsodg

Re: [web2py] web2py 2.7.4 mysterious lock-ups necessitating a service restart

2013-10-23 Thread Niphlod
nope it's a problem in 2.7.4 with a leftover print statement that doesn't play well with web2py installed as a windows service. it's fixed in trunk. https://github.com/web2py/web2py/commit/0faa7d3174070e2a1f6fbee6840c58ba7c540102 -- Resources: - http://web2py.com - http://web2py.com/book (Docum

[web2py] Re: Unable to join more than one table in SQLForm.grid

2013-10-23 Thread Cliff Kachinske
If you want grid to manage groups, use this query: db.auth_group.id>0. On Wednesday, October 23, 2013 4:41:46 AM UTC-4, Jayakumar Bellie wrote: > > When you send the query as you defined to SQLForm, it creates the list. > When you click on add it takes to auth_user add, but it should take to > a

[web2py] Field('mydate', 'date') is not a real datetime object ?

2013-10-23 Thread Stavros Anastasiadis
My task has a simple one, just to find the missing days in a given interval of my database. db_define('mydates', Field('value'), Field('valuedate', 'date') in the controller : import datetime def date_range(start, end): r = (end+datetime.timedelta(days=1)-start).days return [start+da

[web2py] web2py, GAE and pydev

2013-10-23 Thread Tim Clare
Hey everyone, I am very new to web2py & google app engine development. I just wondered if there is a walkthrough/tutorial that shows how to get an environment setup using web2py, GAE and pydev? I have seen tutorials covering web2py with GAE, but I couldn't find one which adds pydev to the equa

[web2py] SQLForm issue with $("#dialog-form").load

2013-10-23 Thread Sebastian Bonta
Hi all, I'm having a issue with tha javascirpt load function. I'm able to see the form but when I submit the changes they are not reflected in the database. could you please help me to understand what am I doing wrong? Following is a simple example (model, view and controller) Model: db.define

[web2py] mongodb support

2013-10-23 Thread Thomas Tang
Hi, can anyone advise the current status of web2py support of mongodb? thanks thomas -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this mes

[web2py] Re: Unable to join more than one table in SQLForm.grid

2013-10-23 Thread Nico de Groot
-- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubsc

Re: [web2py] Best way to learn web2py

2013-10-23 Thread Derek
You can certainly try something on your own, the best thing to do is read the book. When people ask questions here, I usually refer them to the book, aka the documentation itself. It's well documented. On Wednesday, October 23, 2013 8:29:49 AM UTC-7, Richard wrote: > > You can reference this :

[web2py] Re: mongodb support

2013-10-23 Thread Alan Etkin
> > Hi, > can anyone advise the current status of web2py support of mongodb? > thanks > The MongoDBAdapter is experimental, and implements all standard DAL commands. https://groups.google.com/d/msg/web2py/ify9tjXSooU/y0ZYx1Z3v8cJ -- Resources: - http://web2py.com - http://web2py.com/book (Doc

[web2py] Re: web2py 2.7.4 mysterious lock-ups necessitating a service restart

2013-10-23 Thread Derek
I would recommend you run the Web2Py from Source (since the whole thing is all python, you can just run it without compiling anything). I would recommend you do it with gevent, as that may give better performance on Windows. Also, you can lookup those error lines and potentially fix them ( or j

[web2py] Re: web2py 2.7.4 mysterious lock-ups necessitating a service restart

2013-10-23 Thread Rob Paire
Thank you all for taking time to look at this error and making such useful and prompt replies. I will pursue the solution using the latest source code as advised - I am grateful for your help. On Wednesday, October 23, 2013 12:17:15 PM UTC-4, Rob Paire wrote: > > Hello all, I have been running

[web2py] mongodb support

2013-10-23 Thread Thomas Tang
Hi Alan, thanks. I played with it few months back and got something basic feature working but went into problem when I tried to use it for large object. just checking if there is any enhancement made n the adapter. I am using it for small project and do some more evalution on the adapter. Thomas

[web2py] Re: mongodb support

2013-10-23 Thread Alan Etkin
> went into problem when I tried to use it for large object. Please post the issue here if you think it's the adapter's fault: http://code.google.com/p/web2py/issues Adding any code and environment information needed to reproduce it. -- Resources: - http://web2py.com - http://web2py.com/book (

Re: [web2py] Re: web2py scheduler not working

2013-10-23 Thread ranjith
Is that not possible? On Wednesday, 23 October 2013 11:13:53 UTC+5:30, ranjith wrote: > > Thanks for the response. > > Other than the below script, it was mentioned in the document that > scheduler workers can be started via cron@reboot > The scheduler does not use cron, although one can use cron

[web2py] Re: Unable to join more than one table in SQLForm.grid

2013-10-23 Thread Jayakumar Bellie
That does not work. Add button still takes to user add. On Thursday, October 24, 2013 1:51:26 AM UTC+5:30, Cliff Kachinske wrote: > > If you want grid to manage groups, use this query: db.auth_group.id>0. > > On Wednesday, October 23, 2013 4:41:46 AM UTC-4, Jayakumar Bellie wrote: >> >> When you

[web2py] Re: Table inheritance: _before_insert?

2013-10-23 Thread User
The discrepancy between form generation time and database insertion time is mostly an annoyance when creating new records in appadmin. However, doing it this way I notice the modified time field will not get updated in appadmin because it will already have a value from when the record was or

[web2py] Re: Unable to join more than one table in SQLForm.grid

2013-10-23 Thread Niphlod
use the field_id argument to tell the grid what id should use to generate the links. On Thursday, October 24, 2013 7:39:02 AM UTC+2, Jayakumar Bellie wrote: > > That does not work. > Add button still takes to user add. > > > On Thursday, October 24, 2013 1:51:26 AM UTC+5:30, Cliff Kachinske wrote

[web2py] showing some help when making an entry to db

2013-10-23 Thread Thomas S
Hi, in my application the user has to specify a Datetime format the parser is using following the guidelines hhere http://docs.python.org/2/library/datetime.html#strftime-strptime-behavior Rather than offering just an empty field I would like to point the user to this page. What's an elegant sol

[web2py] Re: Table inheritance: _before_insert?

2013-10-23 Thread User
Actually unless I'm missing something I don't think using a computed field will work for the create_on field because this seems to modify the field any time you update the record. However it does work for the modified_on field. On Thursday, October 24, 2013 2:30:44 AM UTC-4, User wrote: >

[web2py] Re: Field('mydate', 'date') is not a real datetime object ?

2013-10-23 Thread Niphlod
check again on a fresh app. you're doing something wrong db.define_table('mydates', Field('value'), Field('valuedate', 'date')) import datetime def date_range(start, end): r = (end+datetime.timedelta(days=1)-start).days return [start+datetime.timedelta(days=i) for i in range(r)] def c

[web2py] Re: showing some help when making an entry to db

2013-10-23 Thread Niphlod
use a comment with a link to it. http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=comment On Thursday, October 24, 2013 8:36:14 AM UTC+2, Thomas S wrote: > > Hi, in my application the user has to specify a Datetime format the parser > is using following the gui