-
Notifications
You must be signed in to change notification settings - Fork 0
/
README
32 lines (30 loc) · 1.02 KB
/
README
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
Drupal 7 hardcode's a specific set of sql_mode options in it's MySQL PDO
driver. Tungsten replicator incorrectly escapes queries using ANSI_QUOTES,
which causes replication to break with D7+MySQL+Tungsten.
This driver offers a work around that removes ANSI_QUOTES from the default
sql_mode. Enable the driver by copying the contents of the mysqltungsten
directory to includes/database/mysqltungsten and switching to the mysqltungsten
database driver in settings.php:
$databases = array (
'default' =>
array (
'default' =>
array (
'database' => '',
'username' => '',
'password' => '',
'host' => '',
'port' => '',
'driver' => 'mysqltungsten',
'prefix' => '',
// The init_commands array allows arbitrary commands be executed for each
// database connection. sql_mode can also be overridden here.
'init_commands' =>
array (
sql_mode => "SET sql_mode='TRADITIONAL'",
other_init_command => "SET SQL_BIG_SELECTS=1",
...
),
),
),
);