[web2py] Re: cache.redis server unavailable = traceback. Bug?

2015-05-07 Thread Jose C
Ok, issue opened: https://github.com/web2py/web2py/issues/958 Thanks 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 received this message

[web2py] Re: web2py-mongodb-engine

2015-05-07 Thread Paolo Valleri
I don't see any problem at all in implementing a common post-comment page in web2py. You can code it independently from the backend. On Wednesday, May 6, 2015 at 8:28:08 PM UTC+2, Ron Chatterjee wrote: Here is another tutorial from django:

Re: [web2py] downloading old web2py version from github

2015-05-07 Thread Niphlod
*unable to open database file* doesn't mean that web2py isn't running. Probably the earlier version doesn't contain appconfig, which your app seems to rely on for configuration... On Thursday, May 7, 2015 at 1:12:25 AM UTC+2, Richard wrote: Hello, I was wanting to get an old version of

[web2py] Re: from desktop to web2py

2015-05-07 Thread 黄祥
if you use sqlform.factory, i think you should do the insert data from sqlform.factory to the table manually. e.g. taken from http://web2py.com/books/default/chapter/29/07/forms-and-validators#SQLFORM-factory modified it def form_from_factory(): form = SQLFORM.factory(

[web2py] Pydal issues

2015-05-07 Thread José Ricardo Borba
Sorry about that title, but I'm seeing in the messages that is a number of messages with pydal connection errors, even with some (little) older versions. My issue with MONGODB is (at some point) replicated with MSSQL, @Alan (don't know about what database). So, after (another) installation of

Re: [web2py] Re: MongoDB

2015-05-07 Thread José Ricardo Borba
Yes, I did! Thanks for the advice. But submodule when cloning web2py still doesn't work. Best regards, 2015-05-07 16:25 GMT-03:00 Paolo Valleri paolo.vall...@gmail.com: update your local copy of pydal, there are several updates regarding mongo in master branch Paolo 2015-05-07 21:14

Re: [web2py] Pydal issues

2015-05-07 Thread Richard Vézina
I had the same issue last night trying to clone web2py... pydal never shows up!! Richard On Thu, May 7, 2015 at 3:06 PM, Richard Vézina ml.richard.vez...@gmail.com wrote: copy mannually the pydal in web2py gluon/packages folder... which is what git clone --recursive web2py repo should do...

Re: [web2py] Re: MongoDB

2015-05-07 Thread José Ricardo Borba
Allright! Updating pymongo to version 3.0 solves this up! Now I take care of the mongo time / pydal issue! Thanks a lot. 2015-05-07 9:05 GMT-03:00 Paolo Valleri paolo.vall...@gmail.com: You should use pymongo 3.0 On Wednesday, May 6, 2015 at 2:38:56 PM UTC+2, José Borba wrote: I'm very

Re: [web2py] Re: MongoDB adapter

2015-05-07 Thread José Ricardo Borba
YAY Everything is working FINE! Thank you very much, Paolo, Massimo and others. Cheers. 2015-05-04 10:39 GMT-03:00 Ron Chatterjee achatterjee...@gmail.com: What is mongodb adapter? Where do I find that info? On Monday, May 4, 2015 at 8:39:48 AM UTC-4, Paolo Valleri wrote: It should

Re: [web2py] Pydal issues

2015-05-07 Thread Richard Vézina
copy mannually the pydal in web2py gluon/packages folder... which is what git clone --recursive web2py repo should do... Richard On Thu, May 7, 2015 at 3:02 PM, José Ricardo Borba jrborba...@gmail.com wrote: Sorry about that title, but I'm seeing in the messages that is a number of messages

Re: [web2py] Re: MongoDB

2015-05-07 Thread Paolo Valleri
update your local copy of pydal, there are several updates regarding mongo in master branch Paolo 2015-05-07 21:14 GMT+02:00 José Ricardo Borba jrborba...@gmail.com: Allright! Updating pymongo to version 3.0 solves this up! Now I take care of the mongo time / pydal issue! Thanks a lot.

Re: [web2py] Pydal issues

2015-05-07 Thread Niphlod
unfortunately, bad commit happens. we know already. https://github.com/web2py/web2py/commit/6f91fdd8332beb5e6a17a1444655e9b9f22e2f4c#commitcomment-11073544 On Thursday, May 7, 2015 at 9:06:51 PM UTC+2, Richard wrote: I had the same issue last night trying to clone web2py... pydal never shows

