Transferred joomla site to non https site

Joomla turn off 'Force SSL' in mysql


Actually it's not set in mysql - you'll need to OPEN configuration.php

AND CHANGE

var $force_ssl = '1';

TO

var $force_ssl = '0';

and always with a Joomla Virtuemart site transfer you'll need to change the address saved in Virtuemart - read this blog ->
'duplicated joomla and virtuemart site goes to old website address when accessing virtuemart through the backend'