[web2py] Re: current trunk using memdb results in crash

2014-04-14 Thread pallav
deleting memcache causes a separate issue (https://code.google.com/p/web2py/issues/detail?id=1919) that you may be seeing. Basically, your browser now refers to a session that is not in memory anymore. Web2py looks for the missing key in memdb and crashes. Try clearing out your browser's

[web2py] Re: Broken migration

2014-04-14 Thread pallav
To use fake_migrate, first you have to revert your model definition to the old version (that matches the existing db), run the app. This will make web2py update the table definition file. Now, you can change your models and set fake_migrate to False, and migrate to True. On Sunday, April 13,

[web2py] Re: Why does appadmin have css overflow: hidden in database results?

2014-04-14 Thread User
Yes but with overflow:visible (the default css setting) there are no scroll bars and if the table has enough columns than the browser will show a horizontal scrollbar anyway as part of the browser window (as opposed to with auto showing the scrollbars as part of the div). With auto It just

Re: [web2py] great news: Sphinx Documentation

2014-04-14 Thread Johann Spies
Thanks! On 14 April 2014 02:44, Brian M bmere...@gmail.com wrote: Great job niphlod! -- 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

[web2py] autodelete(?) on computed field

2014-04-14 Thread Marin Pranjić
db.define_table(..., Field('image', 'upload', autodelete=True), Field('thumbnail', 'upload', autodelete=True, compute=create_thumbnail), ...) This is not working because on _before_update/_before_delete callbacks thumbnail is not one of the upload_fields. I am talking about

[web2py] Re: Database compute fields

2014-04-14 Thread horridohobbyist
Are you saying I have to update the price field, regardless of whether it has changed or not?? That's not very logical. On Sunday, 13 April 2014 18:39:51 UTC-4, Anthony wrote: I believe you have to provide the price field in your update as well. -- Resources: - http://web2py.com -

[web2py] Re: current trunk using memdb results in crash

2014-04-14 Thread Sebastian Cambeo
I just discovered a related issue: With session in memcache: Accessing a page repeatedly without being logged in leads to a changing session_id on every request. This destroys the purpose of a session_id completely... As far as I can see this is caused by _try_store_in_db() which fails to

[web2py] Re: Online Manual: Chapter 9: Access Control - Formatting/content issues?

2014-04-14 Thread Seeker
Hi Tim, Any idea how long it will take for caches to clear? The problem still persists :-| On Friday, 11 April 2014 06:40:58 UTC+2, Tim Richardson wrote: it;s been fixed ... just waiting for caches to clear, I think. On Friday, 11 April 2014 00:03:39 UTC+10, DenesL wrote: True,

[web2py] Re: great news: Sphinx Documentation

2014-04-14 Thread villas
Thanks Niphlod, this is great! On Sunday, 13 April 2014 16:43:26 UTC+1, Massimo Di Pierro wrote: Great news! We are finally moving to Sphinx. http://web2py.readthedocs.org/en/latest/ Kudos to Simone (niphlod) who single handedly ported all the docstrings and made this possible. Thank

[web2py] Re: Database compute fields

2014-04-14 Thread Anthony
Yes, otherwise the DAL would have to do a db query to retrieve all the records being updated and issue a separate update for each record (since they may not all have the same price value and therefore might require different updated values in the computed field). On Monday, April 14, 2014

[web2py] Re: great news: Sphinx Documentation

2014-04-14 Thread Gour
Massimo Di Pierro massimo.dipie...@gmail.com writes: Great news! We are finally moving to Sphinx. Very nice!! Does it mean the web2py book will also move to reST/Sphinx and/or more support for using reST within web2py? Sincerely, Gour -- One who restrains his senses, keeping them under

[web2py] Re: What does this timeout error in pg8000 mean?

2014-04-14 Thread Mobility
Thanks Derek I changed the driver to psycopg2 and since then I got no problems. Mariano Reingart gave this advice. I would recommend that everybody use psycopg2 in deployment. Thanks. Em sábado, 5 de abril de 2014 10h13min06s UTC-3, Mobility escreveu: Versionweb2py™Version

Re: [web2py] great news: Sphinx Documentation

2014-04-14 Thread Daniel Aguayo
On 13/04/14 12:43, Massimo Di Pierro wrote: Great news! We are finally moving to Sphinx. http://web2py.readthedocs.org/en/latest/ Kudos to Simone (niphlod) who single handedly ported all the docstrings and made this possible. Thank you Simone! Awesome! This is very useful, Thank you

[web2py] Garbled html in online book!?

2014-04-14 Thread Michele Comitini
It's only me? See a few lines below this anchor: http://www.web2py.com/books/default/chapter/29/09/access-control#Renaming-Auth-tables mic -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Garbled html in online book!?

2014-04-14 Thread Seeker
Nope, I have also reported it: https://groups.google.com/forum/?fromgroups#!topic/web2py/0hEVdXMY6BE I think Tim did try to fix it, but the cache seems to be the problem now. On Monday, 14 April 2014 14:59:36 UTC+2, Michele Comitini wrote: It's only me? See a few lines below this anchor:

Re: [web2py] Re: Garbled html in online book!?

2014-04-14 Thread Michele Comitini
thank you Seeker. The cache must have some problem if it taking so long. 2014-04-14 15:04 GMT+02:00 Seeker tmurn...@gmail.com: Nope, I have also reported it: https://groups.google.com/forum/?fromgroups#!topic/web2py/0hEVdXMY6BE I think Tim did try to fix it, but the cache seems to be the

[web2py] Re: Why does appadmin have css overflow: hidden in database results?

2014-04-14 Thread Paolo Caruccio
Now I see your POV. You are speaking about browser's scrollbars and not about div content area scrollbars. The overflow:auto setting has been applied to the container div of the result table for aestethic reasons because such div should have a width of 80% but there is a bug in the code. I

[web2py] Re: SQLFORM.grid and custom edit form

2014-04-14 Thread Tim Price
And what about if I do want to create my own edit form from scratch? How do I get the 'edit' button on the SQLFORM.grid to link to my custom form? On Friday, February 21, 2014 2:32:25 PM UTC+1, Anthony wrote: You can also customize the edit form created by the grid in the usual ways (without

[web2py] Re: Networkx draw graph

2014-04-14 Thread Massimo Di Pierro
matplotlib has two API. A stateless and a statefull. The statefull mode is called matplotlib.pyplot and is it designed for some compatibility with Matlab. Most of the examples posted are with pyplot. The problem is that pyplot does not work for multithreaded web apps because the state is in a

[web2py] Re: current trunk using memdb results in crash

2014-04-14 Thread Massimo Di Pierro
Please open a ticket about this. Is this cachedb specific? Which page did you try it with? On Monday, 14 April 2014 06:16:37 UTC-5, Sebastian Cambeo wrote: I just discovered a related issue: With session in memcache: Accessing a page repeatedly without being logged in leads to a changing

[web2py] Re: Broken migration

2014-04-14 Thread Wonton
Hello and thank you very much for your answers. stifan: I thought that when you set migrate=False the content of db.py file was not executed, but obviously I was wrong. So, if I put the CREATE INDEX in a controller, the performance should be much better? pallav: Thank you very much, I will

Re: [web2py] Nginx/passenger/web2py - 504 Gateway Timeout?

2014-04-14 Thread Richard Vézina
Use unicorn!! Phusion is more work... You can have a look in contrib there is a scrip that help deploy redmine beside web2py with unicorn, so you can derive something for you need from it. It works with 12.04. Richard On Sun, Apr 13, 2014 at 4:52 PM, Krzysztof Socha kszy...@gmail.com wrote:

Re: [web2py] great news: Sphinx Documentation

2014-04-14 Thread Richard Vézina
Simone BIG THANK YOU!! Richard On Mon, Apr 14, 2014 at 8:50 AM, Daniel Aguayo daniel.agu...@gmail.comwrote: On 13/04/14 12:43, Massimo Di Pierro wrote: Great news! We are finally moving to Sphinx. http://web2py.readthedocs.org/en/latest/ Kudos to Simone (niphlod) who single handedly

[web2py] Re: Database compute fields

2014-04-14 Thread horridohobbyist
Sonovagun, you're right! But that rather diminishes the usefulness of 'compute', IMO. On Monday, 14 April 2014 08:15:14 UTC-4, Anthony wrote: Yes, otherwise the DAL would have to do a db query to retrieve all the records being updated and issue a separate update for each record (since

[web2py] array with select in the view

2014-04-14 Thread Multiplery
Hey Guys, i have a few problems with the various view possibilities. The reference manual gives this piece of code as an example for the select in the view: [code] print SELECT('hello', XML('bworld/b'), _class='test', _id=0) select id=0 class=test option value=lt;hellogt;lt;hellogt;/option

[web2py] Re: current trunk using memdb results in crash

2014-04-14 Thread Sebastian Cambeo
Sorry, never mind: I was on 2.9.4 and tried to reproduce it in latest trunk (Apparently it has been fixed since last month) -- 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: Database compute fields

2014-04-14 Thread Anthony
On Monday, April 14, 2014 11:10:28 AM UTC-4, horridohobbyist wrote: Sonovagun, you're right! But that rather diminishes the usefulness of 'compute', IMO. Yes, though I suppose the alternative would add a lot of complexity (and potentially inefficiency). Maybe at least when .update_record is

[web2py] Re: current trunk using memdb results in crash

2014-04-14 Thread Sebastian Cambeo
Sorry again the error is still there: I opened an issue: https://code.google.com/p/web2py/issues/detail?id=1922thanks=1922ts=1397493893 -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

Re: [web2py] great news: Sphinx Documentation

2014-04-14 Thread Michele Comitini
Bravo Niphlod! Looks really slick! besides being useful ;-) 2014-04-14 16:00 GMT+02:00 Richard Vézina ml.richard.vez...@gmail.com: Simone BIG THANK YOU!! Richard On Mon, Apr 14, 2014 at 8:50 AM, Daniel Aguayo daniel.agu...@gmail.com wrote: On 13/04/14 12:43, Massimo Di Pierro wrote:

[web2py] httpd internal 500 error -- out of the blue just from typing service httpd restart

2014-04-14 Thread LoveWeb2py
I've done this 100 times. service httpd restart and it works fine I am running web2py with python 2.7 and using the wsgihandler.py with apache. I've checked the error logs and it says [warn] Init: Name-based SSL virtual hosts only work for clients with TLS server name indication support (RFC

Re: [web2py] httpd internal 500 error -- out of the blue just from typing service httpd restart

2014-04-14 Thread LoveWeb2py
Found out what the problem was. I upgraded my OpenSSL and only had permissions to access OpenSSL for apache. I installed it as root and wsgi tries to access one of the files in the OpenSSL folder (which was owned by root). Once I changed ownership back to apache it started working again.

Re: [web2py] httpd internal 500 error -- out of the blue just from typing service httpd restart

2014-04-14 Thread Marco Mansilla
El Mon, 14 Apr 2014 11:28:25 -0700 (PDT) LoveWeb2py atayloru...@gmail.com escribió: I've done this 100 times. service httpd restart and it works fine I am running web2py with python 2.7 and using the wsgihandler.py with apache. I've checked the error logs and it says [warn] Init:

[web2py] possible issue (read bug) with web2py controllers parser

2014-04-14 Thread Richard
Hello, I had pretty weird issue with commented block of code. I was in the process to migrate to 2.9.5 and I had code in controllers file that were not executing at all. I have been searching for wild and finally discover that I had leave an opening triple double quote in dash commented block

[web2py] Re: great news: Sphinx Documentation

2014-04-14 Thread Cliff Kachinske
Thank you Niphlod. You have done Yet Another Good Thing. On Sunday, April 13, 2014 11:43:26 AM UTC-4, Massimo Di Pierro wrote: Great news! We are finally moving to Sphinx. http://web2py.readthedocs.org/en/latest/ Kudos to Simone (niphlod) who single handedly ported all the docstrings and

[web2py] Re: Broken migration

2014-04-14 Thread 黄祥
the the migrate settings is about the define_table affect on the database side (migrate = True) and on the *.table files (fake_migrate=True). there will be a little performance impact, but in terms of efficincy code (because you only need to execute 1 time for create index). So let say about

[web2py] Re: Why does appadmin have css overflow: hidden in database results?

2014-04-14 Thread User
Yes agree I did modify my own appadmin copy but I guess don't see why anyone would want the overflow auto in this context. I understand it's for aesthetic but from my POV it's appadmin so this is not end users using it. My thinking was that if I'm annoyed by it others would be too and we

[web2py] Re: Broken migration

2014-04-14 Thread Wonton
Oks, it's clear to me now. I'll change this. Thank you very much again! On Monday, April 14, 2014 10:47:49 PM UTC+2, 黄祥 wrote: the the migrate settings is about the define_table affect on the database side (migrate = True) and on the *.table files (fake_migrate=True). there will be a little

Re: [web2py] possible issue (read bug) with web2py controllers parser

2014-04-14 Thread Massimo Di Pierro
Please open a ticket about this. I see the problem. On Monday, 14 April 2014 14:45:07 UTC-5, Richard wrote: Hello, I had pretty weird issue with commented block of code. I was in the process to migrate to 2.9.5 and I had code in controllers file that were not executing at all. I have been

[web2py] Re: Networkx draw graph

2014-04-14 Thread Luis Fontes
Thank you very much Massimo. I will check if NetworkX can draw graphs without pyplot. Othercase I will have to draw my graphs from scratch using Figure, Axis, etc. On Monday, April 14, 2014 3:28:43 PM UTC+2, Massimo Di Pierro wrote: matplotlib has two API. A stateless and a statefull. The

[web2py] use executesql results in grid

2014-04-14 Thread Yufei Li
I am doing a quite complicated sql select with selects nested, which I do not know how to create using DAL, so I decided to go with executesql with fields specified. My questions is once I get back results of class 'gluon.dal.Rows' type, is there a way to create a SQLFORM.grid with them? I am

[web2py] DAL: how to populate a (temporary) table from a Rows object without doing the iteration myself

2014-04-14 Thread Carson Little
In other words, I am looking for code like this: #!/usr/bin/env python # -*- coding: utf-8 -*- from gluon import current from gluon.dal import DAL, Field db = DAL('sqlite://storage.db', lazy_tables=True) db.define_table('mytable', Field('myfield')) rows =

[web2py] SSH Using jquery in Controller or View

2014-04-14 Thread codingerror3
I have a ssh code using javascript. I would like to know whether ssh for a remote server need to be done in view or controller ? I am using jquery because, I want to add remote machine to table and turn link into green / red based on remote server being active. I am completely new to web2py and

Re: [web2py] use executesql results in grid

2014-04-14 Thread Johann Spies
On 14 April 2014 18:35, Yufei Li ymzz...@gmail.com wrote: I am doing a quite complicated sql select with selects nested, which I do not know how to create using DAL, so I decided to go with executesql with fields specified. My questions is once I get back results of class 'gluon.dal.Rows'