Quote Originally Posted by mc12345678 View Post
Code:
INSERT INTO `ceon_uri_mappings` (`uri` ,`language_id` ,`current_uri` ,`main_page` ,`query_string_parameters` ,`associated_db_id` ,`alternate_uri` ,`date_added`) 
VALUES ( '/mysite.com/fr','2','1','index','language=fr',NULL ,NULL , NOW() 
);
This assumes that French is language id 2; although I had also inadvertently used a value of '1' and obtained the same final result.

It doesn't replace the link provided at the language flags, but entering the link using the two letter language designation does result in landing on the home page in the language identified by the two letter abbreviation.

Not sure that using the mysite.com approach is correct meaning having the period included... I have seen a site before that had problems with having a subfolder of mysite.com instead of mysitedotcom or some full text only method.
Many thanks mc12345678 for your help and good intentions, but this doen´t work. I did it weeks ago and the redirection Works, but... zen-cart doesn´t recognize this as the homepage and renders the common index template.