Roundup Tracker - Issues

Issue 1143707

classification
AUTOCOMMIT in MYSQL
Type: Severity: normal
Components: Database Versions:
process
Status: closed fixed
:
: richard : jalanb, richard
Priority: normal :

Created on 2005-02-18 11:24 by jalanb, last changed 2005-02-18 11:24 by jalanb.

Messages
msg1856 Author: [hidden] (jalanb) Date: 2005-02-18 11:24
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
2005-02-18 11:24:52jalanbcreate