[web2py] ticket uncoverable while login on 2.2.1 ?

i am getting ticket unrecoverable error while using the auth login on 2.2.1 once in a while. restarting apache will fix it. any idea what's the problem? how do i trace it out? --

[web2py] Problem in deploying ssl certificates to Rocket server.

Hi , I generated CA certificates, private key, server certificate and client certificate using “Simpatica” application developed in web2py. But when I tried to deploy the certificates to rocket server using below command on windows XP machine: D:\web2py2.1.1\web2py>web2py.py --ssl_cert

[web2py] Re: Formatter and values=None problem

Please see my proposal about changing Field to map None values On Tuesday, October 30, 2012 3:44:03 PM UTC-7, Joe Barnhart wrote: > > OK. I will come up with a plan to extend the custom validators and not > break back

Re: [web2py] Re: delete on GAE

so it turns out that GAE itself fails when i pass an iterator over a large list to gae.delete(). so i've tweaked the implementation to not call count, but to still count the number of entries deleted and it seems to be working. suggested patch included in http://code.google.com/p/web2py/issue

Re: [web2py] bootstrap modal and web2py LOAD()

By "the whole page", do you mean the page from where the modal is called or just the contents of the modal itself..? Anyway, I'm using LOAD() to display a form in a Bootstrap modal, the form submits data, data is processed by a function and a result is displayed in the same modal. I'd have to l

[web2py] Re: how to remove an install plug -- wiki

Unless you use it (auth.wiki()) it is disabled. On Thursday, 1 November 2012 18:55:54 UTC-5, patrick moon wrote: > > i'm having a problem with just trying to get web2py to with mssql on the > latest version and the welcome comes with the wiki pluggin insdtalled as a > default. Is there a way to

[web2py] how to remove an install plug -- wiki

i'm having a problem with just trying to get web2py to with mssql on the latest version and the welcome comes with the wiki pluggin insdtalled as a default. Is there a way to delete this? there seem to be no delete button. 127.0.0.1.2012-11-01.16-48-29.12584d3d-101f-4883-a762-2a9ed0f109d4 ('4

Re: [web2py] How to implement multiple filter for grid?

Hi, Niphlod. If I understood correctly, you're saying that ".select(distinct=True)" on a large db does indeed require a lot of resources, but all of the heavy work is done by the server, rather than the client's computer, and that web2py doesn't have an inbuilt way around it. That sort of heavy

[web2py] Re: Import error with 2.2.1

Where is matplotlib installed? On Thursday, 1 November 2012 15:51:14 UTC-5, Neil wrote: > > I just upgraded from 2.1 to 2.2.1, and I can no longer import matplotlib. > I get the following error: > > ImportError: Cannot import module 'matplotlib' > > > Is this related to the custom import? Perhaps

[web2py] Re: Geolocation

I think I have a silly misunderstood with jQuery.post I'm trying to store the latitude and longitude in a db.events table. I haven't found the right way to do this simple thing, This is my view: {{left_sidebar_enabled,right_sidebar_enabled=False,True}} {{extend 'layout.html'}} View events/ent

Re: [web2py] Re: CONTAINS() takes exactly 3 arguments (2 given)

The code is very simple. @auth.requires_login() def searchtalab(): "an ajax wiki search page" return dict(form=FORM(INPUT(_id='keyword',_name='keyword', _onkeyup="ajax('callbacktalab', ['keyword'], 'target');")), target_div=DIV(_id='target')) @auth.requires_

[web2py] bootstrap modal and web2py LOAD()

Hello, Anyone get work bootstrap modal with web2py LOAD() without having the whole page reloaded on embedded form (load component contain a form) submit?? Thanks Richard --

[web2py] Proposal: Explicit mapping of None values in Field object

This proposal solves a problem I have when formatting Field values. I created a custom Validator class which maps the value None into a string (such as "N/A" or "NT"), but the mapping was ignored because the current Field processing provides an early exit if the value of the Field is None, i.e

[web2py] Import error with 2.2.1

I just upgraded from 2.1 to 2.2.1, and I can no longer import matplotlib. I get the following error: ImportError: Cannot import module 'matplotlib' Is this related to the custom import? Perhaps it is the same as issue 1125? --

Re: [web2py] Re: CONTAINS() takes exactly 3 arguments (2 given)

