Roundup Tracker - Issues

Issue 1727529

classification
storage_engine depreciated
Type: Severity: normal
Components: Database Versions:
process
Status: closed fixed
:
: jpend : jpend, miniwark
Priority: high :

Created on 2007-05-29 13:33 by miniwark, last changed 2007-09-28 15:26 by jpend.

Files
File name Uploaded Description Edit Remove
mysql.patch jpend, 2007-09-25 02:53 engine patch
Messages
msg2435 Author: [hidden] (miniwark) Date: 2007-05-29 13:33
With fresh install when i type "roundup-admin initialise" i have the following (Python ?) alert :

/usr/local/lib64/python2.5/site-packages/roundup/backends/rdbms_common.py:156: Warning: 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead
  self.cursor.execute(sql)

The database was apparently created correctly
msg2436 Author: [hidden] (jpend) Date: 2007-09-03 06:58
This is just a warning, so you can ignore it for the time being.

Apparently in MySQL 5.2 they are going to drop support for the TYPE= syntax in favor of the ENGINE= syntax, so roundup will need to make the change at some point. ENGINE was added in "MySQL 4.0.18 (for 4.0) and 4.1.2 (for 4.1)".

Since even SuSE 9 and RHEL 4 support that, maybe now is the time for the change.
msg2437 Author: [hidden] (jpend) Date: 2007-09-25 02:53
I've attached a patch that probably fixes this. I don't have mysql installed so if someone else tests this and tells me it doesn't break everything horribly I'll commit it to CVS :)
File Added: mysql.patch
msg2438 Author: [hidden] (jpend) Date: 2007-09-28 15:26
Committed the patch to CVS.
History
Date User Action Args
2007-05-29 13:33:39miniwarkcreate