Wasn't sure whether to re-open #2468583: system requirements or not, but this seems like a slightly different issue so went for a new one instead.

Basically I followed the install instructions (enable and fix errors on status report), however the page errored out (Error - The website encountered an unexpected error. Please try again later.), watchdog reports the following:

PDOException: SQLSTATE[HY000]: General error: 3167 The 'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is disabled; see the documentation for 'show_compatibility_56': SELECT variable_value IsolationLevel FROM information_schema.session_variables WHERE variable_name = 'tx_isolation' ; Array ( ) in apdqc_requirements() (line 526 of /sites/all/modules/apdqc/apdqc.install).

This is on a pretty much bog standard install of MySQL 5.7.12

CommentFileSizeAuthor
#6 apdqc-2733459-6.patch647 bytesmustanggb

Comments

MustangGB created an issue. See original summary.

mustanggb’s picture

Issue summary: View changes
mustanggb’s picture

Issue summary: View changes
mustanggb’s picture

Issue summary: View changes
mustanggb’s picture

Issue summary: View changes
mustanggb’s picture

Version: 7.x-1.0-rc2 » 7.x-1.x-dev
Status: Active » Needs review
StatusFileSize
new647 bytes

And a patch.

Status: Needs review » Needs work

The last submitted patch, 6: apdqc-2733459-6.patch, failed testing.

nwoodland’s picture

Getting the same error on MySQL 5.7.12. The patch from #6 worked for me. Thanks MustangGB!

mikeytown2’s picture

I use information_schema queries in a couple locations; will need to look over all use cases; also need to make sure this change works with maria db.

  • mikeytown2 committed 01a58d8 on 7.x-1.x authored by MustangGB
    Issue #2733459 by MustangGB: PDOException: SESSION_VARIABLES is disabled
    
mikeytown2’s picture

Status: Needs work » Fixed

#6 looks good with mariadb 10.1. Thanks! It's been committed.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.