Indeed you are right Thanks to your hint, I found my issue lies in the improper use of « _common_fields ».
I wanted to use it to add a few fields to all my tables except the ones generated by Auth, so I had a code like this : auth.define_tables() db._common_fields.append(my_fields) I thought the sequence order would make it so that the common fields aren’t added to Auth tables but in the end my field « created_on » did get added to « auth_event » which cause this whole issue. My solution was to remove the « _common_fields » statement and add manually the fields using table inheritance. An alternative solution would be to disable logging in Auth : "auth.settings.logging_enabled = False » Thank you Paolo! > Le 12 janv. 2015 à 09:27, Paolo Valleri <paolo.vall...@gmail.com> a écrit : > > Hi, > by default auth_event doesn't have a created_on column. > Can you provide some code to reproduce the issue? > > Paolo > > On Sunday, January 11, 2015 at 10:54:26 PM UTC+1, Louis Amon wrote: > Hello, > > I'm trying to optimize the performance of my website by using lazy tables. > > When I do so, every feature linked with Auth breaks with the following error > msg : > ProgrammingError: ('ERROR', '42703', 'column "created_on" of relation > "auth_event" does not exist') > > I think it is due to the logging of auth events: the lazy_tables feature > should understand that this action requires the load of "auth_event" table > but somehow it doesn't. > > > Any idea how I can solve this issue ? > > > -- > Resources: > - http://web2py.com <http://web2py.com/> > - http://web2py.com/book <http://web2py.com/book> (Documentation) > - http://github.com/web2py/web2py <http://github.com/web2py/web2py> (Source > code) > - https://code.google.com/p/web2py/issues/list > <https://code.google.com/p/web2py/issues/list> (Report Issues) > --- > You received this message because you are subscribed to a topic in the Google > Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/5maEHqLqehs/unsubscribe > <https://groups.google.com/d/topic/web2py/5maEHqLqehs/unsubscribe>. > To unsubscribe from this group and all its topics, send an email to > web2py+unsubscr...@googlegroups.com > <mailto:web2py+unsubscr...@googlegroups.com>. > For more options, visit https://groups.google.com/d/optout > <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.