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

2016-06-07 Thread Andre Kozaczka
wrote: > > 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,

[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 ano

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

2016-06-06 Thread Andre Kozaczka
onds - 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 getti

[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 self.wrapped_repor

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 - http://w

[web2py] Re: Error during scheduled job

2016-05-27 Thread Andre Kozaczka
e, it's a mysql gotcha. 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: >> >&g

[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 signal.

[web2py] Re: Front end design help

2016-05-24 Thread Andre Kozaczka
y, May 24, 2016 at 2:24:11 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 experi

[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 freela

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

2016-05-23 Thread Andre Kozaczka
hing > 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:0

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. -And

[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 s

[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 a

[web2py] Re: Error when modifying auth_user table

2013-06-10 Thread Andre Kozaczka
; db = DAL(., migrate=True) > auth.extra_fields['...'] = . > auth.define_tables(migrate=True) > > Hit the appadmin page again, 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, A

[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,

[web2py] Re: Error when modifying auth_user table

2013-06-10 Thread Andre Kozaczka
True) > > run appadmin. > > 2) > db = DAL(...) > ... > 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 Kozaczk

[web2py] Re: Error when modifying auth_user table

2013-06-10 Thread Andre Kozaczka
auses 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) OR a 'Column not >> f

[web2py] Re: Error when modifying auth_user table

2013-06-10 Thread Andre Kozaczka
eady exists") On Friday, June 7, 2013 3:12:29 PM UTC-4, Niphlod wrote: > > The "column not found" is your "eft" one ? > You code seems legit (setting migrate=True on the define_tables() > function). We need to see the errors and the definition that causes them. > >

[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 err

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

2013-05-15 Thread Andre Kozaczka
hony wrote: >>> >>> Do you even need the Auth system for the customers? Can't you just have >>> an accounts table in the DB and verify the account ID and zip when a >>> payment is made? >>> >>> Anthony >>> >>> On Wednesday,

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

2013-05-15 Thread Andre Kozaczka
in the DB 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? >

[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 sam

[web2py] Re: webgrid Id key error

2012-08-15 Thread Andre Kozaczka
4:00:37 PM 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 &

[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 ex