[web2py] sheepit plugins

2013-01-28 Thread 黄祥
hi is it possible using sheepit plugins in web2py using crud and sqlform? ref: http://www.mdelrosso.com/sheepit/index.php?lng=en_GB thank you --

[web2py] Appadmin does not play nicely when I use postgresql schemas

2013-01-28 Thread Johann Spies
I am working on a very complex multilevel database and I am using postgresql schemas to organise different aspects of the database. Using conditional models I do something like this: models/isl/isi.py: db.executesql(set search_path to isi;) db.define_table('rjoernaal', ... db.executesql(set

Re: [web2py] Appadmin does not play nicely when I use postgresql schemas

2013-01-28 Thread Johann Spies
Problem solved by workaround: add db.executesql(set search_path to nrf, isi, public) to appadmin.py just after the imports. I still think that appadmin should respect the search path set in the model without making it necessary to add it in the appadmin controller too. Regards Johann --

[web2py] Re: records as fields in a single form

2013-01-28 Thread Annet
Hi Anthony, Thanks for you reply. Making name a string solved the problem: fields_list.append(Field(name='s' + str(r.nav.id),type='boolean',default=r. nodeNav.frontend,label=r.nav.name)) Kind regards, Annet --

[web2py] CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Arnon Marcus
I am using the script in the latest build: setup-web2py-nginx-uwsgi-on-centos.sh On a fresh minimal installation of Cent-OS 6.3 + yum update. Only thing I changed is: PREFIX=2.6 VERSION=2.6.6 instead of the default: PREFIX=2.7 VERSION=2.7.3 and removed this: service httpd stop chkconfig

[web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Alan Etkin
I am using the script in the latest build: Check the nginx error logs. It could be that nginx doesn't find uwsgi or there are file permission issues. If I recall correctly, uwsgi is launched by the nginx server. --

[web2py] Contacts database app

2013-01-28 Thread ludwa6
For my first project in web2py, i want to create and deploy -with secure access for a few coworkers and myself- a simple contacts database app. As a first step, i am looking for the simplest example of running code that we might adopt -with as little modification as possible, initially- to

[web2py] Passenger WSGI Session

2013-01-28 Thread Vaibhav Kapoor
Hi, I was really hoping I wouldn't run into trouble if I had purchased shared hosting, but it seems I am somewhat stuck and unsure how to continue. I have been working extensively with jsonrpc service call and have them working well. For the time being I have simple authentication

[web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Niphlod
If I recall correctly, uwsgi is launched by the nginx server. it's configured as a service ... nginx can't start other external processes. @arnon: check if uwsgi is running correctly. you should have a /var/run/uwsgi.pid holding the pid of the current uwsgi process, and the log of uwsgi

Re: [web2py] How to implement web2py password encryption in php

2013-01-28 Thread Alec Taylor
What version of web2py have you started your app on? On Mon, Jan 28, 2013 at 6:32 PM, hasan alnator halna...@gardeniatelco.com wrote: Dear Alen , but i need to know What is the encryption what web2py implements on the password field in the auth_user table ? Best Regards, On Mon, Jan 28,

Re: [web2py] Re: How do I import `gluon.dal` from Python shell?

2013-01-28 Thread Alec Taylor
Thanks, but is there a non-hacky solution? On Mon, Jan 28, 2013 at 6:55 PM, Emilius Omeen om...@bk.ru wrote: import sys sys.path.append('/home/www-data/web2py') from gluon import DAL, Field -- --

Re: [web2py] How to implement web2py password encryption in php

2013-01-28 Thread hasan alnator
How can i get the version of the application ? On Mon, Jan 28, 2013 at 3:24 PM, Alec Taylor alec.tayl...@gmail.com wrote: What version of web2py have you started your app on? On Mon, Jan 28, 2013 at 6:32 PM, hasan alnator halna...@gardeniatelco.com wrote: Dear Alen , but i need to know

[web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Arnon Marcus
Here is something: [root@harmonica2 ~]# service uwsgi start Starting uwsgi: /bin/bash: /opt/uwsgi-python/uwsgi: No such file or directory [FAILED] On Monday, January 28, 2013 1:48:33 PM UTC+2, Niphlod wrote: If I recall correctly,

Re: [web2py] Re: How do I import `gluon.dal` from Python shell?

2013-01-28 Thread Niphlod
it's not hacky. it's normal for whatever module is not yet on sys.path. if you want to import something from whatever.py, you need to have it on sys.path to be able to do from whatever import something (in your case import gluon.dal is equivalent) so, you have 3 main ways: - start python in the

[web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Arnon Marcus
uwsgi.log is empty... On Monday, January 28, 2013 2:57:50 PM UTC+2, Arnon Marcus wrote: Here is something: [root@harmonica2 ~]# service uwsgi start Starting uwsgi: /bin/bash: /opt/uwsgi-python/uwsgi: No such file or directory

[web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Arnon Marcus
The folder /opt/uwsgi-python exists, and it has many files and folders, but no uwsgi file... There are: uwsgi.c uwsgi.h uwsgi.xml uwsgi_API.txt uwsgi_for_nginx.conf uwsgi_handlers.c uwsgibuild.lastprofile uwsgibuild.log uwsgiconfig.py uwsgidecorators.py uwsgidsl.rb uwsgirouter.py uwsgirouter2.py

Re: [web2py] Re: How do I import `gluon.dal` from Python shell?

2013-01-28 Thread Bruno Rocha
Is there the option to put the gluon folder on your site-packages or dist-packages folder Or maybe, start web2py in shell mode? --

[web2py] Re: can you make a reference field in a smartgrid a link to the parent record?

2013-01-28 Thread Michael Beller
appadmin displays the rows of a child table with the link to a parent row. This is what I'm trying to use in the smartgrid. What is the best method? On Saturday, January 26, 2013 8:54:31 AM UTC-5, Michael Beller wrote: I understand (I think) how to create and manage the button links within a

[web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Niphlod
so basically the script apparently didn't build the uwsgi binary from source https://github.com/web2py/web2py/blob/master/scripts/setup-web2py-nginx-uwsgi-on-centos.sh#L77 is the line used to build it. can you run it again inside the /opt/uwsgi-python dir and see what happens ? On Monday,

Re: [web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Richard Vézina
Not sure, but previously uwsgi was using emperor mode and the way to start it was : sudo start uwsgi-emperor Richard On Mon, Jan 28, 2013 at 8:44 AM, Niphlod niph...@gmail.com wrote: so basically the script apparently didn't build the uwsgi binary from source

Re: [web2py] Redmine beside web2py with Nginx deployment script

2013-01-28 Thread Richard Vézina
I will try to reproduce to make web2py were using pg8000, because I am not sure of that. What the behavior of web2py in case psycopg2 is not there? Richard On Sun, Jan 27, 2013 at 6:50 PM, Alan Etkin spame...@gmail.com wrote: I notice that python-psycopg2 were not installed and web2py was

Re: [web2py] Passenger WSGI Session

2013-01-28 Thread Richard Vézina
Are you talking about Phussion Passenger? Do you have any particular reason to use it? I read about differents middleware servers to be used with Redmine and get in touch with one the maintainer of ubuntu nginx package and I change my mind completely about Passenger... I would stay away of

Re: [web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Arnon Marcus
? Isn't sudo an ubuntu command? This is centos... I'm having problems compiling ruby on another vm, I think this might have to do with the fact that this is a minimal install... I didn't even have 'make' installed there... Why is this script compiling anything? This seems redundant... Isn't there

Re: [web2py] Re: How do I import `gluon.dal` from Python shell?

2013-01-28 Thread Anthony
http://docs.python.org/2/install/index.html#modifying-python-s-search-path On Monday, January 28, 2013 7:25:23 AM UTC-5, Alec Taylor wrote: Thanks, but is there a non-hacky solution? On Mon, Jan 28, 2013 at 6:55 PM, Emilius Omeen om...@bk.ru javascript: wrote: import sys

Re: [web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Niphlod
I don't know where the script was tested on. Header reports centos 5. My approach on the ubuntu script is to install uwsgi is retrieve the dependencies and let pip compile it, then run uwsgi in emperor mode. This scrips follows a different path but it's not that different. The issue you're

[web2py] Re: Autoincrement field

2013-01-28 Thread szimszon
Hi! I wonder if somebody could help me. The definet_table('sometable', Field('otherid', compute=lambda r: r['id']) ) doesn't work for me. :( Sould it work? With other than r['id'] it's working. Version 2.4.1-alpha.2+timestamp.2013.01.27.10.24.17 2010. május 28., péntek 16:02:23 UTC+2

Re: [web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Richard Vézina
Are you using the redmine script or the script of Niphold? I use to compile stuff because the ubuntu packages are not up to date. I think the better you version you can have with the ubuntu package was Redmine 1.4.3, and with my script you get the latest stable 2.2.0. I had to compile rails

Re: [web2py] Re: Autoincrement field

2013-01-28 Thread Alec Taylor
Which DB are you using BTW? Because if you're using something like MySQL; they have inbuilt autoincrement fields which would be much better to utilise than what we provide in the DAL. Maybe we should have an 'autoincrement' field, like we have a 'datetime' field? Gracefully degrade to a lambda

Re: [web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Arnon Marcus
10x for your help. I get the don't complain argument, so I'm not complaining! :) I am always grateful for other people's time and effort - that does not mean I have to always be satisfied. There are many ways to write a script - some may have more assumptions than others - I don't think it's as

Re: [web2py] Re: Autoincrement field

2013-01-28 Thread szimszon
postgresql Version: 8.4.12-0squeeze1 (producttion - not tested) postgresql Version: 9.1.7-0ubuntu12.10 (dev) I need somethink like: Field('otherid','string', compute=lambda r: 'SOMETHING%s%s' % ( str(datetime.date.today()), str(r['id']))) 2013. január 28., hétfő 15:48:24 UTC+1

Re: [web2py] Re: Autoincrement field

2013-01-28 Thread szimszon
I'm definitively for an auto-increment field like datetime anyway :-D 2013. január 28., hétfő 15:48:24 UTC+1 időpontban Alec Taylor a következőt írta: Which DB are you using BTW? Because if you're using something like MySQL; they have inbuilt autoincrement fields which would be much

Re: [web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Alan Etkin
Why is this script compiling anything? This seems redundant... That's because the script is based in 5.x versions that did not provide updated compatible packages. You could skip the compilations as long as you have proper replacements for uwsgi and python and link each configuration to the

Re: [web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Arnon Marcus
:) This thread is titled : CentOS 6.3 + nginx ... It's first 2 lines read: I am using the script in the latest build: setup-web2py-nginx-uwsgi-on-centos.sh It has nothing to do with redmine and /or ubuntu. Are you giving examples for why scripts have compilation procedures? If so, that I

Re: [web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Arnon Marcus
Will yum groupinstall 'Development Tools' help ? It's a 308mb package with tons of stuff I'd rather not have... The whole point of a minimal install, is performance, stability and security... --

Re: [web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Arnon Marcus
Here is a discussion on the matter: http://serverfault.com/questions/419591/install-packages-that-must-be-self-compiled-on-centos-server-is-a-bad-practice --

[web2py] Re: Autocomplete problem ...

2013-01-28 Thread Massimo Di Pierro
I think your problem is corrupted data. You have Pippo Pippo in a field that is either integer or reference. This can happen with sqlite if you change a field type. Delete the database and start again. I do not think there is anything wrong with your code. On Sunday, 27 January 2013 15:51:33

[web2py] Re: Contacts database app

2013-01-28 Thread Anthony
* About the following IRC thread, I have to say, i was surprised by the lack of activity in that chatroom (#web2py at Freenode). That being the one published channel for realtime discussion among users of what is a reasonably high-profile framework, i would have expected a bit more

Re: [web2py] Re: web2py world conference 2013

2013-01-28 Thread Jim S
Is there any further news about this? Is this going to happen? -Jim On Thursday, December 6, 2012 3:23:53 PM UTC-6, rochacbruno wrote: I started a thread for volunteers: https://groups.google.com/forum/?fromgroups=#!topic/web2py-world-conference/9_b-TrPqrRs --

[web2py] Re: ORA-01722: invalid number - Does field order matter?

2013-01-28 Thread Massimo Di Pierro
You are right that db.table.insert(**args) the order of the args in the INSERT is not specified. This should not be a problem. If you want to a field to map to NUMBER instead of INT, you can make your own adapter: from gluon import * from gluon.dal import ADAPTERS, OracleAdapter class

Re: [web2py] Re: How do I import `gluon.dal` from Python shell?

2013-01-28 Thread Alec Taylor
On Tue, Jan 29, 2013 at 12:07 AM, Bruno Rocha rochacbr...@gmail.com wrote: Is there the option to put the gluon folder on your site-packages or dist-packages folder Or maybe, start web2py in shell mode? -- Perfect, thanks. Had forgotten about the shell option. --

Re: [web2py] Redmine beside web2py with Nginx deployment script

2013-01-28 Thread Massimo Di Pierro
We are aware of some bugs in pg8000. I strongly suggest you use psycopg8 until the problems have been fixed. On Monday, 28 January 2013 08:04:13 UTC-6, Richard wrote: I will try to reproduce to make web2py were using pg8000, because I am not sure of that. What the behavior of web2py in case

Re: [web2py] Re: web2py world conference 2013

2013-01-28 Thread Massimo Di Pierro
I am a little upset about this. Looks like nobody has proposed a date and the date I proposed did not work for others. We need a date or a date range when the proponents can commit to secure a room. I originally proposed April 26. ow I think May 18 would be more appropriate. I can reserve a

[web2py] where to post problems/feedback on web2py.com?

2013-01-28 Thread Sean Murphy
Hi, I have an issue with one of the appliances on web2py.com. On the page: http://www.web2py.com/appliances it says that we should report any issues we find. However, it's not clear where/to whom we report them. Any pointers? BR, Seán. -- --- You received this message because you are

[web2py] Re: where to post problems/feedback on web2py.com?

2013-01-28 Thread Massimo Di Pierro
Please use the github issues: https://github.com/mdipierro/web2py-appliances On Monday, 28 January 2013 08:15:08 UTC-6, Sean Murphy wrote: Hi, I have an issue with one of the appliances on web2py.com. On the page: http://www.web2py.com/appliances it says that we should report any issues

Re: [web2py] Re: web2py world conference 2013

2013-01-28 Thread Bruno Rocha
I think it is ok to have different dates on each places. Each country/place can do in preferred data since it is in the same week. Lets say: place_here - May 16 (Thu) place_here - May 17 (Fri) Chicago - May 18 (Sat) Brasil - May 19 (Sun) Of course we can have more than one place at the same

Re: [web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Niphlod
Yep, but let's keep it simple and not offtopic. We're talking about the centos deployment script, that states clearly in the header that it works for centos 5. Maybe have to download 312097312 packages (including mysql library) just to compile ruby isn't a viable option (and I'm partially

Re: [web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Arnon Marcus
For example, there is no yum package for ruby 1.9.3 for centos 6.3... The yum package is 1.8.4 Most places you will look for, will tell you that this means that if you want the latest, you have to compile it yourself. Well, apparently that depends on how hard you look, though,,,:

Re: [web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Richard Vézina
Suggested version of Ruby for Rails: http://rubyonrails.org/download Recent security issue with rails : http://weblog.rubyonrails.org/2013/1/8/Rails-3-2-11-3-1-10-3-0-19-and-2-3-15-have-been-released/ https://groups.google.com/forum/?fromgroups=#!topic/rubyonrails-security/61bkgvnSGTQ

Re: [web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Niphlod
On Monday, January 28, 2013 6:00:40 PM UTC+1, Arnon Marcus wrote: For example, there is no yum package for ruby 1.9.3 for centos 6.3... again with ruby. You don't need ruby for web2py. Well, apparently that depends on how hard you look, though,,,: http://blog.timothymullican.com/?p=9

Re: [web2py] Re: web2py world conference 2013

2013-01-28 Thread António Ramos
I´d like to see this in Portugal. Anyone? 2013/1/28 Bruno Rocha rochacbr...@gmail.com I think it is ok to have different dates on each places. Each country/place can do in preferred data since it is in the same week. Lets say: place_here - May 16 (Thu) place_here - May 17 (Fri) Chicago

Re: [web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Richard Vézina
Niphold, I think he is try to install redmine under centos... Richard On Mon, Jan 28, 2013 at 12:16 PM, Niphlod niph...@gmail.com wrote: On Monday, January 28, 2013 6:00:40 PM UTC+1, Arnon Marcus wrote: For example, there is no yum package for ruby 1.9.3 for centos 6.3... again with

Re: [web2py] Re: web2py world conference 2013

2013-01-28 Thread Alan Etkin
If not presented in English, the video will need to be subtitled to English using the YouTube (Amara) tools, for this we count on local volunteers. This is not the first time I try to give it a little visibility, but I insist: http://ar.pycon.org/video2py http://code.google.com/p/video2py

Re: [web2py] Re: web2py world conference 2013

2013-01-28 Thread ludwa6
Me too -so long as it will be no farther N that Lisbon. I am in Lagos (Algarve -practically on the beach :-). Where are you, Ramos? Any web2py users in PT, i wonder? /w On Monday, January 28, 2013 5:17:59 PM UTC, Ramos wrote: I´d like to see this in Portugal. Anyone? 2013/1/28 Bruno

Re: [web2py] Re: web2py world conference 2013

2013-01-28 Thread António Ramos
Ramos from Porto :) We should have a map with all of us! 2013/1/28 ludwa6 wludw...@gmail.com Me too -so long as it will be no farther N that Lisbon. I am in Lagos (Algarve -practically on the beach :-). Where are you, Ramos? Any web2py users in PT, i wonder? /w On Monday, January 28,

Re: [web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Arnon Marcus
Wow, what a mess... Ok, here goes: We are mixing 3 discussions here, and it creates a confusion: 1. The original intent of this thread - making web2py work with nginx on centos6 2. The possible lack of updated/efficient software installation in the current script 3. Ruby installation for

[web2py] Insert works using SQLite, not GAE/Datastore

2013-01-28 Thread Scott Hunter
To elaborate on title: I have a simple web2py app, from which I can insert records into a particular table (using a smart grid, or from within a controller), but trying to do so with the app posted to GAE, it fails (for either method). Operations using other tables work fine. I believe it

Re: [web2py] Re: web2py world conference 2013

2013-01-28 Thread Massimo Di Pierro
I am ok with almost all of this but: I would not have 4 dates. 2 would be ok. 3 a stretch. The reason is that we want people from other location to be online at the same time so we can have some events shared via chat or videoconferences. For example if you and I want to do a QA over IRC we

Re: [web2py] Re: web2py world conference 2013

2013-01-28 Thread Mariano Reingart
Sorry Massimo, I didn't proposed a date for Argentina because now we are in summer vacation (almost all of the educational institutions are closed or with minimal activity) Also, in Argentina, the dates for our python main events are not set yet (PyCon Argentina and PyCamp) I'ld prefer a free

Re: [web2py] Re: web2py world conference 2013

2013-01-28 Thread Jim Steil
I would be wanting to attend in person in Chicago. Jim On Jan 28, 2013 11:18 AM, António Ramos ramstei...@gmail.com wrote: I´d like to see this in Portugal. Anyone? 2013/1/28 Bruno Rocha rochacbr...@gmail.com I think it is ok to have different dates on each places. Each country/place

Re: [web2py] Passenger WSGI Session

2013-01-28 Thread Vaibhav Kapoor
Unfortunately according to web2py on Dreamhosthttp://wiki.dreamhost.com/Web2py, only FastCGI and Passenger WSGI seem to work. And that Passenger works significantly faster than FastCGI. I had heard the stability of Passenger WSGI was also better on Dreamhost. But I can give FastCGI a chance,

Re: [web2py] Passenger WSGI Session

2013-01-28 Thread Roberto De Ioris
Unfortunately according to web2py on Dreamhosthttp://wiki.dreamhost.com/Web2py, only FastCGI and Passenger WSGI seem to work. And that Passenger works significantly faster than FastCGI. I had heard the stability of Passenger WSGI was also better on Dreamhost. But I can give FastCGI a chance,

Re: [web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Niphlod
on 2. : did someone try with a centos 6.3 replacing lines 26,27 from yum install gcc gdbm-devel readline-devel ncurses-devel zlib-devel \ bzip2-devel sqlite-devel db4-devel openssl-devel tk-devel bluez-libs-devel to yum install gcc gdbm-devel readline-devel ncurses-devel zlib-devel \

Re: [web2py] Re: Detect change in sqlform.grid

2013-01-28 Thread Keith Edmunds
Sorry to bump: can anyone give me a pointer on this? Thanks. On Sun, 27 Jan 2013 09:02:45 +, k...@midnighthax.com said: On Sat, 26 Jan 2013 13:05:50 -0800 (PST), niph...@gmail.com said: grid takes formargs={}, createargs={}, editargs={} Thanks. I'm sorry if I'm being a bit slow

Re: [web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Alan Etkin
on 2. : did someone try with a centos 6.3 replacing lines 26,27 from No, but that seems like a bat-centos-6.x-nginx-uwsgi.sh script to me -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group, send email to

[web2py] Re: ORA-01722: invalid number - Does field order matter?

2013-01-28 Thread Bill Thayer
Hi Massimo, Is there a way that you know to get the SQL call so that I can verify the values are going to the correct place? Regards, Bill On Monday, January 28, 2013 9:48:57 AM UTC-6, Massimo Di Pierro wrote: You are right that db.table.insert(**args) the order of the args in the INSERT

[web2py] Re: Insert works using SQLite, not GAE/Datastore

2013-01-28 Thread Alan Etkin
To elaborate on title: I have a simple web2py app, from which I can insert records into a particular table (using a smart grid, o Could you please post the app engine error output? Also I belive that posting the involved model/controller code might help debugging. -- --- You

Re: [web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Arnon Marcus
Niphlod - I will try this tomorro at work, 10x - Also the nginx rpm source path should be changed (from .../5/... to something like .../63/... I'll check that...) Alns - I don't understand - your link doesn't work (at least for me)... On Mon, Jan 28, 2013 at 12:17 PM, Alan Etkin

[web2py] Re: looking for volunteers to help proof-read book 5th ed.

2013-01-28 Thread Dane Wright
A few minor typos - Line 17178 under WingIDE, Rad2Py, and Eclipse - change 'execued' to 'executed' from: +it does not change the logic as this is never execued but it forces the IDE to parse it and understand where the objects in the global namespace come from (the ``gluon`` module) thus

[web2py] Can we add __delitem__ to web2py.gluon.dal.Row?

2013-01-28 Thread Chris
I recently found an error running the following code on the Row object page: del page['page_log'] type 'exceptions.AttributeError' __delitem__ del page.page_log still works, but the above used to work. My suspicion is that __delitem__ was originally in object but was removed for some technical

Re: [web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Arnon Marcus
I might be able to in the future - some day - for now, I am the nubie - I am learning linux for the first time as I go - it's gonna be a while till I can even ponder writing such a script... That's why I am so reliant on other people's work - that's how it is when you are a beginner at

Re: [web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Alan Etkin
Alns - I don't understand - your link doesn't work (at least for me)... No. It's that Simon Carr has re-baptised Niphlod as batman, and I cannot help adressing him that way whenever I can. For more details, you might want consulting this source:

[web2py] 'NoneType' object has no attribute 'split'

2013-01-28 Thread Bill Thayer
I think I figured this one out so I am posting the solution. On the manages wiki_pages page from the manage pages memu item, I would click on a media button and get the error below. Turns out that in the course of testing my application I had uploaded files without a title and web2py does not

[web2py] Re: Insert works using SQLite, not GAE/Datastore

2013-01-28 Thread Scott Hunter
As requested, here is the traceback: In FILE: /base/data/home/apps/s~sbhweb2py/1.364873083036857122/applications/ppt_demo/controllers/default.py Traceback (most recent call last): File /base/data/home/apps/s~sbhweb2py/1.364873083036857122/gluon/restricted.py, line 212, in restricted

[web2py] Why query != same_query?

2013-01-28 Thread Alan Etkin
I have noticed this behavior in trunk. Is this a feature? q = db.auth_user.id 0 q2 = db.auth_user.id 0 q == q2 False I hope I didn't post a read the manual question again, but doesn't seem to be documented in the DAL section. Thanks -- --- You received this message because you are

[web2py] Re: Why query != same_query?

2013-01-28 Thread Alan Etkin
I have noticed this behavior in trunk. Is this a feature? I belive I found the problem: the Query class doesn't implement __eq__ nor __ne__. Is that the cause? -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this

[web2py] Re: Why query != same_query?

2013-01-28 Thread Anthony
According to the Python documentation: If no __cmp__()http://docs.python.org/2/reference/datamodel.html#object.__cmp__ , __eq__() http://docs.python.org/2/reference/datamodel.html#object.__eq__ or __ne__()http://docs.python.org/2/reference/datamodel.html#object.__ne__ operation is defined,

[web2py] Re: Why query != same_query?

2013-01-28 Thread Anthony
repr(q) == repr(q2) I suppose we could implement __eq__() and __ne__() methods that do the above. Anthony -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group, send email to

[web2py] Re: Why query != same_query?

2013-01-28 Thread Alan Etkin
repr(q) == repr(q2) +1 for the repr comparison, as long as it's backwards compatible and it doesn't have conflicts with other query operations -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group, send email

[web2py] Re: web2py world conference 2013

2013-01-28 Thread smoggy
I'm from Lagos Portugal also. If in Portugal i would suggest the use of the University of Algarve installations, It has : - a nearby airport - the weather is awesome specially in the summer. - it is not-expesive. - good nightlife - awesome sea food -- --- You received this message because you

[web2py] Re: Insert works using SQLite, not GAE/Datastore

2013-01-28 Thread Alan Etkin
As requested, here is the traceback: Looks like a non-float value is sent to the GAE adapter for datatastore insertion (without the proper type validation). otherwise the appengine sdk should not raise that exception. Maybe you can debug the form values on submission to check they are

[web2py] Re: Insert works using SQLite, not GAE/Datastore

2013-01-28 Thread Scott Hunter
I entered 15.0 in the form, which sure looks like a float to me. If I had entered a non-float, automatic validation should have caught it before the appengine sdk was called to do a set. And when I used an insert statement myself using the DAL, I tried hard-coding a 10.0 for that field --

[web2py] Re: Insert works using SQLite, not GAE/Datastore

2013-01-28 Thread Alan Etkin
I entered 15.0 in the form, which sure looks like a float to me. If I had entered a non-float, automatic validation should have Not the best solution I guess, but, maybe you could try to define the missing table/field objects in the datastore web interface to check if the adapter is

[web2py] limit on number of smartgrid tables

2013-01-28 Thread Alex Glaros
Is there a limit on the number of smartgrid tables? def manage_data(): grid = SQLFORM.smartgrid(db.Word, linked_tables=['Word','DictionaryType','HumanLanguage'], searchable=True, user_signature=False) Only two of the tables display on the above example.

[web2py] Re: Insert works using SQLite, not GAE/Datastore

2013-01-28 Thread Scott Hunter
OK, it seems that GAE isn't fond of floats, but is quite happy with doubles -- its now happy with inserting both from a smartgrid-created form and from DAL calls. (I couldn't define any fields directly b/c the table/entity no longer appeared.) Thanks. On Monday, January 28, 2013 7:37:52 PM

[web2py] Re: ORA-01722: invalid number - Does field order matter?

2013-01-28 Thread Massimo Di Pierro
{{=response.toolbar()}} will show you all the SQL requests and their timings. On Monday, 28 January 2013 15:06:19 UTC-6, Bill Thayer wrote: Hi Massimo, Is there a way that you know to get the SQL call so that I can verify the values are going to the correct place? Regards, Bill On

[web2py] Re: Can we add __delitem__ to web2py.gluon.dal.Row?

2013-01-28 Thread Massimo Di Pierro
Good idea. In trunk! On Monday, 28 January 2013 15:22:45 UTC-6, Chris wrote: I recently found an error running the following code on the Row object page: del page['page_log'] type 'exceptions.AttributeError' __delitem__ del page.page_log still works, but the above used to work. My

Re: [web2py] Re: CentOS 6.3 + nginx = 502 Bad gateway

2013-01-28 Thread Massimo Di Pierro
LOL On Monday, 28 January 2013 15:45:17 UTC-6, Alan Etkin wrote: Alns - I don't understand - your link doesn't work (at least for me)... No. It's just that Simon Carr said Niphlod is like Batman, and I cannot help addressing him that way whenever I can. For more details, see this post

[web2py] Re: Why query != same_query?

2013-01-28 Thread Massimo Di Pierro
Good idea Anthony, can you send me a patch? On Monday, 28 January 2013 16:39:07 UTC-6, Anthony wrote: According to the Python documentation: If no __cmp__()http://docs.python.org/2/reference/datamodel.html#object.__cmp__ ,

[web2py] Is it possible to use IS_IN_SET() in combination with other validators to validate a list?

2013-01-28 Thread Lamps902
Hi, web2py users. In my model, I've got a field of type list:string which I'm trying to validate. The field is defined as follows: Field('f_field_name', type='list:string', requires=IS_IN_SET(theset=list_of_acceptable_options,zero=T(message), error_message=T(some_error_message)))

[web2py] Re: can you make a reference field in a smartgrid a link to the parent record?

2013-01-28 Thread Michael Beller
I'm now using the .represent property for the table field. In my model, I added: db.t_child.f_parent.represent = \ lambda value, row: A(row.f_parent.f_name, _href=URL('parent_manage', args=['t_parent', 'view', 't_parent', row.f_parent.id], user_signature=True)) Now, all my child items

[web2py] retail web application using web2py

2013-01-28 Thread 黄祥
hi, is there any appliances or tutorial how to build retail web application using web2py? at first i've tried to use sheep it for add multiple product, but it seems that web2py isn't support it. right now, i just try to build it using the shopping cart concept. any suggestion or hints are

[web2py] RuntimeError: Unable to handle upload

2013-01-28 Thread Bill Thayer
I am attempting to write a function that will eventually go in to a migration script to upload legacy data files. As you can see I use the DAL and define the wiki_media table. The function below looks just like the example in the

Re: [web2py] Re: How do I import `gluon.dal` from Python shell?

2013-01-28 Thread Bill Thayer
I defined WEB2PY_HOME in my environment variables and then added %WEB2PY_HOME% to my path system variable. This way I can change it's value depending on the version I am developing on at the time. -Bill On Monday, January 28, 2013 9:49:12 AM UTC-6, Alec Taylor wrote: On Tue, Jan 29, 2013 at

[web2py] Data not inserting via ajax after login. web2py 2.3.2

2013-01-28 Thread martzi
Hi all, I wonder is am doing something wrong. creating a user (normal user), i tried inserting into a database from a custom form, But the values aren't inserting, and not errors is generated. But when i leave the field empty, i get an error message. please could anyone help! controller: def

[web2py] Re: Is it possible to use IS_IN_SET() in combination with other validators to validate a list?

2013-01-28 Thread Massimo Di Pierro
I think you want requires=IS_LIST_OF(IS_IN_SET()) It should validate but you will not get dropdowns. On Monday, 28 January 2013 20:57:58 UTC-6, Lamps902 wrote: Hi, web2py users. In my model, I've got a field of type list:string which I'm trying to validate. The field is defined as

[web2py] Re: retail web application using web2py

2013-01-28 Thread Massimo Di Pierro
https://github.com/mdipierro/web2py-appliances/tree/master/PosOnlineStore On Monday, 28 January 2013 22:21:32 UTC-6, 黄祥 wrote: hi, is there any appliances or tutorial how to build retail web application using web2py? at first i've tried to use sheep it for add multiple product, but it

[web2py] Re: Is it possible to use IS_IN_SET() in combination with other validators to validate a list?

2013-01-28 Thread Anthony
Are you saying you want to be able to apply the IS_IN_SET validator to each entry in the field? If so, you can do IS_IN_SET(..., multiple=True) or IS_IN_SET(..., multiple=(min, max)). See the IS_IN_SET documentation here: http://web2py.com/books/default/chapter/29/07#Validators Anthony On