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 [email protected].
For more options, visit https://groups.google.com/d/optout.
