A while ago I mentioned that running web2py with mySQL 5.7.7+ / pymysql gives the following warning:
/usr/local/lib/python2.7/site-packages/pymysql/cursors.py:165: Warning: (3090, u"Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.") I have tracked this down to line 56 in gluon/packages/dal/pydal/adapters/mysql.py, which should have the NO_AUTO_CREATE_USER mode set (see https://dba.stackexchange.com/questions/120421/mysql-5-7-9-log-set-session-mode-gives-warning-about-no-auto-create-user-is-depr). This is set in the recent pymysql files, such as pymysql/tests/test_connection.py (line 512/513) self.execute("SET sql_mode='NO_BACKSLASH_ESCAPES,NO_AUTO_CREATE_USER';") Can someone correct pydal/adapters/mysql.py? Cheers Yan -- 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.
