Roundup Tracker - Issues

Message1856

Author jalanb
Recipients
Date 2005-02-18.11:24:52
Message-id
In-reply-to
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"


History
Date User Action Args
2009-02-03 14:21:12adminlinkissue1143707 messages
2009-02-03 14:21:12admincreate