[web2py] 'is of type integer but expression is of type character varying'?

I added the "timestamp" field to the table: { *db.define_table("auction_item_bids_lexa",* *Field("bidder"),* *Field("block_size"),* *Field("bid_per_block","integer", default = 0),* *Field("number_of_blocks"),* *Field("timestamp","datetime"),* * ) #CDN-000275* } the started

[web2py] Re: Is there an issue with my web2py install? "can't pickle function objects"

Should be fixed. Can you check? On Thursday, 29 August 2013 15:52:07 UTC-5, Frederick Yankowski wrote: > > I have opened https://code.google.com/p/web2py/issues/detail?id=1655 about > this problem. > > -- --- You received this message because you are subscribed to the Google Groups "web2py-u

[web2py] Re: Starting web2py fails silently with Cygwin python

I think the version in trunk (and the nightly build) does not. On Thursday, 29 August 2013 14:36:03 UTC-5, Razvan Teslaru wrote: > > Interesting; I tried following the solution outlined there (installed > xinit, started X Server, export DISPLAY=:0.0), but the behavior remains > exactly the same.

[web2py] Re: Help with deploying on nginx

http://stackoverflow.com/questions/10748108/nginx-uwsgi-unavailable-modifier-requested-0 its better to build uwsgi from source, so you dont' get caught in this crazy-organized apt packages. On Thursday, August 29, 2013 9:18:45 PM UTC+2, Apple Mason wrote: > > There's a lot of lines but here's a

Re: [web2py] Re: Latest Trunk - problem with auth(session) and login using 'remember me'

*bump* On Thu, Aug 22, 2013 at 4:07 PM, Michele Comitini < michele.comit...@gmail.com> wrote: > Marin, > > I agree there is something wrong there > > > 2013/8/22 Marin Pranjić > >> What's with the line 1018? >> >> >> https://github.com/web2py/web2py/blob/5d67db3bfd15a00403d3e0b94fe9175935d007

[web2py] Re: Logged in dropdown links

Thank you. On Wednesday, August 28, 2013 6:19:28 PM UTC, dirman wrote: > > is it posible to add another link to the logged in dropdown in adding to > the profile,password and logout links? > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group

[web2py] Re: Webhosts for Web2py

You might consider Digital Ocean (just moved there from Amazon) -- $5/month gets you quite a bit, and for an extra $1 you get backups. Data centers in New York, San Francisco, and Amsterdam. Anthony On Tuesday, August 27, 2013 2:11:22 PM UTC-7, Vivek Jha w

[web2py] Re: Is there an issue with my web2py install? "can't pickle function objects"

I have opened https://code.google.com/p/web2py/issues/detail?id=1655 about this problem. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr..

Re: [web2py] Smartgrid line color

Many thanks for your time. I will think about it tomorrorw. 2013/8/29 Roberto Perdomo > Hi António, > > You can use a conditional represent to change the color of the date field > in your outdated record. > > something like: > > 1) db.table.field.represent =lambda value, row: " COLOR='red'>"+v

[web2py] Re: Starting web2py fails silently with Cygwin python

Here is the stack trace: /usr/lib/python2.7/bdb.py(400)run() -> exec cmd in globals, locals (1)() /home/eraztes/web2py/web2py.py(19)() -> import gluon.widget /home/eraztes/web2py/gluon/__init__.py(15)() -> from globals import current /home/eraztes/web2py/gluon/globals.py(21)() -> from ht

[web2py] Re: Logged in dropdown links

Now in trunk, the auth navbar has a "bare" mode that should simplify its customization. For details please see https://github.com/web2py/web2py/pull/186 Il giorno mercoledì 28 agosto 2013 20:19:28 UTC+2, dirman ha scritto: > > is it posible to add another link to the logged in dropdown in adding

[web2py] Re: Webhosts for Web2py

Regarding pythonanywhere.com, what's the best way to run own background tasks? In the website they state 1-hour scheduled task, but I need to run multiple tasks almost real-time (e.g. sending registration emails and such). I've designed my website so that most tasks are queued and done in the b

