[web2py] Re: Scheduler_Task Table Commit Issue (not Commiting) - Using queue_task and commit after

2018-02-22 Thread Dave S


On Thursday, February 22, 2018 at 4:51:30 PM UTC-8, Fabrizzio Abogadoc 
wrote:
>
> I've migrated to a new server (AWS), 
> ubuntu/images/hvm-ssd/ubuntu-trusty-14.04-amd64-server-20180201 
> (ami-a22323d8), 
>
> Last migration was around four months ago, everithing were ok, all the 
> configuration server, web2py, and code it's do it by ansible playbooks, so 
> there is "not possible some misconfiguration".
>
> Now, task creation inside task ( and task in general) are not working, not 
> created, I could issolate the issue to some commit problem with the 
> scheduler_task table.
>
> I've created some tests, for debuggin the server, I can insert in all 
> tables, but, when it comes scheduler_task table, I cannot commit.
>
>
What DBS are you using?

 

>
> Definition of Scheduler and Tasks in one Model:
>
> db_scheduler = DAL(path,
>pool_size=20,
>migrate=True,
>fake_migrate=False)
>
> tasks = dict()
> tasks['master_updates_task'] = master_updates_task
> tasks['master_abogadoc_task'] = master_abogadoc_task
>
> scheduler = Scheduler(db_scheduler, tasks=tasks, heartbeat=3)
>
> I have a controller from where I call to Test Insertion
>
> def insert_task():
> from datetime import date, time
> from abogadoc import utilitario
> import random
>
> dia = date.today()
> dia_str = dia.strftime('%Y-%m-%d')
> numero = random.randint(1, 1000)
> abogadoc_task_name = '%s_%s' % (dia_str, str(numero))
>
> start_time = utilitario.santiago_to_utc(hora=8)
> stop_time = utilitario.santiago_to_utc(hora=20)
>
> scheduler.queue_task('agendar_abogadoc',
>  task_name=abogadoc_task_name,
>  period=cuatro_horas,
>  timeout=treinta_min, repeats=0)
> scheduler.queue_task('master_abogadoc_task',
>  period=cinco_min,
>  timeout=una_hora, repeats=0)
> db_scheduler.commit()
>

That line was what I was going to suggest.  queue_task returns an ID, 
doesn't it?  Do those IDs show up in the table at all?

 

>
> Also I 've other function to insert in other table one register
>
> Locally, I don have problems, can insert in any table, and scheduler task, 
> but in the server, just can commit in any table but no in scheduler_task, 
> i've tried, different versions of web2py (2.14, locally and server), also 
> using different DBs one for code and other for scheduler, same behaviour
>
> I have the same version of Web2PY, 
> Version 2.16.1-stable+timestamp.2017.11.14.05.54.25
> Server:
> Version 2.16.1-stable+timestamp.2017.11.13.23.50.07
>
> Maybe someone can give me any directon, i'm running out of ideas
>

Just to check the obvious, I think you're saying you can queue tasks when 
not inside a task.
There may be a table-level lock involved when you're inside a task.

/dps
 

-- 
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 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...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Scheduler_Task Table Commit Issue (not Commiting) - Using queue_task and commit after

2018-02-22 Thread Fabrizzio Abogadoc
I've migrated to a new server (AWS), 
ubuntu/images/hvm-ssd/ubuntu-trusty-14.04-amd64-server-20180201 
(ami-a22323d8), 

Last migration was around four months ago, everithing were ok, all the 
configuration server, web2py, and code it's do it by ansible playbooks, so 
there is "not possible some misconfiguration".

Now, task creation inside task ( and task in general) are not working, not 
created, I could issolate the issue to some commit problem with the 
scheduler_task table.

I've created some tests, for debuggin the server, I can insert in all 
tables, but, when it comes scheduler_task table, I cannot commit.


Definition of Scheduler and Tasks in one Model:

db_scheduler = DAL(path,
   pool_size=20,
   migrate=True,
   fake_migrate=False)

tasks = dict()
tasks['master_updates_task'] = master_updates_task
tasks['master_abogadoc_task'] = master_abogadoc_task

