[web2py] orderby and NULLS last

Hello, is it possible to sort NULLS last with orderby desc? orderby=~db.table.last_login I want the empty last_login last in desc sorting. On postgresql: ORDER BY sort_expression1 [ASC | DESC] [NULLS { FIRST | LAST }] Thanks, Mike -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Fwd: Us congress hearing of maan alsaan Money laundry قضية الكونغجرس لغسيل الأموال للمليادير معن الصانع

YouTube videos of U.S. Congress money laundering hearing of Saudi Billionaire " Maan Al sanea" with *bank of America* and The owner of Saad Hospital and Schools in the Eastern Province in *Saudi Arabia* and the Chairman of the Board of Directors of Awal Bank in *Bahrain*

[web2py] Re: As an MVC framework, does web2py allows updating model from view?

Thanks On Thursday, November 9, 2017 at 6:25:00 PM UTC+5:30, Leonel Câmara wrote: > > It's not recommended because the logic in web2py is that you use the same > controller for many different views (html, json, pdf, etc) so if you put > the getting of data in the view you will have to replicate

[web2py] Re: As an MVC framework, does web2py allows updating model from view?

So in the same way, can it make updates in the db? And why is it not recommended in web2py if the diagram doesn't say so? On Thursday, November 9, 2017 at 6:17:42 PM UTC+5:30, Leonel Câmara wrote: > > In the way shown in that diagram yes it can. You can make > db(query).select() inside a view

[web2py] As an MVC framework, does web2py allows updating model from view?

Can

[web2py] How to speed up query processing in web2py's sqlite?

I see that with a million of rows, the search takes almost 15-20 seconds. How do I speed it up? -- 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

[web2py] Can't show images from database in web2py 2.14.6?

I used the following snippet before in the old versions of web2py. They worked like charm there. However doesn't work here. What am I losing? controller: row1=db(db.slideshow).select().first().picture in view: the image doesn't display at all! -- Resources: - http://web2py.com -

[web2py] IMMD NEED !! SAP IM/MM Consultant - Woodbury, NY.

arly with peers, end-users and executive management. Exceptional organizational and documentation skills. Strong analytical and problem-solving skills. Ability to work both independently and within a team. Willing to travel on occasion, as required. *Mike Smith - IT RecruiterDirect: (630) 444-7490E

[web2py] IMMD NEED !! Financial Analyst - Phila, PA

and problem solving skills Strong organizational and interpersonal skills *Best Regards,* *Mike Smith - IT Recruiter* *Direct: (630) 444-7490* *Email: msm...@ayrglobal.com <msm...@ayrglobal.com>* *AYR Global IT Solutions Inc. | * *1431 Opus Pl, Suite 110, Downers Grove, IL - 60515* -- Res

[web2py] Date selector doesn't display properly after changing layout(see screenshot).What can be the reason?

Any idea on what must be wrong in any of the external css file in the layout. What I should do to rectify this? -- 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

[web2py] Why the response.flash can't be dismissed here?

I am using this layout from web2py's official site: web2py.plugin.layout_Chasmogamous However I see that the response.flash can't be dismissed. I guess there is a problem with this snippet in its layout.html: {{=response.flash or ''}} How do I make it work like it does in default layout? This

[web2py] How to make Web2py not block 'get' as well as 'post' requests from external sources?

