[web2py] Need help

Hi, Can any one help on this issue. https://groups.google.com/forum/#!topic/pymysql-users/vrnKcoE6ZD0 Thanks sushanth

Re: [web2py] Re: web2py 1.90.1 is OUT

from trunk VirtualFields is working well! Thanks! But, 1.90.2 still has this line: if callable(method)... and virtual fields not working. I'll wait next update to upgrade my working sites. Thank you, new dal seen to be much faster! 2010/12/19 tomt > Updating to 1.90.2 fixed all the mysq

[web2py] Re: Unable to detect your browser

On ubuntu you can change your defualt browser with below steps susha...@ubuntu:~$ sudo update-alternatives --config x-www-browser [sudo] password for sushanth: There are 2 choices for the alternative x-www-browser (providing /usr/bin/x-www-browser). SelectionPathPrior

[web2py] Re: Unable to detect your browser

this never worked for me. Under ArchLinux, I cant start web2py and chromium is indeed my default browser. This is what I tried: https://wiki.archlinux.org/index.php/Chromium#Default_browser On Nov 17, 3:35 pm, mdipierro wrote: > you should set the environment variableBROWSER > > http://docs.p

[web2py] Say hello to pyStack.com

Dear community, I am pleased to inform the release the first (beta) revision of pyStack.com, an open source questions and answers web application loosely based on the successful stack overflow web site. pyStack aims to be a simple to use Q&A app with all the fat trimmed off and at the same time ea

[web2py] Re: web2py 1.90.1 is OUT

Updating to 1.90.2 fixed all the mysql problems I listed and all my apps are working again. Thanks alot - Tom On Dec 18, 7:13 pm, tomt wrote: > I upgraded to Version 1.90.1 and all of my applications that use mysql > stopped working. The traceback shows: > > Traceback (most recent call last):

[web2py] Re: MENU items with target='_blank'

Instead of menu = MENU([['name',False,URL('default')]]) do menu = MENU([[A('name',_href=URL('default'),_target="_blank"),False,None]]) On Dec 18, 8:11 pm, Bruno Rocha wrote: > Hi, > > *I am trying to change every A item of MENU object, including > target='_blank' attribute,* > *menu is a '' ta

[web2py] Re: csvstudio: for those who need to handle csv files

One missing feature is something that "detects/guesses" columns types. This could be easily be integrated in the wizard to generate models/ lookup tables and import data from csv/excel files. That was the idea. On Dec 18, 8:35 pm, Bruno Rocha wrote: > I just see that it already has the function

[web2py] Re: KeyError: 'users'

Nope, its not working I have posted the issue in pymsql group. if possible can you please add mysql documentation on web2py site. coz most of the web application are designed in mysql i didn't much documentation. right now i am finding most of the content sqllite. Thank for the support. Regar

[web2py] Re: web2py 1.90.1 is OUT

web2py team rocks :)

[web2py] Re: web2py 1.90.1 is OUT

All problems (virtualfields and missing ssl) should be fixed in 1.90.2. out now! On Dec 18, 9:09 pm, Bruno Rocha wrote: > Crashes in shell too: > > >>> rows = db(db.products.id>0).select() > >>> class virtual(object): > > ...     def test(self): > ...         return 'ok' > ...>>> rows.setvir

Re: [web2py] web2py 1.90.1 is OUT

Crashes in shell too: >>> rows = db(db.products.id>0).select() >>> class virtual(object): ... def test(self): ... return 'ok' ... >>> rows.setvirtualfields(virtual=virtual()) Traceback (most recent call last): File "", line 1, in File "/Users/brunomac/web2py_new_dal/web2py/gluon/d

[web2py] Re: web2py 1.90.1 is OUT

yes you need to easy_install ssl sorry about this. This is actually a problem with pymysql and they should make the dependency optional. I will contact them. Massimo On Dec 18, 7:13 pm, tomt wrote: > I upgraded to Version 1.90.1 and all of my applications that use mysql > stopped working. The