scheduler = Scheduler(db_scheduler, tasks=tasks, heartbeat=3)

I have a controller from where I call to Test Insertion

def insert_task():
from datetime import date, time
from abogadoc import utilitario
import random

dia = date.today()
dia_str = dia.strftime('%Y-%m-%d')
numero = random.randint(1, 1000)
abogadoc_task_name = '%s_%s' % (dia_str, str(numero))

start_time = utilitario.santiago_to_utc(hora=8)
stop_time = utilitario.santiago_to_utc(hora=20)

scheduler.queue_task('agendar_abogadoc',
 task_name=abogadoc_task_name,
 period=cuatro_horas,
 timeout=treinta_min, repeats=0)
scheduler.queue_task('master_abogadoc_task',
 period=cinco_min,
 timeout=una_hora, repeats=0)
db_scheduler.commit()

Also I 've other function to insert in other table one register

Locally, I don have problems, can insert in any table, and scheduler task, 
but in the server, just can commit in any table but no in scheduler_task, 
i've tried, different versions of web2py (2.14, locally and server), also 
using different DBs one for code and other for scheduler, same behaviour

I have the same version of Web2PY, 
Version 2.16.1-stable+timestamp.2017.11.14.05.54.25
Server:
Version 2.16.1-stable+timestamp.2017.11.13.23.50.07

Maybe someone can give me any directon, i'm running out of ideas

-- 
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 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...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [web2py] Error using Postgres

2018-02-22 Thread Dave S


On Thursday, February 22, 2018 at 8:29:43 AM UTC-8, Morganti wrote:
>
> Hi, thanks your time.
>
> How can I check it? If I try to open web2py shell (web2py -S app -M), I 
> had no errors and all tables could be used.
>
> Thanks 
> BR
> André
>
>
That's one way to check.  The actual files should show up in the 
web2py/gluon/packages/dal/pydal/adapters, I think, and not just in 
gluon/contrib.


But the error looks, to my inexpert eye, like a socket error.  So I would 
start by verifying the socket exists and has the proper permissions. 

/dps