[web2py] Re: Starting web2py fails silently with Cygwin python

Interesting; I tried following the solution outlined there (installed xinit, started X Server, export DISPLAY=:0.0), but the behavior remains exactly the same. In any case, ./web2py -a "passwd" (which behaves the same way under X too) should not even attempt to bring up any GUI at all. On Thur

[web2py] Re: Help with deploying on nginx

There's a lot of lines but here's a good portion of it: *** Operational MODE: no-workers *** spawned uWSGI master process (pid: 10483) *** starting uWSGI Emperor *** *** has_emperor mode detected (fd: 6) *** [uWSGI] parsing config file web2py.xml *** Starting uWSGI 1.2.3-debian (64bit) on [Thu A

[web2py] Re: Help with deploying on nginx

what does uwsgi log show ? On Thursday, August 29, 2013 8:18:02 PM UTC+2, Apple Mason wrote: > > I keep getting 502 Bad Gateway, and I'm not sure why. I followed the Nginx > deployment recipe on the website, with the following changes: > > /etc/uwsgi/web2py.xml: Used /var/www-data/web2py/ instead

[web2py] Re: Starting web2py fails silently with Cygwin python

isn't it related to tk and cygwin being a little bit stubborn ? see http://stackoverflow.com/questions/9393462/cannot-launch-git-gui-using-cygwin-on-windows On Thursday, August 29, 2013 4:52:47 PM UTC+2, Razvan Teslaru wrote: > > PS: I have both cygwin python and Windows python installed on the s

[web2py] Re: Starting web2py fails silently with Cygwin python

very weird. On Thursday, 29 August 2013 09:34:55 UTC-5, Razvan Teslaru wrote: > > This is really strange -- apparently, the execution never seems to reach > gluon/widget.py at all. > > I edited widget.py and now the first line is a 'print "1"' statement, > which never gets executed. Still no e

[web2py] Re: new web2py.js changes the sequence of execution

We have a somewhat different fix -- should be pushed to trunk shortly. Please test it once it's there. Thanks. Anthony On Thursday, August 29, 2013 11:46:26 AM UTC-7, simon wrote: > > New version of web2py.js executes: >eval(decodeURIComponent(command))in ajax.success >t.html(html) in aj

[web2py] Re: Using "external" database join with DAL

No you cannot join tables from two different databases. On Thursday, 29 August 2013 08:45:49 UTC-5, Gallien Labeyrie wrote: > > Hi, > > I'm connecting to multiple MySQL databases through Web2Py. So far > everything works fine! > But for some dumb reasons, my databases do not follow usual good d

[web2py] Re: new web2py.js changes the sequence of execution

New version of web2py.js executes: eval(decodeURIComponent(command))in ajax.success t.html(html) in ajax.complete However in the previous version these two commands executed in the reverse order. If I change doc.ajaxSuccess to doc.ajaxComplete then it works.Not sure if this breaks some

[web2py] Help with deploying on nginx

I keep getting 502 Bad Gateway, and I'm not sure why. I followed the Nginx deployment recipe on the website, with the following changes: /etc/uwsgi/web2py.xml: Used /var/www-data/web2py/ instead of /home/www-data/web2py/ nginx conf: server_name is my server ip (I don't have a domain name) inst

Re: [web2py] Smartgrid line color

Hi António, You can use a conditional represent to change the color of the date field in your outdated record. something like: 1) db.table.field.represent =lambda value, row: ""+value+"" if CONDITION else value Or you can put the outdated field inside an specific div with an id and iterate over

Re: [web2py] Any way of removing the text from Grid buttons?

geez, that is easy thanks On Thursday, August 29, 2013 5:04:15 AM UTC-7, Javier Pepe wrote: > > Is simple > > SQLFORM.grid(query,showbuttontext=False) > > > On Wed, Aug 28, 2013 at 8:19 PM, greenpoise > > wrote: > >> is there a way to remove the text from grid buttons? I mean the stock >> ones

[web2py] Re: new web2py.js changes the sequence of execution

