Hey,
Apologies to everyone my life got in the way of this one but I am back trying to figure out the issue. So what I’ve done so far is dump the whole thing out of the MySQL. Then on a local install I have been implementing the tables one by one and it appears the problem is within the ‘wp_usermeta’ table which is pretty obvious I suppose what with the error message appearing on the User’s page.
What I am trying to figure out now is how to rectify the issue when there are 1000+ registered users and half dozen authors? Will an export from within WordPress preserve these ‘subscribers’? Mainly rhetorical question as I will investigate further tomorrow. Although if anyone can guesstimate the table error that would be great.
Cheers