[web2py] current transaction is aborted, commands ignored until end of transaction block

2012-04-14 Thread Bruce Wade
How do you trouble shoot this kind of error? current transaction is aborted, commands ignored until end of transaction block -- -- Regards, Bruce Wade http://ca.linkedin.com/in/brucelwade http://www.wadecybertech.com http://www.fittraineronline.com - Fitness Personal Trainers Online http://www

Re: [web2py] Overlapping periods

2012-04-14 Thread Keith Edmunds
On Fri, 13 Apr 2012 11:38:25 -0700 (PDT), sababa.sab...@gmail.com said: > But the function does not work, and I can't see what's wrong. Any idea? You don't make it very easy for others to help. "The function does not work" - which function doesn't work, and in what way does it not work? What inpu

[web2py] Re: Overlapping periods

2012-04-14 Thread pbreit
The code is a little confusing (although it is indented OK at Google Groups web site). You can do "if request.args(0):" What does this do: if not session.timedelta2==timedelta(days=0): This really confused me: if item_id.vars.begindate < previousenddate: item_id = request.args[0] so I don't kn

Re: [web2py] Overlapping periods

2012-04-14 Thread Keith Edmunds
On Fri, 13 Apr 2012 11:38:25 -0700 (PDT), sababa.sab...@gmail.com said: > The > function should only add periods that doesn't overlap any of the > already registered ones. Let me try to help (I owe this group a lot of help). I've ignored your code, and I don't know what schema you're using, bu

Re: [web2py] Overlapping periods

2012-04-14 Thread Keith Edmunds
On Sat, 14 Apr 2012 09:44:28 +0100, k...@midnighthax.com said: > q = ((db.period.begindatestart)) > if db(query).count(): Argh. Typos. 'q' and 'query' should refer to the same thing, so change the second line to 'if db(q).count():' (that change needs to take place twice). -- "You can

[web2py] Re: Installation on GoDaddy shared server

2012-04-14 Thread netcode
webfaction does not handle domain registration. you still have to get a host and then change your nameservers to that of webfaction so you can have control of your DNS from the webfaction control panel. On Friday, 21 January 2011 19:36:56 UTC+1, stargate wrote: > > How do I install web2py on a Go

[web2py] jQuery Multi-Select Form Input Names

2012-04-14 Thread villas
Hi All, I have just spent a few frustrating hours with the jQuery Multi-Select widget: http://www.abeautifulsite.net/blog/2008/04/jquery-multiselect/ For this field: db.define_table('gallery', Field('tag_id','list:reference tag') it renders for example this HTML element: MyTag

[web2py] How can I create a file in an upload field, and add lines to it ?

2012-04-14 Thread François Delpierre
Hi, I have a table with two upload fields. I need to transform the file from the first upload field, and create it in the second upload field. What is the best way to do it, and possibly avoid to first create the file in memory before writing it to the disk. It looks like I can generate the ran

[web2py] Re: How can I create a file in an upload field, and add lines to it ?

2012-04-14 Thread François Delpierre
Could this be the best solution ? mysecurefilename = db.t_card_posting.f_destfile.store(tempfile.TemporaryFile(), 'my_empty_file.csv') mf = open('applications/CardPosting/uploads/' + mysecurefilename, 'w') mf.write('This is my first test line in my empty csv file.') Le samedi 14 avril 2012 12

[web2py] shared host deployment of my web2py site

2012-04-14 Thread netcode
Hello All, i am trying to follow up on steps in this link:http://www.web2pyslices.com/slice/show/1401/web2py-on-shared-hosting-hostmonster-with-fastcgibut i think am lost now. I have downloaded and extracted the python setup to the Home Directory but after that, it says this: cd $HOME/Python

[web2py] Re: [web2py:26101] Re: Deployment of Python web apps on shared hosts.

