[web2py] Re: SQLFORM.grid with selectable checkboxes that export CSV files on submit

2017-07-03 Thread Peter
Hi Matt, I'm no expert (only discovered the wonders of the grid in the last couple of weeks) and maybe others will have a better way but I have tested this and it might get you going... (Also you might want to give a little more information on the requirements... Where have you got to? Do t

[web2py] Re: Numpy 1.13.0 renders web2py via apache https irresponsive

2017-07-03 Thread Leonel Câmara
This has nothing to do with web2py, this is an issue between mod_wsgi which uses sub-interpreters and numpy which really doesn't like that and may become deadlocked. The best solution is simply not to use mod_wsgi. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: FOREIGN KEY constraint failed

2017-07-03 Thread Santiago Cartasegna
Go to the database folder backup and delete all the .tables. Perhaps a change was not reflected on the creation of the table. A similar error ocurred to me and it was on the creation of the id's references on the forange. But your code looks ok El lunes, 3 de julio de 2017, 15:50:45 (UTC-3), mo

[web2py] Re: Hosting web2py app on BigRock

2017-07-03 Thread Jim S
Have you gone through the deployment chapter of the book? http://web2py.com/books/default/chapter/29/13/deployment-recipes#Linux-and-Unix Are you using nginx? Apache? If you're not that familiar with hosting environment or Linux administration you might want to check out www.pythonanywhere.com

[web2py] Re: FOREIGN KEY constraint failed

2017-07-03 Thread mostwanted
this is the actual code Santi: db.define_table('government', Field('govName', requires=IS_NOT_EMPTY()), Field('tel', requires=IS_NOT_EMPTY()), Field('email', requires=IS_NOT_EMPTY()), format='%(govName)s', migrate=False,fake_migrate=

[web2py] Re: DAL sqlite vs postgresql: Row Orders are different?

2017-07-03 Thread Joe Barnhart
What he said. But in addition, consider the following: 1. The entire purpose of SQL is to treat data as unordered tables and let you establish a "relationship" between data in different tables, or within a single table. To add "order by" to every SQL select statement is a serious de-optimizat

Re: [web2py] Re: Blockquote in markmin

2017-07-03 Thread Richard Vézina
I don't understand what you mean... This is what in gluon/contrib/markmin : https://github.com/web2py/web2py/blob/master/gluon/contrib/markmin/markmin2html.py For sure it has change over time... I was suggesting to use Blame : https://github.com/web2py/web2py/blame/master/gluon/contrib/markmin/ma

Re: [web2py] Re: Blockquote in markmin

2017-07-03 Thread Martin Weissenboeck
I have found an old thread about the same problem https://mail.google.com/mail/u/0/#search/markmin+blockquote/14a8c05a08025b93 It seems that there are a lot of different versions of markmin2html.py in the web. I have opened issue #1671. It contains a proposal for a solution. Regards, Martin 20

Re: [web2py] Numpy 1.13.0 renders web2py vie apache https irresponsive

2017-07-03 Thread Richard Vézina
I would suggest you to open a issue over github and describe how to reproduce the bug, if you can reproduce it yourself... It may be specific to your code or not, maybe your code isn't working porperly with numpy 1.13.0 so web2py hang apparently... If the issue is really specific to numpy web2py c

Re: [web2py] Re: function lazy_user at ...

2017-07-03 Thread António Ramos
I´m moving my computed fields from db.entities to another table db.entities_wf_fields and then i use db.entities_after_update.append(lambda s,f: update_authors(s,f)) db.entities._after_update.append(lambda s,f: update_readers(s,f)) etc... then def update_authors(set,ufields): record = set.select(

Re: [web2py] Numpy 1.13.0 renders web2py vie apache https irresponsive

2017-07-03 Thread Oliver Holmes
Am Montag, 3. Juli 2017 17:30:07 UTC+2 schrieb Richard: > > You don't mention which web2py version you have in place... > > Sorry, I did forget to mention that. Here goes: 2.14.6-stable+timestamp.2016.05.10.00.21.47 (läuft auf Apache/2.4.10 (Raspbian), Python 2.7.9) Regards, Oliver Holmes --

Re: [web2py] Numpy 1.13.0 renders web2py vie apache https irresponsive

2017-07-03 Thread Richard Vézina
You don't mention which web2py version you have in place... Maybe you can investiguate further what cause the problem, maybe shawdoing?? Richard On Mon, Jul 3, 2017 at 10:45 AM, Oliver Holmes wrote: > To whom it may concern, > > I just finished a lenghty research on why my webserver wouldn't r

Re: [web2py] Re: Blockquote in markmin

2017-07-03 Thread Richard Vézina
Can you identify a commit that trigger the issue you observe or it has always be there?? Can you fix it?? Please submit a PR over github if you can... Richard On Sat, Jul 1, 2017 at 6:57 AM, Martin Weissenboeck wrote: > There is the folloging code at the end of > def parse_table_or_blockquote(

Re: [web2py] Re: function lazy_user at ...

2017-07-03 Thread António Ramos
So should i use instead ? _after_update.append(lambda s,f: function_2_compute_some_fields(s,f)) or will i trigger a recursive update and hang the cpu? regards 2017-06-30 19:35 GMT+01:00 Anthony : > On Friday, June 30, 2017 at 11:45:37 AM UTC-4, Ramos wrote: >> >> Another problem or symptom is th

[web2py] Re: FOREIGN KEY constraint failed

2017-07-03 Thread Santiago Cartasegna
Hello, You should reference the table with the same name that is created so the table sould be like: db.define_table('governmetFormPages', Field('formImage', 'upload'), Field('formTitle',requires=IS_NOT_EMPTY()), Field('formName', 'reference gover

[web2py] Numpy 1.13.0 renders web2py vie apache https irresponsive

2017-07-03 Thread Oliver Holmes
To whom it may concern, I just finished a lenghty research on why my webserver wouldn't respond to https requests anymore. Result is, that the current numpy release (1.13.0) somehow disagrees with web2py. I could not find any error logs or messages anywhere on my system. But the symptom is a pl

[web2py] Re: Rendering SVG files

2017-07-03 Thread Gualter Portella
The files are in the static/images folder. Then I render the pages the usual way by calling appname/controller/function. Em domingo, 2 de julho de 2017 20:39:53 UTC-3, Marlysson Silva escreveu: > > It seem just html problem.. > Or do you are generating the svg by controller ? > > Em domingo, 2 de

[web2py] Re: JSON field with MySQL database

2017-07-03 Thread narcissus
OK, I've tried filtering_out (as described into the book) and ended up with the following error when accessing into the table containing the JSON field object of type 'NoneType' has no len() I think this happens because the problem is not at back-end (field filtering function) but at the 'begi

[web2py] Re: JSON field with MySQL database

2017-07-03 Thread narcissus
Thanks, I'll try. Il giorno giovedì 29 giugno 2017 23:59:03 UTC+2, Anthony ha scritto: > > On Thursday, June 29, 2017 at 12:49:16 PM UTC-4, narcissus wrote: >> >> Thanks for your answer. >> Option 1) In my case I cannot change fields into the original database. >> Option 2) and 3) can you provide

[web2py] Re: FOREIGN KEY constraint failed

2017-07-03 Thread mostwanted
It is the actually code Tony, i just changed it after posting it. The table name was initially *govmntForm* as it is referenced in the *governmetFormPages* table. On Sunday, July 2, 2017 at 7:48:43 PM UTC+2, Anthony wrote: > > Not sure if you're showing your actual code, but the table name is sp