msrebuildings

After some playing around I realised it’s really simple with SQL, provided you have full database access.

I’m posting these as SELECT queries because you should run them that way first to check you have the right users before you DELETE. Anyone who doesn’t understand this should not try it!

SELECT * FROM wp_users WHERE ID NOT IN (SELECT user_id FROM WP_usermeta WHERE meta_key = 'wp_##_capabilities')

Your tables may have different prefixes.

You can use a similar query to delete records from other tables when they no longer have a user in users.

Hi – thanks for the quick reply. We never got round to testing this as we found that at some point one of our team had made a small change to WP core, which we reverted and it worked after.

OK, thanks for your help.

We resolved the date issue, I don’t know what the problem was but we deactivated the plugin and removed its data, then reactivated. It is fine now.

I have found a better map solution by using Comprehensive Google Map Plugin in the event description. It is much more configurable (for example, we were able to use a branded map icon in place of the pin) and works fine. Other users might want to try this if they have problems.

Hi, thanks for your response. The WP version is 3.4.1 and the plugin version is 1.1.3.

If we work out the issue with date selection we’ll let you know what we found. It’s clearly conflicting with something in our setup.

Regarding the map, please see here: https://www.rebuildingsociety.com/events/4/the-rebuildingsociety-com-crowdfunding-roadshow/

This is with an address, not the lat. and long.