Ah – thats makes more sense: it’s looking for T_OBJECT in a DB which contains only t_object, so it’s not just the t_objectproperties table which needs to be lower-case – it’s all of them.
This is a much more disruptive change: I need to change ALL the places where I issue direct SQL, to have lower-case table names, which is a load of calls, all of which need to be regression tested, and some of them only get used in some obscure situations.
As I can’t reproduce this on a local mySQL DBMS, I can’t then test it for you.
Do you think it’s become case-sensitive due to being implemented on a remote Linux machine? Have you tried with a local Windows mySQL?
Is this the kind of thing which Linux machines tend to do?
Any chance of you trying a schema change, to make a couple of tables upper-case, and check that EA doesn’t mind?
