Re: [web2py] Re: SQLTABLE(query) produces different SQL than SQLFORM.grid(query)

2012-11-14 Thread Johann Spies
On 15 November 2012 04:04, howesc wrote: > isn't there an option on grid to not show the ID? i know that grid uses > the ID for allowing you to click links to edit and such... > > Yes. It will show only the fields listed in 'fields' if that argument is present. The problem is that it adds the

Re: [web2py] Re: Migrating with postgres

2012-11-14 Thread Johann Spies
I am using the trunk code updated daily on my development computer and recently have had to kill web2py processes manually because of migration issues. I am also using postgresql and this happened regularly while experimenting with temporary tables. Example: I use 'create table x as select ... f

[web2py] REF: lambda table variable passing error

2012-11-14 Thread Teddy Nyambe
Hi, I have the following action in the controller, doing a join to display "office name" and a reference to department of "department name" to which office belongs...but i have an error in the link since I have a modal window am opening to edit/add/delete details...this is the error: 'Row' objec

Re: [web2py] Re: Migrating with postgres

2012-11-14 Thread Richard Baron Penman
I am still on web2py 1.99.4. Perhaps that is the reason. For now my solution was to manually update the postgres database and use fake_migrate to create the corresponding .table files. http://web2py.com/books/default/chapter/29/06#Fixing-broken-migrations I also develop with sqlite and migrations

[web2py] Re: Migrating with postgres

2012-11-14 Thread LightDot
I use postgre on almost all web2py projects and migrations work as expected. I'm not really sure what combination of options are you looking for... I generally recommend a simple approach - during the development, keep migration settings at default. Once the database schema is finalized, turn

[web2py] Importing installed modules

2012-11-14 Thread Richard Penman
I installed a module with pip to: /home/www/lib/python2.6/M2Crypto-0.21.1-py2.6-linux-i686.egg When using python directly I can import this module. How should I help web2py find this? For now I have this in my model: import sys sys.path.append('/home/www/lib/python2.6/M2Crypto-0.21.1-py2.6-linux

[web2py] Migrating with postgres

2012-11-14 Thread Richard Penman
Having trouble migrating with postgres. With fake_migrate=True the the .table files are created. If migrate=True then error: auth_user already exists. Tried all combinations of these and deleting and removing .table files, but no joy. Is web2py meant to support modify the tables with postgres?

[web2py] Re: SQLTABLE(query) produces different SQL than SQLFORM.grid(query)

2012-11-14 Thread howesc
isn't there an option on grid to not show the ID? i know that grid uses the ID for allowing you to click links to edit and such... On Tuesday, November 13, 2012 11:15:17 PM UTC-8, Johann Spies wrote: > > The following code: > > fields = [db.rjoernaal.so, db.rpublisher.pu, db.rpublisher.pi] >

Re: [web2py] Re: Multi-language website with GAE + parameter-based system

2012-11-14 Thread howesc
the error is not obvious to me. :( can you verify that your regex matches your URL? On Tuesday, November 13, 2012 6:01:09 AM UTC-8, David Sorrentino wrote: > > Hi howesc, > > Thanks for your reply! > > I tried to set the regex for my needs, but I guess that I am wrong in > something. > I edited

[web2py] Re: Placing the database of a web2py app on the cloud

2012-11-14 Thread howesc
VP might very well be using an EC2 instance, but his DB might be an RDS instance or something that is not on the EC2 instancethe cross-server connection still needs to be setup in that case as well. :) On Wednesday, November 14, 2012 1:28:26 AM UTC-8, Tim Richardson wrote: > > I'm curious ab

[web2py] Re: How to open a ticket on the web2py itself?

2012-11-14 Thread Tim Richardson
On Thursday, 15 November 2012 01:22:46 UTC+11, Massimo Di Pierro wrote: > > > http://code.google.com/p/web2py/issues/list > > I agree this should be more prominent in the web site. > +1 :) --

Re: [web2py] Re: web2py as Windows service

2012-11-14 Thread Tim Richardson
> use something external, web2py binary and services doesn't really get > along. I use personally the http://nssm.cc/ package and I'm really happy > with that. > I "voted" for removing services support within web2py, the code (as all > code around windows services with python programs) is a c

[web2py] Re: New error after installing 2.2.1 version

2012-11-14 Thread Julien Courteau
Hello Massimo! I send you the complete traceback (see the attach file). Thanks a lot for web2py and your kindness for taking the time to look at that strange problem! -- web2py™ administrative interface Site Edit About Errors Versioning Logout Debug Help E

Re: [web2py] Re: web2py as Windows service

2012-11-14 Thread Derek
The log file should tell you what the issue is. You might also want to look in the windows event logs, it may have more details as to what failed. On Wednesday, November 14, 2012 12:30:38 AM UTC-7, David Sorrentino wrote: > > Hello Derek and Tim, > > First of all thanks for your reply. :) > > @De

