[web2py] Re: reference auth_user from a table in one database to the auth_user table in another database

2014-10-23 Thread Niphlod
you can't reference fields from different databases. On Thursday, October 23, 2014 3:07:50 PM UTC+2, Carl Petersen wrote: > > Hello, > > I'm trying to reference the auth_user table in one database from a field > definition for a table in a different database. Hopefully the code below > will cl

[web2py] Re: working directory and runtime directory when running web2py

2014-10-22 Thread Niphlod
nice catch. https://github.com/web2py/web2py/pull/535 On Wednesday, October 22, 2014 10:48:40 PM UTC+2, David Ripplinger wrote: > > Yep, it works. Good job. > > On Wednesday, October 22, 2014 4:41:31 PM UTC-4, Niphlod wrote: >> >> got the issue, reproduced it, fixed it. I

[web2py] Re: working directory and runtime directory when running web2py

2014-10-22 Thread Niphlod
from > which it gets called. What it needs in order to not be broken is to have > the runtime directory be 'web2py', where web2py.exe is located. > > On Wednesday, October 22, 2014 4:26:01 PM UTC-4, Niphlod wrote: >> >> whoopsy. it needs also the corresponding librar

[web2py] Re: working directory and runtime directory when running web2py

2014-10-22 Thread Niphlod
whoopsy. it needs also the corresponding library.zip. stay tuned, I'll try to make something against 2.9.11. On Wednesday, October 22, 2014 10:12:34 PM UTC+2, David Ripplinger wrote: > > Tried it. It does the same thing. Sorry. > > On Wednesday, October 22, 2014 4:01:32 PM UTC

[web2py] Re: working directory and runtime directory when running web2py

2014-10-22 Thread Niphlod
try this instead https://www.dropbox.com/s/jd4oxlilmel8ghz/web2py.exe?dl=0 On Wednesday, October 22, 2014 9:03:34 PM UTC+2, Niphlod wrote: > > uhm. they should behave in the same way. investigating... > > On Wednesday, October 22, 2014 6:11:56 PM UTC+2, David Ripplinger wr

[web2py] Re: working directory and runtime directory when running web2py

2014-10-22 Thread Niphlod
uhm. they should behave in the same way. investigating... On Wednesday, October 22, 2014 6:11:56 PM UTC+2, David Ripplinger wrote: > > I recently discovered there are a couple things about the working > directory and the runtime directory when running web2py. > >- If you launch "python we

[web2py] Re: Scheduler tasks won't run

2014-10-22 Thread Niphlod
" error assigning tasks " with type ERROR is a pretty big pointer. Usually this happens when you don't let the scheduler migrate/create the tables. On Wednesday, October 22, 2014 4:58:09 PM UTC+2, Jim S wrote: > > I'm using the web2py scheduler. I've used it before without problems but > all of

[web2py] Re: web2py setup scripts for windows

2014-10-22 Thread Niphlod
I'll be joining this discussion as soon as I get time to install a fresh system. ATM I can't replicate your issues, but TBF I tested the creation of applications only 2008r2 and 2012 and no 2012r2 (where I did a fast check to ensure it was running like on 2012) On Wednesday, October 22, 2014 1:

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-10-18 Thread Niphlod
; changed: > > if self.driver_name == "pg8000": > supports_json = self.connection.server_version >= "9.2.0" > > Anthony > > On Wednesday, October 15, 2014 12:07:49 PM UTC-4, ArnvShrma wrote: >> >> Hi Niphlod, >> >> I am a ne

Re: [web2py] Re: How to delete session file on logout

2014-10-18 Thread Niphlod
that's why the whole thing goes away behind SSL. Expiring a session on logout is better than leaving it as it is, but even in that case while userA is logged in there's NO way to prevent a MITM from someone else. On Saturday, October 18, 2014 12:18:30 AM UTC+2, Anthony wrote: > > On Friday, Octo

[web2py] Re: Deployment

2014-10-18 Thread Niphlod
the question is RY strange. goes on the same line as "is it possible to deploy a single python app without python" ? if you have a web2py app, you need web2py to let the app run. On Saturday, October 18, 2014 4:20:17 AM UTC+2, Jigar Mistry wrote: > > Hello everyone, > > Is thi

[web2py] Re: Change to postgresql database issue

2014-10-18 Thread Niphlod
if you change the database uri, you NEED to let web2py migration on, at least for the very first request. Your "migrate_enabled=False" is making web2py think a table is already created. On Saturday, October 18, 2014 4:26:11 AM UTC+2, Tony Huang wrote: > > Recently, I start to research web2py. >

[web2py] Re: Error starting up scheduler with postgresql - "type oid 114 not mapped to py"

