When I tried to enter a bacl slashed field (Odyssey\'s), it failed. So I guess the default behavior is effectively NO_BACKSLASH_ESCAPES
On Jun 14, 11:23 pm, mdipierro <[email protected]> wrote: > what is the default bahvior? > > On Jun 14, 9:51 am, The Czar <[email protected]> wrote: > > > I just checked the docs for the older version (4.1) SQL Modes. There > > is no mention of the NO_BACKSLASH_ESCAPES mode. > > >http://dev.mysql.com/doc/refman/4.1/en/server-sql-mode.html > > > We have some unintended consequences. I'm surprised it doesn't > > complain about this. > > > On Jun 14, 5:06 am, mdipierro <[email protected]> wrote: > > > > This line: > > > > self._execute("SET sql_mode='NO_BACKSLASH_ESCAPES';") > > > > is important for security issues. SQL injections may be possible if > > > you comment it. I do not know why it does not work on your system. It > > > should > > > >http://mysql.linux.cz/doc/refman/5.5/en/server-sql-mode.html#sqlmode_... > > > > On Jun 13, 5:11 pm, The Czar <[email protected]> wrote: > > > > > For some reason, attempted connection to a mysql v4.1.25 db on FreeBSD > > > > fails. The web2py is the latest version - but it happened on earlier > > > > versions also. The error & db.py for the application failing looks > > > > like this: > > > > > Error traceback > > > > > Traceback (most recent call last): > > > > File "/m/content/www/data/web2py-1-79-2/gluon/restricted.py", line > > > > 178, in restricted > > > > exec ccode in environment > > > > File "/m/content/www/data/web2py-1-79-2/applications/myapp/models/ > > > > db.py", line 15, in <module> > > > > db = DAL('mysql://login:[email protected]/myapp') # use mySQL > > > > File "/m/content/www/data/web2py-1-79-2/gluon/sql.py", line 3855, in > > > > DAL > > > > raise RuntimeError, "Failure to connect to DB. Tried 5 times" > > > > RuntimeError: Failure to connect to DB. Tried 5 times > > > > > In file: /m/content/www/data/web2py-1-79-2/applications/myapp/models/ > > > > db.py > > > > > # -*- coding: utf-8 -*- > > > > > ######################################################################### > > > > ## This scaffolding model makes your app work on Google App Engine too > > > > ######################################################################### > > > > > if request.env.web2py_runtime_gae: # if running on Google > > > > App Engine > > > > db = DAL('gae') # connect to Google > > > > BigTable > > > > session.connect(request, response, db=db) # and store sessions and > > > > tickets there > > > > else: # else use a normal > > > > relational database > > > > db = DAL('mysql://login:[email protected]/myapp') # use mySQL > > > > > ===== > > > > Now if I comment out line 934 in gluon/sql.py, it connects without > > > > error! The line looks like this: > > > > self._execute("SET sql_mode='NO_BACKSLASH_ESCAPES';") > > > > > This has been the case from rel. 1.76 to current 1.79.2. Any ideas > > > > about this error & work around. I don't always remember to make the > > > > change for new releases and that causes unnecessary delay . > > > > > Thanks.
