[web2py] Re: count record created in a 10 minutes interval

2013-09-22 Thread Niphlod
ehm, actually is a pretty common, perfectly solvable in a relational db. The point in web2py is that there are only hours, minutes, seconds, so 10 minutes is not achievable by web2py without passing a custom expression (that should be like datepart(minutes, the_datetime) / 10 ) However, if the

Re: [web2py] Re: pluralization system problem

2013-09-22 Thread Vladyslav Kozlovskyy
Hi У сб, 2013-09-21 у 09:18 -0700, mcamel пише: Ok. I did so and worked fine. I supposed words needed to be included in translation file once, but in fact, expressions including words has to be included also in the dictionary as if they were words itself. web2py localisation subsystem uses

[web2py] Re: Security question regarding session

2013-09-22 Thread weheh
Thanks, Massimo. Very thorough. Especially the part about multiple sessions going on for same user. Hadn't considered that. Cheers! On Monday, September 16, 2013 2:20:57 PM UTC+8, weheh wrote: How secure is session? I'm considering 2 methods for downloading a file: The first is via an

[web2py] Grouping and counting using sqlform grid

2013-09-22 Thread 黄祥
hi, i want to use grouping and counting using sqlform grid. while i'm searching and learning on this forum i made something like: purchase_order_left = db.purchase_order_header.on(db.purchase_order_header.supplier==db.supplier.id) #purchase_order_left =

Re: [web2py] web2py 2.6.4 is OUT - IMPORTANT

2013-09-22 Thread 黄祥
when i started to code application from scratch using 2.6.4, i realize there is auth user filled with : Id: 1First name: HomerLast name: SimpsonE-mail: homer@web2py.comPassword: ** how can i remove that? p.s. the 2.6.3 version don't have auth.user filled. thanks and best regards, stifan

Re: [web2py] web2py 2.6.4 is OUT - IMPORTANT

2013-09-22 Thread Massimo Di Pierro
Are you sure? That use should not be there but it would be create if you run web2py tests. Web2py should not ship with a database at all. Perhaps this is a bug. Are you using the windows binary or mac binary? Massimo On Sunday, 22 September 2013 08:15:34 UTC-5, 黄祥 wrote: when i started to

Re: [web2py] web2py 2.6.4 is OUT - IMPORTANT

