doorcowebie

It’s the WooCommerce LightSpeed POS plugin by RioBaker, version 2.3.0 (most recent version). https://woocommerce.com/products/lightspeed-pos-integration/

Here’s the woocommerce system status:

### WordPress Environment ###

WordPress address (URL): https://www.bayshoreoutfitters.com
Site address (URL): https://www.bayshoreoutfitters.com
WC Version: 6.3.0
REST API Version: ? 6.3.0
WC Blocks Version: ? 7.1.0
Action Scheduler Version: ? 3.4.0
WC Admin Version: ? 3.2.1
Log Directory Writable: ?
WP Version: 5.9.1
WP Multisite: –
WP Memory Limit: 2 GB
WP Debug Mode: ?
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.28
PHP Post Max Size: 8 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.81.0
OpenSSL/1.1.1m

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.0.38-MariaDB
Max Upload Size: 8 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.3.0
WC Database Prefix: wpss_
Total Database Size: 578.15MB
Database Data Size: 371.77MB
Database Index Size: 206.38MB
wpss_woocommerce_sessions: Data: 0.10MB + Index: 0.01MB + Engine MyISAM
wpss_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpss_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_woocommerce_order_items: Data: 0.16MB + Index: 0.08MB + Engine MyISAM
wpss_woocommerce_order_itemmeta: Data: 1.35MB + Index: 0.78MB + Engine MyISAM
wpss_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_actionscheduler_actions: Data: 110.71MB + Index: 23.28MB + Engine MyISAM
wpss_actionscheduler_claims: Data: 0.03MB + Index: 0.06MB + Engine MyISAM
wpss_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpss_actionscheduler_logs: Data: 50.97MB + Index: 34.44MB + Engine MyISAM
wpss_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpss_comments: Data: 0.28MB + Index: 0.13MB + Engine MyISAM
wpss_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_loginizer_logs: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpss_ngg_album: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_ngg_gallery: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_ngg_pictures: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wpss_options: Data: 4.08MB + Index: 0.34MB + Engine MyISAM
wpss_postmeta: Data: 38.16MB + Index: 6.66MB + Engine MyISAM
wpss_posts: Data: 7.45MB + Index: 1.20MB + Engine MyISAM
wpss_premmerce_search_words: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wpss_sm_advanced_search_temp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_taxjar_record_queue: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_termmeta: Data: 0.14MB + Index: 0.10MB + Engine MyISAM
wpss_terms: Data: 0.22MB + Index: 0.35MB + Engine MyISAM
wpss_term_relationships: Data: 28.87MB + Index: 63.40MB + Engine MyISAM
wpss_term_taxonomy: Data: 0.23MB + Index: 0.41MB + Engine MyISAM
wpss_usermeta: Data: 2.90MB + Index: 1.66MB + Engine MyISAM
wpss_users: Data: 0.32MB + Index: 0.23MB + Engine MyISAM
wpss_visual_form_builder_entries: Data: 21.09MB + Index: 0.14MB + Engine MyISAM
wpss_visual_form_builder_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_visual_form_builder_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_wclsi_items: Data: 11.06MB + Index: 6.86MB + Engine MyISAM
wpss_wclsi_item_attribute_sets: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpss_wclsi_item_categories: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wpss_wclsi_item_e_commerce: Data: 3.21MB + Index: 0.33MB + Engine MyISAM
wpss_wclsi_item_images: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wpss_wclsi_item_prices: Data: 6.94MB + Index: 4.26MB + Engine MyISAM
wpss_wclsi_item_shops: Data: 8.60MB + Index: 14.25MB + Engine MyISAM
wpss_wcpdf_invoice_number: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
wpss_wcpdf_packing_slip_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_wc_admin_notes: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
wpss_wc_admin_note_actions: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wpss_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_wc_customer_lookup: Data: 0.07MB + Index: 0.03MB + Engine MyISAM
wpss_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_wc_order_coupon_lookup: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wpss_wc_order_product_lookup: Data: 0.13MB + Index: 0.10MB + Engine MyISAM
wpss_wc_order_stats: Data: 0.08MB + Index: 0.05MB + Engine MyISAM
wpss_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine MyISAM
wpss_wc_product_attributes_lookup: Data: 0.07MB + Index: 0.09MB + Engine MyISAM
wpss_wc_product_meta_lookup: Data: 0.47MB + Index: 0.45MB + Engine MyISAM
wpss_wc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpss_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_wfBlockedIPLog: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
wpss_wfBlocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_wfConfig: Data: 1.01MB + Index: 0.02MB + Engine MyISAM
wpss_wfCrawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_wfFileChanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_wfFileMods: Data: 4.65MB + Index: 0.91MB + Engine MyISAM
wpss_wfHits: Data: 0.68MB + Index: 0.11MB + Engine MyISAM
wpss_wfHoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_wfIssues: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wpss_wfKnownFileList: Data: 2.52MB + Index: 0.28MB + Engine MyISAM
wpss_wfLiveTrafficHuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_wfLocs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_wfLogins: Data: 0.36MB + Index: 0.07MB + Engine MyISAM
wpss_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpss_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpss_wfNotifications: Data: 0.03MB + Index: 0.01MB + Engine MyISAM
wpss_wfPendingIssues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_wfReverseCache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_wfSNIPCache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_wfStatus: Data: 0.07MB + Index: 0.04MB + Engine MyISAM
wpss_wfTrafficRates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpss_yoast_indexable: Data: 5.87MB + Index: 1.03MB + Engine MyISAM
wpss_yoast_indexable_hierarchy: Data: 0.11MB + Index: 0.27MB + Engine MyISAM
wpss_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpss_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine MyISAM
wpss_yoast_prominent_words: Data: 0.17MB + Index: 0.23MB + Engine MyISAM
wpss_yoast_seo_links: Data: 0.05MB + Index: 0.02MB + Engine MyISAM
wpss_yoast_seo_meta: Data: 23.04MB + Index: 24.08MB + Engine MyISAM
wpstg0_commentmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_comments: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg0_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_loginizer_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_ngg_album: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_ngg_gallery: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_ngg_pictures: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wpstg0_options: Data: 1.35MB + Index: 0.10MB + Engine MyISAM
wpstg0_postmeta: Data: 8.28MB + Index: 2.38MB + Engine MyISAM
wpstg0_posts: Data: 3.39MB + Index: 0.29MB + Engine MyISAM
wpstg0_premmerce_search_words: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wpstg0_termmeta: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wpstg0_terms: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wpstg0_term_relationships: Data: 0.09MB + Index: 0.18MB + Engine MyISAM
wpstg0_term_taxonomy: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wpstg0_usermeta: Data: 0.03MB + Index: 0.02MB + Engine MyISAM
wpstg0_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg0_visual_form_builder_entries: Data: 0.39MB + Index: 0.00MB + Engine MyISAM
wpstg0_visual_form_builder_fields: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_visual_form_builder_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wclsi_items: Data: 6.61MB + Index: 4.02MB + Engine MyISAM
wpstg0_wclsi_item_attribute_sets: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg0_wclsi_item_categories: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wpstg0_wclsi_item_e_commerce: Data: 0.05MB + Index: 0.01MB + Engine MyISAM
wpstg0_wclsi_item_images: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wpstg0_wclsi_item_prices: Data: 4.77MB + Index: 2.71MB + Engine MyISAM
wpstg0_wclsi_item_shops: Data: 5.49MB + Index: 8.80MB + Engine MyISAM
wpstg0_wcpdf_invoice_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wfBadLeechers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wfBlockedCommentLog: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wfBlockedIPLog: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wfBlocks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wfBlocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wfBlocksAdv: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wfConfig: Data: 1.40MB + Index: 0.01MB + Engine MyISAM
wpstg0_wfCrawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wfFileChanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wfFileMods: Data: 1.86MB + Index: 0.39MB + Engine MyISAM
wpstg0_wfHits: Data: 0.33MB + Index: 0.07MB + Engine MyISAM
wpstg0_wfHoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wfIssues: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg0_wfKnownFileList: Data: 0.98MB + Index: 0.12MB + Engine MyISAM
wpstg0_wfLeechers: Data: 0.02MB + Index: 0.03MB + Engine MyISAM
wpstg0_wfLiveTrafficHuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wfLockedOut: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wfLocs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wfLogins: Data: 0.03MB + Index: 0.01MB + Engine MyISAM
wpstg0_wfNet404s: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wfNotifications: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wpstg0_wfPendingIssues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wfReverseCache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wfScanners: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg0_wfSNIPCache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wfStatus: Data: 0.07MB + Index: 0.04MB + Engine MyISAM
wpstg0_wfThrottleLog: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wfTrafficRates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_wfVulnScanners: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_woocommerce_order_itemmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_woocommerce_sessions: Data: 0.05MB + Index: 0.00MB + Engine MyISAM
wpstg0_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpstg0_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpstg0_yoast_seo_links: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wpstg0_yoast_seo_meta: Data: 0.02MB + Index: 0.02MB + Engine MyISAM