[web2py] Re: How do you deal with obsolete uploaded files?

2012-11-14 Thread Cliff Kachinske
You need two functions. The first will get the name of the old upload. The second deletes it. If using FORM or SQLFORM def edit(): form = SQLFORM(db.sometable, somerecord, ...) ## the onvalidation function fires before SQLFORM commits the change but after field validation. if form.pr

[web2py] Error in Facebook Login using OAuth

2012-11-14 Thread juaneduardo
Hi web2py users: I have configure the the auth.settings.login exactly from the book from gluon.contrib.login_methods.oauth20_account import OAuthAccount auth.settings.login_form=OAuthAccount(YOUR_CLIENT_ID,YOUR_CLIENT_SECRET) I have replaced YOUR_CLIENT_ID and YOUR_CLIENT_SECRET from my app setti

[web2py] Re: request args

2012-11-14 Thread Cliff Kachinske
I always just use. * Rows = db(db.bike.id==request.args(0)).select() * This assumes you are constructing the URLs correctly. localhost:8000///tag/1 I never reassign request.args() unless I'm going to use it a lot and want to save some typing. Same with request.vars. On Tuesday, November 13

Re: [web2py] Re: DB insert confusion

2012-11-14 Thread Mike Anson
Thanks very much for your help Niphlod. On Wednesday, 14 November 2012 16:10:35 UTC-5, Niphlod wrote: > > > Yes I understand your point. The reason it is currently like this is >> because if I use your suggestion (which I obviously had originally) >> >> {"id": 1, "method": "savemessage", "params"

[web2py] Re: postgres problem with crud.update

2012-11-14 Thread Cliff Kachinske
It looks like Postgres is trying to cascade your delete and complaining because it can't find a related record. what is mk_taggable_eq? I don't get what you are trying to do there. Why not use the more common usage? form = crud.update(sometable, somerecord ...) return dict(form=form) On Wed

[web2py] auth.wiki( extra=dict() )

2012-11-14 Thread villas
There is this really long thread, but as far as I can see, no one seems to have answered a main question of the OP. https://groups.google.com/d/topic/web2py/r7qMRK2Eir0/discussion The question is: can we please have the 'extra' dict for auth.wiki() so that this can be passed to Markmin? I

Re: [web2py] Re: DB insert confusion

2012-11-14 Thread Niphlod
> Yes I understand your point. The reason it is currently like this is > because if I use your suggestion (which I obviously had originally) > > {"id": 1, "method": "savemessage", "params": { "*message*": > "variableholdingmessage", "*uid*" : "variableholdingmail"}} > > I get message and uid as

[web2py] Re: auth.signature - how to set is_active back to true?

2012-11-14 Thread Cliff Kachinske
Done. Ticket 1165. On Wednesday, November 14, 2012 9:41:31 AM UTC-5, Massimo Di Pierro wrote: > > This may be a bug. It should work in appadmin. Please submit a ticket. > > On Tuesday, 13 November 2012 12:04:54 UTC-6, Cliff Kachinske wrote: >> >> Version 2.0.9 >> >> Using auth.signature, how can I

[web2py] Re: auth.signature - how to set is_active back to true?

2012-11-14 Thread Cliff Kachinske
If it is a bug and is fixed, will I then be able to make it work for end users as well? On Wednesday, November 14, 2012 9:41:31 AM UTC-5, Massimo Di Pierro wrote: > > This may be a bug. It should work in appadmin. Please submit a ticket. > > On Tuesday, 13 November 2012 12:04:54 UTC-6, Cliff Kach

[web2py] Re: Updating profile does not update auth.user for computed field

2012-11-14 Thread Mark Li
Here's the link to the ticket: http://code.google.com/p/web2py/issues/detail?id=1164&thanks=1164&ts=1352926016 On Wednesday, November 14, 2012 6:21:03 AM UTC-8, Massimo Di Pierro wrote: > > Please open a ticket and well' fix this asap. Probably today at the web2py > sprint at PyCon Ar. > > On Mo

[web2py] Re: Problem with web2py on Linux

2012-11-14 Thread samuel bonilla
try : python web2py.py -a admin -i 127.0.0.1 -p 8000 --

Re: [web2py] Re: DB insert confusion

2012-11-14 Thread Mike Anson
Speediest response as ever Niphlod! Yes I understand your point. The reason it is currently like this is because if I use your suggestion (which I obviously had originally) {"id": 1, "method": "savemessage", "params": { "*message*": "variableholdingmessage", "*uid*" : "variableholdingmail"}} I g

[web2py] Re: CodernityDB: pure python, NoSQL, fast DB

2012-11-14 Thread Niphlod
if it supports multiple writes without locking better than Sqlite, I swear I'll port at least the scheduler code to work with it. On Wednesday, November 14, 2012 5:09:48 PM UTC+1, pbreit wrote: > > http://labs.codernity.com/codernitydb/ > --

[web2py] Re: DB insert confusion

2012-11-14 Thread Niphlod
you are using the wrong orderyou have to send something like {"id": 1, "method": "savemessage", "params": { "*message*": "variableholdingmessage", "*uid*" : "variableholdingmail"}} *message* and *uid* are the named parameters to your function def savemessage(*message, uid*) and instead you

[web2py] DB insert confusion

2012-11-14 Thread Mike Anson
Greetings. I have some strange behavior when saving to my DB. Here is my DB schemer: db.define_table('messages', Field ('uid', 'string'), Field ('message', 'text')

[web2py] Re: Very simple issue: redirect on login - auth.settings.login_next

2012-11-14 Thread Anthony
> > If setting auth.user.settings to a URL stopped the bit of code that > generates _next when default/user/register is 'called' then it would seem > to fit in with developers expectations. > Keep in mind, currently it is possible to enable referrers (i.e., the _next parameter in the URLs) wh

[web2py] Re: flash obtained during not entering a value

2012-11-14 Thread Paolo Caruccio
Important advise: use the book as first help. It is a precious information source. From http://web2py.com/books/default/chapter/29/07?search=validators#Validators Built-in validators have constructors that take an optional argument: IS_NOT_EMPTY(error_message='cannot be empty') error_message

Re: [web2py] Re: Getting error near "interval_time": syntax error

2012-11-14 Thread Paolo Caruccio
Please try: query = Expression(db,"interval_time < (strftime('%M','now') - strftime('%M', updated_on))") On the page suggested by Niphlod we read: Compute the number of seconds between two dates: SELECT strftime('%s','now') - strftime('%s','2004-01-01 02:34:56'); So by replacing '%s' with '%

[web2py] Re: flash obtained during not entering a value

2012-11-14 Thread dantuluri jaganadha raju
please reply as soon as possible On Friday, October 12, 2012 9:37:00 AM UTC+5:30, dantuluri jaganadha raju wrote: > > Hi, > I am getting "enter a value"(with red colored back > ground) when not entering any data to field of table (to which i made > constraint IS_NOT_NULL). H

[web2py] Re: Very simple issue: redirect on login - auth.settings.login_next

2012-11-14 Thread peter
You are not the only person to have wasted a lot of time on this issue. There iso many issues that the Web2py team are excellent on, but this is not one of them. 'auth.navbar(referrer_actions=None)' Also did not work for me with 2.2.1 however putting 'auth.next = None' did work. In the battl

Re: [web2py] change database via class?

2012-11-14 Thread tom h
ah, didn't know there was a technical name. yes, i believe that is what i'm trying to do here. i like to a degree the web2py DAL structure gearing more towards a "controller" class, but i would still like to have business objects as classes also, that will be acted upon by controller classes.

[web2py] CodernityDB: pure python, NoSQL, fast DB

2012-11-14 Thread pbreit
http://labs.codernity.com/codernitydb/ --

Re: [web2py] OperationalError: database is locked

2012-11-14 Thread Mike Anson
I do indeed have greater than 3.7 so I'll see if that prevents the locking. So far so good although it was very sporadic and the scheduler ran over 70 times before it crapped out before adding the line you suggested. Thanks again for your responses. -Mike On Wednesday, 14 November 2012 00:11:4

Re: [web2py] Trouble with JQuery UI - use 1.8.24 not what ships

2012-11-14 Thread LightDot
Note, jQuery and jQuery UI have separate versions. jQuery UI is not included or used in web2py welcome app, there is just a commented link in the code, if I recall correctly. On Wednesday, November 14, 2012 3:44:17 PM UTC+1, Massimo Di Pierro wrote: > > I upgraded to jQuery 1.8.2 which appear to

Re: [web2py] change database via class?

2012-11-14 Thread Vinicius Assef
Are you trying to implement the Business Object pattern, Tom? On Wed, Nov 14, 2012 at 12:54 PM, tom h wrote: > hi, > > thanks i'll take a look at the hasattr(). > > that's not exactly what i mean. the difference is having a model class that > represents a real-world application, vs using the T

Re: [web2py] change database via class?

2012-11-14 Thread tom h
hi, thanks i'll take a look at the hasattr(). that's not exactly what i mean. the difference is having a model class that represents a real-world application, vs using the Table class to make database updates. in your example there, Product(1) is getting a record set, and to insert, one need

[web2py] Re: Git Push ignores .gitignore

2012-11-14 Thread Massimo Di Pierro
This is still listed as an experimental feature. We use some some help fixing it. On Tuesday, 13 November 2012 16:24:17 UTC-6, dhmorgan wrote: > > I don't know if this is a bug or not: > > I added an application to my site using the admin console's 'upload from > git repository' function. The r

Re: [web2py] Trouble with JQuery UI - use 1.8.24 not what ships

2012-11-14 Thread Massimo Di Pierro
I upgraded to jQuery 1.8.2 which appear to be the latest stable. On Tuesday, 13 November 2012 12:49:56 UTC-6, Richard wrote: > > jQuery UI 1.9.1 is the last stable... I use it with web2py without trouble. > > I had experiment little glitch with 1.8.24 > > Also, I usually download jQuery build and

[web2py] Re: auth.signature - how to set is_active back to true?

2012-11-14 Thread Massimo Di Pierro
This may be a bug. It should work in appadmin. Please submit a ticket. On Tuesday, 13 November 2012 12:04:54 UTC-6, Cliff Kachinske wrote: > > Version 2.0.9 > > Using auth.signature, how can I resent is_active back to true? > > In appadmin I can see the records where is_active is set to False, and

[web2py] Re: Empty "db stats" and "db tables" in response.toolbar() despite database connection - MySQL

2012-11-14 Thread Massimo Di Pierro
Any chance you can try trunk? I remember we made some changes about it recently because of a bug. On Tuesday, 13 November 2012 11:01:51 UTC-6, Maciej Kwiecień wrote: > > Dear All, > > I'm using 2.2.1 version on Apache 2.2.19 with ssl, on Windows 7 (64 bit). > The database engine is MySQL. > >

[web2py] Re: REF: Programmatically assign args to LOAD

2012-11-14 Thread Massimo Di Pierro
Not using LOAD but you can check the code LOAD generates and easily tweak that. On Tuesday, 13 November 2012 06:14:15 UTC-6, software.ted wrote: > > Hi, > > I am trying to find out if its possible using javascript assigning > args to the LOAD when button is clicked as follow: > > View: > > my

[web2py] Re: Cannot import module 'lpod'

2012-11-14 Thread Massimo Di Pierro
Moreover. Where is lpod? How was it installed? On Wednesday, 14 November 2012 08:26:09 UTC-6, Massimo Di Pierro wrote: > > Does it work if you simply do: import lpod.document ? > > > On Tuesday, 13 November 2012 04:37:43 UTC-6, omicron wrote: >> >> With web2py 1.99.7 this import was Ok : >>

[web2py] Re: Cannot import module 'lpod'

2012-11-14 Thread Massimo Di Pierro
Does it work if you simply do: import lpod.document ? On Tuesday, 13 November 2012 04:37:43 UTC-6, omicron wrote: > > With web2py 1.99.7 this import was Ok : > import lpod.document as oodoc > > But with version 2.2.1, I have this error : > File "/home/myhome/Applications/web2py/gluon/cust

[web2py] Re: How to open a ticket on the web2py itself?

2012-11-14 Thread Massimo Di Pierro
http://code.google.com/p/web2py/issues/list I agree this should be more prominent in the web site. On Tuesday, 13 November 2012 03:42:28 UTC-6, Maciej Kwiecień wrote: > > Regards, > > After spending significant amount of time on futile searching on the > Internet, Google Groups and web2py book

[web2py] Re: Updating profile does not update auth.user for computed field

2012-11-14 Thread Massimo Di Pierro
Please open a ticket and well' fix this asap. Probably today at the web2py sprint at PyCon Ar. On Monday, 12 November 2012 22:40:14 UTC-6, Mark Li wrote: > > I am currently using auth.profile() for a form where users can update > their information. I have an 'upload' field for images, and a comp

[web2py] Re: New error after installing 2.2.1 version

2012-11-14 Thread Massimo Di Pierro
The error is that here: (self=, message='User %(id)s Logged-in', symbols=("",)) should be (self=, message='User %(id)s Logged-in', symbols="") Yet I do not know why this happens to you. It does not happen to me. Can you post the complete traceback? On Monday, 12 November 2012 19:08:09 UTC-6

Re: [web2py] Re: Some Scheduler questions

2012-11-14 Thread Niphlod
and the log with the debug active says ? --

[web2py] Re: SQLFORM.smartgrid. This is a bug?

2012-11-14 Thread Jose
Here's the answer: https://groups.google.com/forum/#!msg/web2py/bpNJ8bhDs7Q/2U3IRB18MkMJ José --

[web2py] Re: step-by step instructions installing web2py on a CentOS server with cPanel installed

2012-11-14 Thread LightDot
You're really using a CentOS 4.x server? That's quite old... Any chance you could move to a newer version of CentOS to start with? Preferably CentOS 6.x. Regards, Ales On Wednesday, November 14, 2012 10:18:36 AM UTC+1, Daniele wrote: > > Bump! I'd also like to see a guide on how to do this. > >

Re: [web2py] Re: web2py as Windows service

2012-11-14 Thread David Sorrentino
NSSM is just what I was looking for. Simple and effective. I also agree for the use of third-party software in cases like this. Thank you one more time for your help and availability. Saluti, David On 14 November 2012 14:09, Niphlod wrote: > > > Il giorno mercoledì 14 novembre 2012 11:52:36 UT

Re: [web2py] Problem with fresh install of web2py on Linux

2012-11-14 Thread LightDot
It seems to me that Robert's suggestion might be correct. Anyway, the problem is in your Python environment - you're saying that you use Red Hat 64-bit but no released version of Red Hat comes with Python 2.7.x so I'm assuming you've installed this version of Python yourself. This leads me to c

[web2py] Re: Problem with web2py on Linux

2012-11-14 Thread LightDot
You already opened a thread about this, I suggest continuing there: https://groups.google.com/d/topic/web2py/Ca_BxwYOYz0/discussion Regards, Ales On Tuesday, November 13, 2012 6:44:07 PM UTC+1, gabriele dantona wrote: > > > Hello, I've installed the source code of web2py on Linux Redhat, but whe

[web2py] Re: Some Scheduler questions

2012-11-14 Thread Niphlod
ok, what time does your machine's clock do ? These tasks will start on your local time 2012-11-14 15:07 (-MM-DD HH:MM) --

[web2py] Re: Some Scheduler questions

2012-11-14 Thread Johann Spies
Hallo Niphlod, Thanks for your answers which cleared up some of the muddy areas in my mind. Post all the fields, this is far too little to tell what's wrong. I have recreated those records. Here they are: scheduler_task.id scheduler_task.application_name scheduler_task.task_name

Re: [web2py] Re: web2py as Windows service

2012-11-14 Thread Niphlod
Il giorno mercoledì 14 novembre 2012 11:52:36 UTC+1, David Sorrentino ha scritto: > > Ok, I managed to make it work. > I set the *ip* variable to '127.0.0.1'. > > So, the ActivePython environment made the trick. > Thank you very much for your help Tim. ;) > > Did anyone else try to run web2py as

[web2py] Re: Some Scheduler questions

2012-11-14 Thread Niphlod
> I have entered two functions in /models/scheduler.py and have added > them using: > > from gluon.scheduler import Scheduler > myscheduler = Scheduler(db,dict(nr_arts_per_journal=art_pp, publishers =pbs > )) > > This did not add anything to the table db.scheduler_task. Is that normal? > Yep.

Re: [web2py] OperationalError: database is locked

2012-11-14 Thread www.diazluis.com
greetings. I have the same problem. but sometimes I throw a cache miss. and I do not use cache cleared ... I have not configured .. It had implemented db.executesql ('PRAGMA journal_mode = WAL') error: default.py OperationalError: database is locked + details 10_base_config.py O

Re: [web2py] Some Scheduler questions

2012-11-14 Thread Johann Spies
On 14 November 2012 13:58, villas wrote: > Hi Johann, > > IMO the best way forward is to study the app on github ( > https://github.com/niphlod/**w2p_scheduler_tests > ). > After looking at that you should be able to achieve what you want. > > Thank

Re: [web2py] request args

2012-11-14 Thread Vinicius Assef
Are you passing the argument "1" in your URL? On Tue, Nov 13, 2012 at 9:28 PM, Paul Rykiel wrote: > Hi just learning WEB2py and I have a question: > > why do i get an error on this code > *** This code errors out, but when I replace "tag_no" with 1 for record id > 1, it works, also the variable

Re: [web2py] Problem with web2py on Linux

2012-11-14 Thread Vinicius Assef
Try just: $ python web2py.py And direct your URL to http://localhost:8000 On Tue, Nov 13, 2012 at 3:44 PM, gabriele dantona wrote: > > Hello, I've installed the source code of web2py on Linux Redhat, but when I > do the first call (via web browser) I have this call stack trace: > > test@test0

Re: [web2py] change database via class?

2012-11-14 Thread Vinicius Assef
You may implement this getting your table fields and checking if your class has this attribute with hasattr() (it's a Python builtin function). It should be done in a upper level class, who you should extend. But, maybe you're missing that DAL does exactly what you mean: this mapping between your

Re: [web2py] Some Scheduler questions

2012-11-14 Thread villas
Hi Johann, IMO the best way forward is to study the app on github ( https://github.com/niphlod/w2p_scheduler_tests). After looking at that you should be able to achieve what you want. Regards, D On Wednesday, November 14, 2012 11:53:23 AM UTC, Johann Spies wrote: > > On 14 November 2012 12:55,

Re: [web2py] Some Scheduler questions

2012-11-14 Thread Johann Spies
On 14 November 2012 12:55, Johann Spies wrote: > 3. In the video, the command 'python web2py.py -K ' showd some info > about the runs. I have started the worker and nothing is showing but: > 'starting single-scheduler for "akb"...' > > How do I get the worker to be more verbose? > > OK

Re: [web2py] How to get a filter subset?

2012-11-14 Thread Johann Spies
On 13 November 2012 19:04, John Ho wrote: > For a school admin database, different roles for logged in users: admin, > teachers and staff. I can use using auth_group and auth_membership to > define these roles. > > I have the following table: > > db.define_table( "class", Field("teacher_id", db

Re: [web2py] Re: Getting error near "interval_time": syntax error

2012-11-14 Thread Amit
100% correct :) , now facing problem of replacing the query with sqlite compatible query : MySql query were: *query = Expression(db,"date_sub(now(),interval interval_time minute) > updated_on")* where interval_time field is integer field which will be considered to take interval in minutes for e

Re: [web2py] Problem with fresh install of web2py on Linux

2012-11-14 Thread Roberto Perdomo
El 14/11/2012 07:44, "gabriele dantona" escribió: > > Hello, Hi, > I've installed web2py on Linux Redhat 64bit with Python 2.7.3. > > After starting the server, the first request fails with this stack trace. Anyone can help please? > Thanks > > friol@test:~/web2py> python web2py.py --ip 192.168.

Re: [web2py] request args

2012-11-14 Thread David Sorrentino
Hello Paul, request.args[0] returns a string, and for *Rows = db(db.bike.id==tag_no).select() *you need an integer. Try this: tag_no = int(request.args(0)) > And let me know. Cheers, David On 14 November 2012 00:28, Paul Rykiel wrote: > Hi just learning WEB2py and I have a question: > > why

[web2py] Some Scheduler questions

2012-11-14 Thread Johann Spies
I am for the first time trying to use the scheduler and so far it was unsuccessful :( I have watched the video on vimeo on the scheduler and I suspect that is a bit old. I have read what was written in the book as well as the docstrings in gluon/scheduler.py. I have entered two functions in /

Re: [web2py] Re: web2py as Windows service

2012-11-14 Thread David Sorrentino
Thanks to Niphlod, too. I hadn't seen your post! ;) Cheers, David On 14 November 2012 11:52, David Sorrentino wrote: > Ok, I managed to make it work. > I set the *ip* variable to '127.0.0.1'. > > So, the ActivePython environment made the trick. > Thank you very much for your help Tim. ;) > > D

Re: [web2py] Re: web2py as Windows service

2012-11-14 Thread David Sorrentino
Ok, I managed to make it work. I set the *ip* variable to '127.0.0.1'. So, the ActivePython environment made the trick. Thank you very much for your help Tim. ;) Did anyone else try to run web2py as a Windows service using the .exe install? I'd rather to use the .exe install because in that way I

[web2py] Please help me, add button not work

2012-11-14 Thread Ton Dong
Hi all, I am a newbie in web design. I followed the instructions in the video "Build an online store with web2py" at http://vimeo.com/20768689 I don't know why I can not add any items to cart. Please help me to show where I was wrong. Thank you a lot. ~ Ton Dong The code: - Model: hmw.py # cod

[web2py] Empty "db stats" and "db tables" in response.toolbar() despite database connection - MySQL

2012-11-14 Thread Maciej Kwiecień
Dear All, I'm using 2.2.1 version on Apache 2.2.19 with ssl, on Windows 7 (64 bit). The database engine is MySQL. No matter how my models look like I never get anything in "db stats" and "db tables" info in response.toolbar(). When I explicitly output db._timings in the view, at least 3 queri

[web2py] How to get a filter subset?

2012-11-14 Thread John Ho
For a school admin database, different roles for logged in users: admin, teachers and staff. I can use using auth_group and auth_membership to define these roles. I have the following table: db.define_table( "class", Field("teacher_id", db.auth_user), ...) want a form to create a new class,

[web2py] Re: AJAX form submission with image upload

2012-11-14 Thread Krisha Teja
On Monday, 26 December 2011 22:12:27 UTC+5:30, Yarin wrote: > > @Massimo, this worked for me- thanks a lot. > > I'd suggest making mention of jquery.form.js in the regular book as > well. > > Yarin > > On Dec 25, 1:31 am, Massimo Di Pierro > wrote: > > The only way around this is using thi

[web2py] Problem with web2py on Linux

2012-11-14 Thread gabriele dantona
Hello, I've installed the source code of web2py on Linux Redhat, but when I do the first call (via web browser) I have this call stack trace: test@test01:~/web2py> python web2py.py --ip xxx.xxx.xxx.xxx web2py Web Framework Created by Massimo Di Pierro, Copyright 2007-2012 Version 2.2.1 (2012-10-

[web2py] Please help me, add button not work

2012-11-14 Thread Ton Dong
Hi all, I am a newbie in web design. I followed the instructions in the video "Build an online store with web2py" at http://vimeo.com/20768689 I don't know why I can not add any items to cart, It always 0 items. Please help me to show where I was wrong. Thank you a lot. ~ Ton Dong - Models: h

[web2py] How to open a ticket on the web2py itself?

2012-11-14 Thread Maciej Kwiecień
Regards, After spending significant amount of time on futile searching on the Internet, Google Groups and web2py book itself I'm asking the question I was asking myself from the very beginning: Where to add and browse bugs / issues / tickets about the web2py itself? This place has to exist, bu

[web2py] Re: step-by step instructions installing web2py on a CentOS server with cPanel installed

2012-11-14 Thread Daniele
Bump! I'd also like to see a guide on how to do this. On Friday, January 21, 2011 9:18:12 PM UTC, stargate wrote: > > I as wondering if there is step-by step instructions installing web2py > on a CentOS version 4.x server with cPanel installed. --

[web2py] Re: Retype password: None

2012-11-14 Thread Daniele
Hmm I can't figure out how to get the entropy check on a custom form. I'm using a vanilla Twitter Bootstrap without all the web2py stuff because it was breaking my layout. Is there a way to get password entropy check on custom forms with plain Twitter Bootstrap css files?? On Monday, November

[web2py] request args

2012-11-14 Thread Paul Rykiel
Hi just learning WEB2py and I have a question: why do i get an error on this code This code errors out, but when I replace "tag_no" with 1 for record id 1, it works, also the variable "tag_no" has a 1 as a value when i type in an argument 1 on the end of the URL * def tag(): tag_no =

[web2py] Problem with fresh install of web2py on Linux

2012-11-14 Thread gabriele dantona
Hello, I've installed web2py on Linux Redhat 64bit with Python 2.7.3. After starting the server, the first request fails with this stack trace. Anyone can help please? Thanks friol@test:~/web2py> python web2py.py --ip 192.168.168.131 web2py Web Framework Created by Massimo Di Pierro, Copyright 2

Fw: [web2py] SQLFORM.smartgrid. This is a bug?

2012-11-14 Thread Marco Mansilla
Inicio del mensaje redirigido: Fecha: Tue, 13 Nov 2012 15:27:38 -0300 Desde: Marco Mansilla Para: web2py@googlegroups.com Asunto: Re: [web2py] SQLFORM.smartgrid. This is a bug? still you need to give to orderby the name of the field that you want to order, even when the table has only one fie

Re: [web2py] Re: web2py as Windows service

2012-11-14 Thread Niphlod
nope interfaces is a list of tuples of ip,port,key,cert where the webserver replies . like the -i option on cmdline it helps to let the webserver reply on different ports. I think "interfaces" trumps "ip" and "port" parameters Il giorno mercoledì 14 novembre 2012 11:07:50 UTC+1, David

Re: [web2py] postgres problem with crud.update

2012-11-14 Thread Johann Spies
Hallo Andreij, On 14 November 2012 11:50, andrej burja wrote: > i've made app using wizzard > i addes tags > db.define_table('t_tag', > Field('f_game_id', type='reference t_game', > label=T('Game Id')), > Field('f_name', type='string', > label=T('Name')), > auth.si

Re: [web2py] Re: web2py as Windows service

2012-11-14 Thread David Sorrentino
I just tried with ActivePython 2.7 and it works. I mean, at least the task manager says that the service is running. :) However I do not manage to make web2py work. I am pretty sure that the problem is in my* option.py* file. Now it looks like that: import socket > import os > > ip = socket.gethos

[web2py] Re: Getting error near "interval_time": syntax error

2012-11-14 Thread Niphlod
Il giorno mercoledì 14 novembre 2012 09:51:43 UTC+1, Amit ha scritto: > > Hi, > I am getting error > * near "interval_time": syntax error* > syntax error points to something around "interval_time".. my bet is on date_sub() not supported by sqlite http://www.sqlite.org/cvstrac/wiki/wiki?p=

[web2py] postgres problem with crud.update

2012-11-14 Thread andrej burja
i've made app using wizzard i addes tags db.define_table('t_tag', Field('f_game_id', type='reference t_game', label=T('Game Id')), Field('f_name', type='string', label=T('Name')), auth.signature, format='%(f_game_id)s', migrate=settings.migrate) db.define_ta

[web2py] Re: Placing the database of a web2py app on the cloud

2012-11-14 Thread Tim Richardson
I'm curious about why you wouldn't not just deploy the app on the EC2 instance? --

Re: [web2py] Re: web2py as Windows service

2012-11-14 Thread Tim Richardson
Hi David, for me the service installation has worked every time I've used it ... but that's with the ActivePython 2.7 distribution on the windows boxes, and therefore with a source installation of web2py. My practical advice is go for this set up and see if that fixes the problem. You get a con

[web2py] Getting error near "interval_time": syntax error

2012-11-14 Thread Amit
Hi, I am getting error * near "interval_time": syntax error* Please see the code and traceback below: *In db.py:* db.define_table( 'status', Field('serial_no',requires=IS_NOT_EMPTY()), Field('name',requires=IS_NOT_EMPTY()),

[web2py] change database via class?

2012-11-14 Thread tom h
hi web2py gurus, just out of curiousity, i'd like to create a class (let's say Product) that represents a record in my table "product". right now, i can't figure out how to have the class attributes (p = Product(); p.price) saved to the database without internally having p.__fields_dict__ cont