Multisite wordpress SSL fix for wp-admin

For some reason on one multisite wordpress installation, that is manage by our customer, all wp-admin links began redirecting visitor to secure (SSL) site. This has become a problem for many users, since none of them had valid certificate and browsers were giving very ugly message.

First suggestion, that I found was to add these 2 line into wp-config.php.

define('FORCE_SSL_ADMIN', false);
define('FORCE_SSL_LOGIN', false);

This has helped on all sites, but one. To fix that I went into phpMyAdmin, located main database for this wordpress installation and opened table wp_domain_mapping. There I found record, that corresponded to domain, which was still redirecting to secure URL and changed value of the column scheme from 2 to 0.

Further more I looked in a table wp_<ID>_options. This is a table, that contains configuration options for specific domain inside multisite wordpress. You can find <ID> in wp_domain_mapping table. In this wp_<ID>_options table I search for %force_ssl% option (column option_name) and changed value for option_value on all records from 2 to 0 as well.

This has fixed the problem! 🙂