Try to isolate a dummy query the one that pass and the one that not pass... I don't have much time to read all your code... Richard On Thu, Nov 1, 2012 at 4:13 PM, apps in tables wrote: > Hi, > > why is 'contains()' working fine for one table query? and not working for > more than one table quer

Re: [web2py] Re: CONTAINS() takes exactly 3 arguments (2 given)

Hi, why is 'contains()' working fine for one table query? and not working for more than one table query? Any ideas. Regards, Ashraf --

[web2py] Re: session[id]=Storage(id=id) between controllers

> > Because there are exceptions, at the moment your solution solves the > problem, in a next iteration I'll probably solve it differently. > What exceptions ? request.args(0, default=0, cast=int, otherwise=something) does exactly the same thing I described try: int(request.args(0)) excep

Re: [web2py] How to implement multiple filter for grid?

only on the db part. select(distinct=...) sends a different query to the db than select(). It's not web2py that "uniquify" the sets of the record returned to make it distinct. Then. It's true that doing a distinct on a million rows table forces the db to scan through a million of rows but do

Re: [web2py] Re: CONTAINS() takes exactly 3 arguments (2 given)

Hi Richard, yes, the search is working perfect for query based on one table. I am trying to include the details tables in the search. Any special format for the query that is based on more than one table? Regards, Ashraf On Thursday, November 1, 2012 10:28:50 PM UTC+3, Richard wrote: > > >

[web2py] jQuery UI Bootstrap

I was starting to notice some conflict using bootstrap.js and jQueyr UI at the same time and fall on this doing little research... http://addyosmani.github.com/jquery-ui-bootstrap/ Richard --

[web2py] Is there a way to put a grid's search form beneath the column headers of a grid?

