I use the lastest versions of Acesef Plus and Joomfish.

I have a HUGE issue with Joomfish, especialy with the language selection module. When the module is enable, I have the followinf error message in the module position.

No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Energie', 'Joomla! - le portail dynamique et système de gestion de contenu', ' at line 1 SQL=INSERT INTO jos_acesef_urls ( url_real, url_sef, metatitle, metadesc, metakey, published, used, source, sm_indexed, sm_date, sm_freq, sm_priority ) VALUES ( 'index.php?option=com_content&Itemid=1?=tr&view=frontpage', 'tr', 'Lan's Energie', 'Joomla! - le portail dynamique et système de gestion de contenu', 'joomla, Joomla', '1', '5', 'JRoute->_('index.php?option=com_content&view=frontpage&Itemid=1?=tr', '1', '1')--b2--/modules/mod_jflanguageselection/helper.php--b2--218n--b1--nJFModuleHTML->getRoute('index.php?option=com_content&view=frontpage&Itemid=1?=tr', 'tr-TR')--b2--/modules/mod_jflanguageselection/helper.php--b2--203n--b1--nJFModuleHTML->_route('index.php?option=com_content&view=frontpage&Itemid=1?=tr', TableJFLanguage)--b2--/modules/mod_jflanguageselection/helper.php--b2--166n--b1--n', '1', '2010-07-10', 'weekly', '0.5' )
No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Energie', 'Joomla! - le portail dynamique et système de gestion de contenu', ' at line 1 SQL=INSERT INTO jos_acesef_urls ( url_real, url_sef, metatitle, metadesc, metakey, published, used, source, sm_indexed, sm_date, sm_freq, sm_priority ) VALUES ( 'index.php?option=com_content&Itemid=1?=en&view=frontpage', 'en', 'Lan's Energie', 'Joomla! - le portail dynamique et système de gestion de contenu', 'joomla, Joomla', '1', '5', 'JRoute->_('index.php?option=com_content&view=frontpage&Itemid=1?=en', '1', '1')--b2--/modules/mod_jflanguageselection/helper.php--b2--218n--b1--nJFModuleHTML->getRoute('index.php?option=com_content&view=frontpage&Itemid=1?=en', 'en-GB')--b2--/modules/mod_jflanguageselection/helper.php--b2--203n--b1--nJFModuleHTML->_route('index.php?option=com_content&view=frontpage&Itemid=1?=en', TableJFLanguage)--b2--/modules/mod_jflanguageselection/helper.php--b2--166n--b1--n', '1', '2010-07-10', 'weekly', '0.5' )

What's wrong?

I use the lastest versions of Acesef Plus and Joomfish.

I have a HUGE issue with Joomfish, especialy with the language selection module. When the module is enable, I have the followinf error message in the module position.

No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Energie', 'Joomla! - le portail dynamique et système de gestion de contenu', ' at line 1 SQL=INSERT INTO jos_acesef_urls ( url_real, url_sef, metatitle, metadesc, metakey, published, used, source, sm_indexed, sm_date, sm_freq, sm_priority ) VALUES ( 'index.php?option=com_content&Itemid=1?=tr&view=frontpage', 'tr', 'Lan's Energie', 'Joomla! - le portail dynamique et système de gestion de contenu', 'joomla, Joomla', '1', '5', 'JRoute->_('index.php?option=com_content&view=frontpage&Itemid=1?=tr', '1', '1')--b2--/modules/mod_jflanguageselection/helper.php--b2--218n--b1--nJFModuleHTML->getRoute('index.php?option=com_content&view=frontpage&Itemid=1?=tr', 'tr-TR')--b2--/modules/mod_jflanguageselection/helper.php--b2--203n--b1--nJFModuleHTML->_route('index.php?option=com_content&view=frontpage&Itemid=1?=tr', TableJFLanguage)--b2--/modules/mod_jflanguageselection/helper.php--b2--166n--b1--n', '1', '2010-07-10', 'weekly', '0.5' )
No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Energie', 'Joomla! - le portail dynamique et système de gestion de contenu', ' at line 1 SQL=INSERT INTO jos_acesef_urls ( url_real, url_sef, metatitle, metadesc, metakey, published, used, source, sm_indexed, sm_date, sm_freq, sm_priority ) VALUES ( 'index.php?option=com_content&Itemid=1?=en&view=frontpage', 'en', 'Lan's Energie', 'Joomla! - le portail dynamique et système de gestion de contenu', 'joomla, Joomla', '1', '5', 'JRoute->_('index.php?option=com_content&view=frontpage&Itemid=1?=en', '1', '1')--b2--/modules/mod_jflanguageselection/helper.php--b2--218n--b1--nJFModuleHTML->getRoute('index.php?option=com_content&view=frontpage&Itemid=1?=en', 'en-GB')--b2--/modules/mod_jflanguageselection/helper.php--b2--203n--b1--nJFModuleHTML->_route('index.php?option=com_content&view=frontpage&Itemid=1?=en', TableJFLanguage)--b2--/modules/mod_jflanguageselection/helper.php--b2--166n--b1--n', '1', '2010-07-10', 'weekly', '0.5' )

What's wrong?

Go to AceSEF=>SEF URLs, open the following Real URL then Save it one plz:
index.php?option=com_content&view=frontpage&Itemid=1&=tr

Also, make sure you're using the latest version of AceSEF.

index.php?option=com_content&view=frontpage&Itemid=1&=tr

There is no such a Real URL available in the SEF URLs page.
Even if I tried to create a new one sef URF with this one, the new sef URL is not saved....

Just in case, the problem appears only in the homepage (for each language).

What do you mean is not saved? Do you get any error message? Screenshot?

I am having the exact same problem with my website. I just installed Acesef to test it and I get the error below when I access the website. It only happens on the root of the website like "www.m3-multimedia.com, not on any other pages like www.m3-multimedia.com/en/our-services for example. I tried your suggestion and I also tried to use other components as the home page, but the result is always a similar error. If you want I can give you access to my website so you can see for yourself. With core SEF from Joomla there is no problem.

The error:

No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's,', '1', '5', 'JRoute->_('index.php?option=com_content&view=frontpage&Itemid=1' at line 1 SQL=INSERT INTO jos_acesef_urls ( url_real, url_sef, metatitle, metadesc, metakey, published, used, source, sm_indexed, sm_date, sm_freq, sm_priority ) VALUES ( 'index.php?option=com_content&Itemid=167<=fr&view=frontpage', 'fr', 'M3-Multimedia', 'M3-Multimedia, Québec web design, hosting and computer repairs! We build your website tailor made to the functionality you need for your business, all integrated in one easy to use content management system.', 'Quebec, Canada, web, websites, web-design, custom, applications, hosting, support, computer, repairs, custom pc's,', '1', '5', 'JRoute->_('index.php?option=com_content&view=frontpage&Itemid=167<=fr', '1', '1')--b2--modulesmod_jflanguageselectionhelper.php--b2--218n--b1--nJFModuleHTML->getRoute('index.php?option=com_content&view=frontpage&Itemid=167<=fr', 'fr-FR')--b2--modulesmod_jflanguageselectionhelper.php--b2--203n--b1--nJFModuleHTML->_route('index.php?option=com_content&view=frontpage&Itemid=167<=fr', TableJFLanguage)--b2--modulesmod_jflanguageselectionhelper.php--b2--186n--b1--n', '1', '2010-08-19', 'weekly', '0.5' )
No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's,', '1', '5', 'JRoute->_('index.php?option=com_content&view=frontpage&Itemid=1' at line 1 SQL=INSERT INTO jos_acesef_urls ( url_real, url_sef, metatitle, metadesc, metakey, published, used, source, sm_indexed, sm_date, sm_freq, sm_priority ) VALUES ( 'index.php?option=com_content&Itemid=167<=en&view=frontpage', '', 'M3-Multimedia', 'M3-Multimedia, Québec web design, hosting and computer repairs! We build your website tailor made to the functionality you need for your business, all integrated in one easy to use content management system.', 'Quebec, Canada, web, websites, web-design, custom, applications, hosting, support, computer, repairs, custom pc's,', '1', '5', 'JRoute->_('index.php?option=com_content&view=frontpage&Itemid=167<=en', '1', '1')--b2--modulesmod_jflanguageselectionhelper.php--b2--218n--b1--nJFModuleHTML->getRoute('index.php?option=com_content&view=frontpage&Itemid=167<=en', 'en-GB')--b2--modulesmod_jflanguageselectionhelper.php--b2--203n--b1--nJFModuleHTML->_route('index.php?option=com_content&view=frontpage&Itemid=167<=en', TableJFLanguage)--b2--modulesmod_jflanguageselectionhelper.php--b2--166n--b1--n', '1', '2010-08-19', 'weekly', '0.5' )

Same problem here, what is the solution please

I did some testing and it seems that neither Joomfish nor ACEsef was to blame in my case. My configuration.php had gotten corrupted somehow. Try replacing it, I am curious if the same applies for you.

Go to "AceSEF=>Configuration=>Advanced=>Enable Source Tracker" and set it to "No" then Purge URLs.

NOTE: This has been fixed in AceSEF 1.3.13