[web2py] Re: web2py with js framework

2017-08-12 Thread 黄祥
@ mirek thanks for the pointer, that's what i learned from scaffold app, need to remove the unnecessary thing like whoosh, so that i can focus to learn the logic what job is handle by whom (web2py or js framework), need to learn start from simplest first, hehe @ val just want to learn how can

[web2py] Re: web2py with js framework

2017-08-12 Thread Ben Lawrence
If you use that scaffold, it needs vue version 1. Current version of vue is version 2.something. On Tuesday, August 8, 2017 at 5:58:18 PM UTC-7, Anthony wrote: > > See if this helps: https://github.com/web2py/scaffold > > On Tuesday, August 8, 2017 at 8:54:12 PM UTC-4, 黄祥 wrote: >> >> is there

[web2py] Re: web2py with js framework

2017-08-12 Thread Val K
Hi, Stifan! What do you mean by "combine"? Are you ready to migrate to SPA or just want to make some awesome components to replace native web2py ones, but staying with client-server-ping-pong-logic? The latter is much easier (to connect with web2py you need only ajax request to get records,

[web2py] Re: web2py with js framework

2017-08-09 Thread Mirek Zvolský
This is not so much complex if you split it into 2 steps. 1) Be familiar with the welcome/ application - this is scaffold application in standard web2py distribution. - Models are called always and create db (database object and sql database structures) + auth (authorization object) + menu. -

[web2py] Re: $.web2py is undefined

2017-08-09 Thread Filipe Reis
Its all in the same page thats what bothers me why I get that. -- 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

[web2py] Re: web2py 2.15.3-stable: trying to re-bind a field?

2017-08-08 Thread Scott Hunter
How would I determine that, and what would I do about it? I upgraded using the "wizard". - Scott On Tuesday, August 8, 2017 at 11:09:42 PM UTC-4, Anthony wrote: > > Is it possible when you upgraded to 2.15.3, you failed to get the updated > pydal that goes with it? > > On Tuesday, August 8,

[web2py] Re: web2py 2.15.3-stable: trying to re-bind a field?

