[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 rendered

[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 web2py 2.7.4

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 =

[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 =

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.

[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

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 abasta...@gmail.com 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 :

[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

[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 --

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

[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

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 ml.richard.vez...@gmail.com wrote: I guess there is a hardcoded thing introduced for testing purpose that stay there... It seems that you

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

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 ml.richard.vez...@gmail.com wrote: Have a look at the 2.7.4 and there both seems fine... It must come from somewhere else... :(

[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) -

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

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

[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.id0. 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

[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

[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

[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:

[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

[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

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

[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

[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.id0. On Wednesday, October 23, 2013 4:41:46 AM UTC-4, Jayakumar Bellie wrote: When you send the