enable https access across the site

[emeraldjava]

Update the site to use https by default

UPDATE wp_postmeta SET meta_value=(REPLACE (meta_value, '="http://bhaa.ie','https://bhaa.ie'));

UPDATE wp_postmeta SET meta_value=(REPLACE (meta_value, 'http://bhaa.ie','https://bhaa.ie')) WHERE meta_value LIKE 'http://bhaa.ie%';

-- av_image src='http://bhaa.ie

UPDATE wp_postmeta SET meta_value=(REPLACE (meta_value, 'http://bhaa.ie','https://bhaa.ie')) WHERE meta_value LIKE '%http://bhaa.ie%';

UPDATE wp_posts SET post_content=(REPLACE (post_content, 'http://bhaa.ie','https://bhaa.ie')) WHERE post_content LIKE '%http://bhaa.ie%';

UPDATE wp_em_events SET post_content=(REPLACE (post_content, 'http://bhaa.ie','https://bhaa.ie')) WHERE post_content LIKE '%http://bhaa.ie%';

https://css-tricks.com/moving-to-https-on-wordpress/

[emeraldjava]

Done.