2012-04-14 Thread netcode
you may also want to save some money and find a way to run web2py with fastCGI on a shared domain On Friday, 10 July 2009 06:12:14 UTC+1, eric cs wrote: > > Thanks guys, I am just wondering why Php runs better with less memory than > Python and Ruby. > @Massimo > Because in web2py apps are exec

Re: [web2py] current transaction is aborted, commands ignored until end of transaction block

2012-04-14 Thread Michele Comitini
Activate error logging on the postgresql server and read the logs, it helps, not always but most of the time. mic Il 14 aprile 2012 08:59, Bruce Wade ha scritto: > How do you trouble shoot this kind of error? > > current transaction is aborted, commands > ignored until end of transaction block

Re: [web2py] shared host deployment of my web2py site

2012-04-14 Thread Keith Edmunds
On Sat, 14 Apr 2012 05:08:01 -0700 (PDT), doncoleon...@gmail.com said: > but i dont > know what the next line of instruction says It says run this command: ./configure --prefix=$HOME ...from the Python-2.6.5 directory under your home directory. The './configure' is the command that will be run

Re: [web2py] jQuery Multi-Select Form Input Names

2012-04-14 Thread Bruno Rocha
You need to create a custom widget and then: db.gallery.tag_id.widget = mycustomwidget or use the web2py mult select widget that ships with plugin_wiki. http://zerp.ly/rochacbruno Em 14/04/2012 07:50, "villas" escreveu: > Hi All, I have just spent a few frustrating hours with the jQuery > Mul

[web2py] getting mail to work with SSL connection on port 465

2012-04-14 Thread weheh
I'm trying without success to get web2py mail working with an SSL connection. I've searched the forum and come up with this: mail.settings.tls = True mail.settings.login = False # I am not using auth in this case mail.settings.server = 'mail.mydomain.com:465' # your SMTP server mail.settings.lo

[web2py] Re: getting mail to work with SSL connection on port 465

2012-04-14 Thread weheh
Actually, web2py is not sending the email. I neglected to look at the console, which is saying "Mail.send failure:(10060, 'Operation timed out'), so obviously it's not working.

[web2py] Easiest way to handle alternative logins?

2012-04-14 Thread Bruce Wade
Hi, So as most know I am migrating my site from pyramid to web2py. Now I have 1 final step to complete. Because we have over 20,000 members I don't want to force everyone to change there passwords just to start using web2py's login system. Instead I would like to try to log them in with web2py's

[web2py] how to access google spreadsheets using Oauth2 in web2py

2012-04-14 Thread SB
how to access google spreadsheets using Oauth2 in web2py. Need help.

[web2py] CMS/blog app suitable for web2py beginners

2012-04-14 Thread Gour
Hello! I'm looking for recommendation what would be appropriate CMS/blog app for web2py which would allow me to migrate one of my PHP sites - small blog/brochure site to something powered by web2py without having to build too many things from the scracth, but at the same thing enough user-friendly

[web2py] Vertical lines around database string values

2012-04-14 Thread Yarin
When inserting records with web2py's db class, my string values have vertical bars surrounding them. I don't remember seeing this behavior before. What's more, if i insert records through web2py's db admin interface, i don't get vertical bars. What are the vertical bars - is it a unicode thing?

Re: [web2py] Vertical lines around database string values

2012-04-14 Thread Keith Edmunds
Are you using Fields of type list:string? -- "You can have everything in life you want if you help enough other people get what they want" - Zig Ziglar. Who did you help today?

Re: [web2py] Design of a minimal chat-like application in Web2py

2012-04-14 Thread cyan
This looks promising, but any chance of translating into English to server a larger communities of developers? (even some subtitle would help too!) Thanks. On Friday, April 13, 2012 6:43:54 PM UTC-4, rochacbruno wrote: > > Simple example with comet + tornado http://vimeo.com/38972256 (in > Po

Re: [web2py] Vertical lines around database string values

