Message1856
When initialising the roundup data the following error
occurs:
> roundup-admin initialise
...
File
"/usr/lib/python2.4/site-packages/roundup/backends/back_mysql.py",
line 146, in sql_open_connection
cursor.execute("SET AUTOCOMMIT=OFF")
File
"/usr/lib/python2.4/site-packages/MySQLdb/cursors.py",
line 137, in execute
self.errorhandler(self, exc, value)
File
"/usr/lib/python2.4/site-packages/MySQLdb/connections.py",
line 33, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.ProgrammingError: (1064, "You have an
error in your SQL syntax near 'OFF' at line 1")
This occurs when MySQL is used as the backend, and the
MySQL is version greater than 4.0.20. Specifically - it
occurs in MySQL version 4.0.23, but not in 4.0.20, nor
4.0.18, nor 3.2.27
Using the mysql command-line client gives the same
error for
"SET AUTOCOMMIT=OFF"
The MySQL command-line client (all versions) does accept
"SET AUTOCOMMIT=0"
|
|
Date |
User |
Action |
Args |
2009-02-03 14:21:12 | admin | link | issue1143707 messages |
2009-02-03 14:21:12 | admin | create | |
|