MetricsGrimoire / Bicho

Bicho is a command line based tool used to parse bug/issue tracking systems
http://metricsgrimoire.github.com/Bicho/
GNU General Public License v2.0
71 stars 31 forks source link

Error when using Bicho with innodb - foreign key references #21

Open adinabarham opened 11 years ago

adinabarham commented 11 years ago

It seems that there are some problems with foreign key references when the engine is innodb due to the additional checks (for example when creating the trackers table there is a reference to tracker_types - shouldn't that be supported_trackers?).

There are some problems with using MySQL on MacOS so switching to Myisam didn't work very smoothly. As a work around I just added in the table declaration engine=MYISAM in the following files:

Bicho/backends/bg.py Bicho/db/mysql.py

Error output can be found at the following address: http://pastebin.com/cEtuEDi0