karlhunt

FWIW, I had the guy who runs the server that the site is hosted on restart the sql server, that fixed it. I hate the internet, I’m going back to enterprise development land.

I’m kinda working through this, I’m a Java developer so know enough, but probably not enough that I can do it safely 🙂 You know what they say about knowing enough to do damage.

Anyway, checking which engines are available on my SQL server, I see the following. Doesn’t look like InnoDB is available, hence the error, but we haven’t changed anything as far as I am aware, but we did have that hosting outage yesterday. Could that have corrupted it? Can I add InnoDB back in from the mysql command line?

SHOW ENGINES

Sadly, I’m only the guy that gets to try and fix stuff when it goes wrong, so I have a certain amount of access but not full access.

Any pointers now?

Interesting. Looks like there is an issue in the database. We had a hosting issue the other day, I wonder if there is anything that can be done about this?

SQL error

Karl.

### WordPress Environment ###

Home URL: http://www.belvoirtriclub.co.uk
Site URL: http://www.belvoirtriclub.co.uk
WC Version: 2.5.3
Log Directory Writable: ✔  /home/belvoirt/public_html/wp-content/uploads/wc-logs/
WP Version: 4.4.2
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
Language: en_US

### Server Environment ###

Server Info: Apache/2.4.18 (Unix) OpenSSL/1.0.1e-fips mod_bwlimited/1.4
PHP Version: 5.5.31
PHP Post Max Size: 200 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
SUHOSIN Installed: –
MySQL Version: 5.5.48
Max Upload Size: 200 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✕ Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

### Database ###

WC Database Version: 2.5.3
:
woocommerce_sessions: ✔
woocommerce_api_keys: ✔
woocommerce_attribute_taxonomies: ✔
woocommerce_termmeta: ✔
woocommerce_downloadable_product_permissions: ✔
woocommerce_order_items: ✔
woocommerce_order_itemmeta: ✔
woocommerce_tax_rates: ✔
woocommerce_tax_rate_locations: ✔

### Active Plugins (7) ###

Database Browser: by Chris Taylor – 1.2
Disable Comments: by Samir Shah – 1.4
Image Widget: by Modern Tribe
Inc. – 4.2.2

Photo Gallery: by WebDorado – 1.2.89
Users Ultra Pro: by Users Ultra Pro – 1.2.46
WooCommerce: by WooThemes – 2.5.3

### Settings ###

Force SSL: –
Currency: GBP (£)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2

### API ###

API Enabled: ✔
API Version: 3.1.0

### WC Pages ###

Shop Base: #1250 - /shop/
Cart: #1251 - /cart/
Checkout: #1252 - /checkout/
My Account: #1253 - /my-account/

### Taxonomies ###

Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

### Theme ###

Name: Twenty Ten
Version: 2.1
Author URL: https://wordpress.org/
Child Theme: ✕ – If you're modifying WooCommerce on a parent theme you didn't build personally
then we recommend using a child theme. See: How to create a child theme

WooCommerce Support: ✔

### Templates ###

Overrides: –

The category page is blank, even after I try to add a new one, as follows

Categories

The products page references the “missing” categories and although it’s not sortable by that column, if I click one of the categories, it just shows me the products from that category, as follows.

Products

Filtered Products

Karl.