Mautic Community Forums

The site is currently offline due to encountering an error. If the problem persists, please contact

my mautic showing: 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.



my log file showing:



[2017-08-09 19:54:25] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionDriverException: “An exception occurred while executing ‘UPDATE mautc_users SET online_status = ? WHERE last_active <= ?’ with params [“offline”, “2017-08-09 19:39:25”]: Unknown storage engine ‘InnoDB’” at /home/falconem/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘UPDATE mautc_users SET online_status = ? WHERE last_active <= ?’ with params [“offline”, “2017-08-09 19:39:25”]:nnUnknown storage engine ‘InnoDB’ at /home/falconem/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Unknown storage engine ‘InnoDB’ at /home/falconem/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:94)"} []

[2017-08-09 19:54:25] mautic.CRITICAL: Exception thrown when handling an exception (DoctrineDBALExceptionDriverException: An exception occurred while executing ‘UPDATE mautc_users SET online_status = ? WHERE last_active <= ?’ with params [“offline”, “2017-08-09 19:39:25”]: Unknown storage engine ‘InnoDB’ at /home/falconem/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115) {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘UPDATE mautc_users SET online_status = ? WHERE last_active <= ?’ with params [“offline”, “2017-08-09 19:39:25”]:nnUnknown storage engine ‘InnoDB’ at /home/falconem/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Unknown storage engine ‘InnoDB’ at /home/falconem/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:94)"} []

[2017-08-09 19:54:25] mautic.ERROR: DoctrineDBALExceptionDriverException: An exception occurred while executing 'UPDATE mautc_users SET online_status = ? WHERE last_active [] []


<?php
/*
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
* "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
* LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
* A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
* OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
* SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
* LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
* DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
* THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
* OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*
* This software consists of voluntary contributions made by many individuals
* and is licensed under the MIT license. For more information, see
* .
*/

namespace DoctrineDBALDriver;

use DoctrineDBALDBALException;
use DoctrineDBALDriver;
use DoctrineDBALException;
use DoctrineDBALPlatformsMySQL57Platform;
use DoctrineDBALPlatformsMySqlPlatform;
use DoctrineDBALSchemaMySqlSchemaManager;
use DoctrineDBALVersionAwarePlatformDriver;

/**
* Abstract base implementation of the {@link DoctrineDBALDriver} interface for MySQL based drivers.
*
* @author Steve Müller
* @link www.doctrine-project.org
* @since 2.5
*/
abstract class AbstractMySQLDriver implements Driver, ExceptionConverterDriver, VersionAwarePlatformDriver
{
/**
* {@inheritdoc}
*
* @link http://dev.mysql.com/doc/refman/5.7/en/error-messages-client.html
* @link http://dev.mysql.com/doc/refman/5.7/en/error-messages-server.html
*/
public function convertException($message, DriverException $exception)
{
switch ($exception->getErrorCode()) {
case '1050':
return new ExceptionTableExistsException($message, $exception);

case '1051':
case '1146':
return new ExceptionTableNotFoundException($message, $exception);

case '1216':
case '1217':
case '1451':
case '1452':
case '1701':
return new ExceptionForeignKeyConstraintViolationException($message, $exception);

case '1062':
case '1557':
case '1569':
case '1586':
return new ExceptionUniqueConstraintViolationException($message, $exception);

case '1054':
case '1166':
case '1611':
return new ExceptionInvalidFieldNameException($message, $exception);

case '1052':
case '1060':
case '1110':
return new ExceptionNonUniqueFieldNameException($message, $exception);

case '1064':
case '1149':
case '1287':
case '1341':
case '1342':
case '1343':
case '1344':
case '1382':
case '1479':
case '1541':
case '1554':
case '1626':
return new ExceptionSyntaxErrorException($message, $exception);

case '1044':
case '1045':
case '1046':
case '1049':
case '1095':
case '1142':
case '1143':
case '1227':
case '1370':
case '2002':
case '2005':
return new ExceptionConnectionException($message, $exception);

case '1048':
case '1121':
case '1138':
case '1171':
case '1252':
case '1263':
case '1566':
return new ExceptionNotNullConstraintViolationException($message, $exception);
}

return new ExceptionDriverException($message, $exception);
}

/**
* {@inheritdoc}
*/
public function createDatabasePlatformForVersion($version)
{
if ( ! preg_match('/^(?Pd+)(?:.(?Pd+)(?:.(?Pd+))?)?/', $version, $versionParts)) {
throw DBALException::invalidPlatformVersionSpecified(
$version,
'..'
);
}

if (false !== stripos($version, 'mariadb')) {
return $this->getDatabasePlatform();
}

$majorVersion = $versionParts;
$minorVersion = isset($versionParts) ? $versionParts : 0;
$patchVersion = isset($versionParts) ? $versionParts : 0;
$version = $majorVersion . '.' . $minorVersion . '.' . $patchVersion;

if (version_compare($version, '5.7', '>=')) {
return new MySQL57Platform();
}

return $this->getDatabasePlatform();
}

/**
* {@inheritdoc}
*/
public function getDatabase(DoctrineDBALConnection $conn)
{
$params = $conn->getParams();

if (isset($params)) {
return $params;
}

return $conn->query('SELECT DATABASE()')->fetchColumn();
}

/**
* {@inheritdoc}
*/
public function getDatabasePlatform()
{
return new MySqlPlatform();
}

/**
* {@inheritdoc}
*/
public function getSchemaManager(DoctrineDBALConnection $conn)
{
return new MySqlSchemaManager($conn);
}
}