Re: [web2py] web2py 1.90.1 is OUT

Crashes in *setvirtualfields *for Rows object sqlrows.setvirtualfields(virtual=virtualFields()) File "/Users/brunomac/web2py_new_dal/web2py/gluon/dal.py", line 4471, in setvirtualfields if callable(method) and method.im_func.func_code.co_argcount: File "/Users/brunomac/web2py_new_dal/web2p

[web2py] Re: web2py 1.90.1 is OUT

Congratulations, great work! For your information: an older version of an app that I'm working on crashes immediately as shown below. Maybe it helps you fixing something in the new DAL... in this app I used authorization as in the reddish example app... the newer version with the auth module runs f

Re: [web2py] csvstudio: for those who need to handle csv files

I just see that it already has the function to export filtered values! nice! >>> python csvstudio.py -i input.csv -q "year=2003 X005" -c price,quantity,revenue -r "revenue=price*quantity" -o output.csv -f csv Now I think it is easy to use the output file to import in to DAL (?) I am going try to

Re: [web2py] csvstudio: for those who need to handle csv files

Cool! would be nice to use the query functionality to get filtered data from CSV to use with import_from_.. in DAL. could be used to automate the import process. I am trying with large files. Thank you! 2010/12/18 mdipierro > http://csvstudio.googlecode.com/hg/csvstudio.pdf > > would be n

[web2py] MENU items with target='_blank'

Hi, *I am trying to change every A item of MENU object, including target='_blank' attribute,* *menu is a '' tag* >>> ul = UL(LI(A('test',_href='default'))) >>> print ul test *I thought I could change MENU in this way:* >>> ul.elements('a')[0].attributes {'_href': 'default'} >>> ul.elements('a')

[web2py] Re: web2py 1.90.1 is OUT

I upgraded to Version 1.90.1 and all of my applications that use mysql stopped working. The traceback shows: Traceback (most recent call last): File "/home/xa21/workspace/webpy4/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/home/xa21/workspace/webpy4/applic

[web2py] Re: mercurial.py : ignore sessions too

