# System Offline with error DBAL/Driver/Mysqli/MysqliStatement.php:101

**URL:** <https://forum.mautic.org/t/system-offline-with-error-dbal-driver-mysqli-mysqlistatement-php-101/9811>\
**Category:** Product Support\
**Created:** [October 31, 2017, 3:02pm UTC](https://forum.mautic.org/t/system-offline-with-error-dbal-driver-mysqli-mysqlistatement-php-101/9811 "2017-10-31T15:02:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![cynmob](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/cynmob/32/412_2.png) [@cynmob](https://forum.mautic.org/u/cynmob)\
**Post date:** [October 31, 2017, 3:02pm UTC](https://forum.mautic.org/t/system-offline-with-error-dbal-driver-mysqli-mysqlistatement-php-101/9811/1 "2017-10-31T15:02:18Z")

</div>

Run into an error that I’m not sure how I caused and not sure how to fix. (Not a programmer, just a user.)  
  
  
  
New install this week, was working fine, created some emails and landing pages and campaigns. Mautic 2.10.1, siteground hosting, PHP 7  
  
When I checked the install on Softaculous just now, it said, “Hmm, looks like you’re actually runnning Mautic 2.11.0 not 2.10.1. Update records?” I DID try to update Mautic but the update hung up on the fourth step and I eventually just exited the update, figuring it was a display issue. Everything did appear to be okay after that and I was able to create and access evertying.  
  
  
  
Late last night – of course late at night – I broke it.  
  
  
  
I can access my contacts and a few other things, but not my components, emails, Landing pages. When I try to, I get this:  
  
  
  
The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator.  
  
System administrators, check server logs for errors.  
  
  
  
At the time, I was implementing the solution on [https://www.mautic.org/community/index.php/8154-form-is-hang-on-submit-button-after-hit-submit/](https://www.mautic.org/community/index.php/8154-form-is-hang-on-submit-button-after-hit-submit/). I made copies of the file before making changes and restoring those did not work. I was also updating .htaccess files to block a bad bot, but restored the previous .htaccess trying to fix this problem.  
  
  
  
  
  
The error log says this: [2017-10-30 23:13:52] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionInvalidFieldNameException: “An exception occurred while executing ‘SELECT COUNT(_) AS dctrn\_count FROM (SELECT DISTINCT id\_10 FROM (SELECT m0\_.is\_published AS is\_published\_0, m0\_.date\_added AS date\_added\_1, m0\_.created\_by AS created\_by\_2, m0\_.created\_by\_user AS created\_by\_user\_3, m0\_.date\_modified AS date\_modified\_4, m0\_.modified\_by AS modified\_by\_5, m0\_.modified\_by\_user AS modified\_by\_user\_6, m0\_.checked\_out AS checked\_out\_7, m0\_.checked\_out\_by AS checked\_out\_by\_8, m0\_.checked\_out\_by\_user AS checked\_out\_by\_user\_9, m0\_.id AS id\_10, m0\_.title AS title\_11, m0\_.alias AS alias\_12, m0\_.template AS template\_13, m0\_.custom\_html AS custom\_html\_14, m0\_.content AS content\_15, m0\_.publish\_up AS publish\_up\_16, m0\_.publish\_down AS publish\_down\_17, m0\_.hits AS hits\_18, m0\_.unique\_hits AS unique\_hits\_19, m0\_.variant\_hits AS variant\_hits\_20, m0\_.revision AS revision\_21, m0\_.meta\_description AS meta\_description\_22, m0\_.redirect\_type AS redirect\_type\_23, m0\_.redirect\_url AS redirect\_url\_24, m0\_.is\_preference\_center AS is\_preference\_center\_25, m0\_.lang AS lang\_26, m0\_.variant\_settings AS variant\_settings\_27, m0\_.variant\_start\_date AS variant\_start\_date\_28 FROM mauhl\_pages m0\_ LEFT JOIN mauhl\_categories m1\_ ON m0\_.category\_id = m1\_.id WHERE m0\_.variant\_parent\_id IS NULL AND m0\_.translation\_parent\_id IS NULL ORDER BY m0\_.title DESC) dctrn\_result) dctrn\_table’: Unknown column ‘m0\_.is\_preference\_center’ in ‘field list’" at /home/lawyerma/public\_html/cynmobleylaw.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT COUNT(_) AS dctrn\_count FROM (SELECT DISTINCT id\_10 FROM (SELECT m0\_.is\_published AS is\_published\_0, m0\_.date\_added AS date\_added\_1, m0\_.created\_by AS created\_by\_2, m0\_.created\_by\_user AS created\_by\_user\_3, m0\_.date\_modified AS date\_modified\_4, m0\_.modified\_by AS modified\_by\_5, m0\_.modified\_by\_user AS modified\_by\_user\_6, m0\_.checked\_out AS checked\_out\_7, m0\_.checked\_out\_by AS checked\_out\_by\_8, m0\_.checked\_out\_by\_user AS checked\_out\_by\_user\_9, m0\_.id AS id\_10, m0\_.title AS title\_11, m0\_.alias AS alias\_12, m0\_.template AS template\_13, m0\_.custom\_html AS custom\_html\_14, m0\_.content AS content\_15, m0\_.publish\_up AS publish\_up\_16, m0\_.publish\_down AS publish\_down\_17, m0\_.hits AS hits\_18, m0\_.unique\_hits AS unique\_hits\_19, m0\_.variant\_hits AS variant\_hits\_20, m0\_.revision AS revision\_21, m0\_.meta\_description AS meta\_description\_22, m0\_.redirect\_type AS redirect\_type\_23, m0\_.redirect\_url AS redirect\_url\_24, m0\_.is\_preference\_center AS is\_preference\_center\_25, m0\_.lang AS lang\_26, m0\_.variant\_settings AS variant\_settings\_27, m0\_.variant\_start\_date AS variant\_start\_date\_28 FROM mauhl\_pages m0\_ LEFT JOIN mauhl\_categories m1\_ ON m0\_.category\_id = m1\_.id WHERE m0\_.variant\_parent\_id IS NULL AND m0\_.translation\_parent\_id IS NULL ORDER BY m0\_.title DESC) dctrn\_result) dctrn\_table’:nnUnknown column ‘m0\_.is\_preference\_center’ in ‘field list’ at /home/lawyerma/public\_html/cynmobleylaw.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Unknown column ‘m0\_.is\_preference\_center’ in ‘field list’ at /home/lawyerma/public\_html/cynmobleylaw.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:101)”} []  
  
  
  
  
  
The code in question says this:  
  
  
  
public function \_\_construct(mysqli $conn, $prepareString)  
  
{  
  
$this-\>\_conn = $conn;  
  
$this-\>\_stmt = $conn-\>prepare($prepareString);  
  
if (false === $this-\>\_stmt) {  
  
throw new MysqliException($this-\>\_conn-\>error, $this-\>\_conn-\>sqlstate, $this-\>\_conn-\>errno);  
  
}  
  
  
  
$paramCount = $this-\>\_stmt-\>param\_count;  
  
if (0 \< $paramCount) {  
  
$this-\>types = str\_repeat(‘s’, $paramCount);  
  
$this-\>\_bindedValues = array\_fill(1, $paramCount, null);  
  
}  
  
}  
  
  
  
The “throw new MysqliException…” line is 101.  
  
  
  
Could anyone enlighten me? Thank you in advance for any time or advice!  
  
Cyn Mobley

---

<div class="post-metadata">

**Author:** ![cynmob](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/cynmob/32/412_2.png) [@cynmob](https://forum.mautic.org/u/cynmob)\
**Post date:** [October 31, 2017, 3:02pm UTC](https://forum.mautic.org/t/system-offline-with-error-dbal-driver-mysqli-mysqlistatement-php-101/9811/2 "2017-10-31T15:02:18Z")

</div>

Run into an error that I’m not sure how I caused and not sure how to fix. (Not a programmer, just a user.)

New install this week, was working fine, created some emails and landing pages and campaigns. Mautic 2.10.1, siteground hosting, PHP 7  
When I checked the install on Softaculous just now, it said, “Hmm, looks like you’re actually runnning Mautic 2.11.0 not 2.10.1. Update records?” I DID try to update Mautic but the update hung up on the fourth step and I eventually just exited the update, figuring it was a display issue. Everything did appear to be okay after that and I was able to create and access evertying.

Late last night – of course late at night – I broke it.

I can access my contacts and a few other things, but not my components, emails, Landing pages. When I try to, I get this:

The site is currently offline due to encountering an error. If the problem persists, please contact the system administrator.  
System administrators, check server logs for errors.

At the time, I was implementing the solution on [https://www.mautic.org/community/index.php/8154-form-is-hang-on-submit-button-after-hit-submit/](https://www.mautic.org/community/index.php/8154-form-is-hang-on-submit-button-after-hit-submit/). I made copies of the file before making changes and restoring those did not work. I was also updating .htaccess files to block a bad bot, but restored the previous .htaccess trying to fix this problem.

The error log says this: [2017-10-30 23:13:52] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionInvalidFieldNameException: “An exception occurred while executing ‘SELECT COUNT(_) AS dctrn\_count FROM (SELECT DISTINCT id\_10 FROM (SELECT m0\_.is\_published AS is\_published\_0, m0\_.date\_added AS date\_added\_1, m0\_.created\_by AS created\_by\_2, m0\_.created\_by\_user AS created\_by\_user\_3, m0\_.date\_modified AS date\_modified\_4, m0\_.modified\_by AS modified\_by\_5, m0\_.modified\_by\_user AS modified\_by\_user\_6, m0\_.checked\_out AS checked\_out\_7, m0\_.checked\_out\_by AS checked\_out\_by\_8, m0\_.checked\_out\_by\_user AS checked\_out\_by\_user\_9, m0\_.id AS id\_10, m0\_.title AS title\_11, m0\_.alias AS alias\_12, m0\_.template AS template\_13, m0\_.custom\_html AS custom\_html\_14, m0\_.content AS content\_15, m0\_.publish\_up AS publish\_up\_16, m0\_.publish\_down AS publish\_down\_17, m0\_.hits AS hits\_18, m0\_.unique\_hits AS unique\_hits\_19, m0\_.variant\_hits AS variant\_hits\_20, m0\_.revision AS revision\_21, m0\_.meta\_description AS meta\_description\_22, m0\_.redirect\_type AS redirect\_type\_23, m0\_.redirect\_url AS redirect\_url\_24, m0\_.is\_preference\_center AS is\_preference\_center\_25, m0\_.lang AS lang\_26, m0\_.variant\_settings AS variant\_settings\_27, m0\_.variant\_start\_date AS variant\_start\_date\_28 FROM mauhl\_pages m0\_ LEFT JOIN mauhl\_categories m1\_ ON m0\_.category\_id = m1\_.id WHERE m0\_.variant\_parent\_id IS NULL AND m0\_.translation\_parent\_id IS NULL ORDER BY m0\_.title DESC) dctrn\_result) dctrn\_table’: Unknown column ‘m0\_.is\_preference\_center’ in ‘field list’" at /home/lawyerma/public\_html/cynmobleylaw.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {“exception”:"[object] (Doctrine\DBAL\Exception\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT COUNT(_) AS dctrn\_count FROM (SELECT DISTINCT id\_10 FROM (SELECT m0\_.is\_published AS is\_published\_0, m0\_.date\_added AS date\_added\_1, m0\_.created\_by AS created\_by\_2, m0\_.created\_by\_user AS created\_by\_user\_3, m0\_.date\_modified AS date\_modified\_4, m0\_.modified\_by AS modified\_by\_5, m0\_.modified\_by\_user AS modified\_by\_user\_6, m0\_.checked\_out AS checked\_out\_7, m0\_.checked\_out\_by AS checked\_out\_by\_8, m0\_.checked\_out\_by\_user AS checked\_out\_by\_user\_9, m0\_.id AS id\_10, m0\_.title AS title\_11, m0\_.alias AS alias\_12, m0\_.template AS template\_13, m0\_.custom\_html AS custom\_html\_14, m0\_.content AS content\_15, m0\_.publish\_up AS publish\_up\_16, m0\_.publish\_down AS publish\_down\_17, m0\_.hits AS hits\_18, m0\_.unique\_hits AS unique\_hits\_19, m0\_.variant\_hits AS variant\_hits\_20, m0\_.revision AS revision\_21, m0\_.meta\_description AS meta\_description\_22, m0\_.redirect\_type AS redirect\_type\_23, m0\_.redirect\_url AS redirect\_url\_24, m0\_.is\_preference\_center AS is\_preference\_center\_25, m0\_.lang AS lang\_26, m0\_.variant\_settings AS variant\_settings\_27, m0\_.variant\_start\_date AS variant\_start\_date\_28 FROM mauhl\_pages m0\_ LEFT JOIN mauhl\_categories m1\_ ON m0\_.category\_id = m1\_.id WHERE m0\_.variant\_parent\_id IS NULL AND m0\_.translation\_parent\_id IS NULL ORDER BY m0\_.title DESC) dctrn\_result) dctrn\_table’:nnUnknown column ‘m0\_.is\_preference\_center’ in ‘field list’ at /home/lawyerma/public\_html/cynmobleylaw.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Unknown column ‘m0\_.is\_preference\_center’ in ‘field list’ at /home/lawyerma/public\_html/cynmobleylaw.com/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:101)”} []

The code in question says this:

```
public function __construct(mysqli $conn, $prepareString)
{
    $this->_conn = $conn;
    $this->_stmt = $conn->prepare($prepareString);
    if (false === $this->_stmt) {
        throw new MysqliException($this->_conn->error, $this->_conn->sqlstate, $this->_conn->errno);
    }

    $paramCount = $this->_stmt->param_count;
    if (0 < $paramCount) {
        $this->types = str_repeat('s', $paramCount);
        $this->_bindedValues = array_fill(1, $paramCount, null);
    }
}

```

The “throw new MysqliException…” line is 101.

Could anyone enlighten me? Thank you in advance for any time or advice!  
Cyn Mobley

---

<div class="post-metadata">

**Author:** ![cynmob](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/cynmob/32/412_2.png) [@cynmob](https://forum.mautic.org/u/cynmob)\
**Post date:** [October 31, 2017, 5:15pm UTC](https://forum.mautic.org/t/system-offline-with-error-dbal-driver-mysqli-mysqlistatement-php-101/9811/3 "2017-10-31T17:15:34Z")

</div>

Okay, this is very odd. I have not done anything else and suddenly it’s working again. I am missing four emails and an entire campaign, but that I can regenerate pretty easily. I’m thinking that this must have been on siteground’s end of things and they’ve rolled my site back to a slightly earlier backup? It’s about two hours of work lost.