|
|
| (One intermediate revision by one other user not shown) |
| Line 1: |
Line 1: |
| − | | + | #REDIRECT [[System Environment Guide]] |
| − | | |
| − | MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).
| |
| − | | |
| − | A MySQL database is what WHMCS uses to store all of the data your WHMCS system controls.
| |
| − | | |
| − | MySQL is the only supported database engine by WHMCS at this time.
| |
| − | | |
| − | ==PDO==
| |
| − | | |
| − | PHP Data Objects, or PDO for short, is a database access layer that provides a uniform method of access to multiple databases.
| |
| − | | |
| − | <div class="docs-alert-info">As of WHMCS 6.0, PDO became a system requirement for running WHMCS.</div>
| |
| − | | |
| − | In WHMCS 6.0 and later, the PHP environment in which you run WHMCS must support PDO. This requires the loading of two PHP extensions in your PHP environment:
| |
| − | | |
| − | * PDO
| |
| − | * PDO_MYSQL
| |
| − | | |
| − | For more information, please refer to http://php.net/manual/en/ref.pdo-mysql.php
| |
| − | | |
| − | ==Strict SQL Mode==
| |
| − | | |
| − | MySQL Strict Mode controls how MySQL handles invalid or missing values in data-change statements such as INSERT or UPDATE.
| |
| − | | |
| − | <div class="docs-alert-warning">WHMCS requires MySQL strict mode to be turned off in order for it to function.</div>
| |
| − | | |
| − | For more information on SQL Modes, and how to set the SQL Mode for your MySQL environment, please refer to MySQL's official documentation available at the url below.
| |
| − | | |
| − | https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html
| |