Niphlod - I have tried latest trunk and get same issue. Paolo - I tried that but it makes no difference. Anthony is correct. The problem is: that the eval(decodeURIComponent(command)) happens in ajax.success then the t.html(html); On Thursday, 29 August 2013 14:54:19 UTC+1, Paolo Valleri

[web2py] Smartgrid line color

Hello , i need a table (smartgrid) that highlights outdated records, for example forcing the outdated record line inside the table to be filled with red background and yellow text. Can i do it with form.smartgrid? Thank you António -- --- You received this message because you are subscribe

[web2py] Re: WEB2PY iOS install APP

i guess thats the best solution for now. the only downside is jailbreak required anyone have experience with pyobjc? it is possible to just execute python code as daemon? On Monday, August 26, 2013 10:14:33 AM UTC+8, Massimo Di Pierro wrote: > > Did you see this: > http://www.web2pyslices.com

[web2py] Re: CAS provider and registration

I can get the register to redirect as I wanted by adding this to the CAS server application's default controller index function: if session.service_arg: redirect(session.service_arg) The only thing missing then is the register button. It should be relatively trivial to add that in.

[web2py] Re: Many forms in page with CRUD. Just want to check my approach is reasonable.

I have researched more and found out about the cid tag in the link helper. Works much better. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsub

[web2py] Re: Starting web2py fails silently with Cygwin python

PS: I have both cygwin python and Windows python installed on the same machine, if relevant. On Thursday, August 29, 2013 3:29:53 PM UTC+2, Massimo Di Pierro wrote: > > I have experienced the same problem. Yet I do not have a windows/cygwin > machine here to debug it. Can you help us and figure

[web2py] Re: Starting web2py fails silently with Cygwin python

This is really strange -- apparently, the execution never seems to reach gluon/widget.py at all. I edited widget.py and now the first line is a 'print "1"' statement, which never gets executed. Still no error messages. This seems to imply that the 'import gluon.widget' statement does not get

[web2py] Scalability lessons from reddit

Not web2py specific, but most apply also to web2py. http://highscalability.com/blog/2013/8/26/reddit-lessons-learned-from-mistakes-made-scaling-to-1-billi.html mic -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this g

Re: [web2py] Simple BASE in routes.py gives me "invalid request"

On 29 Aug 2013, at 6:37 AM, Wei Wang wrote: > I am embarrassed to report that is has been a user error -- my fault -- that > I got two different versions of web2py running in the same instance of > apache2. I didn't think to check my Apache configuration until I downloaded a > stable version of

Re: [web2py] Simple BASE in routes.py gives me "invalid request"

On 29 Aug 2013, at 6:37 AM, Wei Wang wrote: > I am embarrassed to report that is has been a user error -- my fault -- that > I got two different versions of web2py running in the same instance of > apache2. I didn't think to check my Apache configuration until I downloaded a > stable version of

[web2py] Re: new web2py.js changes the sequence of execution

Just to understand better what is going on, try to comment line 257 in web2py.js or even better the whole success block. Paolo On Thursday, August 29, 2013 3:42:29 AM UTC+2, Anthony wrote: > > Looks like this > change

[web2py] Using "external" database join with DAL

Hi, I'm connecting to multiple MySQL databases through Web2Py. So far everything works fine! But for some dumb reasons, my databases do not follow usual good design practices. For example some of the tables foreign keys refer to other database primary keys (which is surprisingly possible (!

Re: [web2py] Simple BASE in routes.py gives me "invalid request"

Jonathan, I am embarrassed to report that is has been a user error -- my fault -- that I got two different versions of web2py running in the same instance of apache2. I didn't think to check my Apache configuration until I downloaded a stable version of the source, set it up and ran it manually

Re: [web2py] Several controllers inserting and updating one row via forms

It would be nice if you show your view. Probably you're missing a hidden field in second form with the record id. On Thu, Aug 29, 2013 at 10:12 AM, wrote: > Hi! > > I have an issue with UPDATE form. I'm trying to implement something like > enrollment form that has man field beyond standard name

