[web2py] Re: MySQL connection error after scheduled task completes

2016-06-07 Thread Andre Kozaczka
t; uhm, then it'll be quite impossible to fix it given the timeout is > seemingly random. > > On Tuesday, June 7, 2016 at 1:19:07 PM UTC+2, Andre Kozaczka wrote: >> >> Yes, same lines. >> >> On Tuesday, June 7, 2016 at 5:54:37 AM UTC-4, Niphlod wrote: >>&g

[web2py] Re: MySQL connection error after scheduled task completes

2016-06-07 Thread Andre Kozaczka
Yes, same lines. On Tuesday, June 7, 2016 at 5:54:37 AM UTC-4, Niphlod wrote: > > is the exception raised in the same lines ? > > On Tuesday, June 7, 2016 at 4:32:45 AM UTC+2, Andre Kozaczka wrote: >> >> >> Well. adding "sync_output=200" ended up w

[web2py] Re: MySQL connection error after scheduled task completes

2016-06-06 Thread Andre Kozaczka
Well. adding "sync_output=200" ended up working for tasks that were just over the 300 second mark (where previously I was failing). I changed the task length to 600 seconds and I'm back to failing. Ah... so close!!! I tried changing sync_output to 100 but still failed. Unless you have

[web2py] Re: MySQL connection error after scheduled task completes

2016-06-06 Thread Andre Kozaczka
- anything less that that the scheduler is able to finish just fine. On Monday, June 6, 2016 at 6:31:40 AM UTC-4, Niphlod wrote: > how many seconds does it take to be executed ? > > On Monday, June 6, 2016 at 3:46:12 AM UTC+2, Andre Kozaczka wrote: >> >> I'm getting the fol

[web2py] MySQL connection error after scheduled task completes

2016-06-05 Thread Andre Kozaczka
I'm getting the following error after my scheduled task completes: Traceback (most recent call last): File "/home/wdis/web2py/gluon/shell.py", line 273, in run exec(python_code, _env) File "", line 1, in File "/home/wdis/web2py/gluon/scheduler.py", line 717, in loop

Re: [web2py] Re: Ongoing issue with 'Lost connection to MySQL server during query'

2016-06-04 Thread Andre Kozaczka
Where do you put the - db._adapter.close() - db._adapter.reconnect In the Scheduler.py file? For some reason I'm still getting the lost connection error. I'm putting the close() and reconnect() in Scheduler.py and they surround the long processes. -- Resources: - http://web2py.com -

[web2py] Re: Error during scheduled job

2016-05-27 Thread Andre Kozaczka
a. it closes the connection without telling it did > so. Try issuing a query every once in a while. > > On Friday, May 27, 2016 at 3:56:34 AM UTC+2, Andre Kozaczka wrote: >> >> I'm seeing this error occasionally from my scheduler: >> >> File "/usr/lib/python2.7/

[web2py] Error during scheduled job

2016-05-26 Thread Andre Kozaczka
I'm seeing this error occasionally from my scheduler: File "/usr/lib/python2.7/ssl.py", line 341, in recv return self.read(buflen) File "/usr/lib/python2.7/ssl.py", line 260, in read return self._sslobj.read(len) File "/home/andre/web2py/gluon/scheduler.py", line 702, in

[web2py] Re: Front end design help

2016-05-24 Thread Andre Kozaczka
1 PM UTC-4, Andre Kozaczka wrote: > > Hi - I've built a website using web2py (obviously!) but I'm terrible at > front end design (html & javascript) and I'm looking for help. Ideally it's > someone familiar with web2py. Anyone have good experiences and could > recommend a person/c

[web2py] Front end design help

2016-05-24 Thread Andre Kozaczka
Hi - I've built a website using web2py (obviously!) but I'm terrible at front end design (html & javascript) and I'm looking for help. Ideally it's someone familiar with web2py. Anyone have good experiences and could recommend a person/company? Right now I'm looking at bunch of different

Re: [web2py] Re: Handling (2006, 'MySQL server has gone away') from Scheduler, pythonanywhere

2016-05-23 Thread Andre Kozaczka
ything > that was happening. > > I don't see the issue too often now and we have processes that have run > for a month without issue...from memory I think the main thing is commit > the database before calling a long running process (db.commit()). > > On Monday, 23 May 2016 16:05:36 UTC+2, And

Re: [web2py] Re: Handling (2006, 'MySQL server has gone away') from Scheduler, pythonanywhere

2016-05-23 Thread Andre Kozaczka
Hi Ian - I'm running into the same issue as you. Do you know the root cause of the error? Did you end up creating your own scheduling handler? -Andre On Thursday, February 5, 2015 at 5:55:04 AM UTC-5, Ian Ryder wrote: > Think it is pretty similar to this - we have 3 databases open. Seems to >

[web2py] Re: Scheduler - limit on how large the result can be?

2016-05-12 Thread Andre Kozaczka
Ah, well by "recently" I'm guessing you mean within the last 6 months. I just did an update and works now :) Thanks for the additional advice - I will have the scheduled task return a TABLE(). Now I need to take a closer look at your w2p_tvseries code to get the PeriodicalUpdater to work.