2014-10-18 Thread Niphlod
erted to JSON but > just passed with quotes around it. But again, this seems to be inside > web2py, not anyting that I am doing in my code. Do you have any clues on > what the issue may be this time, and what I could do about it? Again, my > goal so far is just to be able to start th

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-10-17 Thread Niphlod
that we can check what > works and what doesn't. > I'd suggest that you can open an issue here > https://github.com/mfenniak/pg8000/issues regarding the missing feature > of having json as field type. > > Paolo > > On Wednesday, October 15, 2014 6:07:49 PM UTC

[web2py] Re: Error starting up scheduler with postgresql - "type oid 114 not mapped to py"

2014-10-17 Thread Niphlod
gt; > On Tuesday, October 14, 2014 9:26:07 AM UTC-3, Niphlod wrote: >> >> the problem comes from pg8000 not supporting the json type. Use psycopg2 >> instead. >> >> On Monday, October 13, 2014 9:56:38 PM UTC+2, Sebastian Echeverria wrote: >>> >>>

[web2py] Re: scheduler isn't starting

2014-10-15 Thread Niphlod
cific app, since it does not > return any error or relevant debug info. What could be the reason for it to > assign no tasks while I have at least 3 tasks on db? > > Em quarta-feira, 15 de outubro de 2014 16h46min41s UTC-3, Niphlod escreveu: >> >> With that record and

[web2py] Re: scheduler isn't starting

2014-10-15 Thread Niphlod
gt; > yeah, I forgot to tell that I "cloned" the app into a new one, with other > name, but I'm using the right name in the parameter anyway. > > Em quarta-feira, 15 de outubro de 2014 12h19min53s UTC-3, Niphlod escreveu: >> >> doh! you're right. I see

[web2py] Re: scheduler isn't starting

2014-10-15 Thread Niphlod
a day after start_time. Anyway, nothing happens if > I don't define a stop_time. > > Em quarta-feira, 15 de outubro de 2014 09h52min13s UTC-3, Niphlod escreveu: >> >> meaning. stop_time isn't there in the video, and shouldn't be there >> in you

[web2py] Re: scheduler isn't starting

2014-10-15 Thread Niphlod
meaning. stop_time isn't there in the video, and shouldn't be there in your record. It means "please don't process this task if stop_time passed" On Wednesday, October 15, 2014 2:49:43 PM UTC+2, Niphlod wrote: > > you have stop_time equal to start_time.

[web2py] Re: scheduler isn't starting

2014-10-15 Thread Niphlod
you have stop_time equal to start_time. that's the reason why it isn't working ... -- 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

Re: [web2py] Re: Scheduler only runs 1 task from 2 queued

2014-10-15 Thread Niphlod
r i change my code i have to exit my shell console and run it again > right? > > Regards > > 2014-10-15 10:03 GMT+01:00 António Ramos > >: > >> >> 2014-10-14 23:06 GMT+01:00 Niphlod >: >> >>> web2py.py -M -S appname >> >> &g

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-10-14 Thread Niphlod
On Tuesday, October 14, 2014 11:50:45 PM UTC+2, ArnvShrma wrote: > > Hi Niphlod, > > I tried using psycopg2 but there are few reasons because of which I can > not use it. I am currently deploying travis CI to run Sahana Eden unit > tests. psycopg2 fails a few of the tes

Re: [web2py] Re: Scheduler only runs 1 task from 2 queued

2014-10-14 Thread Niphlod
have to change the next run minute and wait like a sitting duck > for it to happen. > Is there a better way ? > > Thank you > > > > > > 2014-10-14 20:42 GMT+01:00 Niphlod >: > >> I could say in the same manner "please queue a task without any >> p

[web2py] Re: scheduler isn't starting

2014-10-14 Thread Niphlod
t; same return, but nothing is really happening or working. My task does not > run (and yep, I have one task and it is counting 0 taks on log). > > Em terça-feira, 14 de outubro de 2014 16h33min59s UTC-3, Niphlod escreveu: >> >> what are you expecting to see ? Scheduler

Re: [web2py] Re: Scheduler only runs 1 task from 2 queued

2014-10-14 Thread Niphlod
I could say in the same manner "please queue a task without any parameters" to get it running right away, or "code your own button" In any case, we won't add such a button because you're missing the difference between a "function" and a "task". If you need to run a function "now", either queue it

[web2py] Re: scheduler isn't starting

2014-10-14 Thread Niphlod
> DEBUG:web2py.scheduler.ereshkigal#15083:sleeping... > DEBUG:web2py.scheduler.ereshkigal#15083:recording heartbeat > (ACTIVE) > > The messages keep repeating and nothing happens, but I don't get the > meaning of them. > > > Em terça-feira, 14 de outubro de 2014 10h59mi