2017-08-08 Thread Anthony
Is it possible when you upgraded to 2.15.3, you failed to get the updated pydal that goes with it? On Tuesday, August 8, 2017 at 10:20:58 PM UTC-4, Scott Hunter wrote: > > I have code in my db.py model to add fields to auth_user: > > auth_extras = [ > Field('paid',

[web2py] Re: web2py with js framework

2017-08-08 Thread 黄祥
thanks for reference anthony, already seen and learned from web2py scaffold (vue + whoosh) but for me, it's complex i want to learn it start from simple first, perhaps there is another simple web2py app with whatever js framework (1 table with 1 field that have CRUD operation or GRID is enough

[web2py] Re: $.web2py is undefined

2017-08-08 Thread Anthony
We probably need to see more code. It is not quite clear when/where you are getting that error. If all the code you have shown below is on the same page, you could not get that error with one tab but not the other, as obviously $.web2py is either defined or not on that page. Anthony On

[web2py] Re: web2py with js framework

2017-08-08 Thread Anthony
See if this helps: https://github.com/web2py/scaffold On Tuesday, August 8, 2017 at 8:54:12 PM UTC-4, 黄祥 wrote: > > is there any simple web2py app with js framework (whatever) that have a > CRUD or GRID example? > want to learn to combine it, but confuse, what is web2py job (define > models,

Re: [web2py] Re: web2py 2.15.3 is OUT

2017-08-08 Thread Richard Vézina
Most of the time ticket unknown is the results of bad permissions settings if I recall.. Richard On Tue, Aug 8, 2017 at 7:01 AM, 黄祥 wrote: > Internal error > > Ticket issued: unknown > > *error shown in terminal (previous version shown in appadmin errors)* >

[web2py] Re: web2py 2.15.3 is OUT

2017-08-08 Thread 黄祥
Internal error Ticket issued: unknown *error shown in terminal (previous version shown in appadmin errors)* ERROR:web2py:Traceback (most recent call last): File "/Users/MacBookPro/site/web2py/gluon/restricted.py", line 219, in restricted exec(ccode, environment) File

[web2py] Re: web2py 2.15.3 is OUT

2017-08-08 Thread 黄祥
already fixed leonel, the error caused by the sqlite database that already exist and fake_migrate settings (appears in terminal console that run web2py) the different behaviour is in previous version an error will recorded in appadmin errors, while in latest version it appears in terminal

[web2py] Re: web2py 2.15.3 is OUT

2017-08-08 Thread Leonel Câmara
stifan can you provide the application causing that unknown ticket error? -- 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

[web2py] Re: web2py 2.15.3 is OUT

2017-08-07 Thread 黄祥
problems from 2.15.1 still exist 1. Minify problems still exist models/db.py response.optimize_js = 'concat,minify,inline' Access : http://127.0.0.1:8000/test/appadmin/d3_graph_model Return : Traceback (most recent call last): File "/Users/MacBookPro/site/web2py/gluon/restricted.py", line 219,

[web2py] Re: web2py 2.15.3 is OUT

2017-08-07 Thread 黄祥
test the new version (web2py_src.zip) with the same code that work in previous version (2.15.2) got an error : Internal errorTicket issued: unknown step i took : cd rm -rf ~/web2py/applications/test cp -R ~/web2py/applications/welcome/

[web2py] Re: web2py 2.15.0b1

2017-08-06 Thread wish7code
Opened a ticket at https://github.com/web2py/web2py/issues/1721 On Thursday, 13 July 2017 09:45:11 UTC+2, Jacinto Parga wrote: > > Great job. Thanks. > > First issue with @mobilize import > > >

[web2py] Re: web2py GUI graph

2017-08-04 Thread Dave S
On Friday, August 4, 2017 at 7:47:40 AM UTC-7, Massimo Di Pierro wrote: > > In the multi user mode, shows how many lines are added/removed over time > by the user. > I'm usually looking at the graph when I'm in between actions on either the appadmin side or the client side (yeah, I know, just

[web2py] Re: web2py GUI graph

2017-08-04 Thread Massimo Di Pierro
In the multi user mode, shows how many lines are added/removed over time by the user. On Monday, 31 July 2017 03:49:36 UTC-5, Dave S wrote: > > In the web2py GUI, what does the "activity" graph show? > > In the case of interest, I'm running with Rocket on W10, and since only > the developer is

[web2py] Re: web2py 2.15.0b1

2017-08-04 Thread wish7code
>First issue with @mobilize import Hey everybody, I'm getting the same error with @mobilize after upgrade. Any ideas how to resolve? Thanks &

[web2py] Re: web2py 2.15.1 is OUT

2017-08-03 Thread Leonel Câmara
Alex please create an issue in github, that's a genuine python 3 bug, exactly the kind we want to find during this experimental python 3 support phase. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

Re: [web2py] Re: web2py 2.15.1 is OUT

2017-08-03 Thread Alex
I tested the latest version 2.15.2 and I've got a problem when accessing ajax post parameters with web2py under Python 3. The client sends a PUT request using jquery like this: $.ajax('', { data: JSON.stringify({ report: report outputFormat: 'pdf' }), type: "PUT",

Re: [web2py] Re: web2py 2.15.1 is OUT

2017-08-03 Thread Anthony
On Wednesday, August 2, 2017 at 11:26:31 PM UTC-4, Richard wrote: > > I recall having conversation about that, I am not sure, I think it > language file or pickle objects that get modify in a no way back manner... > I think only the sessions and error tickets should be affected, as they are

Re: [web2py] Re: web2py 2.15.1 is OUT

2017-08-02 Thread Richard Vézina
I recall having conversation about that, I am not sure, I think it language file or pickle objects that get modify in a no way back manner... But, sure the app code it not affected... I should retrieve this exchange... will try tomorrow. Richard On Wed, Aug 2, 2017 at 9:53 PM, Anthony

Re: [web2py] Re: web2py 2.15.1 is OUT

2017-08-02 Thread Anthony
On Wednesday, August 2, 2017 at 12:26:45 PM UTC-4, Richard wrote: > > Don't forget to copy/paste (backup) you app before you try Python 3, > because there is no way back with the app once you use it under python 3 as > certain stuff are modify by python 3 that let your app unusable with python

Re: [web2py] Re: web2py 2.15.1 is OUT

2017-08-02 Thread Richard Vézina
Don't forget to copy/paste (backup) you app before you try Python 3, because there is no way back with the app once you use it under python 3 as certain stuff are modify by python 3 that let your app unusable with python 2 after. Richard On Wed, Aug 2, 2017 at 9:24 AM, Anthony

[web2py] Re: web2py 2.15.1 is OUT

2017-08-02 Thread Anthony
On Wednesday, August 2, 2017 at 9:13:31 AM UTC-4, bonbe wrote: > > The same thing happened to me. > > Are you saying that has happened with the latest release (2.15.2), or only with 2.15.0b1? Please use Python3. > > web2py should continue to work with Python 2, so there is no need to move to

[web2py] Re: web2py 2.15.1 is OUT

2017-08-02 Thread bonbe
The same thing happened to me. Please use Python3. 2017年7月17日月曜日 21時11分58秒 UTC+9 vince: > > i download from > https://mdipierro.pythonanywhere.com/examples/static/web2py_src.zip > > on first line of changelog it's 2.15.0b1 > > and when i run web2py.py error as below > > Traceback (most

Re: [web2py] Re: web2py crashing

2017-08-01 Thread Kiran Subbaraman
Can you provide more details on the issue you see on a newer thread? The thread you are posting on is almost 5 years old, so the issue you may be facing may not be because of what is listed in this old thread. In any case, this is the code referenced in this old thread:

[web2py] Re: web2py crashing

2017-08-01 Thread Fabiano Faver
I got too many of this error lately. And its getting worse every day. I have no idea what to do to stop these errors. I have to reset rocket every few hours. Was this fix eventually reverted ? Someone knows the file it is this workaround? -- Resources: - http://web2py.com -

[web2py] Re: web2py 2.15.0b1

2017-07-31 Thread Oliver Holmes
Yes, that did the trick! Thank you! Cheers! Oliver Holmes -- 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

[web2py] Re: web2py 2.15.0b1

2017-07-31 Thread Manuel Vio
Hi, I think I had the same problem, in my case it was a DAL constructor parameter changing its value in new web2py versions. Try to revert entity_quoting parameter to False as per this issue ticket I filed: https://github.com/web2py/web2py/issues/1697 See also here:

[web2py] Re: web2py 2.15.0b1

2017-07-31 Thread Oliver Holmes
Hi, just extracted 2.15.2-stable over my 2.14.6-stable, prior to that had stopped all services related to web2py, and now whenever I try to access one of my own tables, not web2pys system tables like auth_user or scheduler_task, I get the following error (same for every attempt to access

[web2py] Re: Web2py and Graph Databases

2017-07-28 Thread vikas mittal
शुक्रवार, 28 जुलाई 2017 को 1:50:06 पूर्व UTC+10 को, Anthony ने लिखा: > > For a novice in web programming like me is there a simple blog post or >> some documentation available where I can read how to setup web2py to work >> with the OrinetDB or neo4j databases? >> > > I'm not aware of any, but

[web2py] Re: web2py admin stopped working after update to 2.15.2 through admin interface

2017-07-27 Thread Leonel Câmara
Seems like you need to update the admin application itself. -- 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

[web2py] Re: Web2py and Graph Databases

2017-07-27 Thread Anthony
> > For a novice in web programming like me is there a simple blog post or > some documentation available where I can read how to setup web2py to work > with the OrinetDB or neo4j databases? > I'm not aware of any, but it should be the same as with any Python program/framework -- just use the

[web2py] Re: Web2py and Graph Databases

2017-07-27 Thread vikas mittal
Hi Anthony, For a novice in web programming like me is there a simple blog post or some documentation available where I can read how to setup web2py to work with the OrinetDB or neo4j databases? I u'stand that DAL does not support these databases, but is it possible to completely ignore the

[web2py] Re: web2py 2.15.2 is OUT

2017-07-22 Thread Massimo Di Pierro
Thank you Tim. On Friday, 21 July 2017 03:42:09 UTC-5, tim.nyb...@conted.ox.ac.uk wrote: > > Actually, this should be simple enough that I can post a fix. > > On Friday, 21 July 2017 09:35:34 UTC+1, tim.n...@conted.ox.ac.uk wrote: >> >> Creating a SQLFORM.factory() from tables, or a combination

[web2py] Re: web2py deployment strategies

2017-07-21 Thread pbreit
There are lots of easy ways to optimize for scaling up. Spend your energy on end user functionality until you run into issues. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: web2py deployment strategies

2017-07-21 Thread Jim S
Only if you're using conditional models. -Jim On Thursday, July 20, 2017 at 6:00:45 PM UTC-5, Alex Glaros wrote: > > any performance advantage to moving controller files out of default.py > into their own file? > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: web2py 2.15.2 is OUT

2017-07-21 Thread tim . nyborg
Actually, this should be simple enough that I can post a fix. On Friday, 21 July 2017 09:35:34 UTC+1, tim.n...@conted.ox.ac.uk wrote: > > Creating a SQLFORM.factory() from tables, or a combination of tables and > fields, now breaks, because the underlying logic assumes the tables are > fields:

[web2py] Re: web2py 2.15.2 is OUT

2017-07-21 Thread tim . nyborg
Creating a SQLFORM.factory() from multiple tables, or a combination of tables and fields, now breaks, because the underlying logic assumes the tables are fields: form = SQLFORM.factory(idb.catering, idb.catering_diet) File "/home/www-data/internal-apps/gluon/sqlhtml.py", line 1922, in factory

[web2py] Re: web2py 2.15.2 is OUT

2017-07-20 Thread 黄祥
yes, you are right, fake_migrate_all=True in db.py fixed the auth_user table exist's problem and the clone problem didn't appear again thanks and best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: web2py 2.15.2 is OUT

2017-07-20 Thread Leonel Câmara
@stifan seems like you need a fake migrate to fix your table files. -- 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

[web2py] Re: web2py deployment strategies

2017-07-20 Thread Alex Glaros
any performance advantage to moving controller files out of default.py into their own file? -- 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

[web2py] Re: web2py 2.15.2 is OUT

2017-07-20 Thread 黄祥
found another error that the same code run well in previous version (different from reported before) Traceback (most recent call last): File "/Users/MacBookPro/site/web2py/gluon/restricted.py", line 219, in restricted exec(ccode, environment) File

[web2py] Re: web2py deployment strategies

2017-07-20 Thread Anthony
On Thursday, July 20, 2017 at 2:45:09 PM UTC-4, Alex Glaros wrote: > Jim, regarding "That said, if you've got 500 tables in your app, you probably > don't want to use the web2py default table instantiation on every request." > > > 1. did you mean to put db.py model tables into categorized sub

Re: [web2py] Re: web2py deployment strategies

2017-07-20 Thread Jim Steil
Yes, the goal is to only load the table definitions that you need. http://web2py.com/books/default/chapter/29/04#markmin_conditional_models we use a form of conditional models along with lazy tables ->

[web2py] Re: web2py deployment strategies

2017-07-20 Thread Alex Glaros
Jim, regarding "That said, if you've got 500 tables in your app, you probably don't want to use the web2py default table instantiation on every request." 1. did you mean to put db.py model tables into categorized sub tables - e.g., accounting_related_tables.py, email_related_tables.py,

Re: [web2py] Re: web2py deployment strategies

2017-07-20 Thread Jim Steil
Our redis server only has 8GB of ram. We load balance primarily for redundancy, not load. We only have about 100 users actively using our system. It is an internal app for our business. -Jim On Thu, Jul 20, 2017 at 11:46 AM, Chinh Dang wrote: > Our app starts small

Re: [web2py] Re: web2py deployment strategies

2017-07-20 Thread Chinh Dang
Our app starts small maybe around 50 tables max, but may grow as more features are being added. Planning to use load balancing and failover. Since you use redis, can you give me a ballpark on the memory usage for the amount of traffic you have? My concern is when the redis host runs out of memory.

[web2py] Re: web2py deployment strategies

2017-07-20 Thread Jim S
My philosophy is to not optimize until you need to. That said, if you've got 500 tables in your app, you probably don't want to use the web2py default table instantiation on every request. Any idea what you're traffic will be like? Are you going to load balance? Our main app has over 150

[web2py] Re: web2py 2.15.2 is OUT

2017-07-20 Thread Leonel Câmara
@stifan here's the fix if you want to apply it on your running code before the new version comes out https://github.com/web2py/pydal/pull/486 -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: web2py 2.15.2 is OUT

2017-07-20 Thread Leonel Câmara
Stifan that error is caused because you're putting a Table in common_fields. Which I didn't expect. I'll fix it. -- 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

[web2py] Re: web2py 2.15.0b1

2017-07-20 Thread villas
Just to leave a note for anyone researching my Firebird issue... I see that Firebird has breaking backward-compatibility in web2py from change introduced here: https://github.com/web2py/pydal/pull/365 Entities are quoted by default which can cause issues. The work around is to do the

[web2py] Re: web2py 2.15.0b1

2017-07-18 Thread villas
Hi Leonel Thanks for your suggestion and I created an issue on pyDal. The quoting tends to work ok with DBs which default to lowercase, unfortunately Firebird is uppercase. As you say, it would probably be better not to use quotes at all because

[web2py] Re: web2py 2.15.0b1

2017-07-18 Thread Leonel Câmara
Villas can you submit an issue to pydal. Seems like a bug if we were not using quotes before we probably should not be using them at all. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: web2py 2.15.0b1

2017-07-18 Thread villas
*Re: Firebird* I just tested this version of web2py and I noticed a problem. See the new authapi.py, line 452: rows = self.db(self.table_group().role == role).select() The* new code* produces this SQL: SELECT "auth_group"."id", "auth_group"."role", "auth_group"."description" FROM

[web2py] Re: web2py 2.15.1 is OUT

2017-07-17 Thread Leonel Câmara
Carlos your problem was already reported: https://github.com/web2py/web2py/issues/1672 Before the next release which will have the fix the workaround is: form = SQLFORM.factory(db.tabela.campo.clone()) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: web2py 2.15.1 is OUT

2017-07-17 Thread Carlos Costa
I have a problem with this version. This does not work anymore: db.define_table('tabela', Field('campo')) form = SQLFORM.factory(db.tabela.campo) I throws this: Traceback (most recent call last): File "C:\Users\carlos.costa\Downloads\web2py\gluon\restricted.py", line 219, in

[web2py] Re: web2py 2.15.1 is OUT

2017-07-17 Thread Leonel Câmara
Vince that seems like a bug in the way you updated web2py you seem to be using the old DAL. -- 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

[web2py] Re: web2py 2.15.1 is OUT

2017-07-17 Thread vince
i download from https://mdipierro.pythonanywhere.com/examples/static/web2py_src.zip on first line of changelog it's 2.15.0b1 and when i run web2py.py error as below Traceback (most recent call last): File "./web2py.py", line 21, in import gluon.widget File

[web2py] Re: Web2py like clone in Java?

2017-07-16 Thread Rimantas Nedzinskas
Hi, Take a look at cuba-platform (www.cuba-platform.com) You'll find all the features you have listed and much more. On Friday, October 15, 2010 at 12:38:19 AM UTC+1, DJ wrote: > > Hello web2py people, > > I was in a discussion recently telling my friend how great Web2Py was > for programmer

[web2py] Re: Web2py like clone in Java?

2017-07-15 Thread Joe Barnhart
As long as we're adding interesting but obscure and little-used web platforms, I'd like to submit Seaside, the Smalltalk web platform. Just... well... because Smalltalk! -- Joe -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] Re: web2py 2.15.1 is OUT

2017-07-14 Thread Dave S
On Friday, July 14, 2017 at 1:12:39 AM UTC-7, Dave S wrote: > > > > On Thursday, July 13, 2017 at 6:20:21 PM UTC-7, Dave S wrote: >> >> >> >> On Thursday, July 13, 2017 at 2:43:57 PM UTC-7, Anthony wrote: >>> >>> Are you saying that used to work but doesn't any longer? >>> >>> >> There are 3

[web2py] Re: web2py 2.15.1 is OUT

2017-07-14 Thread Dave S
On Thursday, July 13, 2017 at 5:17:11 PM UTC-7, Leonel Câmara wrote: > > Note this is deprecated: > > row = db().select(max) > > Calling db() like that without a query will break common filters for > instance. > Do we need another pull request on the book, since the examples are there? (They

[web2py] Re: web2py 2.15.1 is OUT

2017-07-14 Thread Dave S
On Thursday, July 13, 2017 at 6:20:21 PM UTC-7, Dave S wrote: > > > > On Thursday, July 13, 2017 at 2:43:57 PM UTC-7, Anthony wrote: >> >> Are you saying that used to work but doesn't any longer? >> >> > There are 3 examples in the book at the link. They work in 2.14.6 using > -S (and I did

[web2py] Re: web2py 2.15.1 is OUT

2017-07-13 Thread lyn2py
Anthony, pls see https://groups.google.com/d/msg/web2py/h4b4xz2NzNM/QHSoRfrcCAAJ If we put double quotes on the table name, which happens to not be there for *aggregates* and *distinct* then the sql query will work. On Friday, July 14, 2017 at 5:43:57 AM UTC+8, Anthony wrote: > > Are you

[web2py] Re: web2py 2.15.1 is OUT

2017-07-13 Thread lyn2py
Thank you Anthony. I always appreciate your input. I recall using the aggregates max() and count() before and they worked fine following the book. That was quite long ago. However, this time, I did not try on the "old" web2py version. I upgraded to 2.15.1 and continued to code in it. Using

[web2py] Re: web2py 2.15.1 is OUT

2017-07-13 Thread Dave S
On Thursday, July 13, 2017 at 2:43:57 PM UTC-7, Anthony wrote: > > Are you saying that used to work but doesn't any longer? > > There are 3 examples in the book at the link. They work in 2.14.6 using -S (and I did cut-n-paste to check). > How about db(db.table).select(max)? > > Anthony >

[web2py] Re: web2py 2.15.1 is OUT

2017-07-13 Thread lyn2py
Thank you Leonel, I actually have a very complex query, and it ran into the error I mentioned. In my query I have: db(query).select(other_fields, aggregate, groupby=...etc..., orderby=...etc ...) and I ran into the error. So I tried to identify if it was my complex query throwing the error, my

Re: [web2py] Re: web2py 2.15.1 is OUT

2017-07-13 Thread lyn2py
No I am not using the rname feature On Friday, July 14, 2017 at 2:26:57 AM UTC+8, Richard wrote: > > Are you using rname feature? > > If so, the issue may need to be further investigate as why SELECT DISTINCT > ON (TABLE_of_sites.title) is not double quoted and all the other table_name > and

[web2py] Re: web2py 2.15.1 is OUT

2017-07-13 Thread Leonel Câmara
Note this is deprecated: row = db().select(max) Calling db() like that without a query will break common filters for instance. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: web2py 2.15.1 is OUT

2017-07-13 Thread Anthony
Are you saying that used to work but doesn't any longer? How about db(db.table).select(max)? Anthony On Thursday, July 13, 2017 at 1:16:31 PM UTC-4, lyn2py wrote: > > I'm using a simple query to get aggregate: > > max = db.table.date.max() > row = db().select(max) > > Just following the example

Re: [web2py] Re: web2py 2.15.1 is OUT

2017-07-13 Thread Richard Vézina
Are you using rname feature? If so, the issue may need to be further investigate as why SELECT DISTINCT ON (TABLE_of_sites.title) is not double quoted and all the other table_name and field instance are... So maybe the flaw is somewhere in the escaping related to rname feature... Richard On

[web2py] Re: web2py 2.15.1 is OUT

2017-07-13 Thread lyn2py
Following this lead https://stackoverflow.com/questions/34708963/error-missing-from-clause-entry-for-table I discovered that if we add double quotes to the tablename, for all instances of the tablename, like this: "TABLE_of_sites" Then the query will work. On Friday, July 14, 2017 at 1:48:10

[web2py] Re: web2py 2.15.1 is OUT

2017-07-13 Thread lyn2py
Table code: db.define_table('TABLE_of_sites', Field('site_id', 'reference sites'), Field('title', 'string'), Field('date','datetime'), ... Field('updated','datetime', update=request.now, writable=False), format='%(site_id)s' ) In controller: table = db['TABLE_of_sites'] rows =

Re: [web2py] Re: web2py 2.15.1 is OUT

2017-07-13 Thread lyn2py
Here it is... db.define_table('TABLE_of_sites', Field('site_id', 'reference sites'), Field('title', 'string'), Field('date','datetime'), ... Field('updated','datetime', update=request.now, writable=False), format='%(site_id)s' ) There are multiple entries for a particular title, so I want to

Re: [web2py] Re: web2py 2.15.1 is OUT

2017-07-13 Thread Richard Vézina
@lyn2py, seems more a issue with naming in your model than anything else... Can you show us your model? On Thu, Jul 13, 2017 at 1:16 PM, lyn2py wrote: > I'm using a simple query to get aggregate: > > max = db.table.date.max() > row = db().select(max) > > Just following the

[web2py] Re: web2py 2.15.1 is OUT

2017-07-13 Thread lyn2py
I'm using a simple query to get aggregate: max = db.table.date.max() row = db().select(max) Just following the example here http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#sum-avg-min-max-and-len But I ran into this error: Traceback (most recent call last):

[web2py] Re: web2py 2.15.1 is OUT

2017-07-13 Thread Anthony
On Thursday, July 13, 2017 at 1:03:31 PM UTC-4, Massimo Di Pierro wrote: > > @Anthony, > > could you provide a simple example? > model: db.define_table('mytable', Field('name'), Field('photo', 'upload')) controller: def main_page(): return dict() def form_component(): return

[web2py] Re: web2py 2.15.1 is OUT

2017-07-13 Thread Massimo Di Pierro
@Anthony, could you provide a simple example? Massimo On Tuesday, 11 July 2017 15:19:58 UTC-5, Anthony wrote: > > One new feature is that in modern browsers (that support FormData), web2py > Ajax components now support file uploads out of the box (no need for > third-party plugins). > >

[web2py] Re: web2py 2.15.0b1

2017-07-13 Thread Jacinto Parga
Great job. Thanks. First issue with @mobilize import from gluon.contrib.user_agent_parser import mobilize El miércoles, 5 de julio de 2017,

[web2py] Re: Web2py like clone in Java?

2017-07-13 Thread pbreit
Check out https://grails.org/ -- 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] Re: web2py 2.15.1 is OUT

2017-07-11 Thread Anthony
One new feature is that in modern browsers (that support FormData), web2py Ajax components now support file uploads out of the box (no need for third-party plugins). Anthony On Monday, July 10, 2017 at 5:40:08 PM UTC-4, Massimo Di Pierro wrote: > > It took a year. Thanks to everybody who

[web2py] Re: web2py 2.15.0b1

2017-07-10 Thread kato
Hi. I found a problem with python3. File ".../web2py/gluon/validators.py", line 455, in options items = [(k, self.labels[i]) for (i, k) in enumerate(self.theset)] File ".../web2py/gluon/validators.py", line 455, in items = [(k, self.labels[i]) for (i, k) in enumerate(self.theset)]

Re: [web2py] Re: web2py 2.15.0b1

2017-07-10 Thread Richard Vézina
Sorry I was wrong... I miss read result I can't get slow result again... On Mon, Jul 10, 2017 at 12:45 PM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > Hello, > > Welcome is pretty slow 500+ ms compare to 32 ms for 2.14.6?? > > Richard > > On Mon, Jul 10, 2017 at 12:30 PM, Paolo

Re: [web2py] Re: web2py 2.15.0b1

2017-07-10 Thread Richard Vézina
Hello, Welcome is pretty slow 500+ ms compare to 32 ms for 2.14.6?? Richard On Mon, Jul 10, 2017 at 12:30 PM, Paolo Valleri wrote: > Massimo, regarding minification see https://github.com/web2py/ > web2py/pull/1658, hopefully it fixed the reported issue. > > > On

[web2py] Re: web2py 2.15.0b1

2017-07-10 Thread Paolo Valleri
Massimo, regarding minification see https://github.com/web2py/web2py/pull/1658, hopefully it fixed the reported issue. On Monday, July 10, 2017 at 10:28:44 AM UTC+2, Massimo Di Pierro wrote: > > Thanks for reporting these issues. > > I think except for minification they have all been resolved.

[web2py] Re: web2py 2.15.0b1

2017-07-10 Thread Massimo Di Pierro
Thanks for reporting these issues. I think except for minification they have all been resolved. and a new beta version is released. On Thursday, 6 July 2017 22:37:02 UTC-5, 黄祥 wrote: > > the error traceback about routes in application is fixed with > *applications/test/routes.py* > from

[web2py] Re: Web2py Cron depreciado ?

2017-07-10 Thread Massimo Di Pierro
You can still use the system cron but we recommend the scheduler. The scheduler makes sure that two execution of the same task do not overlap. for example if a task is supposed to run every minute but the one running 3:21 has not finished by 3:22, we do not start it again until finished, to

[web2py] Re: Web2py Cron depreciado ?

2017-07-08 Thread Leonel Câmara
I'm Portuguese actually :) but we had a few good Brazilian contributors in the past and I'm hoping we get more in the future. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

[web2py] Re: Web2py Cron depreciado ?

2017-07-08 Thread Marlysson Silva
Are you a brazilian developer? If so , a brazilian in core developer of web2py, it's great! .. Em quinta-feira, 6 de julho de 2017 11:49:46 UTC-3, Leonel Câmara escreveu: > > A alternativa é usar o scheduler do web2py ( > http://www.web2py.com/books/default/chapter/29/04#web2py-Scheduler ), >

[web2py] Re: web2py 2.15.0b1

2017-07-07 Thread Dave S
On Friday, July 7, 2017 at 1:55:33 AM UTC-7, Dave S wrote: > > > > On Thursday, July 6, 2017 at 3:29:11 AM UTC-7, Dave S wrote: > [...] > >> For the other, my controller does the usual "form = SQFORM(db.tab2)", where >> tab2 has a field "partof" ref tab1, and a string field I want to get >>

[web2py] Re: web2py 2.15.0b1

2017-07-07 Thread Dave S
On Thursday, July 6, 2017 at 3:29:11 AM UTC-7, Dave S wrote: [...] > For the other, my controller does the usual "form = SQFORM(db.tab2)", where > tab2 has a field "partof" ref tab1, and a string field I want to get > autofocus, so I set the widget, and I set the default value for a boolean

[web2py] Re: web2py 2.15.0b1

2017-07-06 Thread 黄祥
the error traceback about routes in application is fixed with *applications/test/routes.py* from *gluon.*fileutils import abspath from *gluon.*languages import read_possible_languages but the same problem is still exist, (no error occured but the result is not expected), what i expect is

[web2py] Re: web2py 2.15.0b1

2017-07-06 Thread 黄祥
tried routes in applications 1. cp ~/site/web2py/examples/routes.parametric.example.py ~/site/web2py/routes.py 2. cp ~/site/web2py/applications/welcome/routes.example.py ~/site/web2py/applications/welcome/routes.py 3. Start Web2py source ~/site/bin/activate python ~/site/web2py/web2py.py --nogui

[web2py] Re: web2py 2.15.0b1

2017-07-06 Thread 黄祥
Done in pydal issue _before_insert not work when required=True in latest version Done in web2py issue appadmin errors page didn't show detail information admin page, manage button (dropdown) not work (no errors occured) graph model didn't show the erd like in previous version can't use

[web2py] Re: web2py 2.15.0b1

2017-07-06 Thread Donald McClymont
Excellent work with this and lots of new features. No major issues with doing some testing so far - but just sharing an observation that a field definition along the lines of: below will cause an error if you insert a record and it attempts to use the default value. Field('plan_editor',

[web2py] Re: web2py 2.15.0b1

2017-07-06 Thread Paolo Valleri
Hi Stifan, regarding _before_insert open an issue on https://github.com/web2py/pydal with the example you posted for the other issues, open an issue on https://github.com/web2py/web2py Paolo On Thursday, July 6, 2017 at 2:20:25 AM UTC+2, 黄祥 wrote: > > tried to build from scratch with minimal

<    3   4   5   6   7   8   9   10   11   12   >