Re: [web2py] Re: web2py 2.0.8 Firebird driver fdb error

On Wed, Sep 26, 2012 at 8:30 PM, Adrian Marius Popa wrote: > > > On Wednesday, September 12, 2012 3:43:15 PM UTC+3, Massimo Di Pierro wrote: >> >> Please open a ticket about this. >> >> On Wednesday, 12 September 2012 07:06:33 UTC-5, Alexei Vinidiktov wrote: >>> >>> I'm trying to use the new fdb d

Re: [web2py] Re: scheduler cannot detect correct application name

This can not happen. Application name is retrieved from the request try to print request.application in one of your pages and see what is going on. On Thursday, September 27, 2012 2:59:46 AM UTC+2, Vincenzo Ampolo wrote: > > On 09/26/2012 03:29 PM, Niphlod wrote: > > If there was, the column

Re: [web2py] How to get geo location?

Geolocation is a W3C API, standard and is adopted for the HTML5. This API defines objects accesibles in JavaScript, so you must to define the script in the view part of your application. There a lot of javascript code about geolocation. A simple may be : http://www.w3schools.com/html/html5_geo

Re: [web2py] How do you I use geo-spatial types in Web2py DAL?

Il 27/09/2012 05:02, Calvin ha scritto: Hi I am a big fan of Web2py and would like to use the DAL for capturing location specific information. I use MySQL as a back-end and would like to understand how I could define a table with MySQL's Spatial Extension data types into the DAL and hopefully

[web2py] How to Enable logging at DAL level ?

Hi, I'm interested in capturing all the inserts/updates and deletes - Especially I want the auth_user performing these operations and the timestamp(s) for the operations. This will be useful in production setup to figure out who modified/deleted specific record in case things go wrong. (When I

[web2py] Send Errors To Email

Dear ALL , Is there a way to make all the error be sent to my email when it happens ? Best regards, --

Re: [web2py] framework benchmarks - web2py surprisingly slow?

Tim, creator or Rocket has not been very responsive recently. Should we revert to cherrypy wsgiserver? On Wednesday, 26 September 2012 18:18:28 UTC-5, Michele Comitini wrote: > > I confirm that is a rocket issue. After a while it starts leaving CLOSE > WAIT sockets around until consuming all av

[web2py] Re: Manually send confirmation email

auth.define_tables(username=False, signature=False) auth.settings.registration_requires_verification = False ### <<< change this to True On Wednesday, 26 September 2012 23:20:43 UTC-5, Bruno Codeman wrote: > > Hi! > > I'm creating a custom registratio

[web2py] unrecoverable internal error

Dear ALL ,, When i try to login i keep getting this page : Internal errorTicket issued: unrecoverable what to do ? Best Regards, --

[web2py] Re: How to Enable logging at DAL level ?

There is no facility to log all the queries ATM, but the functionality to have all things "traced" for all tables (or only for the tables you want to) is embedded in DAL: there are no logs, just "a way" to version records on the tables. http://web2py.com/books/default/chapter/29/06#Record-versi

Re: [web2py] unrecoverable internal error

When I get this error, it is generally caused by wrong files owner. chown -R www-data.www-data web2py Richard On Thu, Sep 27, 2012 at 8:42 AM, Hassan Alnatour wrote: > Dear ALL ,, > > When i try to login i keep getting this page : > > Internal errorTicket issued: > unrecoverable

[web2py] Re: How to Enable logging at DAL level ?

I was able to get the functionality I wanted :) I "traced" the DAL (import pdb - pdb.set_trace()) and realized that "debug" was set to False - Default value. I updated models/db.py as follows : db = DAL('mysql://user:pass@host/db', debug=True) Now all the queries get logged nicely. I understa

[web2py] Re: How to Enable logging at DAL level ?

I learnt something new today. if you need only the statements for the auth_user table it's a little overkill (and a lot les understandable, and you don't know, e.g. who modified the records). I'd stick with table versioning. On Thursday, September 27, 2012 3:10:59 PM UTC+2, Mandar Vaze wrote: >

[web2py] Re: Manually send confirmation email

Massimo, grazie per rispondere. Actually, I'm not using auth.register, I have a table called company, which is the "main entity" in the system. In my form, I have the data from both tables (the user must type the company data and the user data - email, name and password - in the same form), so I