Em quinta-feira, 22 de fevereiro de 2018 13:08:23 UTC-3, Ovidio Marinho 
> escreveu:
>>
>> make sure the pg8000 and psycopg2 libraries are installed at the start of 
>> web2py
>>
>>
>>
>>
>>
>>
>>[image: http://itjp.net.br] 
>>  http://itjp.net.b r
>>   *Ovidio Marinho Falcao Neto*
>>  ovid...@gmail.com
>> Brasil
>>  
>>
>> 2018-02-22 12:40 GMT-03:00 Morganti :
>>
>>> Hello,
>>>
>>> I have a VPS using ubuntu 16.04, nginx, Postgres and web2py 2.16.1.
>>>
>>> I tried to execute one controller that populate some tables and got the 
>>> error below.
>>>
>>> Then, I used that command to create a csv file with all tables and 
>>> uploaded it in my desktop using SQLITE and no error were found.
>>>
>>> The controller coud create some rows before the error.
>>>
>>> Traceback (most recent call last):
>>>   File "/home/www-data/py27env/web2py/gluon/restricted.py", line 219, in 
>>> restricted
>>> exec(ccode, environment)
>>>   File 
>>> "/home/www-data/py27env/web2py/applications/nwproducao/controllers/carreira.py",
>>>  line 633, in 
>>>   File "/home/www-data/py27env/web2py/gluon/globals.py", line 419, in 
>>> 
>>> self._caller = lambda f: f()
>>>   File 
>>> "/home/www-data/py27env/web2py/applications/nwproducao/controllers/carreira.py",
>>>  line 21, in gera_plano_carreira
>>> vgraduacao = gera_graduacao()
>>>   File 
>>> "/home/www-data/py27env/web2py/applications/nwproducao/controllers/carreira.py",
>>>  line 56, in gera_graduacao
>>> for r in rows:
>>>   File "/home/www-data/py27env/web2py/gluon/packages/dal/pydal/objects.py", 
>>> line 3039, in __iter__
>>> row = next(self)
>>>   File "/home/www-data/py27env/web2py/gluon/packages/dal/pydal/objects.py", 
>>> line 3014, in __next__
>>> db_row = self.cursor.fetchone()
>>>   File "/home/www-data/py27env/web2py/gluon/contrib/pg8000/core.py", line 
>>> 947, in fetchone
>>> return next(self)
>>>   File "/home/www-data/py27env/web2py/gluon/contrib/pg8000/core.py", line 
>>> 1032, in __next__
>>> self._c.handle_messages(self)
>>>   File "/home/www-data/py27env/web2py/gluon/contrib/pg8000/core.py", line 
>>> 2088, in handle_messages
>>> raise self.error
>>> ProgrammingError: (u'ERROR', u'34000', u'portal "pg8000_portal_13259" does 
>>> not exist', u'postgres.c', u'1861', u'exec_execute_message', u'', u'')
>>>
>>> *Thanks your helping.*
>>>
>>> *Best regards*
>>>
>>> *Andre*
>>>
>>> -- 
>>> 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 subscribed to the Google 
>>> Groups "web2py-users" group.
>>> To unsubscribe from this group and stop receiving emails from it, send 
>>> an email to web2py+un...@googlegroups.com.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>

-- 
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 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...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: Form stopped working...

2018-02-22 Thread Dave S


On Thursday, February 22, 2018 at 2:54:21 AM UTC-8, Leonel Câmara wrote:
>
> Well since you already ruined that column. I would go with the lowercase 
> version of the field as I don't think it's a good practice to use uppercase 
> in field names. Then remember to check all your code for db.table.Website 
> references and change them to db.table.website it should work after that. 
> If it doesn't we will need to see some code to find out why.  
>

Also, if you need the column data from the damaged table, you may want to 
check with Pythonanywhere about backups.

 /dps

-- 
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 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...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: Form stopped working...

2018-02-22 Thread Dave S


On Thursday, February 22, 2018 at 2:54:21 AM UTC-8, Leonel Câmara wrote:
>
> Well since you already ruined that column. I would go with the lowercase 
> version of the field as I don't think it's a good practice to use uppercase 
> in field names. Then remember to check all your code for db.table.Website 
> references and change them to db.table.website it should work after that. 
> If it doesn't we will need to see some code to find out why.  
>

Also, if you need the data from the damaged table, you may want to check 
with Pythonanywhere about backups.

 /dps

-- 
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 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...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [web2py] Error using Postgres

2018-02-22 Thread Morganti
Hi, thanks your time.

How can I check it? If I try to open web2py shell (web2py -S app -M), I had 
no errors and all tables could be used.

Thanks 
BR
André

Em quinta-feira, 22 de fevereiro de 2018 13:08:23 UTC-3, Ovidio Marinho 
escreveu:
>
> make sure the pg8000 and psycopg2 libraries are installed at the start of 
> web2py
>
>
>
>
>
>
>[image: http://itjp.net.br] 
>  http://itjp.net.b r
>   *Ovidio Marinho Falcao Neto*
>  ovid...@gmail.com 
> Brasil
>  
>
> 2018-02-22 12:40 GMT-03:00 Morganti :
>
>> Hello,
>>
>> I have a VPS using ubuntu 16.04, nginx, Postgres and web2py 2.16.1.
>>
>> I tried to execute one controller that populate some tables and got the 
>> error below.
>>
>> Then, I used that command to create a csv file with all tables and 
>> uploaded it in my desktop using SQLITE and no error were found.
>>
>> The controller coud create some rows before the error.
>>
>> Traceback (most recent call last):
>>   File "/home/www-data/py27env/web2py/gluon/restricted.py", line 219, in 
>> restricted
>> exec(ccode, environment)
>>   File 
>> "/home/www-data/py27env/web2py/applications/nwproducao/controllers/carreira.py",
>>  line 633, in 
>>   File "/home/www-data/py27env/web2py/gluon/globals.py", line 419, in 
>> 
>> self._caller = lambda f: f()
>>   File 
>> "/home/www-data/py27env/web2py/applications/nwproducao/controllers/carreira.py",
>>  line 21, in gera_plano_carreira
>> vgraduacao = gera_graduacao()
>>   File 
>> "/home/www-data/py27env/web2py/applications/nwproducao/controllers/carreira.py",
>>  line 56, in gera_graduacao
>> for r in rows:
>>   File "/home/www-data/py27env/web2py/gluon/packages/dal/pydal/objects.py", 
>> line 3039, in __iter__
>> row = next(self)
>>   File "/home/www-data/py27env/web2py/gluon/packages/dal/pydal/objects.py", 
>> line 3014, in __next__
>> db_row = self.cursor.fetchone()
>>   File "/home/www-data/py27env/web2py/gluon/contrib/pg8000/core.py", line 
>> 947, in fetchone
>> return next(self)
>>   File "/home/www-data/py27env/web2py/gluon/contrib/pg8000/core.py", line 
>> 1032, in __next__
>> self._c.handle_messages(self)
>>   File "/home/www-data/py27env/web2py/gluon/contrib/pg8000/core.py", line 
>> 2088, in handle_messages
>> raise self.error
>> ProgrammingError: (u'ERROR', u'34000', u'portal "pg8000_portal_13259" does 
>> not exist', u'postgres.c', u'1861', u'exec_execute_message', u'', u'')
>>
>> *Thanks your helping.*
>>
>> *Best regards*
>>
>> *Andre*
>>
>> -- 
>> 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 subscribed to the Google Groups 
>> "web2py-users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to web2py+un...@googlegroups.com .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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 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...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [web2py] Error using Postgres

2018-02-22 Thread Ovidio Marinho
make sure the pg8000 and psycopg2 libraries are installed at the start of
web2py






   [image: http://itjp.net.br] 
 http://itjp.net.b r
  *Ovidio Marinho Falcao Neto*
 ovidio...@gmail.com
Brasil


2018-02-22 12:40 GMT-03:00 Morganti :

> Hello,
>
> I have a VPS using ubuntu 16.04, nginx, Postgres and web2py 2.16.1.
>
> I tried to execute one controller that populate some tables and got the
> error below.
>
> Then, I used that command to create a csv file with all tables and
> uploaded it in my desktop using SQLITE and no error were found.
>
> The controller coud create some rows before the error.
>
> Traceback (most recent call last):
>   File "/home/www-data/py27env/web2py/gluon/restricted.py", line 219, in 
> restricted
> exec(ccode, environment)
>   File 
> "/home/www-data/py27env/web2py/applications/nwproducao/controllers/carreira.py",
>  line 633, in 
>   File "/home/www-data/py27env/web2py/gluon/globals.py", line 419, in 
> self._caller = lambda f: f()
>   File 
> "/home/www-data/py27env/web2py/applications/nwproducao/controllers/carreira.py",
>  line 21, in gera_plano_carreira
> vgraduacao = gera_graduacao()
>   File 
> "/home/www-data/py27env/web2py/applications/nwproducao/controllers/carreira.py",
>  line 56, in gera_graduacao
> for r in rows:
>   File "/home/www-data/py27env/web2py/gluon/packages/dal/pydal/objects.py", 
> line 3039, in __iter__
> row = next(self)
>   File "/home/www-data/py27env/web2py/gluon/packages/dal/pydal/objects.py", 
> line 3014, in __next__
> db_row = self.cursor.fetchone()
>   File "/home/www-data/py27env/web2py/gluon/contrib/pg8000/core.py", line 
> 947, in fetchone
> return next(self)
>   File "/home/www-data/py27env/web2py/gluon/contrib/pg8000/core.py", line 
> 1032, in __next__
> self._c.handle_messages(self)
>   File "/home/www-data/py27env/web2py/gluon/contrib/pg8000/core.py", line 
> 2088, in handle_messages
> raise self.error
> ProgrammingError: (u'ERROR', u'34000', u'portal "pg8000_portal_13259" does 
> not exist', u'postgres.c', u'1861', u'exec_execute_message', u'', u'')
>
> *Thanks your helping.*
>
> *Best regards*
>
> *Andre*
>
> --
> 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 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...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 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...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Error using Postgres

2018-02-22 Thread Morganti
Hello,

I have a VPS using ubuntu 16.04, nginx, Postgres and web2py 2.16.1.

I tried to execute one controller that populate some tables and got the 
error below.

Then, I used that command to create a csv file with all tables and uploaded 
it in my desktop using SQLITE and no error were found.

The controller coud create some rows before the error.

Traceback (most recent call last):
  File "/home/www-data/py27env/web2py/gluon/restricted.py", line 219, in 
restricted
exec(ccode, environment)
  File 
"/home/www-data/py27env/web2py/applications/nwproducao/controllers/carreira.py",
 line 633, in 
  File "/home/www-data/py27env/web2py/gluon/globals.py", line 419, in 
self._caller = lambda f: f()
  File 
"/home/www-data/py27env/web2py/applications/nwproducao/controllers/carreira.py",
 line 21, in gera_plano_carreira
vgraduacao = gera_graduacao()
  File 
"/home/www-data/py27env/web2py/applications/nwproducao/controllers/carreira.py",
 line 56, in gera_graduacao
for r in rows:
  File "/home/www-data/py27env/web2py/gluon/packages/dal/pydal/objects.py", 
line 3039, in __iter__
row = next(self)
  File "/home/www-data/py27env/web2py/gluon/packages/dal/pydal/objects.py", 
line 3014, in __next__
db_row = self.cursor.fetchone()
  File "/home/www-data/py27env/web2py/gluon/contrib/pg8000/core.py", line 947, 
in fetchone
return next(self)
  File "/home/www-data/py27env/web2py/gluon/contrib/pg8000/core.py", line 1032, 
in __next__
self._c.handle_messages(self)
  File "/home/www-data/py27env/web2py/gluon/contrib/pg8000/core.py", line 2088, 
in handle_messages
raise self.error
ProgrammingError: (u'ERROR', u'34000', u'portal "pg8000_portal_13259" does not 
exist', u'postgres.c', u'1861', u'exec_execute_message', u'', u'')

*Thanks your helping.*

*Best regards*

*Andre*

-- 
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 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...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: Python3 and uwsgi

2018-02-22 Thread Ari Lion BR Sp
Hi, is there already a script for making
web2py, python3 and uwsgi work together ?

please create it at:
web2py/scripts/*


Em quarta-feira, 23 de agosto de 2017 12:53:49 UTC-3, Henri Chapelle 
escreveu:
>
> Hi,
> I can't get web2py to work with uwsgi and python3.
> Does anybody succeeded with a similar setup ?
>
> From what I see by searching the internet and my tests, uwsgi doesn't 
> accept unicode text for headers (need to be latin1 encoded text).
> All the pages have 0bytes in the log.
>
> My setup is working well with python2 and uwsgi tough.
>
> Is there an easy way to make web2py, python3 and uwsgi work together ?
>
> Regards,
> Henri
>

-- 
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 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...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: controller with multiprocessing powers. Howto?

2018-02-22 Thread Pierre
i think the entry point to do multiprocessing in web2py is the 
web2py-scheduler. Howewer with this tool you can't share objects betweeen 
processes like you do using the multiprocessing python module so 
synchronization might be an issue. There are other tools like for instance* 
huey* but i am not sure it's easy to integrate with web2py. In case this is 
feasible, i'd be interested in an Howto huey-web2py-integration :

https://huey.readthedocs.io/en/latest/

-- 
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 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...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: Form stopped working...

2018-02-22 Thread Leonel Câmara
Well since you already ruined that column. I would go with the lowercase 
version of the field as I don't think it's a good practice to use uppercase 
in field names. Then remember to check all your code for db.table.Website 
references and change them to db.table.website it should work after that. 
If it doesn't we will need to see some code to find out why.  

-- 
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 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...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.