TYPO3\CMS\Install\SystemEnvironment\DatabasePlatform\MySqlCheck Class Reference

Inheritance diagram for TYPO3\CMS\Install\SystemEnvironment\DatabasePlatform\MySqlCheck:

Public Member Functions
FlashMessageQueue	getStatus ()

Protected Member Functions
	checkInvalidSqlModes (Connection $connection)
	checkMysqlVersion (Connection $connection)
	checkMysqlDatabaseUtf8Status (Connection $connection)
array	getIncompatibleSqlModes (Connection $connection)

Protected Attributes
FlashMessageQueue	$messageQueue
string	$minimumMySQLVersion = '5.5.0'
array	$incompatibleSqlModes

Detailed Description

Check database configuration status for MySQL server

This class is a hardcoded requirement check for the database server.

The status messages and title must not include HTML, use plain text only. The return values of this class are not bound to HTML and can be used in different scopes (eg. as json array).

This class is only meant to be used within EXT:install and is not part of the TYPO3 Core API.

Definition at line 36 of file MySqlCheck.php.

Member Function Documentation

checkInvalidSqlModes()

TYPO3\CMS\Install\SystemEnvironment\DatabasePlatform\MySqlCheck::checkInvalidSqlModes ( Connection  $connection )

protected

Check if any SQL mode is set which is not compatible with TYPO3

Parameters

Connection

$connection

‪to the database to be checked

Definition at line 82 of file MySqlCheck.php.

References TYPO3\CMS\Core\Messaging\AbstractMessage\ERROR, and TYPO3\CMS\Install\SystemEnvironment\DatabasePlatform\MySqlCheck\getIncompatibleSqlModes().

Referenced by TYPO3\CMS\Install\SystemEnvironment\DatabasePlatform\MySqlCheck\getStatus().

checkMysqlDatabaseUtf8Status()

TYPO3\CMS\Install\SystemEnvironment\DatabasePlatform\MySqlCheck::checkMysqlDatabaseUtf8Status ( Connection  $connection )

protected

Checks the character set of the database and reports an error if it is not utf-8.

Parameters

Connection

$connection

‪to the database to be checked

Definition at line 132 of file MySqlCheck.php.

References TYPO3\CMS\Core\Database\Connection\createQueryBuilder(), TYPO3\CMS\Core\Messaging\AbstractMessage\ERROR, TYPO3\CMS\Core\Database\Query\QueryBuilder\execute(), TYPO3\CMS\Core\Database\Query\QueryBuilder\from(), TYPO3\CMS\Core\Database\Query\QueryBuilder\select(), and TYPO3\CMS\Core\Database\Query\QueryBuilder\where().

Referenced by TYPO3\CMS\Install\SystemEnvironment\DatabasePlatform\MySqlCheck\getStatus().

checkMysqlVersion()

TYPO3\CMS\Install\SystemEnvironment\DatabasePlatform\MySqlCheck::checkMysqlVersion ( Connection  $connection )

protected

Check minimum MySQL version

Parameters

Connection

$connection

‪to the database to be checked

Definition at line 108 of file MySqlCheck.php.

References TYPO3\CMS\Core\Messaging\AbstractMessage\ERROR, and TYPO3\CMS\Core\Database\Connection\getServerVersion().

Referenced by TYPO3\CMS\Install\SystemEnvironment\DatabasePlatform\MySqlCheck\getStatus().

getIncompatibleSqlModes()

array TYPO3\CMS\Install\SystemEnvironment\DatabasePlatform\MySqlCheck::getIncompatibleSqlModes ( Connection  $connection )

protected

Returns an array with the current sql mode settings

Parameters

Connection

$connection

‪to the database to be checked

Returns

‪array Contains all configured SQL modes that are incompatible

Definition at line 168 of file MySqlCheck.php.

Referenced by TYPO3\CMS\Install\SystemEnvironment\DatabasePlatform\MySqlCheck\checkInvalidSqlModes().

getStatus()

FlashMessageQueue TYPO3\CMS\Install\SystemEnvironment\DatabasePlatform\MySqlCheck::getStatus

(

)

Get all status information as array with status objects

Returns

‪FlashMessageQueue

Exceptions

Implements TYPO3\CMS\Install\SystemEnvironment\CheckInterface.

Definition at line 63 of file MySqlCheck.php.

References TYPO3\CMS\Install\SystemEnvironment\DatabasePlatform\MySqlCheck\$messageQueue, TYPO3\CMS\Install\SystemEnvironment\DatabasePlatform\MySqlCheck\checkInvalidSqlModes(), TYPO3\CMS\Install\SystemEnvironment\DatabasePlatform\MySqlCheck\checkMysqlDatabaseUtf8Status(), TYPO3\CMS\Install\SystemEnvironment\DatabasePlatform\MySqlCheck\checkMysqlVersion(), and TYPO3\CMS\Core\Database\ConnectionPool\DEFAULT_CONNECTION_NAME.

Member Data Documentation

$incompatibleSqlModes

array TYPO3\CMS\Install\SystemEnvironment\DatabasePlatform\MySqlCheck::$incompatibleSqlModes

protected

Initial value:

= array( 
        'NO_BACKSLASH_ESCAPES'
     )

List of MySQL modes that are incompatible with TYPO3 CMS

Definition at line 52 of file MySqlCheck.php.

$messageQueue

FlashMessageQueue TYPO3\CMS\Install\SystemEnvironment\DatabasePlatform\MySqlCheck::$messageQueue

protected

Definition at line 40 of file MySqlCheck.php.

Referenced by TYPO3\CMS\Install\SystemEnvironment\DatabasePlatform\MySqlCheck\getStatus().

$minimumMySQLVersion

string TYPO3\CMS\Install\SystemEnvironment\DatabasePlatform\MySqlCheck::$minimumMySQLVersion = '5.5.0'

protected

Minimum supported MySQL version

Definition at line 46 of file MySqlCheck.php.