Edventures in Normalcy

To edit your settings log into your Google Checkout Account, Click on Settings, and then Click on Integration.  You will find the correct settings to set these to within your Miva Merchant admin section, at the screen where you edit the Payment settings for your Google Checkout module.

[View with PicLens]

To edit your settings log into your PayPal Account, Click on Profile.  Both sections you want to edit are here.  The First one is Instant Payment Notification Preferences (6 down on the right column in my image) the second is the Website Payment Preferences (10 down on the right column in my image).  You will find the correct settings to set these to within your Miva Merchant admin section, at the screen where you edit the Payment settings for your PayPal Website Payments Standard module.

[View with PicLens]

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:

update s02_USPSMethods set name = replace(name, '�', '®');

Now because I took the time to make sure the above command displays as should be run, it is semi safe to copy and paste it, 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.

I ran across this error on a new server when configuring Miva Merchant.  Upload the diag5.mvc from Miva Merchant and go to the MIVA License Manager Call. Here you should see errors to assist in troubleshooting the error.