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'"));

Magento: Problem with DIBS module

Using the DIBS module (from Magento connect); we had the “slight” problem that if the order was payed using the test visa card (from DIBS 10 steps) viewing the order was not possible.
The page only partially rendered but most of it was not shown.

We “fixed” this by adding two things to app/code/local/Mage/Adminhtml/Block/Sales/Order/View/Tab/Info.php

We figured out the problem lied in the “switch($paytype)” statement in the “function printLogo($paytype)”

We started by editing the “default:” statement to read

$res = 'no image for ' . $paytype;

instead of the old statement of

$res = '<img src="' . $paytype;

was what broke the page rendering as that img tag was not ended.

We also added an extra case for the card that didn’t exist in the old switch:

case 'VISA,V-DK':  {
                $res = '<img alt="" />getSkinUrl('images/dibs/visa.gif') . '" border="0" />';  break;
            }

Magento: Adding tax (Swedish moms for example)

There is 4 momsclasses in Sweden (25%, 12%, 6% and 0%).

Under Sales-Tax-Manage tax zones & rates:

Create one rule per momsclass for Sweden with * as region and * as Zip.

Create one rule for customers.

Create one rules per momsclass for products.

Create one Tax rule for each momsclass.

Make sure that the products in the catalog have tax set (if there are product in the catalog).

Under System-Config-Tax make the appropriate settings. (defines if the prices are including or excluding tax, if tax should be added on shipping or not etc)

DSN 5.0.0 – Service Unavaliable

Ran into this error today on a server. Some mails got through but some was not getting through.

Check that /etc/hosts has a FQDN (fully qualified domain name).

Also check the size of the mails being sent, in my case the issue was that mail was to large for the receiving server thus this error message was produced at the sender.