$().ready(function () { //here any https will work but below is not working because of cross origin ..code is correct, just change url or put some json string or file var url = 'http://biglibrary.pythonanywhere.com/app/phonegap/temp.json'; $.get(url, function (data) { alert(data); });

Re: [web2py] This is not working as expected. Please correct this.

I am not getting the day of the month On Monday, November 28, 2016 at 10:47:13 PM UTC+5:30, Yoel Benitez Fonseca wrote: > > and what value are u getting on 'k', the day of month i suppose !? > > 2016-11-28 9:56 GMT-05:00 Mike Stephenson <raghi...@iiits.in >: > > > fo

[web2py] This is not working as expected. Please correct this.

form3 = SQLFORM.factory(Field('ddate','date', label='Enter a date')).process() if form3.accepted: k=form3.vars.ddate.day() redirect(URL('readings', 'check', args=[k,k,k])) K doesn't read value as expected. -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Re: Why is this query not giving me the correct set of rows as expected?

request.args[0] is just a number representing a day. What's wrong here? On Thursday, November 24, 2016 at 7:14:55 PM UTC+5:30, Marlysson Silva wrote: > > what is request.args[0] ? a datetime? > > Em quinta-feira, 24 de novembro de 2016 08:38:29 UTC-3, Mike Stephenson > escreveu

[web2py] Re: Why is this query not giving me the correct set of rows as expected?

Just to make sure both are strings. request.args[0] is just a number representing a day. What's wrong here? On Thursday, November 24, 2016 at 6:57:59 PM UTC+5:30, Leonel Câmara wrote: > > str??? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Howto override login_bare?

Am Donnerstag, 24. November 2016 14:07:07 UTC+1 schrieb Leonel Câmara: > > You can actually use login_user which just takes a user Row and makes it > be the logged in user, which is what login_bare and the other login methods > use after verifying the password. I think this is a bad idea even

[web2py] Re: Howto override login_bare?

Strictly speaking I want the original login_bare plus an login_bare_without_password, which allows login only with username. This is only for intranet use. Mike -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https

[web2py] Howto override login_bare?

.mc_login_bare("Username", "password") I get user = auth.mc_login_bare("Username", "password") request = current.request NameError: global name 'current' is not defined This is my first try to ovveride an method... I think there is a simple solution. Can

[web2py] Why is this query not giving me the correct set of rows as expected?

rows=db((str(db.emeter.instant.month) == str(request.args[0])) & (db.emeter.userid==auth.user_id) ).select() emeter: db.define_table('emeter', Field('userid'), Field('instant', 'datetime', default=request.utcnow+datetime.timedelta(0,19800), writable=False,

[web2py] Re: I am unable to parse contents from a json view in javascript? How do I do it?

Yeah exactly that doesn't work. How do I avoid that error? It says:" XMLHttpRequest cannot load https://biglibrary.pythonanywhere.com/app/phonegap/temp.json. No 'Access-Control-Allow-Origin' header is present on the requested resource. Origin 'null' is therefore not allowed access." when I use

[web2py] Re: I am unable to parse contents from a json view in javascript? How do I do it?

vember 11, 2016 at 7:05:00 PM UTC+5:30, Anthony wrote: > > On Friday, November 11, 2016 at 7:29:06 AM UTC-5, Mike Stephenson wrote: >> >> Hi Dave. for example how do I read the json from this link: >> https://biglibrary.pythonanywhere.com/app/phonegap/temp.json >> &l

[web2py] Re: I am unable to parse contents from a json view in javascript? How do I do it?

:02 PM UTC-8, Mike Stephenson wrote: >> >> It's messed up. >> > > How so? What does it do? What do you expect it to do? > > Can you show us how your controller prepares the json? What does your > view look like? > > >> Can you help out with a code

[web2py] Re: I am unable to parse contents from a json view in javascript? How do I do it?

It's messed up. Can you help out with a code snippet? Will be of much help. On Thursday, November 10, 2016 at 12:17:17 AM UTC+5:30, Leonel Câmara wrote: > > What do you mean? What are you trying to do? How are you putting the json > there? Are you getting it using $.getJSON or something like

[web2py] I am unable to parse contents from a json view in javascript? How do I do it?

I have totally messed up. Can you write the required snippet for me or share a helpful link? Thanks for the same. -- 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

[web2py] What kind of application is web2py good for designing and what kind of application it isn't as good?

for example, you may compare chatting and other kinds. -- 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 because you are

[web2py] What kind of application is web2py for designing and what kind of application it isn't as good?

for example, you may compare chatting and other kinds. -- 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 because you are

[web2py] Re: readonly field only in SQLFORgrid edit page if field is not empty

gt; timedelta(hours=1) > db.foobar.text.writable = not (record.text and older_than_an_hour) > form = SQLFORM.grid(db.foobar) > return dict(form=form) > Thank you Anthony, this works perfectly. Also thank you Val. Regards, Mike -- Resources: - http://web2py.com - http://web2py.com/book (Document

[web2py] readonly field only in SQLFORgrid edit page if field is not empty

foobar.text.writable = False? I can use request.args(1) = 'edit', but how can I then take the row, test it and set the writable to false? I don't want to validate after sending the form. The input field should be initially readonly. Regards, Mike -- Resources: - http://web2py.com - http

[web2py] Re: Upload file using the LOAD (....., ajax = True)

Hello Massimo, Am Sonntag, 27. März 2016 17:18:42 UTC+2 schrieb Massimo Di Pierro: > > Hello Mike, > > could you explain your patch to web2py-developers? it is quite extensive. > > I think you misunderstood me (or I didn't explain it well). This "patch" is on

[web2py] Re: Upload file using the LOAD (....., ajax = True)

are >5 years old. This one is the one which seems the most usable. Regards, Mike -- 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 mess

[web2py] Re: Additional field type for real boolean

Am Montag, 18. Januar 2016 18:06:32 UTC+1 schrieb Anthony: > > Maybe this will work: > http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Custom-Field-types--experimental- > This looks good. Don't know why I didn't see this before... This seems to work: from

[web2py] Additional field type for real boolean

self.parsemap[key](value,field_type) KeyError: 'boolean2' What is the correct code to archieve this? I need the regular web2py boolean field plus a new field type in web2py with another name for real boolean. Is this possible? I use web2py 2.13.4 and PostgreSQL 9.4.5. Regards, Mike -- Reso

[web2py] Re: Can you have multiple plugins use Web2py Scheduler in the same App?

App separately. If they are both >> isnstalled in the same App only one of the plugins scheduled tasks get run. >> (The one with the last loaded model alphabetically). Can someone point me >> in the right direction to get this working? >> >> Thanks, >> >> Mik

[web2py] Can you have multiple plugins use Web2py Scheduler in the same App?

in the right direction to get this working? Thanks, Mike -- 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 because you

[web2py] Logger works locally but not when deployed to a server

ions issue, and I see nothing. I'm running web2py's built in server via a cronjob like this: @reboot python /home/mike/web2py/web2py.py -i 0.0.0.0 -p 80 -a "" The reason I'm adding the logging is because I was trying to run a subprocess in order to ping a certain set of URL's t

[web2py] Re: Change in application request.vars when switching from Rocket to Lighttpd+FastCGI

On Wednesday, February 25, 2015 at 12:18:29 PM UTC-8, Niphlod wrote: reaally strange, although I don't use lighttpd since nginx came out. request.vars are parsed out of request.QUERY_STRING. could you please doublecheck what request.get('QUERY_STRING') dumps ?

[web2py] Re: Change in application request.vars when switching from Rocket to Lighttpd+FastCGI

;) } } fastcgi.server = ( .fcgi = ( localhost = ( #name for logs debug = 1, check-local = disable, min-procs = 1, socket = /tmp/fcgi.sock ) ), ) fcgi handler is started with: sudo -u www-data python fcgihandler.fcgi thanks, Mike On Tuesday, February 24, 2015

[web2py] Change in application request.vars when switching from Rocket to Lighttpd+FastCGI

{}* Although, the request.env.query_string contents are valid: *'query_string': 'id=2src=cmd'* Any suggestions to resolve this issue would be greatly appreciated, thanks, Mike -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code

[web2py] howto: ajax call in FORM with signed URL

@auth.requires_signature() to callback function, it no longer works. The ajax call must be signed. @auth.requires_signature() def callback(): return P(foo) But how can I add user_signature=True to the code above so that the ajax call will be signed? Regards, Mike -- Resources: - http://web2py.com

[web2py] Re: howto: ajax call in FORM with signed URL

', _name='keyword', _onkeyup=ajax(URL('callback', ['keyword', 'stype'], user_signature=True), 'target');), _name= search_type))) Regards On Wednesday, March 19, 2014 1:59:38 PM UTC+1, Mike Constabel wrote: Hi, in a form i have TD(INPUT(_id='keyword', _name='keyword', _onkeyup=ajax(URL

[web2py] Re: howto: ajax call in FORM with signed URL

/04/the-core?search=signed#Digitally-signed-urls BTW: auth.requires_signature() takes hash_vars as a parameter too. On Wednesday, March 19, 2014 10:18:38 PM UTC+1, Mike Constabel wrote: Doesn't work. The generated HTML code: input id=keyword name=keyword onkeyup=ajax(URL(#x27;callback#x27

[web2py] Best way to use a standalone DAL

I will actually call dal from within some scripts and from the webgui. What would be the best and cleanest way to do that ? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

[web2py] Re: Best way to use a standalone DAL

UTC+8, Anthony wrote: In a script, you can just import it like any other Python module. Not sure what you mean by calling it from the webgui. Anthony On Monday, March 3, 2014 3:58:39 AM UTC-5, Gwayne aka Mike Veltman wrote: I will actually call dal from within some scripts and from

[web2py] web2py + gae + google:sql : Not authorized to access (database) instance

I have started working with web2py + gae and a Cloud SQL database. The application db connection string is : db = DAL('google:sql://cloud1:ctm-manager/ctmdb') Logs on GAE show the following: File

[web2py] Multiple SOLIDFORMs from table rows

many other combinations of fields, forms, selects, but got every time errors. It would be really great if I can get a hint howto correct code this. Regards, Mike -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https

Re: [web2py] Multiple SOLIDFORMs from table rows

Hi, Am Montag, 10. Februar 2014 16:05:49 UTC+1 schrieb viniciusban: Maybe I missed something, but what is a SOLIDFORM? Sorry, forget to mention it. SOLIDFORM is an extended SQLFORM http://dev.s-cubism.com/plugin_solidform -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Re: Multiple SOLIDFORMs from table rows

Am Montag, 10. Februar 2014 16:21:57 UTC+1 schrieb Cliff Kachinske: Have you tried it without the showid arg? Yes, same error. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Multiple SOLIDFORMs from table rows

Yes. same error. Am Montag, 10. Februar 2014 16:21:57 UTC+1 schrieb Cliff Kachinske: Have you tried it without the showid arg? On Monday, February 10, 2014 3:12:36 AM UTC-5, Mike Constabel wrote: Hi, I try to generate multiple SOLIDFORMS from table rows. Simple example in pseudo code

[web2py] Re: github - please follow

Done! up to 528 now. On Sunday, 25 August 2013 00:26:03 UTC+1, Massimo Di Pierro wrote: web2py has many users but few github followers. This is a problem because the number of followers is a metric that can be used to guess popularity. You can help. Get a github account and click on the

Re: [web2py] 1071, 'Specified key was too long; max key length is 767 bytes'

=request.now), format='%(framename)s', migrate=True) On Tuesday 08 October 2013 13:41:31 Mike Veltman wrote: Ok, I am now fighting with it for two days and it drives me crazy. My gut feeling says mysql 5.1 -- mysql 5.5 upgrade is the cause. Am I right ? And how do I solve it. :-) *Error

[web2py] 1071, 'Specified key was too long; max key length is 767 bytes

My gut feeling says mysql 5.1 -- mysql 5.5 upgrade is the cause. Am I right ? And how do I solve it. :-) *Error ticket for adeploy* *Ticket ID* 192.168.2.106.2013-10-08.12-46-19.24f3f1a5-d637-4522-965b-fed4958115ed *class '_mysql_exceptions.OperationalError' (1071, 'Specified key was too

[web2py] 1071, 'Specified key was too long; max key length is 767 bytes'

Ok, I am now fighting with it for two days and it drives me crazy. My gut feeling says mysql 5.1 -- mysql 5.5 upgrade is the cause. Am I right ? And how do I solve it. :-) *Error ticket for adeploy* *Ticket ID* 192.168.2.106.2013-10-08.12-46-19.24f3f1a5-d637-4522-965b-fed4958115ed *class

Re: [web2py] Re: Changelog for 2.6.3?

: On Wednesday, September 18, 2013 3:52:38 AM UTC-7, Niphlod wrote: http://web2py.com/init/**default/changeloghttp://web2py.com/init/default/changelog Mike might be wondering what changed between 2.6.1 and 2.6.3, which isn't yet visible at that URL. If I heard right, both .2 and .3 were

Re: [web2py] Re: [web2pyy] Mysql 2 Mongodb

On Wednesday 24 July 2013 18:34:08 Alan Etkin wrote: Note: If you are restoring data with the DAL method import_from_csv_file (not the Table class method) using id_map={}, which is the method that should be used to keep references in sync, you should not have issues keeping reference values.

[web2py] Re: [web2pyy] Mysql 2 Mongodb

On Monday 22 July 2013 05:16:56 Alan Etkin wrote: I am just playing around with mongodb and web2py I noticed that when I just make a web2py dump of my mysql db and then upload it to mongodb some of the joins now just rec id's are right and some are newly generated. Also would it be

Re: [web2py] Re: [web2pyy] Mysql 2 Mongodb

On Wednesday 24 July 2013 11:52:36 Alan Etkin wrote: Also I concluded that because all the references are replaced by mongodb id's it is not possible to say dump a table with references in one database and then restore it on mongodb. Neither you can (or should) with other adapters, for

[web2py] [web2pyy] Mysql 2 Mongodb

for mongodb ? I was wondering if it was a bug. In this case in the setup table the pointers to the frame work fine, but the pointers in the setupprofile named lparprofile do not exist anymore in the lparprofile table. Mike db.define_table('frame', Field('framename', type='string

[web2py] Re: No module named plural_rules errro after upgrade

web2py.py and it all worked fine. Thanks for your help. On Monday, 10 June 2013 16:38:12 UTC+1, Niphlod wrote: do you have a VERSION file in the folder ? Il giorno domenica 9 giugno 2013 22:44:36 UTC+2, mike dawson ha scritto: I downloaded the latest zip file from the web site

[web2py] No module named plural_rules errro after upgrade

RuntimeError, Cannot determine web2py version RuntimeError: Cannot determine web2py version Can anyone advise whats missing? I'm running Linux Mint 14 thanks Mike -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group

[web2py] Re: No module named plural_rules errro after upgrade

I downloaded the latest zip file from the web site and unzipped it to /usr/share/web2py folder (after deleting the old copy that had been there) On Sunday, 9 June 2013 20:53:57 UTC+1, Niphlod wrote: what did you use to upgrade your installation ? On Sunday, June 9, 2013 9:40:43 PM UTC+2, mike

Re: [web2py] Re: SQLFORM.Smartgrid and with parent table in Linked Tables

Yeah, been a long day it should be: db.define_table( 'contact', Field http://www.web2py.com/examples/global/vars/Field('name'), Field http://www.web2py.com/examples/global/vars/Field('address'), format = '%(name)s') db.define_table( 'courses' , Field

[web2py] Custom User Registration

stuff. The reason I ask is I have a desktop client that talks to my web2py server via JSON RPC and I'd like to enable users to register from there without having to do everything else myself. Thanks, Mike -- --- You received this message because you are subscribed to the Google Groups web2py

[web2py] Mongodb error in appadmin

The action I have a table/collection with 3 objects In the table this is reverenced as Field('host_id', mdb.hoststable, comment=Like nim or hmc server., label=T('Destination Host ID')), But when in appadmin I select a other object to change then it throws a error. The

[web2py] Mongodb error in appadmin

Created the following table mdb.define_table('syscommands', Field('commandname', type='string', unique=True, label=T('Commandname')), Field('commandline', type='string', label=T('Command')), Field('host_id', mdb.hoststable, comment=Like nim or

Re: [web2py] Mongodb error in appadmin

Op 21-03-13 17:50, Niphlod schreef: seems to me that a lot of people are interested in using mongodb but really few are contributing back with tests and patches. BTW: you DO know that Mongo generally doesn't play well with joins, right ? Using references in mongodb is not a smart design.

Re: [web2py] Mongodb error in appadmin

On 03/21/2013 08:06 PM, Alan Etkin wrote: I would love to have some pointers about how though define mongo in db.py in a proper nosql way. Could you open an issue at the project page? Done :-) Issue 1401 https://code.google.com/p/web2py/issues/detail?id=1401: Mongodb error in

[web2py] RPC Versioning Scheme

each function into every new version of the API so that I can just fix any bugs in one spot. Any thoughts on this? Too hard? Won't work? If anyone has done this before and can help me out I'd appreciate it. Thanks, Mike -- --- You received this message because you are subscribed to the Google

[web2py] Re: RPC Versioning Scheme

gets /app/v2 On Tuesday, February 19, 2013 3:50:05 PM UTC-7, Mike D wrote: Hi, I'm using web2py to serve RPC methods to a desktop client that a user can download. I'd like to know if anyone has any thoughts on a good way to version my API so that I can keep the older versions available

[web2py] grid, user_signature, and apache auth

? Can anyone offer me some pointers here? Thanks in advance for any assistance. --Mike -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr

Re: [web2py] Possible bug in JSONRPC in v2.3.2

AM UTC+1, rochacbruno wrote: On Sat, Dec 22, 2012 at 3:57 AM, Mike D mike@gmail.com wrote: s = methods[method](**params) I guess it should be s = methods[method](*args, **params) to be more flexible --

[web2py] Possible bug in JSONRPC in v2.3.2

= methods[method](*params) to s = methods[method](**params) I changed it back and everything works perfectly now. Is this a bug or am I doing something incorrectly? Thanks, Mike --

[web2py] Re: Web2py scheduler timeout

it's surely worth the effort. Anyway, I'm more and more curious to see logs (and possibly a packed app to reproduce) ^_^ On Thursday, December 13, 2012 9:16:27 PM UTC+1, Mike D wrote: I have only this one task. I am certainly going to change the retry_failed and hopefully

[web2py] Re: Web2py scheduler timeout

Sorry about that. I just tried to attach the log and it keeps giving me an error. The scheduler_task record is marked QUEUED and the last scheduler_run record is marked COMPLETED. The task just isn't being run for some reason. On Monday, December 17, 2012 12:29:34 PM UTC-8, Niphlod wrote:

[web2py] Re: Web2py scheduler timeout

I have now tried with two different browsers to attach the log with no success. I keep getting error (340) occurred while communicating with the server. Do you want me to just email you the log? On Monday, December 17, 2012 12:45:45 PM UTC-8, Mike D wrote: Sorry about that. I just tried

[web2py] Mongodb and db.py

Hello People, I am looking into converting my mysql database setup into a mongodb and I was wondering about how at the moment db.py does translate the tables. Because I would like to have some control/understanding about it. --

[web2py] Re: Web2py scheduler timeout

for directory monitoring and not use the scheduler. Can't you use a task with retry_failed ? Next step is enabling debug logging of the scheduler to see what goes on when the task timeouts On Thursday, December 13, 2012 7:17:29 AM UTC+1, Mike D wrote: Hello, I am using the web2py scheduler

[web2py] Re: Web2py scheduler timeout

I have only this one task. I am certainly going to change the retry_failed and hopefully that will be a sufficient solution. I actually tried your other solution a while ago and that monitoring task actually ended up in a TIMEOUT state as well. Sad face. Any idea on that one? Do you think that

[web2py] Web2py scheduler timeout

if anyone has any ideas on what could be causing this issue. Any help would be very much appreciated. If I cannot fix it I will have to find a different solution for directory monitoring and not use the scheduler. Thanks again, Mike --

[web2py] Re: Truncate Sqlite DB

Can anyone else give my advice on clearing out my database? On Wednesday, November 28, 2012 12:10:13 PM UTC-5, Mike Anson wrote: *Database: Sqlite v3.7* Hello all, I have thousands of test records accumulated through testing my application. Forgive me for not taking the advice

Re: [web2py] Re: Truncate Sqlite DB

8:47:45 PM UTC+1, viniciusban wrote: Do you want a code snippet to clear you database? Try this: for t in db.tables: db[t].truncate() db.commit() On Mon, Dec 3, 2012 at 5:17 PM, Mike Anson mojor...@gmail.com wrote: Can anyone else give my advice on clearing out my database

Re: [web2py] Re: Truncate Sqlite DB

also the 3 tables the scheduler needs to work (just as the auth_* tables if you're using web2py's Auth system). On Monday, December 3, 2012 9:16:47 PM UTC+1, Mike Anson wrote: Yes I did delete everything from /databases before but my problems could have arisen from not having migrations

[web2py] Truncate Sqlite DB

to truncate the DB? Cheers, -Mike --

[web2py] Re: Querying on 1:M Relationships in SQLFORM.grid and SQLFORM.smartgrid

FYI, I did create an issue for this (#979) in google code. Best, Mike L On Monday, November 26, 2012 3:51:52 PM UTC-5, Adi wrote: +1 this would be a great and needed feature... just stumbled into this problem, and working around it :) On Friday, August 31, 2012 5:48:17 PM UTC-4, Massimo

Re: [web2py] Re: Extracting row id from url using request.args

Wow Cliff thank you for this superb bit of info. Like all the best problems it seems glaringly obvious to me now. Thank you everyone for your help. Mike On Wed, Nov 21, 2012 at 2:40 AM, Cliff Kachinske cjk...@gmail.com wrote: It's been a while since I've played with smartgrid, but I seem

[web2py] Changing Validators for SQLFORM on same table

. Is there a better way to do this? Is there perhaps some way to reach into the SQLFORM and pull out the fields and their validators? I went spelunking in that code but came up empty-handed. It's pretty dense stuff. Thanks, -Mike --

[web2py] Extracting row id from url using request.args

locals() View Code: {{extend 'layout.html'}} {{if 'view' in request.args:}} pDo something with {{=memberId}}/p h2Manage Contact/h2p{{=form}}/p {{else:}} h2Manage Contact/h2p{{=form}}/p {{pass}} Thanks in advance. Mike --

Re: [web2py] OperationalError: database is locked

I do indeed have greater than 3.7 so I'll see if that prevents the locking. So far so good although it was very sporadic and the scheduler ran over 70 times before it crapped out before adding the line you suggested. Thanks again for your responses. -Mike On Wednesday, 14 November 2012 00:11

[web2py] DB insert confusion

, the values are correct at this point so it has to be the curl script. Can anyone see something I clearly cannot? Thanks in advance. -Mike --

Re: [web2py] Re: DB insert confusion

Speediest response as ever Niphlod! Yes I understand your point. The reason it is currently like this is because if I use your suggestion (which I obviously had originally) {id: 1, method: savemessage, params: { *message*: variableholdingmessage, *uid* : variableholdingmail}} I get message and

Re: [web2py] Re: DB insert confusion

Thanks very much for your help Niphlod. On Wednesday, 14 November 2012 16:10:35 UTC-5, Niphlod wrote: Yes I understand your point. The reason it is currently like this is because if I use your suggestion (which I obviously had originally) {id: 1, method: savemessage, params: { *message*:

Re: [web2py] OperationalError: database is locked

Hi Vasile, Where would I put this in my script to run it once? Within the script itself say near the db.commit()? Cheers, -Mike On Friday, 9 November 2012 10:33:01 UTC-5, Vasile Ermicioi wrote: PS: it is enough to execute that only once db.executesql('PRAGMA journal_mode=WAL

[web2py] OperationalError: database is locked

Greetings... I may have a problem with my database (sqlite) locking. Traceback (most recent call last): File /home/web2py/src/web2py/gluon/scheduler.py, line 218, in executor result = dumps(_function(*args,**vars)) File applications/ircmessage/models/tasks.py, line 57, in

[web2py] Re: OperationalError: database is locked

) and to queue tasks you can then use db2.scheduler_tasks.validate_and_insert() or, with the new API mysched.queue_task(***) On Friday, November 9, 2012 3:56:59 PM UTC+1, Mike Anson wrote: Greetings... I may have a problem with my database (sqlite) locking. Traceback (most recent call

Re: [web2py] OperationalError: database is locked

I really appreciate your input Vasile. I will round back on to your advice should Niphlod's advice of separating the scheduler DB and my messaging DB not help me out here. On Friday, 9 November 2012 10:33:01 UTC-5, Vasile Ermicioi wrote: PS: it is enough to execute that only once

[web2py] type 'exceptions.KeyError' 'id'

Greetings... I have a bash script that uses cURL to send a json packet of data in order to save it in sqlite DB. #!/bin/bash message=$1 uid=$2 url=https://somehost; curl -v -k -X POST -H Content-Type: application/json --data {\message\: \This will prbbly be my lst post.\, \uid\:

[web2py] Re: type 'exceptions.KeyError' 'id'

in the controller ? Without that we can't help you . On Wednesday, November 7, 2012 7:48:28 PM UTC+1, Mike Anson wrote: Greetings... I have a bash script that uses cURL to send a json packet of data in order to save it in sqlite DB. #!/bin/bash message=$1 uid=$2 url=https://somehost; curl -v

[web2py] Re: type 'exceptions.KeyError' 'id'

to tell you: Follow the protocol, Mike! :P You are publishing a service behind the jsonrpc protocol, but you surely missed on how to interact with them ^_^ Every request per the spec has to carry an id , a method and a params value in the json body of the request. So, you are trying

[web2py] Re: type 'exceptions.KeyError' 'id'

UTC-5, Niphlod wrote: supposedly you have call() and save_message() in default.py The url to call the webservice would then be /appname/default/call/jsonrpc . On Wednesday, November 7, 2012 9:31:51 PM UTC+1, Mike Anson wrote: Thanks very much Niphlod. I am much closer now.. However I am

[web2py] Scheduler conflict

I upgraded to the newest web2py (2.1.1) Launch it with: ./web2py.py -i xxx.xxx.xx.xx -p 8000 -c /etc/ssl/certs/cert-file.crt -k /etc/ssl/certs/key-file.key -a apassword -K applicationName When I run the -K application (ie scheduler) I am then unable to access the admin or front end of the

  1   2   3   >