jplacy2

Okay, using that error message as a guide, I discovered a FAQ that is clearly covered in the readme. I enabled the PDO_MySQL extension and I’m now able to connect.

I’m using WordPress 4.6.1, and version 3.20 of the plugin. Now when I enter in the connection details and click “Test the database connection,” I don’t get anything… nothing shows in the log window.

I looked in the system php errors file, and see this:

[26-Oct-2016 18:53:33 UTC] PHP Fatal error: Uncaught Error: Undefined class constant ‘MYSQL_ATTR_INIT_COMMAND’ in C:\www\wp-content\plugins\fg-joomla-to-wordpress\admin\class-fg-joomla-to-wordpress-admin.php:483

Any suggestion for what I should troubleshoot first?

Awesome, thanks for your note. I’ll give this a try.

Great question! Thanks for the discussion. I’ve found similar charts, and initially figured I could use those as well. I mean, how hard can this be right?

To be honest, your source for the zip code info seems a little sketchy. How do you know it’s accurate? What is the original source? Clearly though, the Florida DOR is the definitive source for tax info.

The crude maps I produced used US Census Zip Code Tabulation Area data. ZCTA’s are perhaps the best “mapped” approximation of zip codes you can find for free.

Try this: go to zillow.com, and do a search on zip code 32640. It’s hard to see, but you’ll notice a very faint line that splits that zip into two pieces… one in Putnam County, the other in Alachua County. Maybe by dumb luck those two counties charge the same for sales tax, in which case you’d be fine. But what if they don’t?

If you really want your head to pop, read this: https://en.wikipedia.org/wiki/ZIP_code

… thus, zips may seem fine at first glance, but when you dig in, it may not be so.

I really wish I knew how the big online merchants with brink and mortar stores figure all of this out! Probably big $$ to throw at commercial services.

Thanks again.

Thanks for your response. In my experience, zip code boundaries cross county boundaries quite frequently. Meaning, a single zipcode could easily fall into multiple counties that each charge different rates.

Check out these crude maps for an area in Wisconsin and also Florida. Helps illustrate what I’m saying.

True. But the payment would already be posted by our payment gateway. My thinking is it would be easier to charge a “cheater” the proper tax after the fact, vs having to refund a tax exempt organization.