[web2py] Re: Is it possible to restrict a user to single login instance ?

2014-10-14 Thread Niphlod
you should track somewhere that userA from machineA is in there and check when userA logs in from machineB. There's a pretty outstanding issue in your design, though how do you recognize machineA from machineB ? On Tuesday, October 14, 2014 8:01:19 PM UTC+2, Mandar Vaze wrote: > > This is r

Re: [web2py] Re: Scheduler only runs 1 task from 2 queued

2014-10-14 Thread Niphlod
your next_run_time is one month ahead . On Tuesday, October 14, 2014 2:37:35 PM UTC+2, Ramos wrote: > > thank you > [image: Imagem inline 1] > > 2014-10-14 13:23 GMT+01:00 Niphlod >: > >> if you care to paste your current scheduler_task records, we can tell you &g

[web2py] Re: scheduler isn't starting

2014-10-14 Thread Niphlod
use python web2p.py -K test -D 0 to activate the debug logging if you need more details On Tuesday, October 14, 2014 3:29:12 PM UTC+2, Júlia Rizza wrote: > > Hey guys :) > > I was following this video (http://vimeo.com/27478796) to run the > scheduler, but whenever I try to run it in my app call

[web2py] Re: Error starting up scheduler with postgresql - "type oid 114 not mapped to py"

2014-10-14 Thread Niphlod
the problem comes from pg8000 not supporting the json type. Use psycopg2 instead. On Monday, October 13, 2014 9:56:38 PM UTC+2, Sebastian Echeverria wrote: > > Hello, > > I am having some trouble starting up web2py's scheduler. I am working on a > Ubuntu server, using web2py 2.9.9 deployed with

Re: [web2py] pg8000 driver that comes with web2py 2.8.2 is not supporting JSON field type?

2014-10-14 Thread Niphlod
t; >>> If this kind of changes could be accepted (psycopg2 compatibility, >>> simple query protocol, dbapi 2.0 two-pass commit, etc.), I could help to >>> make the pull requests (note that some could depend on each other). >>> Sorry I couldn't keep track of pg

[web2py] Re: Scheduler only runs 1 task from 2 queued

2014-10-14 Thread Niphlod
if you care to paste your current scheduler_task records, we can tell you what's preventing the task from being executed. On Tuesday, October 14, 2014 1:17:59 PM UTC+2, Ramos wrote: > > Hello i have 2 tasks > one hourly and one daily > The daily did not run today so i changed it to next minute to

[web2py] Re: SQLFORM.grid, selectable and id

2014-10-13 Thread Niphlod
nt_side=True), > maxtextlength=256,paginate=256, formstyle= > my_formstyle, ui=grid_ui) > > > It is bringing the ID field from the feedLoad table. I want the id from > the feedOrderLine table. Also, I've tried changing the order of the fields > in

Re: [web2py] Re: Item in ``from list'' not a string (custom_import.py) web2py 2.9.11

2014-10-13 Thread Niphlod
y it still uses Python *2.7.6*. > > On the other hand I've tried to apply the patch with no luck (actually I'm > learning how to do it :P) > > Any suggestions?. Thanks! > > On Sun, Oct 12, 2014 at 10:07 AM, Niphlod > > wrote: > >> uhm, could be something r

[web2py] Re: RESTful request args/vars with JSON array