Re: [web2py] Pydal issues

2015-05-07 Thread José Ricardo Borba
Thank you, Niphlod and Richard, to take care about. Cheers, 2015-05-07 16:18 GMT-03:00 Niphlod niph...@gmail.com: unfortunately, bad commit happens. we know already. https://github.com/web2py/web2py/commit/6f91fdd8332beb5e6a17a1444655e9b9f22e2f4c#commitcomment-11073544 On Thursday, May 7,

Re: [web2py] Re: from desktop to web2py

2015-05-07 Thread Marcello Console
Thank you for your help Stifan. The problem here is that i need to let the user choose among some value gotted from the excel file he gave as input. And i should do this meanwhile writing other files. How can i do this? Make all this stuff as an ajax function called after the user select the file

[web2py] Re: MSSQLAdapter missing?

2015-05-07 Thread Niphlod
On Thursday, May 7, 2015 at 6:01:17 PM UTC+2, Ron Chatterjee wrote: May be now people will start using mongodb and I will get all my question answered! lol it doesn't have nothing to do with it. @carl: looks like you screwed something up... latest web2py version should use pydal embedded

Re: [web2py] Two SQLFORMs side by side?

2015-05-07 Thread LoveWeb2py
Okay... must be something on my end. I'm getting Filaed to load resourrce: the server responded with a status of 500 (INTERNAL SERVER ERROR) http;//www.mysite.com/myapp/controller/add_function/name_of_table_field I'll keep playing around with it and let you know how it turns out. Thank you so

[web2py] Re: Issues with PythonAnywhere - /proc/meminfo

2015-05-07 Thread Paolo Valleri
Hi, you have spotted an issue on the new cache system. I've opened the issue so we can fix it soon. https://github.com/web2py/web2py/issues/959 Paolo On Wednesday, May 6, 2015 at 3:28:44 PM UTC+2, Lovecannon wrote: Hello I'm having some issues with web2py and PythonAnywhere. It seems as

[web2py] Re: Postgresql problems with 2 tabs

2015-05-07 Thread Niphlod
try to use different formname= argument for each page. On Thursday, May 7, 2015 at 12:14:38 PM UTC+2, Gael Princivalle wrote: Hello all. I've moved a db from sqlite to postgresql, but I've got a strange problem. With only one tab, ok. If I have two tabs with the same application, it seems

[web2py] Re: web2py-mongodb-engine

2015-05-07 Thread Ron Chatterjee
Below is what I have the model in django. I can do the ListField() in web2py using list:string I believe but I am having problem with how to do EmbeddedModelField! in web2py. I don't understand what you mean by do it independently of backend! Do you mean to insert the table in mongodb

Re: [web2py] Two SQLFORMs side by side?

2015-05-07 Thread LoveWeb2py
Hi Richard! I think I'm getting close. No more errors, and I applied the widget to the field successfully. I see the + sign next to my field, but nothing happens when I click it so I'm going over the javascript with a fine tooth comb. Is there any additional .js or .css files I need to

Re: [web2py] parenthesis in SQLFORM.grid search

2015-05-07 Thread Richard Vézina
Here what I got for now : from pyparsing import nestedExpr # Not the worse case but has enough complexity to start with grouped_query_string = \ 'a_table.integer_field 1) ' \ ' (a_table.integer_field not equal 2) ' \ ' (~a_table.integer_field in 200, 300, 400))

[web2py] Re: many to many with SQLFORM.grid

2015-05-07 Thread 黄祥
had you tried it? another work around is u can use smartgrid constraints e.g. def test(): table = db.co_meet query = db.co_meet.ref_company == 1 # whatever value that refer to table company grid = SQLFORM.smartgrid(table, constraints = dict(co_meet=query) ) return locals() best

[web2py] Re: many to many with SQLFORM.grid

2015-05-07 Thread Ben Lawrence
Thanks! But wouldn't that just give me a grid of 'co_meet' and not 'meeting'? On Monday, May 4, 2015 at 9:20:01 AM UTC-7, 黄祥 wrote: perhaps, you can do e.g. def test(): query = db.co_meet.ref_company == 1 # whatever value that refer to table company grid=SQLFORM.grid(query)

Re: [web2py] parenthesis in SQLFORM.grid search