[web2py] Re: Starting web2py fails silently with Cygwin python

I have experienced the same problem. Yet I do not have a windows/cygwin machine here to debug it. Can you help us and figure out exactly where in gluon/widget.py it gets stuck? On Thursday, 29 August 2013 08:04:26 UTC-5, Razvan Teslaru wrote: > > Update: I managed to trace execution in web2py.py

[web2py] Re: Thread problems

Should now be fixed. On Thursday, 29 August 2013 07:01:37 UTC-5, Johann Spies wrote: > > For weeks I saw 'Failed to setup thread-interuupt handler. This is > usually not critical' but today after updating from the trunk I got the > following: > > *"ERROR:web2py:Traceback (most recent call last

[web2py] Re: Why is the plugins list empty in the wizard?

Can you show me an example? On Wednesday, 28 August 2013 20:52:39 UTC-5, Alan Etkin wrote: > > The problem is that the plugin app has been deprecated and plugins are >> being moved to github and web2pyslices. It was a nice automatism we did not >> have enough manpower to keep the plugins updated

[web2py] Several controllers inserting and updating one row via forms

Hi! I have an issue with UPDATE form. I'm trying to implement something like enrollment form that has man field beyond standard name, email, etc. For the sake of usability I've decided to split it to two steps (i.e. controllers - pages): first asks user for name and email, and after user submi

[web2py] Re: Starting web2py fails silently with Cygwin python

Update: I managed to trace execution in web2py.py until "import gluon.widget" -- execution doesn't continue in web2py.py after that line, but again, no error message. On Thursday, August 29, 2013 12:00:20 AM UTC+2, Razvan Teslaru wrote: > > Trying to run web2py under cygwin. Python 2.7.5 install

Re: [web2py] Any way of removing the text from Grid buttons?

Is simple SQLFORM.grid(query,showbuttontext=False) On Wed, Aug 28, 2013 at 8:19 PM, greenpoise wrote: > is there a way to remove the text from grid buttons? I mean the stock ones > (View, Edit, Delete) > > -- > > --- > You received this message because you are subscribed to the Google Groups >

[web2py] Thread problems

For weeks I saw 'Failed to setup thread-interuupt handler. This is usually not critical' but today after updating from the trunk I got the following: *"ERROR:web2py:Traceback (most recent call last): File "/home/js/web2py/gluon/main.py", line 467, in wsgibase session._try_store_in_db(reque

[web2py] Re: nginx web2py http to https rewrite

Awesome Niphlod, that works like a bomb. I really appreciate it. On Thursday, 29 August 2013 12:36:35 UTC+2, Niphlod wrote: > > if you want the server not to work on http but only in https, then you > should have only one directive in the server block listeing to the 80 port: > server { >

[web2py] Re: nginx web2py http to https rewrite

Thank you Niphlod, I would like it to listen on 80, but rewrite to https for all. I take it this is to be configured in the /etc/nginx/sites-available/web2py file? I will give it a bash now. Much appreciated. On Thursday, 29 August 2013 12:36:35 UTC+2, Niphlod wrote: > > if you want the serve

[web2py] Re: nginx web2py http to https rewrite

if you want the server not to work on http but only in https, then you should have only one directive in the server block listeing to the 80 port: server { listen 80; return 301 https://$host$request_uri; } On Thursday, August 29, 2013 10:15:43 AM UTC+2, lbd wrote: > > Hi all, I rec

[web2py] Many forms in page with CRUD. Just want to check my approach is reasonable.

I have some tables that I want to be easily readable and editable. We groups with information, with subgroups that should all be easy edit and overview. We have came up with a design that works but I now need to figure out how to be able to show edit forms for each row in the tables. My first

[web2py] nginx web2py http to https rewrite

Hi all, I recently setup a site using the nginx web2py ubuntu script. What I want to do is redirect all http traffic to https. In order to do this I tried modifying the /etc/nginx/sites-available/web2py script with a simple rewrite rule: server { listen 80; server_name