2014-10-13 Thread Niphlod
you have to code your own methods. On Sunday, October 12, 2014 11:32:23 PM UTC+2, Henry Nguyen wrote: > > I have a function in my controller decorated with the @request.restful() > decorator. I would like to be able to accept a JSON array of objects, > > [{"id": 1, "new_value": 1},{"id": 2, "new

[web2py] Re: SQLFORM.grid, selectable and id

2014-10-13 Thread Niphlod
I'm assuming it gets the quite-obvious field_id parameter. If none, it just gets the first 'id' field of the first table in the join. On Monday, October 13, 2014 5:38:51 PM UTC+2, Jim S wrote: > > I see this was never answered, but I'm looking for the same thing. How > does SQLFORM.grid's 'sele

[web2py] Re: crash - session_pickled = pickle.dumps(self, pickle.HIGHEST_PROTOCOL) on 2.9.11

2014-10-13 Thread Niphlod
I'm worried that in the session there's something that isn't picklable, a-la "old" Storage . On Monday, October 13, 2014 8:00:32 PM UTC+2, Leonel Câmara wrote: > > You need to delete your browser cookies too. That said, this may also be a > web2py error because it shouldn't break just because th

[web2py] Re: Item in ``from list'' not a string (custom_import.py) web2py 2.9.11

2014-10-12 Thread Niphlod
uhm, could be something related to http://bugs.python.org/issue21720 On Sunday, October 12, 2014 1:53:40 AM UTC+2, Luciano Laporta Podazza wrote: > > Hello, > > I'm using locally web2py (*2.9.8*) + Shopify API (2.0.4) on Mac OS X > 10.9.5 (Python *2.7.5*) and this code works perfectly: > > fr

[web2py] Re: bootswatch theme - how to do it

2014-10-11 Thread Niphlod
What is not "rendered as expected" in particular ? On Saturday, October 11, 2014 4:19:04 PM UTC+2, clara wrote: > > Hello, > > I am not a css expert and I always stumble upon this with web2py: > > I select a nice theme from bootswatch 2.2.2 and replace the > bootstrap.min.css file in web2py with

[web2py] Re: How to make search in grid/smartgrid case insensitive ? (v2.9.11)

2014-10-10 Thread Niphlod
or MongoDB and GAE. We should still have a ticket > perhaps we can deal with these cases and we (I) will not forget. > > On Friday, 10 October 2014 10:01:09 UTC-5, Niphlod wrote: >> >> it's case-insensitive in trunk right now without the need to open a >> ticket. >> &

[web2py] Re: pythonanywhere

2014-10-10 Thread Niphlod
why should you ever want to ditch https if you get it for free ? On Thursday, October 9, 2014 10:11:20 PM UTC+2, clara wrote: > > Hello, > > I realize that when deploying simple web2py applications on > pythonanywhere, they get deployed via HTTPS so it is served as > https://myuser.pythonanywher

[web2py] Re: How to make search in grid/smartgrid case insensitive ? (v2.9.11)

2014-10-10 Thread Niphlod
it's case-insensitive in trunk right now without the need to open a ticket. On Friday, October 10, 2014 6:41:19 AM UTC+2, Massimo Di Pierro wrote: > > Please open a ticket. We should be able to pass a parameter. > > On Thursday, 9 October 2014 04:09:47 UTC-5, Nikos Papageorgiou wrote: >> >> Hi, >>

Re: [web2py] Re: Limit SQLFORM.grid results

2014-10-08 Thread Niphlod
given you can pass whatever you want to cache_count, I'd say you can use whatever technique you'd like. Of course "approximation" won't never land to "perfectness" ;-P On Wednesday, October 8, 2014 12:45:28 PM UTC+2, Johann Spies wrote: > > This thread triggered a thought regarding very large ta

Re: [web2py] Re: Limit SQLFORM.grid results

2014-10-08 Thread Niphlod
On Tuesday, October 7, 2014 4:00:56 PM UTC+2, Narūnas Krasauskas wrote: > > Hi, > > Thanks for the reply. > > I just tested my notorious 38 sec query directly on the MySQL, and it also > took nearly 40 sec to complete, so after all it was not web2py's fault :-) > > Further I also tested *cache_c

[web2py] Re: Sending very large forms....

2014-10-07 Thread Niphlod
web2py doesn't impose any limits ... you can have a "hosting" app that needs to receive 1GB file and you can have a data-entry app that needs 150 fields to be sent over the wire. Usually web2py is behind a webserver that has "sane" defaults that, in any case, NEED tuning on a per-app base. Miti

[web2py] Re: Add Fields to tables using loops

2014-10-07 Thread Niphlod
I'd urge you to consider a table with 2 fields, "date" and "user" instead. On Sunday, October 5, 2014 1:11:22 AM UTC+2, Nurendra Choudhary wrote: > > A calendar with flag for each user > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2

Re: [web2py] Re: Limit SQLFORM.grid results

2014-10-07 Thread Niphlod
Those are not identical queries (constraints DO change, not only pagination). Again, select a from table limit 10 offset 0 and select a from table limit 10 offset 10 SHOULD DEFINITIVELY NOT have different execution times. And again, if you want 10 pages of 50 records, just pass paginate=50,

[web2py] Re: Scheduler always QUEUED and no record in scheduler_worker and scheduler_run data table

2014-10-07 Thread Niphlod
n.task_id==task.id).delete() > db(db.scheduler_task.uuid==processID).delete() > > On Saturday, October 4, 2014 2:51:42 PM UTC-4, Niphlod wrote: >> >> On Friday, October 3, 2014 8:19:46 PM UTC+2, Pengfei Yu wrote: >>> >>> Thanks a lot for your detailed expla

[web2py] Re: web2py trunk is broken??

2014-10-06 Thread Niphlod
I'd seriously stop trying pulling from hg and start from github. That's the main repo now. On Monday, October 6, 2014 4:36:13 PM UTC+2, Jim S wrote: > > Any chance of getting an estimate on when this is all going to be > resolved? Pulling with hg from google code is still broken. > > -Jim > >

[web2py] Re: Insert method in DAL returns incorrect id

2014-10-05 Thread Niphlod
Simple debug to do what web2py does. print the statement print db.mes._insert(me=metext,locale=localeid) execute it in workbench and then do a select last_insert_id(). what does workbench return ? On Sunday, October 5, 2014 10:42:49 PM UTC+2, Gliese 581 g wrote: > > Please let me kn

[web2py] Re: Insert method in DAL returns incorrect id

2014-10-05 Thread Niphlod
the id returned by DAL is the one mysql sends back as last_insert_id(). Do you have an autoincrement field there ? the only explanation of a wrong id could be that. On Sunday, October 5, 2014 8:56:41 PM UTC+2, Gliese 581 g wrote: > > I have a simple controller method where I insert a record in m

[web2py] Re: HTML multiple select attribute bug in 2.9.11?

2014-10-05 Thread Niphlod
app reproducing the issue would definitely help investigating what's going on On Sunday, October 5, 2014 9:01:30 PM UTC+2, DJ wrote: > > Just migrated code from an older version web2py app to the latest code > structure (js, css, etc.). The Multiple select box does not show up in the > form

Re: [web2py] Re: Limit SQLFORM.grid results

2014-10-04 Thread Niphlod
ok, lets reset us the question a bit. This "original" issue had a logic because the grid makes TWO queries by default. One is to retrieve the data for a particular page (and there's NOTHING we can do about it) , the other is to count the total of the records disregarding the pagination. Now, if

[web2py] Re: No Dropdown with forign key constraing even though table has format=''

2014-10-04 Thread Niphlod
because when you bash your head around model definitions for more than 2 hours you're probably doing something wrong and you'll need to recheck the book. reference fields needs to be explicitely called as 'reference othertable' or 'reference othertable.field', not with the table object, nor wit

[web2py] Re: Scheduler always QUEUED and no record in scheduler_worker and scheduler_run data table

2014-10-04 Thread Niphlod
need to make a tour on w2p_scheduler_test <https://github.com/niphlod/w2p_scheduler_tests> beforehand. It seems that some basic concept on what is the scheduler API is somehow obscure to you. The scheduler is a way to let some task be processed outside web2py. How you (and anyone else)

[web2py] Re: Where are attachments?

2014-10-04 Thread Niphlod
it depends. By default, a Field('something', 'upload') stores files in the uploads folder. You can choose to store them on the db but it requires a few configurations more Field('something', 'upload', uploadfield='otherfield'), Field('otherfield', 'blob') in that case, the contents will be sto

[web2py] Re: Add Fields to tables using loops

2014-10-04 Thread Niphlod
fields = [] for a in range(10): fields.append(Field(...)) db.define_table(*fields) but before diving in, what on earth requires such a model ? On Saturday, October 4, 2014 1:26:49 AM UTC+2, Nurendra Choudhary wrote: > > Hi, > Firstly, thanks for such a great framework. > > I wanted to know h

[web2py] Re: mssql legacy tables reference

2014-10-03 Thread Niphlod
what if you don't use requires=IS_EMPTY() ? On Friday, October 3, 2014 8:52:12 AM UTC+2, Alen Cerovic wrote: > > is there any resolution to this, any ideas, or are there plans to make it > work in future? > > Dana ponedjeljak, 29. rujna 2014. 12:26:11 UTC+2, korisnik Alen Cerovic > napisao je: >

[web2py] Re: Manual reset password link

2014-10-03 Thread Niphlod
I assume it's this one https://groups.google.com/d/msg/web2py/wljBn6rVHTo/rus7OnvMCO4J On Friday, October 3, 2014 5:38:37 PM UTC+2, Leonel Câmara wrote: > > Ok I removed it in my pull request. At least, in my manual testing, no > infinite loops happen: > > https://github.com/web2py/web2py/pull/5

Re: [web2py] Re: Limit SQLFORM.grid results

2014-10-03 Thread Niphlod
if your backend needs tons of times to extract 50 records (no matter what the page is) there's a problem. Grid has not. If ou want to show your users a set of records, just pass to grid a query instead of the entire table. On Friday, October 3, 2014 12:50:57 PM UTC+2, Narūnas Krasauskas wrote: >

[web2py] Re: Scheduler always QUEUED and no record in scheduler_worker and scheduler_run data table

2014-10-02 Thread Niphlod
On Wednesday, October 1, 2014 4:34:08 PM UTC+2, Pengfei Yu wrote: > > So that means all the communications between different machines are from > database management system, and has little thing to do with the scheduler? > Sorry, I am new to this field and the question may be stupid. > all the

[web2py] Re: Upgrading an old version - will my app work?

2014-10-01 Thread Niphlod
you're having a problem with the upgrade. auth.define_tables() didn't change anything, and *signature* is a valid argument for it check again if your current version of web2py is correctly updated. On Wednesday, October 1, 2014 8:40:49 PM UTC+2, Marko Poutiainen wrote: > > Looks like there's

[web2py] Re: Heroku: multiple dynos using Web2py

2014-10-01 Thread Niphlod
to be fair, you shouldn't have migration turned on on production. what you're seeing is some app trying to store the equivalent of .table files inside the db. Only one app should be allowed to do that, not both (i.e. only one "frontend"). On Wednesday, October 1, 2014 2:07:58 PM UTC+2, Louis Am

Re: [web2py] Re: web2py trunk is broken??

2014-10-01 Thread Niphlod
uhm. strange. did you care to prune the old dir before overwriting ? (i.e. you don't have a gluon/dal.py file) ? On Wednesday, October 1, 2014 2:08:36 PM UTC+2, Johann Spies wrote: > > > > On Tuesday, September 30, 2014 8:45:46 AM UTC-7, Anthony wrote: You'll need to get it from Github

[web2py] Re: Scheduler always QUEUED and no record in scheduler_worker and scheduler_run data table

2014-10-01 Thread Niphlod
On Tuesday, September 30, 2014 3:42:41 PM UTC+2, Pengfei Yu wrote: > Hi Simone, > > Thanks for your reply. I used the solution from the web2py document site: > http://www.web2py.com/books/default/chapter/29/13/deployment-recipes, in > section "Start the scheduler as a Linux service (upstart)". A

Re: [web2py] Re: web2py trunk is broken??

2014-10-01 Thread Niphlod
red" source now? > > On Tuesday, September 30, 2014 8:45:46 AM UTC-7, Anthony wrote: >> >> You'll need to get it from Github -- Google Code is broken at the moment >> (the commit is missing the entire new dal folder). >> >> Anthony >> >> On Tuesd

[web2py] Re: jquery ajax post vars not accessible

2014-09-30 Thread Niphlod
request.post_vars is always key-value mapping, and you're asking one of its values to be a mapping itself (uploading should have a "key" named file). This is only possible under a particular circumstance, i.e. when you're posting a json object, but it seems that you're instead trying to do som

[web2py] Re: Redirect page after submit load form

2014-09-30 Thread Niphlod
I'm not sure on what you mean by "does the redirect that has the function call". Generally speaking, a redirect within component doesn't trigger the entire page to be redirected, but just the component. This is "by design". The default behaviour can be altereted, and all the possibile "combinat

Re: [web2py] Re: web2py trunk is broken??

2014-09-30 Thread Niphlod
if you fetch the main repo instead of the old one it's all ok right now. On Tuesday, September 30, 2014 5:13:15 PM UTC+2, Jim S wrote: > > Thanks Niphlod, I'll be patient and let you guys do your work. If you > could drop a note when it is resolved I'd really appreciat

[web2py] Re: web2py trunk is broken??

2014-09-30 Thread Niphlod
there's a biiig change going on on dal (modularization). it should not go into exception but we're in the process of fixing those hiccups. On Tuesday, September 30, 2014 4:51:24 PM UTC+2, Jim S wrote: > > Sorry, when I said I updated 'my code' I meant that I pulled the latest > web2py code. > >

[web2py] Re: Path to jquery and other libs is wrong in the admin app (2.9.11)

2014-09-30 Thread Niphlod
you need to fix static serving in GAE so it supports versioning of static files. The default config file for GAE already takes care of it. On Tuesday, September 30, 2014 3:22:19 PM UTC+2, Miguel wrote: > > Hi > > I just downloaded web2py source code and I am running the local GAE SDK. > When I go

[web2py] Re: Scheduler always QUEUED and no record in scheduler_worker and scheduler_run data table

2014-09-30 Thread Niphlod
if there are no records in the scheduler_worker, the scheduler is not running. Please check your "permanent daemon" solution to see if it's running and what it logs. On Monday, September 29, 2014 4:37:53 PM UTC+2, Pengfei Yu wrote: > > Hi, > > I have a web application hosted on AWS EC2 with Apac

[web2py] Re: Automate JQuery for Button

2014-09-30 Thread Niphlod
t; > On Monday, September 29, 2014 6:35:15 AM UTC-7, Niphlod wrote: >> >> we did a pretty heavy job to discard any inline javascript this goes >> exactly in the opposite way. What are you seeking in functionality ? It >> seems that your *button *is better suited with a no

[web2py] Re: Automate JQuery for Button

2014-09-29 Thread Niphlod
we did a pretty heavy job to discard any inline javascript this goes exactly in the opposite way. What are you seeking in functionality ? It seems that your *button *is better suited with a normal *a* On Sunday, September 28, 2014 10:37:33 PM UTC+2, Bernhard Radermacher wrote: > > I was al

[web2py] Re: Upgrading an old version - will my app work?

2014-09-28 Thread Niphlod
upgrading and switching back to any version is really easy. Download the zip, extract, voilà. we try hard (really hard) to not break backward compatibility, and if we do, we consider the "breakage" as a bug to fix, unless the "breakage" is indeed a bug (i.e. something that NEEDED to be fixed bec

[web2py] Re: Unable to connect to MSSQL via web2py - SSL Security Error

2014-09-26 Thread Niphlod
I believe it's a problem in bbfreeze. But I must do additional tests for it. -- 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 bec

[web2py] Re: Edit previous/next record from /edit view in sqlform.grid after update

2014-09-26 Thread Niphlod
Grid hasn't something like that. You'd need to code it yourself. On Friday, September 26, 2014 5:24:32 AM UTC+2, D.P. wrote: > > I have a large table with large amounts of text that is displayed through > sqlform.grid. I want to be able to click the 'edit' link for a record from > the sqlform.g

[web2py] Re: search with like/contains & case sensitive

2014-09-26 Thread Niphlod
%' returns the resultset you want. On Friday, September 26, 2014 6:14:13 AM UTC+2, Vladimir Makarov wrote: > > *For cyrillic types I mean for example words in russian language.* > > On Thursday, September 25, 2014 9:44:31 PM UTC+3, Niphlod wrote: >> >> what d

[web2py] Re: search with like/contains & case sensitive

2014-09-25 Thread Niphlod
what do "cyrillyc types" mean ? On Thursday, September 25, 2014 8:27:55 PM UTC+2, Vladimir Makarov wrote: > > Give me a clue of how to set my search case insensitive for all kind > types?!? > > def search(): > lname = request.vars.name #form field > q = db.tbl.l_name.like('%'+str(lname)+

[web2py] Re: IIS help with permissions

2014-09-25 Thread Niphlod
n why I tell the application pool to run as me. > The create_app code turns the .w2p file into a .tar file. > It is supposed to os.unlink(tarname) the tar file but this fails; the .tar > remains. I think this may be the first thing which doesn't work. > > > > On Thursday, Sep

[web2py] Re: SQLFORM and Virtual fields (2.9.6 - 2.9.11)

2014-09-24 Thread Niphlod
Ok, good points, but I'd be careful to support something (this or anything else) for a reason resembling "it's not prohibited, it worked --> needs to be stable". Bugs can be found, lack of documentation too, it's not said that something built on a "bug" or a shortcoming of the code should be su

Re: [web2py] Re: Default time for datetime picker widget

2014-09-24 Thread Niphlod
let's break it down a bit. It's one thing to have a field "prefilled" with a default value and it's a totally different one to have a field empty by default but when you click on it it "presets" the time to 00:00. The former needs a Field(, default=something), the latter, given that the

[web2py] Re: IIS help with permissions

2014-09-24 Thread Niphlod
access denied you're still having permission problems. On Wednesday, September 24, 2014 2:43:26 PM UTC+2, Tim Richardson wrote: > > OK. the GUI management tool make a new application pool by default if > creating a new site. I deleted that and I'm using the default application > pool. I am

[web2py] Re: lxml - cannot import etree

2014-09-24 Thread Niphlod
sources aren't enough lxml needs to be built, it's not a pure python module. -- 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 messag

[web2py] Re: Update with a string as the key

2014-09-24 Thread Niphlod
you need to pass a "mapping" to the update() method. so, something like this mapping = {field_name : value} ...update(**mapping) On Wednesday, September 24, 2014 5:10:33 PM UTC+2, Andy Joel wrote: > > I want a method to update the database record behind a model, and I > thought something like t

[web2py] Re: Unable to connect to MSSQL via web2py - SSL Security Error

2014-09-24 Thread Niphlod
robably surprise you, but I >>>> still >>>> get the same SSL error when I switch to this connection >>>> string: mssql://DRIVER={SQL >>>> Server};SERVER=localhost;DATABASE=testDB;UID=testUser;PWD=password. >>>> >>>> I again test

Re: [web2py] Re: Web Editor Blank Screen

2014-09-24 Thread Niphlod
if locally it works and behind nginx it doesn't, it doesn't seem like something web2py dependant ... On Wednesday, September 24, 2014 9:00:05 PM UTC+2, Trevor Strauss wrote: > > Permissions are all the same, any other thoughts? > > On Thu, Sep 18, 2014 at 8:31

[web2py] Re: SQLFORM and Virtual fields (2.9.6 - 2.9.11)

2014-09-24 Thread Niphlod
once again, 2 months later I didn't even know of an extra_fields argument to SQLFORM. To be fair, though, I always though about virtual fields as something you need to show, not something you need to fill. By definition virtual Fields are something that closely follow the functionality of

[web2py] Re: IIS help with permissions

2014-09-24 Thread Niphlod
you don't need an application pool at all. Those are only for .NET apps. On Wednesday, September 24, 2014 11:16:46 AM UTC+2, Tim Richardson wrote: > > > > Also, the owner of the application folder and the three files are which > are created is > web2py_production, which is the name of the applica

[web2py] Re: IIS help with permissions

2014-09-24 Thread Niphlod
to rule out other problems, just give all permissions to "everyone" . If then it works, we'll start from there ^_^ On Wednesday, September 24, 2014 4:51:46 AM UTC+2, Tim Richardson wrote: > > With IIS 8, I am trying to get web2py running with wfastcgi.py v2.1RC2, > web2py 2.9.11, python 2.7 32 b

[web2py] Re: Version 2.9.6 indeed breaks backward compat for some users

2014-09-23 Thread Niphlod
sorry for being not that deeply explicit in the previous post. contains() on list:something is case-insensitive. If you try to create a table with a TEXT field, then do a *LOWER(textfield) LIKE '%whatever%'* on it. You'll find out that while lots of functions can be applied to varchar, not

[web2py] Re: Default time for datetime picker widget

2014-09-23 Thread Niphlod
Sometimes, in web2py, it's just THAT simple import datetime . Field('whatever', 'time', default=datetime.time(0,0,0)) ;-) On Tuesday, September 23, 2014 10:59:30 AM UTC+2, libe...@gmail.com wrote: > > Hi, > > I was wondering if there is an easy way to specify a default time (say > 00:

[web2py] Re: Table creation error 139 using MySql

2014-09-23 Thread Niphlod
6 PM UTC+2, Richard wrote: > > Leonel, > > You are right, the most important message you and Niphlod give me is the > bad design of the dynamic tables and the need for migration=True. > Is this conclusion correct? > > If so, I'll redesign the functionality towards a table

[web2py] Re: Table creation error 139 using MySql

2014-09-23 Thread Niphlod
ask them, it's an error on mysql side, not web2py's. BTW: creating temporary tables at runtime is the dumbest thing since the invention of ORMs. On Tuesday, September 23, 2014 9:02:25 AM UTC+2, Richard wrote: > > I am hosting my app on python anywhere and get sometimes the following > error: >

[web2py] Re: Version 2.9.6 indeed breaks backward compat for some users

2014-09-22 Thread Niphlod
Unfortunately, mssql:// is there only for MSSQL 2000 (and others derived from that baseclass). It's a known issue...unfortunately there's no operator / function that can turn a 'text' into a something that gets a LIKE applied correctly without the possibility of truncation, not until MSSQL 200

[web2py] Re: Signed url to non users of the app

2014-09-22 Thread Niphlod
you code your own logic to check for a time-limited token in some request.vars On Sunday, September 21, 2014 11:35:35 PM UTC+2, Ramos wrote: > > Hello i have an app that creates some graph about some data > > > How can i share a link to a view of that graph and send it to a person > that is

[web2py] Re: Running a long task with task scheduler multiple times in the same browser

2014-09-21 Thread Niphlod
On Sunday, September 21, 2014 4:05:02 PM UTC+2, pn wrote: > > Did you test in a production environment (example behind an apache/other > server calling web2py via wsgi as described in the deployment recipes > chapter) or just using the built-in web2py server on your dev machine? > > The differe

[web2py] Re: Float issue

2014-09-19 Thread Niphlod
I wouldn't know, without seeing the actual code and the table definition. >>> testvalue = -0.20001 >>> import json >>> json.dumps(round(testvalue, 2)) '-0.2' >>> testvalue = 141093864 >>> json.dumps(testvalue) '141093864' On Friday, September 19, 2014 1:53:55 PM UTC+2, Ramo

[web2py] Re: a html comment with COMMENT

2014-09-18 Thread Niphlod
I'm so -1 that -NaN doesn't begin to describe the downvote. Why pollute html with something that is marginally useful only in debug ? On Thursday, September 18, 2014 2:43:03 PM UTC+2, Robin Manoli wrote: > > Because html comments are part of the html language so why shouldn't they > have a helpe

[web2py] Re: Changing The Default Start Application

2014-09-18 Thread Niphlod
see http://web2py.com/books/default/chapter/29/04/the-core#Application-init On Tuesday, September 16, 2014 11:16:29 AM UTC+2, Chukwudi Nwachukwu wrote: > > How do I change the default start application from *welcome* to something > like *library*. I am running a free www.pythonanywhere.com accoun

<    11   12   13   14   15   16   17   18   19   20   >