anyone help me to resolve it please ?

my mautic showing: 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.

my log file showing:

[2017-08-09 19:54:25] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionDriverException: “An exception occurred while executing ‘UPDATE mautc_users SET online_status = ? WHERE last_active <= ?’ with params [“offline”, “2017-08-09 19:39:25”]: Unknown storage engine ‘InnoDB’” at /home/falconem/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘UPDATE mautc_users SET online_status = ? WHERE last_active <= ?’ with params [“offline”, “2017-08-09 19:39:25”]:nnUnknown storage engine ‘InnoDB’ at /home/falconem/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Unknown storage engine ‘InnoDB’ at /home/falconem/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:94)"} []
[2017-08-09 19:54:25] mautic.CRITICAL: Exception thrown when handling an exception (DoctrineDBALExceptionDriverException: An exception occurred while executing ‘UPDATE mautc_users SET online_status = ? WHERE last_active <= ?’ with params [“offline”, “2017-08-09 19:39:25”]: Unknown storage engine ‘InnoDB’ at /home/falconem/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115) {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘UPDATE mautc_users SET online_status = ? WHERE last_active <= ?’ with params [“offline”, “2017-08-09 19:39:25”]:nnUnknown storage engine ‘InnoDB’ at /home/falconem/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\Mysqli\MysqliException(code: 0): Unknown storage engine ‘InnoDB’ at /home/falconem/public_html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php:94)"} []
[2017-08-09 19:54:25] mautic.ERROR: DoctrineDBALExceptionDriverException: An exception occurred while executing 'UPDATE mautc_users SET online_status = ? WHERE last_active [] []

<?php /* * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. * * This software consists of voluntary contributions made by many individuals * and is licensed under the MIT license. For more information, see * . */ namespace DoctrineDBALDriver; use DoctrineDBALDBALException; use DoctrineDBALDriver; use DoctrineDBALException; use DoctrineDBALPlatformsMySQL57Platform; use DoctrineDBALPlatformsMySqlPlatform; use DoctrineDBALSchemaMySqlSchemaManager; use DoctrineDBALVersionAwarePlatformDriver; /** * Abstract base implementation of the {@link DoctrineDBALDriver} interface for MySQL based drivers. * * @author Steve Müller * @link www.doctrine-project.org * @since 2.5 */ abstract class AbstractMySQLDriver implements Driver, ExceptionConverterDriver, VersionAwarePlatformDriver { /** * {@inheritdoc} * * @link http://dev.mysql.com/doc/refman/5.7/en/error-messages-client.html * @link http://dev.mysql.com/doc/refman/5.7/en/error-messages-server.html */ public function convertException($message, DriverException $exception) { switch ($exception->getErrorCode()) { case '1050': return new ExceptionTableExistsException($message, $exception); case '1051': case '1146': return new ExceptionTableNotFoundException($message, $exception); case '1216': case '1217': case '1451': case '1452': case '1701': return new ExceptionForeignKeyConstraintViolationException($message, $exception); case '1062': case '1557': case '1569': case '1586': return new ExceptionUniqueConstraintViolationException($message, $exception); case '1054': case '1166': case '1611': return new ExceptionInvalidFieldNameException($message, $exception); case '1052': case '1060': case '1110': return new ExceptionNonUniqueFieldNameException($message, $exception); case '1064': case '1149': case '1287': case '1341': case '1342': case '1343': case '1344': case '1382': case '1479': case '1541': case '1554': case '1626': return new ExceptionSyntaxErrorException($message, $exception); case '1044': case '1045': case '1046': case '1049': case '1095': case '1142': case '1143': case '1227': case '1370': case '2002': case '2005': return new ExceptionConnectionException($message, $exception); case '1048': case '1121': case '1138': case '1171': case '1252': case '1263': case '1566': return new ExceptionNotNullConstraintViolationException($message, $exception); } return new ExceptionDriverException($message, $exception); } /** * {@inheritdoc} */ public function createDatabasePlatformForVersion($version) { if ( ! preg_match('/^(?Pd+)(?:.(?Pd+)(?:.(?Pd+))?)?/', $version, $versionParts)) { throw DBALException::invalidPlatformVersionSpecified( $version, '..' ); } if (false !== stripos($version, 'mariadb')) { return $this->getDatabasePlatform(); } $majorVersion = $versionParts['major']; $minorVersion = isset($versionParts['minor']) ? $versionParts['minor'] : 0; $patchVersion = isset($versionParts['patch']) ? $versionParts['patch'] : 0; $version = $majorVersion . '.' . $minorVersion . '.' . $patchVersion; if (version_compare($version, '5.7', '>=')) { return new MySQL57Platform(); } return $this->getDatabasePlatform(); } /** * {@inheritdoc} */ public function getDatabase(DoctrineDBALConnection $conn) { $params = $conn->getParams(); if (isset($params['dbname'])) { return $params['dbname']; } return $conn->query('SELECT DATABASE()')->fetchColumn(); } /** * {@inheritdoc} */ public function getDatabasePlatform() { return new MySqlPlatform(); } /** * {@inheritdoc} */ public function getSchemaManager(DoctrineDBALConnection $conn) { return new MySqlSchemaManager($conn); } } anyone help me to resolve it please ?