Magento: Problem with the Fontis WYSIWYG editor (FCKeditor) and custom database predix

We were having lots of trouble getting the Configuration JavaScript working.
The problem turned out to be that we are having a prefix in our database of magento, and the code was not handling this case.
While setting up views in the db would have been one workaround…

To find out if you are suffering from this issue as well, open the fontis_custom_config.php file in an browser – and if you see mysql errors then there is a problem – and below is a solution that worked for us.

We did some edits to the js/fontis/fckeditor/fontis_custom_config.php file to make it handle database prefixes.
added:

28
29
    $prefix = $xml->global->resources->db->table_prefix;
    $tablename = $prefix . "core_config_data";

And then simply replace all the following instances of ‘core_config_data’ (without ‘s) with ‘” . $tablename .”‘ (again without ‘s) (as for insance)

35
            "SELECT * FROM " . $tablename . " WHERE path = 'fontis_wysiwyg/fckeditor/usecustomtoolbarjs'"));