In a previous thread, we discussed how to implement multiple search filter fields for a grid. That being done, I'm curious if there's a reasonable way to put the filters (all currently part of a single FO

Re: [web2py] Re: CONTAINS() takes exactly 3 arguments (2 given)

Does it works if you remove one table from you query? Richard On Thu, Nov 1, 2012 at 3:21 PM, apps in tables wrote: > > > I only made the query based on more than one table, and that caused the > problem. > > -- > > > > --

[web2py] Re: CONTAINS() takes exactly 3 arguments (2 given)

I only made the query based on more than one table, and that caused the problem. --

[web2py] Re: CONTAINS() takes exactly 3 arguments (2 given)

I only made the query based on more than one table, and that caused the problem. --

Re: [web2py] How to implement multiple filter for grid?

Regarding the first point, the concern is not that the selector (as defined in the DB model) is instantiated with a huge variety of fields. If I'm not mistaken, if the "distinct" keyword in the select() function is left out, the program literally goes through every entry in the DB that matches t

Re: [web2py] emmet

It nice, but the shortcut are not well choosed I think... They seems to conflict will Linux desktop shortcut. Richard On Thu, Nov 1, 2012 at 2:38 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > http://docs.emmet.io/ > > in case you do not know. This has been in admin stable for a wh

[web2py] Re: CONTAINS() takes exactly 3 arguments (2 given)

I got the same error with version 2.2.1 > Ashraf >> > --

[web2py] Re: CONTAINS() takes exactly 3 arguments (2 given)

I do not know. Anyway, you are using 2.0.9. Can you upgrade to 2.2.1? On Thursday, 1 November 2012 12:07:41 UTC-5, apps in tables wrote: > > Hi, > > I did small changes to the example in the book (ajax search), > > @auth.requires_login() > def searchtalab(): > "an ajax wiki search page" >

[web2py] Re: long load time for scipy package

I believe the session problem is solved. I cannot completely exclude problems with retrieving sessions created with early/different web2py versions. On Thursday, 1 November 2012 12:03:19 UTC-5, lucas wrote: > > On Thursday, November 1, 2012 8:43:12 AM UTC-4, Massimo Di Pierro wrote: >> >> Unless

[web2py] Re: zero='select a value' no longer shows

This code would have never triggered a dropbox. requires = IS_IN_DB(...) # dropbox requires = [IS_IN_DB(...)...] # no dropbox this has been the rule since web2py 1.0. On Thursday, 1 November 2012 11:46:38 UTC-5, Annet wrote: > > I defined the following validator: > > nodeSocialMedia.nodeID.req

[web2py] emmet

http://docs.emmet.io/ in case you do not know. This has been in admin stable for a while --

Re: [web2py] Re: CONTAINS() takes exactly 3 arguments (2 given)

Not sure, but the request.vars.VAR is text type even if your value is integer, so maybe there is a check to do there. Richard On Thu, Nov 1, 2012 at 1:25 PM, apps in tables wrote: > > I got the same error with > > VERSIONweb2py™(2, 2, 1, datetime.datetime(2012, 10, 21, 16, 57, 4), > 'stable') >

[web2py] Re: CONTAINS() takes exactly 3 arguments (2 given)

I got the same error with VERSIONweb2py™(2, 2, 1, datetime.datetime(2012, 10, 21, 16, 57, 4), 'stable') --

[web2py] CONTAINS() takes exactly 3 arguments (2 given)

Hi, I did small changes to the example in the book (ajax search), @auth.requires_login() def searchtalab(): "an ajax wiki search page" return dict(form=FORM(INPUT(_id='keyword',_name='keyword', _onkeyup="ajax('callbacktalab', ['keyword'], 'target');")), targ

[web2py] Re: long load time for scipy package

On Thursday, November 1, 2012 8:43:12 AM UTC-4, Massimo Di Pierro wrote: > > Unless you enabled track_changes(True) this should not be the case. The > package should only be loaded once. Where did you put the package? > hey massimo, i didn't have track_changes(True) anywhere, but your last quest

[web2py] Re: clean up session[id]=Storage(id=id)

Hi, Thanks for providing me with this solution. save "update_time" on session[id] (or elsewhere) whenever session is "used" > and then check... > > if session[id].creation_time and session[id].creation_time > request.now > -datetime > .timedelta(seconds=60): > ...do the cleanup > > Kind r

[web2py] Re: session[id]=Storage(id=id) between controllers

Hi, Thanks for providing me with a solution. > > request.args(0,default=0, cast=int, otherwise=URL(...)) > > PS: if it's recurrent I wonder why you aren't normalizing it already as > with > try: > arg0 = int(request.args(0)) > except: > redirect() > Because there are exceptions, at th

[web2py] zero='select a value' no longer shows

I defined the following validator: nodeSocialMedia.nodeID.requires=[IS_IN_DB(db,'socialMedia.id','%(name)s',zero=T('select a value')),IS_NOT_IN_DB(db(db.nodeSocialMedia.nodeID==request.vars.nodeID),'nodeSocialMedia.socialMediaID',error_message=T('combination node and social media already in d

Re: [web2py] How to implement multiple filter for grid?

Lamps Wish I could be more help with your questions. Here is my take. 1. If you are thinking about having a large list, I would try to avoid that. Maybe your DISTINCT keyword will keep the list small. My thoughts are that a long list (25 entries or more) is not very user friendly and if I had

Re: [web2py] How to implement multiple filter for grid?

I've followed Jim's model in creating my search filter, and it appears to be working beautifully! Just have some questions that I would like to ask. First - I slightly modified the selector code so that entries show up as unique, by adding the "distinct" clause and ordering alphabetically by ca

Re: [web2py] Re: How to create long running tasks?

> > I don't get the "it's not applicable in this case" part. The way you > start them on web2py is the same one you can use with the scheduler > > Does not seem applicable because does not address the problem of > dependent child processes. > Let's not get lost: you have something to st

[web2py] Re: Are there known problems of SQL Server with the built in wiki

Not a solution but for reference: http://stackoverflow.com/questions/851625/foreign-key-constraint-may-cause-cycles-or-multiple-cascade-paths On Thursday, 1 November 2012 09:39:47 UTC-5, Patrick Büchler wrote: > > Dear All, > > I plan to use web2py for an internal wiki. I wanted to use SQL Serve

Re: [web2py] Re: Reading a text file after uploading in a form

Whoops, sent that before completing: Should have been... Sorry, the reports module is my own. It is a directory under the modules directory for that app. this is just my own special code. The important thing to note is that you have to pass the directory name. The important part is this: '%s/%s'

Re: [web2py] Re: Reading a text file after uploading in a form

Sorry, the reports module is my own. It is a directory under the modules directory for that app. this is just my own special code. The important thing to note is that you have to pass the directory name. The important part is this: '%s/%s' % (os.path.join(request.folder,'uploads'), fileName)

[web2py] Re: mail.send transposing "to" and "subject" ; can anybody explain this?

Guys I figured out how to solve this bug ... in my version of web2py 1.99.2 changed in the file "db.py" line: email = auth.settings.mailer to: mail = Mail () Em sexta-feira, 17 de agosto de 2012 18h25min44s UTC-3, Cliff Kachinske escreveu: > > The simple controller says this: > > record = ge

[web2py] Are there known problems of SQL Server with the built in wiki

Dear All, I plan to use web2py for an internal wiki. I wanted to use SQL Server as database, however, when I try to run my application I get: pyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][ODBC SQL Server > Driver][SQL Server]Introducing FOREIGN KEY constraint > 'wiki_page_modified_by

Re: [web2py] Re: How to create long running tasks?

> I don't get the "it's not applicable in this case" part. The way you start > them on web2py is the same one you can use with the scheduler Does not seem applicable because does not address the problem of dependent child processes. > Starting child processes from webserver main process is

[web2py] Re: Reading a text file after uploading in a form

a simple skeleton code (please check for errors): def page_controller(): form = FORM( TABLE ( TR( TD(LABEL('Upload File:')), TD(INPUT(_type='file', name='myfile', id='myfile', requires=IS_NOT_EMPTY())) ), TR( TD(INPUT(_type='submit',_value='Submit')) ) ) ) txt_content[] if form.process().accepted

Re: [web2py] page min height

hmm, interresting... I will have a look, thanks. Richard On Thu, Nov 1, 2012 at 8:31 AM, villas wrote: > Hi Richard, I presume you already saw this? > > http://twitter.github.com/bootstrap/examples/sticky-footer.html > > -- > > > > --

[web2py] Re: How to create long running tasks?

I don't get the "it's not applicable in this case" part. The way you start them on web2py is the same one you can use with the scheduler Starting child processes from webserver main process is never safe because of the problem you're facing. The second you kill the webserver process (or, in

[web2py] Re: How to create long running tasks?

Would be great to use the new scheduler but doesn't seem applicable in this case. I have no difficulty starting these processes. As described in OP, the problem is these are child processes which makes them dependent on the main web2py process. So I was wanting these to be independent processes

[web2py] Re: long load time for scipy package

Unless you enabled track_changes(True) this should not be the case. The package should only be loaded once. Where did you put the package? On Thursday, 1 November 2012 06:32:28 UTC-5, lucas wrote: > > hello one and all, > > i am trying to load the scipy package into one of my apps under web2py >

Re: [web2py] Reading a text file after uploading in a form

where can I download the 'reports' module? I am getting error while calling that module. On Thu, Nov 1, 2012 at 1:12 PM, Jim S wrote: > This is working for me. I have a similar requirement. Select a text file > to be processed and pass it to a separate routine to process the file: > > form = SQ

Re: [web2py] page min height

Hi Richard, I presume you already saw this? http://twitter.github.com/bootstrap/examples/sticky-footer.html --

[web2py] Re: Unescaped single quotes break my json

Hi dlypka, Not sure I was clear. I need to maintain the escaping. My point was this: my data was escaped OK in the controller, but when it arrived in the view, it was not escaped. Something broke the escaping of single-quotes passing between the two. Double quotes are a bit of problem too.

Re: [web2py] Reading a text file after uploading in a form

This is working for me. I have a similar requirement. Select a text file to be processed and pass it to a separate routine to process the file: form = SQLFORM.factory( Field('brillXf1', 'upload', uploadfolder=os.path.join(request.folder,'uploads'), label='Brill XF1 File')) if form.process(

[web2py] Re: Unescaped single quotes break my json

I used this code in my controller: result = '{ "IsLoggedIn": "%s", "resmsg": "%s"}' % (retIsLoggedIn, resmsg) response.headers['Content-Type'] = 'application/jsonp' response.view = 'generic.jsonp' # Using python code in file init/views/generic.jsonp to leave data unescaped return result On We

[web2py] long load time for scipy package

hello one and all, i am trying to load the scipy package into one of my apps under web2py 2.2.1 on centos 6.3. when i load it, like via "from scipy import optimize", under pure python command line, it loads very quickly. however, when i try to load it under a web2py controller it takes a huge

Re: [web2py] Reading a text file after uploading in a form

Nol there is no such requirement.Actually I am able to upload and read a text file by zipping it but for my task I have upload a text file . On Thu, Nov 1, 2012 at 7:24 AM, Johann Spies wrote: > On 31 October 2012 17:45, praveen krishna wrote: > >> Hi, >>For my task I have to upload a text f