Well, and this is from left field as I have at least a half dozen apps I have written.
One huge app, and a bunch of great publish to rest type apps. I have never touched the locks.
I haven't even had any problems, until now.
Relationships weren't relating, and locks were coughing back exceptions.
Finally, I created a new database from migration. Removed all locks everywhere except for modtime. Hey this is mysql
and there will only be a half dozen users. Basically a REST publisher for filling up iOS apps.
Then data sychn'd the old data back into the new database. And it works. However, I did this a few times and until
I unlocked almost everything did it work.
Very perplexing. But good enough for now to get this puppy publishing data.
Thanks
James