Hi All:
I've developed an app, now is time to depoly in production server. In
development stage the app works perfect, using with mysql v5.
Even if access from console, using mysql -u *username* -p *password* -h
*serverIP
... * logged in as expected.
And my production server, cant be upgraded to mysql 5 for now.
But openning the app in the browser, im getting this error:
Traceback (most recent call last):
File "/opt/http/www-data/web2py/gluon/restricted.py", line 194, in
restricted
exec ccode in environment
File "/opt/http/www-data/web2py/applications/messageManager/models/db.py"
line 7, in
db = DAL("mysql://*username:password*@*serverIP*/databasename",migrate=
False)
File "/opt/http/www-data/web2py/gluon/dal.py", line 4156, in __init__
* raise RuntimeError, "Failure to connect, tried %d times:\n%s" %
(attempts, error)*
RuntimeError: Failure to connect, tried 5 times:
*(1231, u"Variable 'sql_mode' can't be set to the value of
'NO_BACKSLASH_ESCAPES'")*
I think the problem is related with this post:
http://comments.gmane.org/gmane.comp.python.web2py/36191
But I dont know what to do with this line of code (pointed by massimo):
self._execute("SET sql_mode='NO_BACKSLASH_ESCAPES';")
Is there a work around, to make it works, or mysql 4 is "unsupported"
ANY HELP IS APPRECIATED :)
Thanks in advance!
