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.

Reply via email to