[web2py] Scheduler - limit on how large the result can be?

2016-05-12 Thread Andre Kozaczka
This question is in reference to Brad's post a couple years ago: https://groups.google.com/forum/#!searchin/web2py/scheduler$20results/web2py/WM7cyrUV5-U/49JVuq5uL0wJ Is there a limit on how large a "result" from a scheduled task can be? If so, how are folks working around this? My site parses

[web2py] Re: web2py scheduler with huge output or return values always timeout (even if the task finishes)

2016-05-11 Thread Andre Kozaczka
I'm curious what workarounds folks have come up with regarding this issue. On Monday, February 29, 2016 at 1:41:41 PM UTC-5, Boris Aramis Aguilar Rodríguez wrote: > > Hi, there is an issue driving me crazy with the web2py scheduler: > > If you return something that has a huge size then it will

[web2py] Re: Error when modifying auth_user table

2013-06-10 Thread Andre Kozaczka
on the define_tables() function). We need to see the errors and the definition that causes them. On Friday, June 7, 2013 7:29:12 PM UTC+2, Andre Kozaczka wrote: I'm trying to modify the auth_user table and I keep either getting a Table 'auth_user' already exist error (when migrate=True

[web2py] Re: Error when modifying auth_user table

2013-06-10 Thread Andre Kozaczka
, Andre Kozaczka wrote: I'm trying to modify the auth_user table and I keep either getting a Table 'auth_user' already exist error (when migrate=True) OR a 'Column not found' (when migrate=False). Not sure what I need to do. I've also tried experimenting with fake_migrate but I'm still

[web2py] Re: Error when modifying auth_user table

2013-06-10 Thread Andre Kozaczka
(...) ... auth.settings.extra_fields['auth_user'] = [Field('eft', 'integer')] auth.define_tables(migrate=True) run appadmin again. On Monday, 10 June 2013 10:52:26 UTC-5, Andre Kozaczka wrote: Also, to clarify I'm trying to add this column after I've done some development and already had an auth_user table

[web2py] Re: Error when modifying auth_user table

2013-06-10 Thread Andre Kozaczka
Correct, I do *not* have that file in the databases folder. On Monday, June 10, 2013 3:16:42 PM UTC-4, Niphlod wrote: so probably you don't have an *_auth_user.table in the databases/* folder. Can you confirm ? On Monday, June 10, 2013 6:38:18 PM UTC+2, Andre Kozaczka wrote: Tried step 1

[web2py] Re: Error when modifying auth_user table

2013-06-10 Thread Andre Kozaczka
, and you should have your extra column. Let us know if there are still problems On Monday, June 10, 2013 9:21:03 PM UTC+2, Andre Kozaczka wrote: Correct, I do *not* have that file in the databases folder. On Monday, June 10, 2013 3:16:42 PM UTC-4, Niphlod wrote: so probably you don't have

[web2py] Error when modifying auth_user table

2013-06-07 Thread Andre Kozaczka
I'm trying to modify the auth_user table and I keep either getting a Table 'auth_user' already exist error (when migrate=True) OR a 'Column not found' (when migrate=False). Not sure what I need to do. I've also tried experimenting with fake_migrate but I'm still getting either one of those

[web2py] Different login/authentication system for different groups

2013-05-15 Thread Andre Kozaczka
Is there a way to create two different login/authentication systems for different groups? For example, I'm creating an application for Businesses and their Customers. Businesses would have a login and would be able to access information for all their customers, run reports, etc. Under the

[web2py] Re: Different login/authentication system for different groups

2013-05-15 Thread Andre Kozaczka
and verify the account ID and zip when a payment is made? Anthony On Wednesday, May 15, 2013 11:14:52 AM UTC-4, Andre Kozaczka wrote: Is there a way to create two different login/authentication systems for different groups? For example, I'm creating an application for Businesses

[web2py] Re: Different login/authentication system for different groups

2013-05-15 Thread Andre Kozaczka
login for the customers. Just create a page with a form that takes the account ID and the billing zip. When the form is submitted, check that the input matches an existing account, and then put the account ID in the session. Anthony On Wednesday, May 15, 2013 11:40:59 AM UTC-4, Andre Kozaczka

[web2py] Re: webgrid Id key error

2012-08-15 Thread Andre Kozaczka
UTC-4, Andre Kozaczka wrote: For a majority of my tables I do not use the default 'id' column. Instead, I explicitly define one with the 'id' keyword. However, I seem to be running into a problem when trying to use webgrid. Whenever I use webgrid with a table that does not have a column

[web2py] webgrid Id key error

2012-08-14 Thread Andre Kozaczka
For a majority of my tables I do not use the default 'id' column. Instead, I explicitly define one with the 'id' keyword. However, I seem to be running into a problem when trying to use webgrid. Whenever I use webgrid with a table that does not have a column named 'Id,' I get the KeyError