Edventures in Normalcy

Some times I see strange characters when viewing the Shipping Options in a Miva Merchant store.  This is because the characters are dependent on a character set.  The way to correct this is to run the following command:

It is semi safe to copy and paste the above command, ensure you change the s02 as needed. On a side note, this runs best from phpMyAdmin as pasting this in putty can cause problems with it matching the bad characters.

I got this error:
Runtime error in features/sta/sta_db.mvc @ [00000007:00000028]: Line 151: MvQUERY: mysql_stmt_prepare: Table ‘user.s01_Stats’ doesn’t exist

Miva Merchant has encountered a fatal error and is unable to continue. The following information may assist you in determining the cause of the error:
Error Code: MER-STA-DTB-00008
Description: mysql_stmt_prepare: Table ‘user.s01_Stats’ doesn’t exist

The problem was I use a shared SSL from my host and I rant he Add Store when logged in insecurely.  I had to have the store dropped from the Stored table and set the Stores value in the DomainKeys table down by one.  So if it was set to 1, I had to set it to 0.  I was then able to add the store securely without error.

As promised, see below:

Here are pictured of my X the Eliminator costume. I wore this to work. Hopefully I will be winning the contest as only 12 others came in costume. This character is seen on Harvey Birdman, Attorney at Law, which aired on Adult Swim.