[web2py] Re: how to avoid an overhead

I suppose it depends on whether all the calculations and db accesses are needed for the processing as well as the initial creation. If not, you could do something like: if not request.post_vars: form = a_lot_of_calculations_and_db_accesses() else: form = minimal_form_without_all_the_calc

[web2py] NDB Support

Hey guys, Is there some effort going on (or at least planed) to support NDB on appengine? Thanks! --

Re: [web2py] unrecoverable internal error

Dear Richard , I have restarted the apache and the error is gone , but still i didnt understand the error . Best Regards, On Thu, Sep 27, 2012 at 4:10 PM, Richard Vézina wrote: > When I get this error, it is generally caused by wrong files owner. > > chown -R www-data.www-data web2py > > Ric

Re: [web2py] unrecoverable internal error

Look at the owner of the web2py/ and subfiles and folder, it may be only one file or folder somewhere and depending of the url it not fall on the problem if the wrong owned file is not called... ls -l Richard On Thu, Sep 27, 2012 at 10:18 AM, hasan alnator wrote: > Dear Richard , > > I have res

Re: [web2py] unrecoverable internal error

ls -l -R On Thu, Sep 27, 2012 at 10:26 AM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > Look at the owner of the web2py/ and subfiles and folder, it may be only > one file or folder somewhere and depending of the url it not fall on the > problem if the wrong owned file is not called...

Re: [web2py] Re: Problems with a validation procedure ? - a Canadian postal code !

replaced mine with this one now :) thanks small typos: from gluon.validators import Validator def __init__(self,error_message='invalid!'): On Wed, Sep 26, 2012 at 3:25 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Yes. > > you can do: > > import re > from gluon.validator import V

[web2py] I cannot make ".../[app]/default/user/register " to behave differently !!!

hello web2py users, I have been playing with web2py & python for a few months now ... I am proud of myself with what I have been able to accomplished so far and so quickly ! but I am still learning !... There have been several post regarding the following issue !! and I thought I had figure

[web2py] Smartgrid Add button missing

I just updated to the 2.0.9 (2012-09-26 12:45:50) this morning and now see that all of my Add buttons are missing from all of my smartgrid forms. I've been away for a couple weeks and unfortunately don't remember what version I had before (2.0.6 or greater though). I checked my generated HTML

[web2py] Routes.py causing a server error?