2012-04-14 Thread Yarin
no- they're type 'string': Field('link_url', 'string'), On Saturday, April 14, 2012 11:24:44 AM UTC-4, backseat wrote: > > Are you using Fields of type list:string? > > -- > "You can have everything in life you want if you help enough other people > get what they want" - Zig Ziglar. > > Who did

[web2py] Re: Easiest way to handle alternative logins?

2012-04-14 Thread Bruce Wade
I got it working. On Sat, Apr 14, 2012 at 7:32 AM, Bruce Wade wrote: > Hi, > > So as most know I am migrating my site from pyramid to web2py. Now I have > 1 final step to complete. > > Because we have over 20,000 members I don't want to force everyone to > change there passwords just to start us

Re: [web2py] jQuery Multi-Select Form Input Names

2012-04-14 Thread villas
Well there is the widget on Web2pySlices (which I believe is the one in the Cookbook). Sadly that doesn't seem to work. However, if I put this in my HTML, I don't seem to need a widget at all, so maybe that's better. I mean I already have the multiselect function there, so it's only one

[web2py] Multiselect form and many-to-many relationship

2012-04-14 Thread Chris Rowson
Hi all, I'm pretty new to web2py and web app development and I've spend some time trying to figure out the best way to do this. I have two tables, house-types and regions. A house-type can exist in many regions, and a region can have many house types: db.define_table( 'region', Field('na

Re: [web2py] Design of a minimal chat-like application in Web2py

2012-04-14 Thread Bruno Rocha
I found this website http://www.universalsubtitles.org/en/ so now I have to learn how to use and insert the subtitles On Sat, Apr 14, 2012 at 12:31 PM, cyan wrote: > > This looks promising, but any chance of translating into English to server > a larger communities of developers? (even some subt

[web2py] Tagging - Cookbook

2012-04-14 Thread villas
I've just been reading about 'efficiently' tagging in the Cookbook and I read that this was a suitable tagging design: A model for containing the data: db.define_table('data', Field('value')) A model for storing the tags: db.define_table('tag', Field('record_id', db.data), Field('name'))

[web2py] Re: Multiselect form and many-to-many relationship

2012-04-14 Thread villas
I would just mention that if you only have a few regions/housetypes, you might consider de-normalising the data and using list:reference and work with the jQuery.multiselect (if you have any problems with that, you might like to read my other thread on the topic). Best regards, David On Sat

[web2py] extra column with random number to make record not guessable

2012-04-14 Thread Sebastian E. Ovide
Hi All, as I'm using some links with id=blablabla where the ID is the real ID as generated by web2py, that make very easy to guess other records (see the movie "Social Networks" how they got the pictures of students just changing the ID from the URL)... just wondering if web2py has already s

[web2py] Get email on ticket creation

2012-04-14 Thread Bruce Wade
Hi, Is there an easy to way to have an email sent to me whenever a ticket is generated? -- -- Regards, Bruce Wade http://ca.linkedin.com/in/brucelwade http://www.wadecybertech.com http://www.fittraineronline.com - Fitness Personal Trainers Online http://www.warplydesigned.com

Re: [web2py] Re: Multiselect form and many-to-many relationship

2012-04-14 Thread Chris Rowson
Hi David, Thanks for your reply. I did come across the list:reference option while trying to figure this out. I couldn't figure this out though: Say I add the following to my house-type table: Field('regions', 'list:reference region') If I generate a form using SQLFORM, it presents me with

[web2py] Re: Get email on ticket creation

2012-04-14 Thread Anthony
One option might be to have routes_onerror ( http://web2py.com/books/default/chapter/29/4#Routes-on-error) route to a dynamic error handler, which could then send an email (in addition to presenting a friendly error message). Another option might be to set up a background task to watch for new t

[web2py] Re: extra column with random number to make record not guessable

2012-04-14 Thread Anthony
Maybe something like: from gluon.utils import web2py_uuid db.define_table('mytable', Field('myid', default=web2py_uuid), ...) That will create a unique 36-character uuid for each record inserted. Anthony On Saturday, April 14, 2012 4:12:45 PM UTC-4, sebastian wrote: > > Hi All, > > as I'm usi

Re: [web2py] Re: extra column with random number to make record not guessable

2012-04-14 Thread Sebastian E. Ovide
nice !, thanks On Sat, Apr 14, 2012 at 9:41 PM, Anthony wrote: > Maybe something like: > > from gluon.utils import web2py_uuid > > db.define_table('mytable', Field('myid', default=web2py_uuid), ...) > > That will create a unique 36-character uuid for each record inserted. > > Anthony > > > On Sa

[web2py] Re: extra column with random number to make record not guessable

2012-04-14 Thread pbreit
How do people usually do this? Obviously it's easiest just to use IDs and prety easy to avoid any problems with guessing IDs. But if you do want to obfuscate IDs I suppose you could either add the column (not ideal since better to work with IDs) or do the encryption each time you create and ret

[web2py] Re: Easiest way to handle alternative logins?

2012-04-14 Thread pbreit
I'd be curious what you did. I've been wanting to switch my passwords to something salted or bcrypt. Can web2py's password handling be modified to try the new one, try the old one, if old one works convert to new one?

Re: [web2py] Re: Multiselect form and many-to-many relationship

2012-04-14 Thread villas
Yes, it would store the ids of the regions between vertical bars, something like this: |4|7|23|. So say you are looking for the house-types in China (which is id = 7). It would be something like this: if you already have the record id no.7, then just this: houses = db(db.house_types.regions.

Re: [web2py] Re: Multiselect form and many-to-many relationship

2012-04-14 Thread Chris Rowson
Thank you again David, I shall give it a go. Chris On Sat, Apr 14, 2012 at 10:29 PM, villas wrote: > Yes, it would store the ids of the regions between vertical bars, > something like this: |4|7|23|. So say you are looking for the house-types > in China (which is id = 7). It would be someth

[web2py] Re: extra column with random number to make record not guessable

2012-04-14 Thread Anthony
Well, it's probably best to use access control on the server rather than relying on someone not guessing an ID, but if you really need to enable access solely via the URL, then you probably want a long ID (like a UUID). Anthony On Saturday, April 14, 2012 5:16:53 PM UTC-4, pbreit wrote: > > How

Re: [web2py] Re: Multiselect form and many-to-many relationship

2012-04-14 Thread villas
Oops I think I got confused with the vertical bars, try it with just a plain integer: houses = db(db.house_types.regions.contains(7)).select() On Saturday, 14 April 2012 22:33:54 UTC+1, leftcase wrote: > > Thank you again David, > > I shall give it a go. > > Chris > > On Sat, Apr 14, 2012 at 1

Re: [web2py] Re: Get email on ticket creation

2012-04-14 Thread Bruce Wade
I have been finding most of the book samples don't have enough information to actually implement what the second talks about. For example where/how do I implement routes_onerror routes_onerror = dict(application='error', controller='default', function='index') ERROR:Rocket.Errors.Thread-3:Traceba

Re: [web2py] Re: Easiest way to handle alternative logins?

2012-04-14 Thread Bruce Wade
Yeah that is pretty much what I did. Their may be a better way to handle this however this was fast and easy. I have two different frameworks that need to access the database, this way allows for members to use both frameworks. in def user(): auth.settings.login_onvalidation = [check_old_login

[web2py] Re: extra column with random number to make record not guessable

2012-04-14 Thread howesc
nothing stops you from making the UUID the ID field in the database. most databases support such behavior. GAE even provides a way to name a record though i don't think we have built that in to web2py yet.but GAE's default ID generation is across the entire database so i have never been ab

Re: [web2py] Re: Get email on ticket creation

2012-04-14 Thread howesc
CAVEAT: i'm using routes.py NOT router.py.not sure if that changes the syntax the following is what i have to direct all errors to a user friendly page: routes_onerror = [ ('/*', '//home/missing.html'), ] and in controller home.py i have a function missing(). :) On Saturday, April

Re: [web2py] Re: Get email on ticket creation

2012-04-14 Thread Bruce Wade
Yeah I have mine in routes.py also I will try your suggestion and report back, thanks. On Sat, Apr 14, 2012 at 4:33 PM, howesc wrote: > CAVEAT: i'm using routes.py NOT router.py.not sure if that changes the > syntax > > the following is what i have to direct all errors to a user friendly

[web2py] Re: Get email on ticket creation

2012-04-14 Thread Rowdy
On 15/04/12 6:19 AM, Bruce Wade wrote: Hi, Is there an easy to way to have an email sent to me whenever a ticket is generated? -- -- Regards, Bruce Wade http://ca.linkedin.com/in/brucelwade http://www.wadecybertech.com http://www.fittraineronline.com - Fitness Personal Trainers Online http://ww

Re: [web2py] Re: Get email on ticket creation

2012-04-14 Thread Bruce Wade
Thanks I didn't even notice that script. On Sat, Apr 14, 2012 at 4:37 PM, Rowdy wrote: > On 15/04/12 6:19 AM, Bruce Wade wrote: > >> Hi, >> >> Is there an easy to way to have an email sent to me whenever a ticket is >> generated? >> >> -- >> -- >> Regards, >> Bruce Wade >> http://ca.linkedin.com

Re: [web2py] Re: Get email on ticket creation

2012-04-14 Thread Jonathan Lundell
On Apr 14, 2012, at 4:33 PM, howesc wrote: > CAVEAT: i'm using routes.py NOT router.py.not sure if that changes the > syntax > > the following is what i have to direct all errors to a user friendly page: > > routes_onerror = [ > ('/*', '//home/missing.html'), > ] > > and in control

[web2py] Custom attributes in

2012-04-14 Thread Jon Molesa
Does the div class support hyphenated attribute names data-role="listview"? I can't seem to get it to work. I can get _dat_role and _datarole to work, but any attempt to use _data-role causes an error. -- Jon Molesa rjmol...@gmail.com

[web2py] Major problem I am facing connection to https

2012-04-14 Thread Bruce Wade
Hi, For some reason I am having issues connecting to HTTPS for everything except admin -- -- Regards, Bruce Wade http://ca.linkedin.com/in/brucelwade http://www.wadecybertech.com http://www.fittraineronline.com - Fitness Personal Trainers Online http://www.warplydesigned.com

[web2py] CPU 210%

2012-04-14 Thread Bruce Wade
Hi, So I just launched and have been hit with a tone of traffic and my CPU on linode is showing 210% usage. Any suggestions? -- -- Regards, Bruce Wade http://ca.linkedin.com/in/brucelwade http://www.wadecybertech.com http://www.fittraineronline.com - Fitness Personal Trainers Online http://www.

Re: [web2py] Re: Get email on ticket creation

2012-04-14 Thread Anthony
> > I have been finding most of the book samples don't have enough information > to actually implement what the second talks about. > > For example where/how do I implement routes_onerror > routes_onerror = dict(application='error', controller='default', > function='index') > Did you read this

Re: [web2py] Re: Get email on ticket creation

2012-04-14 Thread Anthony
On Saturday, April 14, 2012 7:33:19 PM UTC-4, howesc wrote: > > CAVEAT: i'm using routes.py NOT router.py.not sure if that changes the > syntax There's no such thing as router.py -- routes always go in routes.py (whether using the parameter-based or pattern-based systems). Unfortunatel

[web2py] Digitally signed URLs

2012-04-14 Thread pyhead
I copied and pasted the examples for web2py Digitally signed URLs andthey are giving errors on the latest stable build. http://www.web2py.com/books/default/chapter/29/4#Digitally-signed-urls TypeError: verifyURL() takes at least 1 argument (1 given) The error is confusing as it seems to confi

[web2py] DAL IMAP errors

2012-04-14 Thread pyhead
Hi web2py users, db = DAL('imap://') successfully logs in to the mail server, but fails when the commonly used spaces or '.' are returned in a folder name. Is there any way to substitute not allowed characters for '_' so imap works? only [0-9a-zA-Z_] allowed in table and field names, receive

Re: [web2py] Custom attributes in

2012-04-14 Thread Bruno Rocha
DIV(, **{"_data-role": "something"}) http://zerp.ly/rochacbruno Em 14/04/2012 22:24, "Jon Molesa" escreveu: > Does the div class support hyphenated attribute names > data-role="listview"? I can't seem to get it to work. I can get _dat_role > and _datarole to work, but any attempt to use _dat

Re: [web2py] CPU 210%

2012-04-14 Thread Bruno Rocha
We have to see significant part of the code too figure out what is going on... http://zerp.ly/rochacbruno Em 14/04/2012 22:45, "Bruce Wade" escreveu: > Hi, > > So I just launched and have been hit with a tone of traffic and my CPU on > linode is showing 210% usage. Any suggestions? > > -- > -- >

[web2py] How to create a form from db.mytable, add checkboxes to each row and use form.custom.begin?

2012-04-14 Thread web2py_Superfan
I need to display my form in a customized view with checkboxes I added to each row but it wont let me use form.custom, whats the solution, drivin me nuts? heres my code controller def buy_now_coin_listing(): ''' list all coins in users collection that don't have a for sale listing

[web2py] Re: new feature in trunk: full auditing

2012-04-14 Thread tomt
I discovered why the archive table wasn't being created, there is a typo in gluon/tools.py at line 1293: for table in tables: if 'modifed_on' in table.fields(): should be for table in tables: if 'modified_on' in table.fields(): Now the the 'mythings_archi

[web2py] jstree, controller call

2012-04-14 Thread Simon Ashley
Having difficulties coming up with an appropriate call back from a jstree triggered from a .bind event. Javascript/ JQuery/ jsTree code is as follows: ).bind("select_node.jstree", function (event, data) { "xxx" } what we're trying to do is to make the call back ("xxx") to the controller t

Re: [web2py] shared host deployment of my web2py site

2012-04-14 Thread Chibuzo Ottih
So you mean I should just click the 'configure' file? And how do I add the parameters, are u saying I need to edit the file or once u click to run it, everything is going to go as expected. Another thing is this, I don't see anyway to run files in my Home directory. There are other options to a fil

Re: [web2py] CMS/blog app suitable for web2py beginners

2012-04-14 Thread Chibuzo Ottih
InstantPress is a more suitable CMS for blogs. That's its main aim. Movuca is a general CMS but more focused on social sites. I've used instantpress and its much fun. Its very easy to customize and has so many features you may want to add to your blog(e.g disquss) On Saturday, April 14, 2012, Gour

[web2py] Re: CMS/blog app suitable for web2py beginners

2012-04-14 Thread Gour
On Sun, 15 Apr 2012 07:39:58 +0100 Chibuzo Ottih wrote: > InstantPress is a more suitable CMS for blogs. Thank you. > That's its main aim. But it ca nbe use as CMS as well, right? > Movuca is a general CMS but more focused on social sites. Yeah, we're not interested for social sites, but m

[web2py] Re: priority of web2py CMS

2012-04-14 Thread Gour
On Mon, 16 Jan 2012 12:41:32 -0800 (PST) Ross Peoples wrote: Hello Ross, > The good news is I've already figured out how to do it, I just have to > put the work in. Have you done some work on your web2py-powered-CMS-ala-C5? Sincerely, Gour -- But those who, out of envy, disregard these teac