Please open a ticket about this. I would prefer is there where a way to
tell the driver to send the error directly to the logfile.
On Friday, 14 September 2012 14:00:27 UTC-5, Jim Karsten wrote:
>
> I use MySQL and after upgrading to 2.0.x I see MySQL warnings from time to
> time printed to stdout. It appears they originate from MySQLdb.
>
> Here is a simple example of how to produce the warnings.
>
> db.executesql('DROP TABLE IF EXISTS non_existent_table')
> /path/to/2.0.8/web2py/gluon/dal.py:1653: Warning: Unknown table
> 'non_existent_table'
> ret = self.cursor.execute(*a, **b)
>
> Here is how I solved it. In *gluon/dal.py* add:
>
> import warnings
>
> class MySQLAdapter(BaseAdapter):
>
> def execute(self, *a, **b):
> if 'MySQL(MySQLdb)' in DRIVERS:
> with warnings.catch_warnings(record=True) as warning_messages:
> result = self.log_execute(*a, **b)
> for w in warning_messages:
> logger.warning(w)
> else:
> result = self.log_execute(*a, **b)
> return result
>
> Could that be considered for the trunk?
>
--
