Are you saying it should be self.execute("SET sql_mode='NO_BACKSLASH_ESCAPES,NO_AUTO_CREATE_USER';")
or should be self.execute("SET sql_mode='NO_BACKSLASH_ESCAPES';") because I believe this was fixed some time ago. On Monday, 5 March 2018 14:35:58 UTC-6, Yan Wong wrote: > > 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.