2015-05-07 Thread Richard Vézina
Recursive problem... I get closer, but have a lot of difficulty figuring out how to assembling the nested queries in the right order and the right depth of each query... I have been so far able to extract a flatten dict of each individually nested query and translated them into web2py query...

Re: [web2py] Re: Sublime Text web2py plugin

2015-05-07 Thread António Ramos
if i open console i see this before installing SublimeREPL warning: mnemonic r not found in menu caption SublimeREPL warning: mnemonic r not found in menu caption Ruby warning: mnemonic p not found in menu caption Python warning: mnemonic d not found in menu caption Python - PDB current file

[web2py] Re: web2py-mongodb-engine

2015-05-07 Thread Alan Etkin
I did not check the django app code but if you want to handle embedded json objects you should use table definitions with a json field. Something like db.define_table(mytable, Field(embeddedobject, json) # db is a mongodb connection (DAL instance) -- Resources: - http://web2py.com -

Re: [web2py] IS_IN_DB() multiple tables

2015-05-07 Thread Richard Vézina
Ok, I don't understand... Can you go back one step and explain what kind of information you want to manage and why you think you have to update the IP address... Is there multiple records with the same server name if so why... It seems to me that you want to manage kind of history of IP attached

Re: [web2py] IS_IN_DB() multiple tables

2015-05-07 Thread Anthony
On Wednesday, May 6, 2015 at 10:52:05 AM UTC-4, Richard wrote: A set which you have, but your validator has wrong syntax : IS_IN_DB(db(db.ipaddress.status=='Free'),db.ipaddress.ip, '%(ip)s') free_ip_set = db(db.ipaddress.status=='Free') IS_IN_DB(free_ip_set, 'ipaddress.ip', '%(ip)s') When

Re: [web2py] deploment on an obsolete Debian 5 server

2015-05-07 Thread Niphlod
rather recently https://github.com/web2py/pydal/issues/60 (20 march) On Thursday, May 7, 2015 at 3:39:05 PM UTC+2, Alan Etkin wrote: @Michelle Looks like the backports does not include python 2.7 (at least with the sources I searched so far). @Simone we don't support python 2.5 from

Re: [web2py] downloading old web2py version from github

2015-05-07 Thread Richard Vézina
Not my app welcome app!! I saw ne appconfig.ini which is great, but not seems to works properly... I try to troubleshoot with limited time and didn't get anywhere... Richard On Thu, May 7, 2015 at 3:05 AM, Niphlod niph...@gmail.com wrote: *unable to open database file* doesn't mean that

Re: [web2py] Two SQLFORMs side by side?

2015-05-07 Thread Richard Vézina
you need bootstrap 2.3.2 (not tested with BS3, but I am pretty sure it is not working, too differents)... Did you try it with a recent web2py setup? I would suggest you try with web2py 2.9.5 which is what I use actually and it works... Richard On Thu, May 7, 2015 at 9:20 AM, LoveWeb2py

[web2py] MSSQLAdapter missing?

2015-05-07 Thread Carl Petersen
Hello All, Working with the latest versions of web2py and it seems that my sql server connections are breaking. I noticed that a fairly large section of code related to MSSQLAdapter in gluon/dal.py has been taken out. Should I be approaching sql server connections differently now. I was

Re: [web2py] deploment on an obsolete Debian 5 server

2015-05-07 Thread Alan Etkin
@Michelle Looks like the backports does not include python 2.7 (at least with the sources I searched so far). @Simone we don't support python 2.5 from some time.. it's possible that I can't import is a result of tried and failed rather than didn't find it. When was python 2.5

[web2py] Re: MSSQLAdapter missing?

2015-05-07 Thread Niphlod
still there. https://github.com/web2py/pydal/blob/master/pydal/adapters/mssql.py . noone removed anything. On Thursday, May 7, 2015 at 3:41:28 PM UTC+2, Carl Petersen wrote: Hello All, Working with the latest versions of web2py and it seems that my sql server connections are breaking. I

Re: [web2py] Two SQLFORMs side by side?

2015-05-07 Thread LoveWeb2py
Another observation: All of this code: js += '$(function() {' \ '$(#%s_option_add_trigger).button({' \ 'text: true,' \ 'icons: {' \ 'primary: ui-icon-circle-plus' \ '}' \

[web2py] Re: Solve enconding on diferent server

2015-05-07 Thread Tom Stratton
Hi Leonardo - I think that the issue probably lies in the pg8000 adapter in pydal. I'm trying to hunt down a couple of unicode errors in that module. It would really help me if you could post the stack trace of the error that you get. The error message itself is not much help in finding the

Re: [web2py] IS_IN_DB() multiple tables

2015-05-07 Thread kecajkecaj123
Hi, What's the difference between what i wrote and what You wrote? And i believe You didn't get my point. Checking if IP is Free works correctly. Point is that i want do update the one row in Server table and change i.e. server name. I click on update button provided by grid, and i can

[web2py] Re: Any problem in list:reference in 2.10 ?

2015-05-07 Thread Ben Lawrence
This fixes an error I experience in the db admin interface, when I use postgresql. When i use sqlite, I did not see this error for the same code in my app. On Wednesday, April 29, 2015 at 3:07:21 AM UTC-7, Paolo Valleri wrote: Hi, Can you try the fix I proposed in

Re: [web2py] Re: from desktop to web2py

2015-05-07 Thread Dave S
On Thursday, May 7, 2015 at 12:12:20 PM UTC-7, goome wrote: Thank you for your help Stifan. The problem here is that i need to let the user choose among some value gotted from the excel file he gave as input. Do you need to do this before adding anything from the file to the database?

[web2py] Re: MSSQLAdapter missing?

2015-05-07 Thread Carl Petersen
OK, obviously I approached this in the wrong manner. Sorry! I'm upgrading from 2.9.11-stable+timestamp.2014.09.15.23.35.11 to 2.10.4-stable+timestamp.2015.04.26.15.11.54 and it looks like DAL has changed somewhat in that timeframe. For some reason it seems my sql server connections are

[web2py] Re: MSSQLAdapter missing?

2015-05-07 Thread Ron Chatterjee
May be now people will start using mongodb and I will get all my question answered! lol On Thursday, May 7, 2015 at 11:58:06 AM UTC-4, Carl Petersen wrote: OK, obviously I approached this in the wrong manner. Sorry! I'm upgrading from 2.9.11-stable+timestamp.2014.09.15.23.35.11 to

Re: [web2py] Re: Show tables

2015-05-07 Thread Kevin Capuchino
Thanks for your answer. But I tried that. I need create a subquery of many tables and show it where the user can edit or delete. I have understood that SQLFORM grid only accepts tables no rows, is it true? 2015-05-06 17:00 GMT-05:00 黄祥 steve.van.chris...@gmail.com: for show two tables in 1 page

Re: [web2py] IS_IN_DB() multiple tables

2015-05-07 Thread Richard Vézina
Anthony, do you mean that the set can be define before ipaddress table get defines? On Thu, May 7, 2015 at 10:13 AM, Anthony abasta...@gmail.com wrote: On Wednesday, May 6, 2015 at 10:52:05 AM UTC-4, Richard wrote: A set which you have, but your validator has wrong syntax :

[web2py] Re: web2py-mongodb-engine

2015-05-07 Thread Ron Chatterjee
Thank you Alan and Massimo and others. I didn't realize mongodb adaptor support reference field. My bad. Thanks for all the help guys. On Thursday, May 7, 2015 at 9:59:58 AM UTC-4, Alan Etkin wrote: I did not check the django app code but if you want to handle embedded json objects you

[web2py] from desktop to web2py

2015-05-07 Thread goome
Hello I am porting a desktop script to web by means of web2py. The desktop script gets in input some file, process them,make some stuff to sqlitedb, and give as output other xls file. I have already done similar porting for similar script, but the problem now is the in the desktop script after

[web2py] Postgresql problems with 2 tabs

2015-05-07 Thread Gael Princivalle
Hello all. I've moved a db from sqlite to postgresql, but I've got a strange problem. With only one tab, ok. If I have two tabs with the same application, it seems that data's are mixed. For example in tab 1 I have a grid, in tab 2 a page. When I save from tab 1 grid I see some data's from tab

[web2py] Re: MongoDB

2015-05-07 Thread Paolo Valleri
You should use pymongo 3.0 On Wednesday, May 6, 2015 at 2:38:56 PM UTC+2, José Borba wrote: I'm very busy in these days, but I tried to start a new installation from the ground (to test the TIME issue with Mongodb in pydal #170), but even without this correction (i.e, with plain web2py