### Post Type Counts ###

announcement: 40
attachment: 4234
display_type: 7
jetpack_migration: 2
library_modules: 1
library_rows: 1
nav_menu_item: 68
ngg_gallery: 4
ngg_pictures: 22
oembed_cache: 1
page: 47
post: 16
product: 635
product_variation: 3232
revision: 1649
shop_coupon: 35
shop_order: 860
shop_order_refund: 167
tbuilder_layout: 2
tribe_events: 4
tribe_organizer: 1
tribe_venue: 4
wp_global_styles: 1

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (41) ###

Query Monitor: by John Blackbourn – 3.8.2
Announcement Bar: by Themify – 2.0.7
Builder Image Pro: by Themify – 2.0.6
Classic Editor: by WordPress Contributors – 1.6.2
Constant Contact Forms for WordPress: by Constant Contact – 1.12.0
Debug Bar: by wordpressdotorg – 1.1.2
FareHarbor for WordPress: by FareHarbor – 3.6.4
Flexible Shipping UPS: by WP Desk – 1.17.6
Google Analyticator: by SumoMe – 6.5.4
ipushpull: by ipushpull – 2.3.2
Jetpack: by Automattic – 10.7
Google Ads & Marketing by Kliken: by Kliken – 1.0.8
Loginizer: by Softaculous – 1.7.0
Maintenance: by WebFactory Ltd – 4.05
Premmerce Product Search for WooCommerce: by premmerce – 2.2.3
Product Sales Report for WooCommerce: by Aspen Grove Studios – 1.5.1
Sales Report for WooCommerce: by BeRocket – 3.5.7.3
Fast Secure Contact Form: by fastsecure – 4.0.56
Smart Manager For WooCommerce – Stock Management, Bulk Edit & more...: by StoreApps – 5.37.0
SQL Executioner: by Justin Watt – 1.4
Tabby Responsive Tabs: by cubecolour – 1.3.3
TaxJar - Sales Tax Automation for WooCommerce: by TaxJar – 4.1.1
The Events Calendar: by The Events Calendar – 5.14.0.1
Themify Portfolio Post: by Themify – 1.1.9
Themify Updater: by Themify – 1.3.4
Themify - WooCommerce Product Filter: by Themify – 1.3.6
Visual Form Builder: by Matthew Muro – 3.0.6
Discount and regular price cart and checkout page display WooCommerce: by wpnetworkit – 1.3.2
WooCommerce Blocks: by Automattic – 7.1.0
WooCommerce Admin: by WooCommerce – 3.2.1
WooCommerce Stripe Gateway: by WooCommerce – 6.2.0
WooCommerce LightSpeed POS: by RioBaker – 2.3.0
WooCommerce PDF Invoices & Packing Slips: by WP Overnight – 2.14.0
WooCommerce Shipping & Tax: by WooCommerce – 1.25.23
WooCommerce: by Automattic – 6.3.0
Wordfence Security: by Wordfence – 7.5.8
Yoast SEO Premium: by Team Yoast – 15.5
WP Debugging: by Andy Fragen – 2.11.9
WP Notification Bars: by MyThemeShop – 1.0.11
WP STAGING: by WP-STAGING – 2.9.5
NextGEN Gallery: by Imagely – 3.23

### Inactive Plugins (2) ###

Facebook for WooCommerce: by Facebook – 2.6.9
Yoast SEO: by Team Yoast – 18.1

### Dropin Plugins (1) ###

db.php: Query Monitor Database Class

### Must Use Plugins (1) ###

WP STAGING Optimizer: by René Hermenau – 1.5.1

### Settings ###

API Enabled: –
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: ?

### WC Pages ###

Shop base: #1178 - /shop/
Cart: #1179 - /cart/
Checkout: #1180 - /checkout/
My account: #1181 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Ultra Child
Version: (update to version 0 is available)
Author URL: 
Child Theme: ?
Parent Theme Name: Themify Ultra
Parent Theme Version: 5.1.6 – 5.5.7 is available
Parent Theme Author URL: https://www.themify.me
WooCommerce Support: ?

### Templates ###

Overrides: themify-ultra/woocommerce/loop/loop-end.php
themify-ultra/woocommerce/loop/loop-start.php

### Action Scheduler ###

Complete: 217,256
Oldest: 2022-02-05 16:42:37 -0600
Newest: 2022-03-08 19:25:19 -0600

Failed: 30,228
Oldest: 2019-08-31 12:52:14 -0500
Newest: 2022-02-16 15:19:13 -0600

Pending: 12
Oldest: 2022-03-08 19:25:20 -0600
Newest: 2022-03-09 12:06:28 -0600

### Status report information ###

Generated at: 2022-03-08 19:25:43 -06:00

Thankfully I was able to find a solution to what was going on here – it was something with the WP Db Abstraction plugin, here is a link to the fix: https://www.ads-software.com/support/topic/plugin-wp-db-abstraction-select-top-0

Thanks Voodoo, I was able to adapt what you had done to the site I’m working on and display an image if given a “yes” value for each of the dropdowns.

It ended up being an issue with the client’s Charter hosting account. They were on an old hosting platform and we were told wouldn’t be migrated to the newer platform anytime soon. The client contacted Charter and threatened to discontinue their services with them so Charter eventually migrated them to the new hosting and the site is up and running without any database connection issues.

Yes, I tried both localhost and mysql52int.cp.charter-business.net for the db_host.

I had no issues with getting wordpress to connect when it was under our HostGator account/database – it is just the connection with our client’s Charter mysql database.

I had not previously but when I looked back under the Charter database control panel, here is some of the info they provided:
Database name dbyyyyyy_xxxxxx
Database type MySQL
Status Ready
Internal hostname mysql52int.cp.charter-business.net
Host port 3306
Access from external hosts Disabled

I called Charter tech support a couple times and they didn’t have any ideas and told me to submitted a support ticket to them, which I’ve done.