Edventures in Normalcy

Common example errors:

Unable to authorize payment: The certificate chain did not validate, no local certificate found, Cert Path = c:\pfpcerts\, Working Directory = c:\windows\system32\inetsrv

or

Result Code: -31
Response Message: The certificate chain did not validate, no local certificate found, Cert Path = c:\pfprocerts, Working Directory = c:\windows\system32\inetsrv
Transaction ID:
Auth. Code:

or

I’m Sorry, there was a problem with your transaction.

Transaction Result:
The certificate chain did not validate, no local certificate found, Cert Path = certs, Working directory = c:\winnt\system32\inetsrv

Well, as of January 4, 2010, your Payflow Pro SDK expires permanently and your payment processing will stop if you are using an outdated SDK. You can see this on their website here:
https://cms.paypal.com/us/cgi-bin/?cmd=_render-content&content_ID=developer/gateway_update_FAQ

Depending on the method or scripting language you are using this can be an easy or difficult thing to get around. As I am Miva Merchant savvy, If you are using Miva Merchant 5, run your updates. If you are running Miva Merchant 4, you can get an updated version of the Payment Module and instructions for instillation at https://support.mivamerchant.com/supportsuite/index.php?_m=downloads&_a=viewdownload&downloaditemid=46&nav=0,12. Zen Cart forums make reference to this change here http://www.zen-cart.com/forum/showthread.php?p=823250#post823250. Anyway, if you have a hand coded cart, visit the top link I supplied for more information. If you find specific articles or information for specific carts, please comment. I will gladly update this post.

Runtime error in lib/db.mvc @ [00000164:00000024]: lib/dbprim/stores.mv: Line 202: MvOPENVIEW: mysql_stmt_bind_results: Using unsupported buffer type: 246 (parameter: 27)

I run into this one once in a while and always have to remember to upgrade the MySQL driver to the latest.

To reorder products within a given category
in your admin section, click on Categories on the left hand side
Then to the right of the category you want to reorder products for
click the “Edit” button
Once the page loads, click the Products tab
Then click the Assigned button
This will show you the products specific to this category
To the right of Product order is a link that should say Hide, if not click the word Show
You can now see the order products will show up on this category
If you wanted the Product 2 to be the first item, you can go to its box, change the 2 to a 1 and hit enter, not Update
You will then notice the order of products has changed on your category that you edited

[View with PicLens]

So you have some categories (image one) and this is what they look like (image two). Then you add a third Category (image three) and you see what it looks like (image four), but you feel this is a sub category, or a sub type of a main category. So what you want to do, is set it as a sub category. To do this, in the admin, on the far right, click Edit (image five). Click the Look Up button (image six) and chose the appropriate parent category (image seven). Then Click the Update button (image eight). Now, if you go to the site, the site by default looks like Image two, but if you click on Category One, it shows you the sub categories (image nine)

[View with PicLens]

To edit your settings log into your Seller Central Account, Click on Checkout Pipeline Settings under Settings on the left hand menu. Click on the Edit button. 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 Checkout by Amazon module. The correct settings are listed on the bottom. Keep in mind the Merchant URL must be a secure (https) URL. Then Click Update to complete.

[View with PicLens]

Scripts seem to have been upgraded but the backend was not, so the scripts are looking for a field that does not exist.  From my understanding may be related to core 14.

This post is primarily for when going from 4-5 to find out what module the missing one was.

For all of those like me that can never remember, when looking for the OINF page, look to the OCST and ORDL pages instead.

If customer is not logged in -> OINF Goes to ORDL
If customer is logged in -> OINF Goes to OCST

To edit your settings log into your PayPal Manager Account, Click on Service Settings, and then Click on Configuration.  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 Verisign Payflow Link module.

[View with PicLens]

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]