[web2py] When i JOIN something it goes ok, but if there is no join i got an error..

2011-02-08 Thread Bart
e topic? What am i missing at this point? Thanks for the help. regards, Bart

[web2py] error starting scheduler: error retreiving status

2016-06-03 Thread Bart
I am trying to start web2py scheduler with python web2py.py -K myapp on a Ubuntu 16.04 server with web2py 2.14.6-stable+timestamp.2016.05.10.00.21.47 (running on nginx/1.10.0, Python 2.7.11+) db connector is psycopg2 myapp is using a remote postgres database over ssl In the app every is worki

[web2py] Re: error starting scheduler: error retreiving status

2016-06-03 Thread Bart
Addition: I am using several schema's in the postgres database. The scheduler tables are in schema 'scheduler' Schema 'public' does not exist. Can this cause the problem? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code)

[web2py] Re: error starting scheduler: error retreiving status

2016-06-03 Thread Bart
k if there is no "public" schema, unless you > tinkered with scheduler's table definitions > > On Friday, June 3, 2016 at 4:57:23 PM UTC+2, Bart wrote: >> >> Addition: >> >> I am using several schema's in the postgres database. >> >

[web2py] Re: error starting scheduler: error retreiving status

2016-06-03 Thread Bart
; you can try fiddling with the source of the scheduler (along these lines > https://github.com/web2py/web2py/blob/master/gluon/scheduler.py#L948) to > set the same search path. > > Please be aware that even if it seems to work, support for it is not > assured (so use at your own risk)

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

2015-11-19 Thread Bart
n(e) { e.preventDefault(); var input_name = $(this).attr('name'); if(input_name != undefined) { $('').attr('name', input_name) .attr('value', $(this).val()).appendTo(form) } form.t

[web2py] Scheduler error using python3.6 and psycopg2

2018-06-06 Thread Bart
For a new application, i have installed web2py 2.16.1 under python 3.6 and using psycopg2 2.7.4 for postgresql access. Everything is working okay, except the web2py scheduler. After successfull execution of the first task, the scheduler gives an error in the send_heartbeat function. The task ou

[web2py] Re: Scheduler error using python3.6 and psycopg2

2018-06-20 Thread Bart
x = self.db_thread(self.db_thread.scheduler_worker.worker_name == self.worker_name).select() except self.db_thread._adapter.connection.OperationalError: self.db_thread = None With this addition, the scheduler works okay. Op woensdag 6 juni 2018 21:26:40 UTC+2 schreef Bart: > >

[web2py] web2py RESTful timeout

2014-11-21 Thread Bart
I have a python script that posts data to my web2py/application/projects database using RESTful services. Everything works fine for an hour or two, but then all future posts will timeout. If, using a web browser, I reload the web2py application's main page then the RESTful services start worki

[web2py] Re: web2py RESTful timeout

2014-11-22 Thread Bart
need more details. How often do you post? How long does it take to get > a response? > > On Friday, 21 November 2014 09:36:36 UTC-6, Bart wrote: >> >> I have a python script that posts data to my web2py/application/projects >> database using RESTful services. Everything

[web2py] Re: web2py RESTful timeout

2014-11-28 Thread Bart
t; > On Friday, November 21, 2014 8:36:36 AM UTC-7, Bart wrote: >> >> I have a python script that posts data to my web2py/application/projects >> database using RESTful services. Everything works fine for an hour or two, >> but then all future posts will timeout. If, usin

[web2py] Re: web2py RESTful timeout

2014-11-28 Thread Bart
I'm using MySQL, but I've also used SQLite. Yes I've verified that the POST is timing out. I ran another test and the script ran for 2 days until the error showed up again. I reloaded the default/index webpage in my browser and now its working again. I'll try disabling sessions as Derek sug

[web2py] Re: web2py RESTful timeout

2014-12-04 Thread Bart
of sleep mode. On Wednesday, November 26, 2014 9:55:47 PM UTC-7, Bart wrote: > > Thanks I'm testing this now. I'll let you know if it works. > > On Monday, November 24, 2014 10:04:56 AM UTC-7, Derek wrote: >> >> If you don't need sessions for those requests,

[web2py] Re: web2py RESTful timeout

2015-01-05 Thread Bart
Adding exception handling inside my RESTful api fixed my problem. Sometimes my RESTful posts contained corrupted data and this would cause an exception and hang future posts. Adding try/except solved my issue. Thanks, Bart On Friday, November 21, 2014 8:36:36 AM UTC-7, Bart wrote: > >

[web2py] Web2py sessions table does not exist?

2014-07-03 Thread Austin Bart
Recently after some updates to some of my models, I got this error in web2py. Traceback (most recent call last): File "/Users/acbart/web2py/gluon/main.py", line 457, in wsgibase session._try_store_in_db(request, response) File "/Users/acbart/web2py/gluon/globals.py", line 1116, in _try_

[web2py] Re: Web2py sessions table does not exist?

2014-07-03 Thread Austin Bart
*web2py_session_runestone*.table > file into the database/ folder. If there is, delete it and web2py will > recreate it. > > On Thursday, July 3, 2014 1:44:38 AM UTC+2, Austin Bart wrote: >> >> Recently after some updates to some of my models, I got this error in >>

[web2py] Re: Web2py sessions table does not exist?

2014-07-03 Thread Austin Bart
e_migrations, then delete ONLY webp2y_session_runestone and > retry. > > Simone > > On Thursday, July 3, 2014 11:30:35 AM UTC+2, Austin Bart wrote: >> >> Migrations should be on. I have it enabled through my DAL: >> db = DAL(settings.database_uri, migrate_enabled=True) &g

[web2py] Re: When i JOIN something it goes ok, but if there is no join i got an error..

2011-02-08 Thread Bart van Berkel
Hi villas, Thnx for your reply. I am only playing for a couple of day's with web2py and python. I have more experience in php. ;) As what i see now is that the JOIN is not correct i think.. going to give it another try. speak to you later. regards Bart On 8 feb, 19:00, villas wrote:

[web2py] Field set the default value +1 on insert

2015-11-10 Thread Bart van Berkel
the max number out of the database and insert that with a new value( +1) Does anybody have a good insperation or an good idea to get me on the right track? Many thanks. Bart -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source co

[web2py] Re: Routes problem?

2015-11-10 Thread Bart van Berkel
Dit you also press the button reload routes after the change? -- 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 su

[web2py] Re: Field set the default value +1 on insert

2015-11-21 Thread Bart van Berkel
Hello my friends, Thanks for the inspiration. The answer from Craig, looks to me a good idea how i can do it. many thanks, Bart -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues