#36 Deleting items in MySQL leaves addInfo fields

[Matthias Ihmig]

Forum entry:
http://sourceforge.net/forum/forum.php?thread_id=1731555&forum_id=285354

Just encountered another, quite severe bug when using MySQL.

It seems, deleting entries is not completly finished. This is noticeable when creating new entries.

How to reproduce:
1) Create a new MySQL database
2) Add a movie with file info (Get File Info, Get IMDb info)
3) Add additional field, enter some text in additional field for movie added in (2)
4) Delete movie entry
5) Add another move, this time only with "Get IMDb info", Save&Close
BUG: Additional Fields (including User field) is "used" again for this new entry
(both additional field categories shows data from Movie (2), though they should be empty)

Matthias

java.sql.SQLException: Duplicate entry '1' for key 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)

I know Bro could not reproduce this on his myqsl db, but I think this bug might be related to another "deleting mysql entry" bug reported before.

The problems seems to be a different handling of SQL Delete-Commands by different MySQL versions when it comes to delete connected Additional Fields.

So I think this issue is quite important to find and to make it work with the average MySQL engine.

Matthias

[Matthias Ihmig]

Logged In: YES
user_id=921651
Originator: YES

I just updated my MySQL from 4.0.24 to 5.0.38 and the problem is still the same - AdditionalInfo and ExtraInfo is _not removed and reappears/mixes up with new entries.

So it does not seem to be a problem with MySQL but rather with somewhere in xmm. Though there is no error message when deleting the entry.

Matthias

[Matthias Ihmig]

Logged In: YES
user_id=921651
Originator: YES

It seems there is an issue with the MyISAM engine, but it works when using the InnoDB engine (thanks Bro for figuring this out and fixing this in CVS by forcing InnoDB).

To check the engine of existing MySQL DB:
mysql> show table status from yourdatabase;

How to migrate MySQL from MyISAM to InnoDB:
http://www.linux.com/articles/46370?tid=72

Thanks!

Matthias