As part of the upgrade and persistence migration from old mysql to jdbc, you have to change the config to ensure it keeps your item mappings.
However, even if you use the recommended config
tableNamePrefix=Item tableUseRealItemNames=false tableIdDigitCount=0
it uses an index table called items and not Items. As a result, everything is out of whack.
I assume this is not by-design?
To fix, you simply have to run the following in mysql query
truncate table items insert INTO items SELECT * FROM Items
only to be run if your DB is case sensitive
Anyone else seen this happen?