2013-09-22 Thread Massimo Di Pierro
I double checked and I am pretty sure it does not ship with a database at all. You must have run tests before running web2py. I suggest you delete applications/welcome/databases/* welcome.w2p Than start web2py again. On Sunday, 22 September 2013 08:15:34 UTC-5, 黄祥 wrote: when i started to

[web2py] Re: Some forms need to be submitted multiple times.

2013-09-22 Thread Christian Foster Howes
i have noticed that if in the same browser i open the same page with the same form in multiple tabs my stored session data only stores 1 form key, so the most recently loaded tab will submit the form fine, the others will be denied until i reload the page. any chance you have form key

[web2py] Re: Some forms need to be submitted multiple times.

2013-09-22 Thread Massimo Di Pierro
That is by design. Perhaps we should change it. The problem is how not to pollute the session with un-used keys. On Sunday, 22 September 2013 10:53:26 UTC-5, Christian Foster Howes wrote: i have noticed that if in the same browser i open the same page with the same form in multiple tabs my

Re: [web2py] Re: Some forms need to be submitted multiple times.

2013-09-22 Thread Christian Foster Howes
and i don't mind the design at alli can't think of a good reason that a real user would be in this situation. i tend to break things when testing or doing rote admin tasks (with my admin forms not web2py admin) cfh On 9/22/13 9:11 , Massimo Di Pierro wrote: That is by design. Perhaps

[web2py] Admin disabled because too many invalid login attempts

2013-09-22 Thread Pascal
Hello mate, I forgot the password of the https online admin page of my Web2py application and I tried several password. After few attempt it disable the Admin. Please can you let me know how to solve this issue ? Thank you. -- Resources: - http://web2py.com - http://web2py.com/book

Re: [web2py] web2py 2.6.4 is OUT - IMPORTANT

2013-09-22 Thread 黄祥
sure, i run using windows binary. not just auth user, auth group and auth membership is also filled. problem solved following your recommendation, delete welcome.w2p. when i delete applications/welcome/databases/*, the homer simpson is still in auth user. thanks and best regards, stifan --

Re: [web2py] Re: Some forms need to be submitted multiple times.

2013-09-22 Thread szimszon
Hi! I have some apps where I usually do multiple things simultaneously or I have to look at some page for information (page with form too) and copypast to the first. But I have to reload the first page because the single form key. It can be really annoying :( So if it could be change I'm for

Re: [web2py] Re: Some forms need to be submitted multiple times.

2013-09-22 Thread Massimo DiPierro
Please open a ticket. I have an idea about what to do. On Sep 22, 2013, at 12:31 PM, szimszon wrote: Hi! I have some apps where I usually do multiple things simultaneously or I have to look at some page for information (page with form too) and copypast to the first. But I have to reload

Re: [web2py] web2py 2.6.4 is OUT - IMPORTANT

2013-09-22 Thread Massimo Di Pierro
OK. Homer indeed managed to get an account in welcome. This is an error in the build process for the Windows distribution only. It is now fixed and I have reposted web2py_win.zip Thanks for reporting it. On Sunday, 22 September 2013 12:02:33 UTC-5, 黄祥 wrote: sure, i run using windows binary.

Re: [web2py] Re: Some forms need to be submitted multiple times.

2013-09-22 Thread szimszon
http://code.google.com/p/web2py/issues/detail?id=1688 Thanks. 2013. szeptember 22., vasárnap 19:33:22 UTC+2 időpontban Massimo Di Pierro a következőt írta: Please open a ticket. I have an idea about what to do. On Sep 22, 2013, at 12:31 PM, szimszon wrote: Hi! I have some apps where I

[web2py] Trouble Updating to 2.6.4 from 2.5.1

2013-09-22 Thread archeaneon
When I try to update from 2.5.1 to 2.6.4 the admin is no longer operational. Is there any fix for this? I am not sure where the error logs are held. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

Re: [web2py] Trouble Updating to 2.6.4 from 2.5.1

2013-09-22 Thread Roberto Perdomo
What kind of failure you are presenting? 2013/9/22 archean...@gmail.com When I try to update from 2.5.1 to 2.6.4 the admin is no longer operational. Is there any fix for this? I am not sure where the error logs are held. -- Resources: - http://web2py.com - http://web2py.com/book

Re: [web2py] Trouble Updating to 2.6.4 from 2.5.1

2013-09-22 Thread archeaneon
When I try to access the admin, it presents me with an error ticket, but when I press the link for the error ticket, it renders yet another (different) ticket. On Sunday, September 22, 2013 4:48:50 PM UTC-4, Roberto Perdomo wrote: What kind of failure you are presenting? 2013/9/22

[web2py] Unique validation

2013-09-22 Thread Avi A
Hi, 'unique=True' works but 'one' is different from 'One' for the validator. What should I add to prevent it? Thanks. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

Re: [web2py] Trouble Updating to 2.6.4 from 2.5.1

2013-09-22 Thread Massimo Di Pierro
Did you re-start the web server? If so, and you still get errors, could you please send us the ticktes? they are in applications/admin/errors/* On Sunday, 22 September 2013 16:08:07 UTC-5, arche...@gmail.com wrote: When I try to access the admin (127.0.0.1:8000/admin/), it presents me with

[web2py] Re: Unique validation

2013-09-22 Thread Massimo Di Pierro
You can do: requires=(IS_LOWER(), IS_NOT_IN_DB(db,'tablename.fieldname')) So they are always converted in lower case before checking. On Sunday, 22 September 2013 16:14:15 UTC-5, Avi A wrote: Hi, 'unique=True' works but 'one' is different from 'One' for the validator. What should I add to

[web2py] Re: Unique validation

2013-09-22 Thread Avi A
Thank you very much :). On Monday, September 23, 2013 12:23:20 AM UTC+3, Massimo Di Pierro wrote: You can do: requires=(IS_LOWER(), IS_NOT_IN_DB(db,'tablename.fieldname')) So they are always converted in lower case before checking. On Sunday, 22 September 2013 16:14:15 UTC-5, Avi A

[web2py] Re: Unique validation

2013-09-22 Thread Avi A
This doesn't seem to work: db.define_table('t_categories', Field('f_category_name', type='string', notnull=True, label=T('Category Name')), auth.signature, format='%(f_category_name)s', migrate=settings.migrate)

[web2py] deleting the result of a select

2013-09-22 Thread Jonathan Lundell
Suppose I have a list of Row as the result of a select, and I want to delete those records. I can't delete the Set, since it might not be the same rows (the query has a limitby, and more records might have been inserted since I processed the result of the select; I don't want to delete the

[web2py] Re: SQLFORM.grid: how can I return to a page after a custom edit function

2013-09-22 Thread tomt
I thought I'd post the solution I came up with. It turned out to be easier than I thought it would be. Just read the page number from request.vars.page, and pass it in the redirect after the form.accepts. # I define the links in a subroutine. def markup_body(row): page =

[web2py] scheduler help

2013-09-22 Thread Antonis Konstantinos Tzorvas
tried to schedule a task that takes a about 1-2 minutes, but it's always failing in about 20 seconds.. its a module that i am calling from inside a function, which function is available to scheduler. i am creating the task, with appadmin, and from run output i can see that it hangs somewhere

[web2py] Re: web2py 2.6.4 is OUT - IMPORTANT

2013-09-22 Thread IVINH
Sometimes, I have this error, it will disappear when refreshing the page: web2py™Version 2.6.4-stable+timestamp.2013.09.22.01.43.37PythonPython 2.7.3: C:\Python27\python.exe (prefix: C:\Python27)Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. Traceback (most recent call last):

[web2py] dlsym(0x8fe46768, CCKeyDerivationPBKDF): symbol not found ?????

2013-09-22 Thread Brood
Greetings, Just downloaded web2py for max OS X (using 10.6.8) and I get this strange error while trying to start the server - dlsym(0x8fe46768, CCKeyDerivationPBKDF): symbol not found Have tried both the web2py.app and the web2py.py version without successideas? -- Resources: -