CiviCRM Community Forums (archive)

I've just recently upgraded to 3.3 from 3.1.4 and performed some merges tonight for the first time.

I failed to notice the 'add new' box next to memberships and am worried that I may have lost some active memberships and retained some pending ones by failing to tick this box to keep both for post-merge inspection as I used to do.

I have a daily mysqldump backup (yay) so can use this to inspect the original records but first I need to find them again.  A search for changes done today is failing through the main interface (i think it is timing out) so I want to run a manual SQL query.

However I can't find where the change log date is stored on the civi database structure.  Can someone point me in the right direction please (or suggest a better approach if you have one).

Thanks for this.

I don't have logging enabled yet, tried to do that on installing the upgrade but got an error - I think I may need to grant the mysql user extra permissions but haven't checked the error log yet.

In the meantime I discovered about two hours ago the new "Trash Contact" feature with this upgrade (I was several versions behind) so have managed to get the list of potentially affected members from that as all the dropped members from the merges were in there.

Tomorrow nights task will be to reload the live mysqldump from a few days ago into my test region and I can then browse them all manually - only about 12 affected I reckon.

Next time I'll be more careful to understand what features have changed between versions.