and uploads/* ?

[web2py] csvstudio: for those who need to handle csv files

http://csvstudio.googlecode.com/hg/csvstudio.pdf would be nice to have a web2py interface.

Re: [web2py] request for error log to default to "list by ticket"

+1

Re: [web2py] Re: curd.create redirect to created item on success

On Dec 18, 2010, at 2:45 PM, pbreit wrote: > This seems to work: > > form = SQLFORM(db.item) > if form.accepts(request.vars, session): > response.flash = 'Item added.' > redirect(URL('item', args=form.vars.id)) > With one caveat; you won't see the flash message unless you

[web2py] Re: curd.create redirect to created item on success

This seems to work: form = SQLFORM(db.item) if form.accepts(request.vars, session): response.flash = 'Item added.' redirect(URL('item', args=form.vars.id))

Re: [web2py] request for error log to default to "list by ticket"

+1 the same for me (to be honest I thonk it is so hard to manage tickets by exception, it is a nice feature as report, but I think teh default should be by ticket. 2010/12/18 weheh > 99.99% of the time when I visit the error log, it's to see the latest > ticket. In a recent release, the error lo

Re: [web2py] Powertable remarks

> > jqGrid also supports progressive loading (without paging , it > does ajax to load while scrolling down). > > I do not see those features exist in datatables. Just got progressive loading working on powerTable plugin powerTable.dtfeatures['bScrollInfinite'] = True powerTable.dtfeatures['iScr

[web2py] Re: Run Web2py as a Service? on Ubuntu Lucid?

Thanks Kenneth. When I look in the specified dir I see that no web2py existed. I thought maybe you meant changing the value $PIDDIR, so I tried that. I changed it to /root/$name and I ended up with the same result. It created /root/web2py, but the directory is empty. On Dec 18, 2:18 pm, Kenneth Lu

Re: [web2py] web2py 1.90.1 is OUT

+1 excellent teamwork 2010/12/18 mdipierro > This is a major - major release mostly because it includes the new > DAL. > > It is supposed to be 100% backward compatible but cleaner, and more > readable. We have fixed every known issue. If 1.90.1 breaks you DAL > queries, please report it asap s

[web2py] request for error log to default to "list by ticket"

99.99% of the time when I visit the error log, it's to see the latest ticket. In a recent release, the error log started to default to "list by exception". This is a nice feature, but I almost never use it. So I'm always forced to click on "list by ticket" and then click on the first item. If othe

[web2py] Re: KeyError: 'users'

Is this something that worked before? The error appear to be in the new pymysql driver. I do not know what it means but they have a very responsive mailing list (like ours) and perhaps you should also ask them. Massimo On Dec 18, 12:36 pm, sushanth wrote: > I am using new dal.py file from trunk,

[web2py] web2py 1.90.1 is OUT

This is a major - major release mostly because it includes the new DAL. It is supposed to be 100% backward compatible but cleaner, and more readable. We have fixed every known issue. If 1.90.1 breaks you DAL queries, please report it asap so that it can be addressed sooner. It also includes a lo

Re: [web2py] Re: Run Web2py as a Service? on Ubuntu Lucid?

Try to move the web2py.pid file and try again. Kenneth Thanks for the tip! Removed --quiet from the two lines. The service still doesn't appear to start on startup (after reboot). When I manually start with /etc/init.d/web2py (root user) I get this: No process in pidfile '/var/run/web2py/web2p

[web2py] Re: Run Web2py as a Service? on Ubuntu Lucid?

Thanks for the tip! Removed --quiet from the two lines. The service still doesn't appear to start on startup (after reboot). When I manually start with /etc/init.d/web2py (root user) I get this: No process in pidfile '/var/run/web2py/web2py.pid' found running; none killed. And the service doesn't s

[web2py] Re: KeyError: 'users'

if possible,can you please small mysql example for creating FK for string field with dal.py. this example will help me lot in fix key issue. Thanks in advance

[web2py] Re: KeyError: 'users'

I am using new dal.py file from trunk,but it throws below error Traceback (most recent call last): File "/home/sushanth/web2py/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/home/sushanth/web2py/applications/new/models/db.py"

[web2py] Re: KeyError: 'users'

I am not accepting any more patch to sql.py. This file is deprecated. Any new DAL patches should apply to trunk and the dal.py file. Massimo On Dec 18, 10:40 am, sushanth wrote: > I have added below lines to gluon/sql.py,but stil getting same error > >  'reference FK': 'INDEX %(field_name)s__idx

[web2py] Re: variables

I seriously doubt this would work. The [] where you have [n=n+1] is supposed to be a list of html targets whose values will be passed back to the controller URL('index'). The proper ajax call would be onclick="ajax('index',[],':eval');return false;". In this case, "index" is defined in the controll

[web2py] Re: variables

If "n" would be a global variable in a controller file, can I use something like this then? {{=n}} plus On Dec 18, 4:23 pm, Rick wrote: > Perhaps there is a way to get different variable values depending on > what address you load??? For example: > http:...default/index.html...something...

Re: [web2py] Re: OT: why are old style classes still used ?

thanks Massimo. cheers, Stef On 18-12-2010 17:00, mdipierro wrote: > web2py should use new style classee everywhere. Prompted by your > messages and an email form Jonathan and double checked and I found a > few old style classes around. I just fixed them in trunk. > > massimo > > On Dec 18, 4:32 a

[web2py] Re: KeyError: 'users'

I have added below lines to gluon/sql.py,but stil getting same error 'reference FK': 'INDEX %(field_name)s__idx (%(field_name)s), FOREIGN KEY (%(field_name)s) REFERENCES %(foreign_key)s ON DELETE %(on_delete_action)s', 'reference TFK': ' INDEX %(field_name)s__idx (%(field_name)s), FORE

[web2py] Re: BUG on new DAL and _filter_fields?

this is a major bug and it should now be fixed in trunk. Massimo On Dec 18, 8:16 am, Tito Garrido wrote: > It prints: > > INSERT INTO > user_jogo(user,jogo,versao_jogo,disponivel_troca,condicao,comentario,valor,troco_por,status,avaliacao_vendedor,avaliacao_comprador,date_on) > VALUES (2,1,'Asia'

[web2py] Re: the new dal is returning none instead of "" when default=""

oops. fixed in trunk. On Dec 18, 6:13 am, "Martin.Mulone" wrote: > From web2py from trunk I have this code. In older version has no problem with > this. This stop instant press working with the last version. > > ==BEGIN CODE == > db.define_table('problematic'

[web2py] Re: OT: why are old style classes still used ?

web2py should use new style classee everywhere. Prompted by your messages and an email form Jonathan and double checked and I found a few old style classes around. I just fixed them in trunk. massimo On Dec 18, 4:32 am, Stef Mientki wrote: > hello, > > a few weeks ago, I was debugging a web2py a

[web2py] Re: Run Web2py as a Service? on Ubuntu Lucid?

When I had this kind of problem, I removed the --quiet and -- background in the /etc/init.d/web2py file (line 65 and 67 of your 3rd file). I was then able to get some error messages when doing /etc/init.d/ web2py start In my case, it helped me to find a stupid error I did. Good luck. On Dec 18,

[web2py] Re: variables

Perhaps there is a way to get different variable values depending on what address you load??? For example: http:...default/index.html...something...n=1,m=0 On Dec 18, 4:07 am, Luther Goh Lu Feng wrote: > You can use javascript or jquery(since web2py includes jquery) to do > this: > > ==javasc

Re: [web2py] Re: BUG on new DAL and _filter_fields?

It prints: INSERT INTO user_jogo(user,jogo,versao_jogo,disponivel_troca,condicao,comentario,valor,troco_por,status,avaliacao_vendedor,avaliacao_comprador,date_on) VALUES (2,1,'Asia','T','Novo','sdaskjdklsajdkas ljklasj dklsajdlksajkldjsakl j',80,,'Aberto','Positiva','Positiva','2010-12-18 11:14:12

[web2py] Re: KeyError: 'users'

Only DB2, MS-SQL, Ingres and Informix have support for keyed tables so far as per the note in http://web2py.com/book/default/chapter/06#Legacy-Databases-and-Keyed-Tables But it can be added with fairly little effort, see section E) in http://groups.google.com/group/web2py/browse_thread/thread/db1

[web2py] the new dal is returning none instead of "" when default=""

>From web2py from trunk I have this code. In older version has no problem with >this. This stop instant press working with the last version. ==BEGIN CODE == db.define_table('problematic', Field('id', 'id'), Field('myfield','str

[web2py] KeyError: 'users'

Hi, How to create a primary key as name as filed not id,right now i have exiting mysql schema in that string is PK and connected FK to other string field.i am design a app in web2py in that creating models using existing schema but web2py is creating only id as PK default. Can you please h

[web2py] OT: why are old style classes still used ?

hello, a few weeks ago, I was debugging a web2py application, and printing some intermediate variables I got weird results, like : TypeError: 'int' object is not callable and || || |I didn't understand these results then,| |and solved my problems in another way Now I debugging a totally d

Re: [web2py] helper tabs

forgot comment: 1) PEST was changed by "TAB" 2) the system detects the color of the main DIV and appliesthe tab 3) can even customize the color of the tab off, default is light green 2010/12/18 Luis Díaz > > as recommended by a friend: Bruno Rocha > > make some changes to the system tab > > I ge