My site hosted on webfaction started returning a 500 internal server error this morning and it looks like it's choking on my routing. What's strange is that it was all working (with no changes made) for quite a while prior to this. My server log shows this at the start of the problem: [Thu Sep

[web2py] Re: I cannot make ".../[app]/default/user/register " to behave differently !!!

> > It always goes to the default web2py user/register What do you mean by it always goes to user/register? Are you talking about the "Register" link in the navbar? If so, yes, the navbar assumes the default setup whereby you have a single user function (though it doesn't have to be called "u

[web2py] Re: Smartgrid Add button missing

I found the problem has to do with the search_widget. I'm overriding the search widget with my own custom one. Doesn't make sense to me that the Add button should be part of the search widget though. I should be able to override the search widget without affecting the add button. -Jim On Th

[web2py] Re: Smartgrid Add button missing

Do your smartgrid forms require you to be logged in? The add buttons won't show unless you're logged in... On Thursday, September 27, 2012 10:14:55 AM UTC-5, Jim S wrote: > > I just updated to the 2.0.9 (2012-09-26 12:45:50) this morning and now see > that all of my Add buttons are missing from

[web2py] Re: Smartgrid Add button missing

Yes, I'm required to login and am logged in. I found the problem and the fix is to insert this line: console.append(add) at at line 1927 of sqlhtml.py. The problem is what I mentioned in the earlier post. If you override the provided search form with your own, the add button is not added to

[web2py] Re: Routes.py causing a server error?

Sorry, found the problem. I was just missing a comma in the list of tuples (sheepish grin). On Thursday, September 27, 2012 11:26:51 AM UTC-4, monotasker wrote: > > My site hosted on webfaction started returning a 500 internal server error > this morning and it looks like it's choking on my rout

[web2py] Re: SQLite NULL value error?

Can you try print or log request.args? On Thursday, 27 September 2012 11:51:21 UTC-5, Alec Taylor wrote: > > Given the model: > > db.define_table( > 'choice_list', > Field('choice', notnull=True, default='Yes', requires=IS_IN_SET(['Yes', > 'Maybe', 'No']))) > > > With the controllers: > >

[web2py] Re: how to avoid an overhead

By 'cache' do you mean a session variable (or several)? Wouldn't that work? On Thursday, September 27, 2012 8:00:59 AM UTC-6, Anthony wrote: > > I suppose it depends on whether all the calculations and db accesses are > needed for the processing as well as the initial creation. If not, you > cou

Re: [web2py] Re: how to avoid an overhead

I think he mean : var_name = cache.ram('var_name', lambda: do_something, time_expire=3600) You can then clear the cache like this : cache.ram.clear(var_name) Richard On Thu, Sep 27, 2012 at 1:27 PM, MichaelF wrote: > By 'cache' do you mean a session variable (or several)? Wouldn't that work

Re: [web2py] Re: how to avoid an overhead

> > var_name = cache.ram('var_name', lambda: do_something, time_expire=3600) > > You can then clear the cache like this : > > cache.ram.clear(var_name) > You can also do: expire = 3600 if request.post_vars else 0 var_name = cache.ram('var_name', lambda: do_something, time_expire=expire) So, wh

[web2py] Re: how to avoid an overhead

On Thursday, September 27, 2012 1:27:42 PM UTC-4, MichaelF wrote: > > By 'cache' do you mean a session variable (or several)? Wouldn't that work? > If the stored values are specific to a given user/session, then yes, the session would be the right place. If they are general values that don't dep

Re: [web2py] Re: I cannot make ".../[app]/default/user/register " to behave differently !!!

Ouppsss ... Anthony, Thank you for the eye opener ! I was so focused on user/ and other things ... I did not even realized that I have not made my own navbar !!! Oh my god ! ... sorry this issue has been resolved in less than 2 minutes ! instead of creating my own navbar and redu

[web2py] Re: SQLite NULL value error?

I am calling the app "test2" and using the url: http://127.0.0.1:8000/test2/default/call/json/push_choice/Yes I cannot reproduce the problem. On Thursday, 27 September 2012 11:51:21 UTC-5, Alec Taylor wrote: > > Given the model: > > db.define_table(

[web2py] Re: Smartgrid Add button missing

I do not have this problem with the trunk version but I looked at the code and found a potential problem with the [add] button in case of custom search_widgets in grid. I fixed it but I cannot push to github until later today (damn firewall!). On Thursday, 27 September 2012 10:46:12 UTC-5, Jim

Re: [web2py] Re: Smartgrid Add button missing

Thanks Massimo, appreciate the promptness. On Sep 27, 2012 2:23 PM, "Massimo Di Pierro" wrote: > I do not have this problem with the trunk version but I looked at the code > and found a potential problem with the [add] button in case of custom > search_widgets in grid. I fixed it but I cannot pus

[web2py] Re: Forms removing data on errors...

Strange. I see the effect (the manifestation of the problem) and I understand your explanation but I do not see the nested textarea. Can you point a particular version that broke this? The strange thing is that widget= SQLFORM.widgets.text.widget should be the default. On Thursday, 27 September

Re: [web2py] Re: Forms removing data on errors...

http://code.google.com/p/web2py/source/detail?r=5ce727c88ab7e99f5d16c26a45facc539679c40b On Thu, Sep 27, 2012 at 9:34 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Strange. I see the effect (the manifestation of the problem) and I > understand your explanation but I do not see the

[web2py] Re: Forms removing data on errors...

Ok fixed. The problem is that field_parent[id] in 2.0.x is pointing to the wrong place. I cannot push for another 2-3hrs. massimo On Thursday, 27 September 2012 14:34:56 UTC-5, Massimo Di Pierro wrote: > > Strange. I see the effect (the manifestation of the problem) and I > understand your expl

Re: [web2py] Re: How to reload a div containing a component

On 26 September 2012 16:10, Anthony wrote: > > No problem. Anyway, you might want to consider the second option, as > web2py_component() handles some setup specific to web2py components, such > as trapping links and forms, displaying flash messages, etc. > This: {{=LOAD('authors', 'publikasiev

[web2py] Re: Version 2.09 wipes source files

Just did a clean install, copied one of the apps over, started on a different port, and it's working fine. :scratches head: ??? On Wednesday, September 26, 2012 1:47:58 PM UTC-7, chicks wrote: > I'm using the embedded Rocket server. Will try another clean install and > see what happens. Tha

[web2py] Re: Help with menu error using web2py 2.0.9

Joe, maybe I understand which is the problem and I have a solution. Please put the attached layout.html in testxjoe/wiews in place of the old one and check if it works. In this latter case, I will submit a patch to issue tracker. Issue summary: Start an application when browser window size is <

[web2py] appadmin.html, only one Database is correctly shown in the table

Its only a small bug, if at all; If there are more than one databases, the table entitled 'Available Databases and Tables' shows only the first db (alphabetically, I guess) in the corresponding HTML - table. Assume a second model: # -*- coding: utf-8 -*- somedb=SQLDB("sqlite://some.db") somed

[web2py] Re: Help with menu error using web2py 2.0.9

Joe, maybe I understand which is the problem and I have a solution. Please put the attached layout.html in testxjoe/views in place of the old one and check if it works. [note:this message has been canceled 3 times from group (security police?). Please rename the extension file to html] In this

[web2py] Re: Version 2.09 wipes source files

Did the following. The ONLY alert being triggered is the final one, so nothing in the if/else statement is evaluting to true. The final one says "data: undefined" function getData() { if (window.ace_editor) { alert("ace"); var data = window.ace_editor.getSession().getValue();

[web2py] TypeError: list indices must be integers, not str

Hello! I have a problem with DAL. I have this table: *cdb.define_table('laptops', * *Field('id_laptop','integer'),* *Field('serial_number','string'),* *Field('id_trademark','integer'),* *primarykey=['i

[web2py] Re: Help with menu error using web2py 2.0.9

Joe, maybe I understand which is the problem and I have a solution. Please put the attached layout.html in testxjoe/wiews in place of the old one and check if it works. In this latter case, I will submit a patch to issue tracker. Issue summary: Start an application when browser window size is <

[web2py] Re: Version 2.09 wipes source files

Dunno why my other posts haven't shown up, but the resolution was to do a clean install of 2.0.9. Leftover extraneous files in the admin app from version 1.99.7? Not sure, but probably a good idea to do a clean install vs. and update over the existing install. On Wednesday, September 26, 2012

[web2py] Re: Help with menu error using web2py 2.0.9

Joe, maybe I understand which is the problem and I have a solution. Please put the attached layout.html in testxjoe/wiews in place of the old one and write me if it works. In this latter case I will submit a patch to issue tracker. Issue summary: Start an application when browser window size is

[web2py] [OT] Has Massimo ever considered a JavaScript framework?

I keep looking at the various JavaScript frameworks and generally come away disappointed in that I fail to grok them. I have really appreciated Web2py because it is very powerful yet very sensible. The JavaScript frameworks I assume are powerful but don't seem very sensible. I'd love to see wha

[web2py] Re: potential problem w db.executesql(sql) not updating table when done during onvalidation process

There are two callbacks: onvalidation and onaccept. They are executed before and after the record is updated by the form submission. If you alter the record on validation, it gets overwritten when the form is accepted. Not sure why adding rows=... fixes the problem. Anyway you can replace your

[web2py] Re: TypeError: list indices must be integers, not str

I tried this from shell and cannot reproduce the problem: >>> db = DAL() >>> db.define_table('laptops', ... Field('id_laptop','integer'), ... Field('serial_number','string'), ... Field('id_trademark','integer'), ...

[web2py] Re: web2py 2.0 DAL no longer usable for mysql stored procedures

Is this issue still open? If so, can you open a ticket about it? Massimo On Monday, 24 September 2012 14:38:14 UTC-5, Yarin wrote: > > > > db.py: > db.define_table('mytable',Field('myfield','string')) > > sproc: > DELIMITER // > CREATE PROCEDURE TestSproc() > BEGIN > SELECT COUNT(*) FROM myta

[web2py] Re: Help with menu error using web2py 2.0.9

it's not a web2py issue, you are having issues with the new scaffolding app and the css running on it. Just copy the welcome app folders "views" and "static" of 1.99.2 over the app you are developing on 2.0.9 . On Thursday, September 27, 2012 11:16:21 PM UTC+2, JoeCodeswell wrote: > > Dear web2p

[web2py] Re: Help with menu error using web2py 2.0.9

Dear Niphlod, Thanks for the suggestion. I'll try that. I also answered my own question about where are the old versions. The last 1.99.x version looks to be 1.99.7 and is found here. http://code.google.com/p/web2py/source/browse/

[web2py] Re: Help with menu error using web2py 2.0.9

It's very strange. I tested my layout.html in several Windows scenarios (windows7, windowsXp sp3) with several browsers (last version of Opera, Firefox, Chrome and IE9) without any issue. I used the last trunk of web2py, not stable version 2.0.9. Anyway, web2py 2.0.9 has topbar menu managed via b

[web2py] How do you change memcache session expiry?

(Using web2py 1.99.7. Running on Ubuntu/EC2 with Elasticache) I've followed the deployment recipe for storing sessions in memcache but they expire after 300 seconds of inactivity. That appears to be because MEMDB doesn't look to pass down a time_expiry, therefore the set() function from gluon

[web2py] Re: NDB Support

i personally hadn't looked at it until you just askedit might be helpful to me if i didn't have to change much (any) of my code. i know i won't get to implementation myself for a while, but i'm sure massimo will take a patch. :) On Thursday, September 27, 2012 7:07:52 AM UTC-7, Felipe Meire

[web2py] Re: Manually send confirmation email

you may be able to use the onaccept handler of auth.register() to add custom processing to auth without too much extra work. you can add extra fields to the auth form, and then do custom processing and let auth do the rest of the work. On Thursday, September 27, 2012 6:24:15 AM UTC-7, Bruno Co

[web2py] Re: Help with menu error using web2py 2.0.9

Joe a last try. I confused web2py versions on my pc. In last trunk of web2py the javascript hover menu funcion has been moved in static/js/web2py_bootstrap.js Here attached new test4joe. Finger crossed. Il giorno giovedì 27 settembre 2012 23:38:26 UTC+2, JoeCodeswell ha scritto: > > Dear Niphlod,

[web2py] Re: web2py 2.0 DAL no longer usable for mysql stored procedures

Done: http://code.google.com/p/web2py/issues/detail?id=1037 On Thursday, September 27, 2012 4:33:37 PM UTC-4, Massimo Di Pierro wrote: > > Is this issue still open? If so, can you open a ticket about it? > > Massimo > > On Monday, 24 September 2012 14:38:14 UTC-5, Yarin wrote: >> >> >> >> db.py: >

[web2py] pathoc: testing web servers with pathological requests

http://corte.si/posts/code/pathod/pythonservers/index.html We should try this. Massimo --

[web2py] Rows to Storage conversion available?

I want to store Rows values in a session variable. I realize I can't store the Rows object directly, so I use rows.to_list(). The problem is that where I used to be able to use attributes on the Rows object (e.g., rows[0].Meet.Name), now I would have to use string keys when I access the list of

[web2py] Re: Rows to Storage conversion available?

While we can do this. I think you try d rows = db().select(cacheable=True) rows will lack update_record and delete_record methods but they should be pickable. Let is know if that works. On Thursday, 27 September 2012 21:26:32 UTC-5, MichaelF wrote: > > I want to store Rows values in a session

[web2py] Re: potential problem w db.executesql(sql) not updating table when done during onvalidation process

little bit of code reshuffling in one line, and it works perfect! Thank you again Massimo. Tremendous help. Order.CCnr_secure.compute = \ lambda row, token=TOKEN: Expression(db,"AES_ENCRYPT('%s','%s')" % ( row.CCnr, token)) On Thursday, September 27, 2012 4:26:01 PM UTC-4, Massimo

[web2py] Re: Rows to Storage conversion available?

No, it doesn't work. The results of the select (with cacheable=True) is a Rows object: Person.id,Person.First_name,Person.Last_name,Person.Address1,Person.Address2,Per son.City,Person.State,Person.Zip,Session.Start_datetime,Session.End_datetime 32,Sue,Clavin,1720 Wood Ave.,,Colorado Springs,CO,80

[web2py] Re: Send Errors To Email

I have written a script that will load the error pickle file and email me parts of it. The thing I had to be careful about was compliance. One of my apps is an ecommerce app. If there is an error during the checkout process, there is a chance that sensitive data may be in the error file. In

Re: [web2py] Re: Rows to Storage conversion available?

This is the same think that happens when we use memcache, redis or cache.disk for Rows objects. --

[web2py] Remember me with custom or alternate login?

Is there an easy way to allow "remember me" functionality with anything but the standard Auth()? I am nearly finished writing my own open authentication class for a project I am working on. I dont see this functionality in the baked Janrain / RPX class either though. Im trying to figure out

Re: [web2py] [OT] Has Massimo ever considered a JavaScript framework?

Please, is there any recipe for using web2py with the dojo toolkit? Thanks On Thu, Sep 27, 2012 at 9:19 PM, pbreit wrote: > I keep looking at the various JavaScript frameworks and generally come > away disappointed in that I fail to grok them. I have really appreciated > Web2py because it is ver

[web2py] Re: Remember me with custom or alternate login?

I think this is all you have to do to enable "remember me" for a particular user: session.auth.expiration = auth.settings.long_expiration session.auth.remember = True So, if you add a "remember me" checkbox to the login form, just check whether it is selected, and if so, run the above two lines

Re: [web2py] [OT] Packpub giving free e-books

I've registered but... it seems that there's a lot of people. I got 503 errors a lot of times > > > --

[web2py] Re: Remember me with custom or alternate login?

Hm. In the case of RPX, the "login form" is actually an iframe. It doesn't get posted to the web2py framework except through a callback URL. My service is similar to janrain, but i need to "link" multiple OAuth services to a singular user account. In my case a button will link to the authori

[web2py] scheduler: signal only works in main thread

After starting python.exe web2py.py -a abc -K secure -X I get this message: Traceback (most recent call last): File "H:\web2py\gluon\shell.py", line 224, in run exec(python_code, _env) File "", line 1, in File "H:\web2py\gluon\scheduler.py", line 506, in loop signal.signal(signal.

Re: [web2py] Re: Rows to Storage conversion available?

OK. we need to rewrite the pickle/unpickle functions. Will try asap. On Thursday, 27 September 2012 23:03:40 UTC-5, rochacbruno wrote: > > This is the same think that happens when we use memcache, redis or > cache.disk for Rows objects. --

[web2py] Re: Remember me with custom or alternate login?

You could include a checkbox or button that sends an Ajax request to store the choice in the session and then look for it there upon login. Or just let the user set the option in their profile (perhaps defaulting to being enabled). Anthony On Friday, September 28, 2012 12:51:37 AM UTC-4, Dave

Re: [web2py] [OT] Packpub giving free e-books

Just grabbed myself a getting started with Ruby On Rails and MongoDB book Note that you can also get the web2py cookbook through this On Fri, Sep 28, 2012 at 2:46 PM, Javier Quarite wrote: > > I've registered but... it seems that there's a lot of people. I got 503 > errors a lot of times > >> >

[web2py] SQLFORM.grid custom search where is the error?

I have this table db.define_table('t', Field('a', type='string'), Field('b', type='string'), ) db.t.insert(a='US', b='Washington') db.t.insert(a='US', b='Rochester') db.t.insert(a='US', b='Los Angeles') db.t.insert(a='US', b='Minneapolis') Now I want to search the items in a grid wit

[web2py] Re: Remember me with custom or alternate login?

As I sit here and think more about it, I am liking the "profile" option. I almost typed that in my first reply. I just need to figure out how to check for the cookie "onlogin". Or does the Auth class do that for me? hmm. I will end up having a pretty involved registration process and I will

Re: [web2py] [OT] Has Massimo ever considered a JavaScript framework?

AngularJS has been gaining a lot of popularity lately. The idea that could make web2py [more] popular, is automatic generating of completely decoupled client-side views in JavaScript+HTML using REST. On Fri, Sep 28, 2012 at 2:22 PM, Ezugworie Ikechukwu wrote: > Please, is there any recipe for us