Install: "DB Error: unknown error" / "Specified key was too long; max key length is 1000 bytes"
Was trying to install on a MySQL 5.5 + PHP 5.5 cpanel (ramhost shared plan)
happens both on master and 1.2.x
object(PEAR_Exception)#9 (9) {
["cause":protected]=>
NULL
["_trace":"PEAR_Exception":private]=>
NULL
["message":protected]=>
string(23) "DB Error: unknown error"
["string":"Exception":private]=>
string(0) ""
["code":protected]=>
int(-1)
["file":protected]=>
string(63) "/home/michael/gnu-social//lib/framework.php"
["line":protected]=>
int(187)
["trace":"Exception":private]=>
array(8) {
[0]=>
array(4) {
["file"]=>
string(60) "/home/michael/gnu-social//lib/schema.php"
["line"]=>
int(539)
["function"]=>
string(26) "PEAR_ErrorToPEAR_Exception"
["args"]=>
array(1) {
[0]=>
object(DB_Error)#8 (8) {
["error_message_prefix"]=>
string(0) ""
["mode"]=>
int(1)
["level"]=>
int(1024)
["code"]=>
int(-1)
["message"]=>
string(23) "DB Error: unknown error"
["userinfo"]=>
string(591) "CREATE TABLE profile_prefs (
profile_id int not null comment 'user',
namespace varchar(191) not null comment 'namespace, like pluginname or category',
topic varchar(191) not null comment 'preference key, i.e. description, age...',
data blob comment 'topic data, may be anything',
created datetime not null comment 'date this record was created',
modified timestamp not null comment 'date this record was modified',
PRIMARY KEY (profile_id,namespace,topic)
) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_bin [nativecode=1071 ** Specified key was too long; max key length is 1000 bytes]"
["backtrace"]=>
array(14) {
[0]=>
array(6) {
["file"]=>
string(59) "/home/michael/gnu-social//extlib/DB.php"
["line"]=>
int(967)
["function"]=>
string(10) "PEAR_Error"
["class"]=>
string(10) "PEAR_Error"
["type"]=>
string(2) "->"
["args"]=>
array(5) {
[0]=>
string(23) "DB Error: unknown error"
[1]=>
int(-1)
[2]=>
int(1)
[3]=>
int(1024)
[4]=>
string(591) "CREATE TABLE profile_prefs (
profile_id int not null comment 'user',
namespace varchar(191) not null comment 'namespace, like pluginname or category',
topic varchar(191) not null comment 'preference key, i.e. description, age...',
data blob comment 'topic data, may be anything',
created datetime not null comment 'date this record was created',
modified timestamp not null comment 'date this record was modified',
PRIMARY KEY (profile_id,namespace,topic)
) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_bin [nativecode=1071 ** Specified key was too long; max key length is 1000 bytes]"
}
}
[1]=>
array(7) {
["file"]=>
string(21) "/usr/lib/php/PEAR.php"
["line"]=>
int(531)
["function"]=>
string(8) "DB_Error"
["class"]=>
string(8) "DB_Error"
["object"]=>
*RECURSION*
["type"]=>
string(2) "->"
["args"]=>
array(4) {
[0]=>
int(-1)
[1]=>
int(1)
[2]=>
int(1024)
[3]=>
string(591) "CREATE TABLE profile_prefs (
profile_id int not null comment 'user',
namespace varchar(191) not null comment 'namespace, like pluginname or category',
topic varchar(191) not null comment 'preference key, i.e. description, age...',
data blob comment 'topic data, may be anything',
created datetime not null comment 'date this record was created',
modified timestamp not null comment 'date this record was modified',
PRIMARY KEY (profile_id,namespace,topic)
) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_bin [nativecode=1071 ** Specified key was too long; max key length is 1000 bytes]"
}
}
[2]=>
array(7) {
["file"]=>
string(66) "/home/michael/gnu-social//extlib/DB/common.php"
["line"]=>
int(1907)
["function"]=>
string(10) "raiseError"
["class"]=>
string(4) "PEAR"
["object"]=>
object(DB_mysqli)#5 (28) {
["phptype"]=>
string(6) "mysqli"
["dbsyntax"]=>
string(6) "mysqli"
["features"]=>
array(7) {
["limit"]=>
string(5) "alter"
["new_link"]=>
bool(false)
["numrows"]=>
bool(true)
["pconnect"]=>
bool(false)
["prepare"]=>
bool(false)
["ssl"]=>
bool(true)
["transactions"]=>
bool(true)
}
["errorcode_map"]=>
array(26) {
[1004]=>
int(-15)
[1005]=>
int(-15)
[1006]=>
int(-15)
[1007]=>
int(-5)
[1008]=>
int(-17)
[1022]=>
int(-5)
[1044]=>
int(-26)
[1046]=>
int(-14)
[1048]=>
int(-3)
[1049]=>
int(-27)
[1050]=>
int(-5)
[1051]=>
int(-18)
[1054]=>
int(-19)
[1061]=>
int(-5)
[1062]=>
int(-5)
[1064]=>
int(-2)
[1091]=>
int(-4)
[1100]=>
int(-21)
[1136]=>
int(-22)
[1142]=>
int(-26)
[1146]=>
int(-18)
[1216]=>
int(-3)
[1217]=>
int(-3)
[1356]=>
int(-13)
[1451]=>
int(-3)
[1452]=>
int(-3)
}
["connection"]=>
object(mysqli)#6 (19) {
["affected_rows"]=>
int(-1)
["client_info"]=>
string(6) "5.5.45"
["client_version"]=>
int(50545)
["connect_errno"]=>
int(0)
["connect_error"]=>
NULL
["errno"]=>
int(1071)
["error"]=>
string(56) "Specified key was too long; max key length is 1000 bytes"
["error_list"]=>
array(1) {
[0]=>
array(3) {
["errno"]=>
int(1071)
["sqlstate"]=>
string(5) "42000"
["error"]=>
string(56) "Specified key was too long; max key length is 1000 bytes"
}
}
["field_count"]=>
int(19)
["host_info"]=>
string(25) "Localhost via UNIX socket"
["info"]=>
NULL
["insert_id"]=>
int(0)
["server_info"]=>
string(14) "5.5.45-cll-lve"
["server_version"]=>
int(50545)
["stat"]=>
string(155) "Uptime: 1143263 Threads: 13 Questions: 318899103 Slow queries: 10062 Opens: 32195 Flush tables: 1 Open tables: 10240 Queries per second avg: 278.937"
["sqlstate"]=>
string(5) "00000"
["protocol_version"]=>
int(10)
["thread_id"]=>
int(4717607)
["warning_count"]=>
int(0)
}
["dsn"]=>
array(9) {
["phptype"]=>
string(6) "mysqli"
["dbsyntax"]=>
string(6) "mysqli"
["username"]=>
string(16) "my_db_user"
["password"]=>
string(18) "password"
["protocol"]=>
string(3) "tcp"
["hostspec"]=>
string(9) "localhost"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["database"]=>
string(20) "my_db_name"
}
["autocommit"]=>
bool(true)
["transaction_opcount"]=>
int(0)
["_db"]=>
string(20) "my_db_name"
["mysqli_flags"]=>
array(11) {
[1]=>
string(8) "not_null"
[2]=>
string(11) "primary_key"
[4]=>
string(10) "unique_key"
[8]=>
string(12) "multiple_key"
[16]=>
string(4) "blob"
[32]=>
string(8) "unsigned"
[64]=>
string(8) "zerofill"
[512]=>
string(14) "auto_increment"
[1024]=>
string(9) "timestamp"
[2048]=>
string(3) "set"
[32768]=>
string(8) "group_by"
}
["mysqli_types"]=>
array(25) {
[0]=>
string(7) "decimal"
[1]=>
string(7) "tinyint"
[2]=>
string(3) "int"
[3]=>
string(3) "int"
[4]=>
string(5) "float"
[5]=>
string(6) "double"
[7]=>
string(9) "timestamp"
[8]=>
string(6) "bigint"
[9]=>
string(9) "mediumint"
[10]=>
string(4) "date"
[11]=>
string(4) "time"
[12]=>
string(8) "datetime"
[13]=>
string(4) "year"
[14]=>
string(4) "date"
[247]=>
string(4) "enum"
[248]=>
string(3) "set"
[249]=>
string(8) "tinyblob"
[250]=>
string(10) "mediumblob"
[251]=>
string(8) "longblob"
[252]=>
string(4) "blob"
[253]=>
string(7) "varchar"
[254]=>
string(4) "char"
[255]=>
string(8) "geometry"
[16]=>
string(3) "bit"
[246]=>
string(7) "decimal"
}
["fetchmode"]=>
int(1)
["fetchmode_object_class"]=>
string(8) "stdClass"
["was_connected"]=>
NULL
["last_query"]=>
string(513) "CREATE TABLE profile_prefs (
profile_id int not null comment 'user',
namespace varchar(191) not null comment 'namespace, like pluginname or category',
topic varchar(191) not null comment 'preference key, i.e. description, age...',
data blob comment 'topic data, may be anything',
created datetime not null comment 'date this record was created',
modified timestamp not null comment 'date this record was modified',
PRIMARY KEY (profile_id,namespace,topic)
) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_bin"
["options"]=>
array(8) {
["result_buffering"]=>
int(500)
["persistent"]=>
bool(false)
["ssl"]=>
bool(false)
["debug"]=>
int(0)
["seqname_format"]=>
string(6) "%s_seq"
["autofree"]=>
bool(false)
["portability"]=>
int(0)
["optimize"]=>
string(11) "performance"
}
["last_parameters"]=>
array(0) {
}
["prepare_tokens"]=>
array(0) {
}
["prepare_types"]=>
array(0) {
}
["prepared_queries"]=>
array(0) {
}
["_last_query_manip"]=>
bool(true)
["_next_query_manip"]=>
bool(false)
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(8) "DB_Error"
["_expected_errors"]=>
array(0) {
}
}
["type"]=>
string(2) "->"
["args"]=>
array(7) {
[0]=>
NULL
[1]=>
int(-1)
[2]=>
NULL
[3]=>
NULL
[4]=>
string(591) "CREATE TABLE profile_prefs (
profile_id int not null comment 'user',
namespace varchar(191) not null comment 'namespace, like pluginname or category',
topic varchar(191) not null comment 'preference key, i.e. description, age...',
data blob comment 'topic data, may be anything',
created datetime not null comment 'date this record was created',
modified timestamp not null comment 'date this record was modified',
PRIMARY KEY (profile_id,namespace,topic)
) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_bin [nativecode=1071 ** Specified key was too long; max key length is 1000 bytes]"
[5]=>
string(8) "DB_Error"
[6]=>
bool(true)
}
}
[3]=>
array(7) {
["file"]=>
string(66) "/home/michael/gnu-social//extlib/DB/mysqli.php"
["line"]=>
int(928)
["function"]=>
string(10) "raiseError"
["class"]=>
string(9) "DB_common"
["object"]=>
object(DB_mysqli)#5 (28) {
["phptype"]=>
string(6) "mysqli"
["dbsyntax"]=>
string(6) "mysqli"
["features"]=>
array(7) {
["limit"]=>
string(5) "alter"
["new_link"]=>
bool(false)
["numrows"]=>
bool(true)
["pconnect"]=>
bool(false)
["prepare"]=>
bool(false)
["ssl"]=>
bool(true)
["transactions"]=>
bool(true)
}
["errorcode_map"]=>
array(26) {
[1004]=>
int(-15)
[1005]=>
int(-15)
[1006]=>
int(-15)
[1007]=>
int(-5)
[1008]=>
int(-17)
[1022]=>
int(-5)
[1044]=>
int(-26)
[1046]=>
int(-14)
[1048]=>
int(-3)
[1049]=>
int(-27)
[1050]=>
int(-5)
[1051]=>
int(-18)
[1054]=>
int(-19)
[1061]=>
int(-5)
[1062]=>
int(-5)
[1064]=>
int(-2)
[1091]=>
int(-4)
[1100]=>
int(-21)
[1136]=>
int(-22)
[1142]=>
int(-26)
[1146]=>
int(-18)
[1216]=>
int(-3)
[1217]=>
int(-3)
[1356]=>
int(-13)
[1451]=>
int(-3)
[1452]=>
int(-3)
}
["connection"]=>
object(mysqli)#6 (19) {
["affected_rows"]=>
int(-1)
["client_info"]=>
string(6) "5.5.45"
["client_version"]=>
int(50545)
["connect_errno"]=>
int(0)
["connect_error"]=>
NULL
["errno"]=>
int(0)
["error"]=>
string(0) ""
["error_list"]=>
array(0) {
}
["field_count"]=>
int(19)
["host_info"]=>
string(25) "Localhost via UNIX socket"
["info"]=>
NULL
["insert_id"]=>
int(0)
["server_info"]=>
string(14) "5.5.45-cll-lve"
["server_version"]=>
int(50545)
["stat"]=>
string(155) "Uptime: 1143263 Threads: 13 Questions: 318899104 Slow queries: 10062 Opens: 32195 Flush tables: 1 Open tables: 10240 Queries per second avg: 278.937"
["sqlstate"]=>
string(5) "00000"
["protocol_version"]=>
int(10)
["thread_id"]=>
int(4717607)
["warning_count"]=>
int(0)
}
["dsn"]=>
array(9) {
["phptype"]=>
string(6) "mysqli"
["dbsyntax"]=>
string(6) "mysqli"
["username"]=>
string(16) "my_db_user"
["password"]=>
string(18) "password"
["protocol"]=>
string(3) "tcp"
["hostspec"]=>
string(9) "localhost"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["database"]=>
string(20) "my_db_name"
}
["autocommit"]=>
bool(true)
["transaction_opcount"]=>
int(0)
["_db"]=>
string(20) "my_db_name"
["mysqli_flags"]=>
array(11) {
[1]=>
string(8) "not_null"
[2]=>
string(11) "primary_key"
[4]=>
string(10) "unique_key"
[8]=>
string(12) "multiple_key"
[16]=>
string(4) "blob"
[32]=>
string(8) "unsigned"
[64]=>
string(8) "zerofill"
[512]=>
string(14) "auto_increment"
[1024]=>
string(9) "timestamp"
[2048]=>
string(3) "set"
[32768]=>
string(8) "group_by"
}
["mysqli_types"]=>
array(25) {
[0]=>
string(7) "decimal"
[1]=>
string(7) "tinyint"
[2]=>
string(3) "int"
[3]=>
string(3) "int"
[4]=>
string(5) "float"
[5]=>
string(6) "double"
[7]=>
string(9) "timestamp"
[8]=>
string(6) "bigint"
[9]=>
string(9) "mediumint"
[10]=>
string(4) "date"
[11]=>
string(4) "time"
[12]=>
string(8) "datetime"
[13]=>
string(4) "year"
[14]=>
string(4) "date"
[247]=>
string(4) "enum"
[248]=>
string(3) "set"
[249]=>
string(8) "tinyblob"
[250]=>
string(10) "mediumblob"
[251]=>
string(8) "longblob"
[252]=>
string(4) "blob"
[253]=>
string(7) "varchar"
[254]=>
string(4) "char"
[255]=>
string(8) "geometry"
[16]=>
string(3) "bit"
[246]=>
string(7) "decimal"
}
["fetchmode"]=>
int(1)
["fetchmode_object_class"]=>
string(8) "stdClass"
["was_connected"]=>
NULL
["last_query"]=>
string(513) "CREATE TABLE profile_prefs (
profile_id int not null comment 'user',
namespace varchar(191) not null comment 'namespace, like pluginname or category',
topic varchar(191) not null comment 'preference key, i.e. description, age...',
data blob comment 'topic data, may be anything',
created datetime not null comment 'date this record was created',
modified timestamp not null comment 'date this record was modified',
PRIMARY KEY (profile_id,namespace,topic)
) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_bin"
["options"]=>
array(8) {
["result_buffering"]=>
int(500)
["persistent"]=>
bool(false)
["ssl"]=>
bool(false)
["debug"]=>
int(0)
["seqname_format"]=>
string(6) "%s_seq"
["autofree"]=>
bool(false)
["portability"]=>
int(0)
["optimize"]=>
string(11) "performance"
}
["last_parameters"]=>
array(0) {
}
["prepare_tokens"]=>
array(0) {
}
["prepare_types"]=>
array(0) {
}
["prepared_queries"]=>
array(0) {
}
["_last_query_manip"]=>
bool(true)
["_next_query_manip"]=>
bool(false)
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(8) "DB_Error"
["_expected_errors"]=>
array(0) {
}
}
["type"]=>
string(2) "->"
["args"]=>
array(5) {
[0]=>
int(-1)
[1]=>
NULL
[2]=>
NULL
[3]=>
NULL
[4]=>
string(64) "1071 ** Specified key was too long; max key length is 1000 bytes"
}
}
[4]=>
array(7) {
["file"]=>
string(66) "/home/michael/gnu-social//extlib/DB/mysqli.php"
["line"]=>
int(402)
["function"]=>
string(16) "mysqliRaiseError"
["class"]=>
string(9) "DB_mysqli"
["object"]=>
object(DB_mysqli)#5 (28) {
["phptype"]=>
string(6) "mysqli"
["dbsyntax"]=>
string(6) "mysqli"
["features"]=>
array(7) {
["limit"]=>
string(5) "alter"
["new_link"]=>
bool(false)
["numrows"]=>
bool(true)
["pconnect"]=>
bool(false)
["prepare"]=>
bool(false)
["ssl"]=>
bool(true)
["transactions"]=>
bool(true)
}
["errorcode_map"]=>
array(26) {
[1004]=>
int(-15)
[1005]=>
int(-15)
[1006]=>
int(-15)
[1007]=>
int(-5)
[1008]=>
int(-17)
[1022]=>
int(-5)
[1044]=>
int(-26)
[1046]=>
int(-14)
[1048]=>
int(-3)
[1049]=>
int(-27)
[1050]=>
int(-5)
[1051]=>
int(-18)
[1054]=>
int(-19)
[1061]=>
int(-5)
[1062]=>
int(-5)
[1064]=>
int(-2)
[1091]=>
int(-4)
[1100]=>
int(-21)
[1136]=>
int(-22)
[1142]=>
int(-26)
[1146]=>
int(-18)
[1216]=>
int(-3)
[1217]=>
int(-3)
[1356]=>
int(-13)
[1451]=>
int(-3)
[1452]=>
int(-3)
}
["connection"]=>
object(mysqli)#6 (19) {
["affected_rows"]=>
int(-1)
["client_info"]=>
string(6) "5.5.45"
["client_version"]=>
int(50545)
["connect_errno"]=>
int(0)
["connect_error"]=>
NULL
["errno"]=>
int(0)
["error"]=>
string(0) ""
["error_list"]=>
array(0) {
}
["field_count"]=>
int(19)
["host_info"]=>
string(25) "Localhost via UNIX socket"
["info"]=>
NULL
["insert_id"]=>
int(0)
["server_info"]=>
string(14) "5.5.45-cll-lve"
["server_version"]=>
int(50545)
["stat"]=>
string(155) "Uptime: 1143263 Threads: 13 Questions: 318899105 Slow queries: 10062 Opens: 32195 Flush tables: 1 Open tables: 10240 Queries per second avg: 278.937"
["sqlstate"]=>
string(5) "00000"
["protocol_version"]=>
int(10)
["thread_id"]=>
int(4717607)
["warning_count"]=>
int(0)
}
["dsn"]=>
array(9) {
["phptype"]=>
string(6) "mysqli"
["dbsyntax"]=>
string(6) "mysqli"
["username"]=>
string(16) "my_db_user"
["password"]=>
string(18) "password"
["protocol"]=>
string(3) "tcp"
["hostspec"]=>
string(9) "localhost"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["database"]=>
string(20) "my_db_name"
}
["autocommit"]=>
bool(true)
["transaction_opcount"]=>
int(0)
["_db"]=>
string(20) "my_db_name"
["mysqli_flags"]=>
array(11) {
[1]=>
string(8) "not_null"
[2]=>
string(11) "primary_key"
[4]=>
string(10) "unique_key"
[8]=>
string(12) "multiple_key"
[16]=>
string(4) "blob"
[32]=>
string(8) "unsigned"
[64]=>
string(8) "zerofill"
[512]=>
string(14) "auto_increment"
[1024]=>
string(9) "timestamp"
[2048]=>
string(3) "set"
[32768]=>
string(8) "group_by"
}
["mysqli_types"]=>
array(25) {
[0]=>
string(7) "decimal"
[1]=>
string(7) "tinyint"
[2]=>
string(3) "int"
[3]=>
string(3) "int"
[4]=>
string(5) "float"
[5]=>
string(6) "double"
[7]=>
string(9) "timestamp"
[8]=>
string(6) "bigint"
[9]=>
string(9) "mediumint"
[10]=>
string(4) "date"
[11]=>
string(4) "time"
[12]=>
string(8) "datetime"
[13]=>
string(4) "year"
[14]=>
string(4) "date"
[247]=>
string(4) "enum"
[248]=>
string(3) "set"
[249]=>
string(8) "tinyblob"
[250]=>
string(10) "mediumblob"
[251]=>
string(8) "longblob"
[252]=>
string(4) "blob"
[253]=>
string(7) "varchar"
[254]=>
string(4) "char"
[255]=>
string(8) "geometry"
[16]=>
string(3) "bit"
[246]=>
string(7) "decimal"
}
["fetchmode"]=>
int(1)
["fetchmode_object_class"]=>
string(8) "stdClass"
["was_connected"]=>
NULL
["last_query"]=>
string(513) "CREATE TABLE profile_prefs (
profile_id int not null comment 'user',
namespace varchar(191) not null comment 'namespace, like pluginname or category',
topic varchar(191) not null comment 'preference key, i.e. description, age...',
data blob comment 'topic data, may be anything',
created datetime not null comment 'date this record was created',
modified timestamp not null comment 'date this record was modified',
PRIMARY KEY (profile_id,namespace,topic)
) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_bin"
["options"]=>
array(8) {
["result_buffering"]=>
int(500)
["persistent"]=>
bool(false)
["ssl"]=>
bool(false)
["debug"]=>
int(0)
["seqname_format"]=>
string(6) "%s_seq"
["autofree"]=>
bool(false)
["portability"]=>
int(0)
["optimize"]=>
string(11) "performance"
}
["last_parameters"]=>
array(0) {
}
["prepare_tokens"]=>
array(0) {
}
["prepare_types"]=>
array(0) {
}
["prepared_queries"]=>
array(0) {
}
["_last_query_manip"]=>
bool(true)
["_next_query_manip"]=>
bool(false)
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(8) "DB_Error"
["_expected_errors"]=>
array(0) {
}
}
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
[5]=>
array(7) {
["file"]=>
string(66) "/home/michael/gnu-social//extlib/DB/common.php"
["line"]=>
int(1215)
["function"]=>
string(11) "simpleQuery"
["class"]=>
string(9) "DB_mysqli"
["object"]=>
object(DB_mysqli)#5 (28) {
["phptype"]=>
string(6) "mysqli"
["dbsyntax"]=>
string(6) "mysqli"
["features"]=>
array(7) {
["limit"]=>
string(5) "alter"
["new_link"]=>
bool(false)
["numrows"]=>
bool(true)
["pconnect"]=>
bool(false)
["prepare"]=>
bool(false)
["ssl"]=>
bool(true)
["transactions"]=>
bool(true)
}
["errorcode_map"]=>
array(26) {
[1004]=>
int(-15)
[1005]=>
int(-15)
[1006]=>
int(-15)
[1007]=>
int(-5)
[1008]=>
int(-17)
[1022]=>
int(-5)
[1044]=>
int(-26)
[1046]=>
int(-14)
[1048]=>
int(-3)
[1049]=>
int(-27)
[1050]=>
int(-5)
[1051]=>
int(-18)
[1054]=>
int(-19)
[1061]=>
int(-5)
[1062]=>
int(-5)
[1064]=>
int(-2)
[1091]=>
int(-4)
[1100]=>
int(-21)
[1136]=>
int(-22)
[1142]=>
int(-26)
[1146]=>
int(-18)
[1216]=>
int(-3)
[1217]=>
int(-3)
[1356]=>
int(-13)
[1451]=>
int(-3)
[1452]=>
int(-3)
}
["connection"]=>
object(mysqli)#6 (19) {
["affected_rows"]=>
int(-1)
["client_info"]=>
string(6) "5.5.45"
["client_version"]=>
int(50545)
["connect_errno"]=>
int(0)
["connect_error"]=>
NULL
["errno"]=>
int(0)
["error"]=>
string(0) ""
["error_list"]=>
array(0) {
}
["field_count"]=>
int(19)
["host_info"]=>
string(25) "Localhost via UNIX socket"
["info"]=>
NULL
["insert_id"]=>
int(0)
["server_info"]=>
string(14) "5.5.45-cll-lve"
["server_version"]=>
int(50545)
["stat"]=>
string(155) "Uptime: 1143263 Threads: 13 Questions: 318899107 Slow queries: 10062 Opens: 32195 Flush tables: 1 Open tables: 10240 Queries per second avg: 278.937"
["sqlstate"]=>
string(5) "00000"
["protocol_version"]=>
int(10)
["thread_id"]=>
int(4717607)
["warning_count"]=>
int(0)
}
["dsn"]=>
array(9) {
["phptype"]=>
string(6) "mysqli"
["dbsyntax"]=>
string(6) "mysqli"
["username"]=>
string(16) "my_db_user"
["password"]=>
string(18) "password"
["protocol"]=>
string(3) "tcp"
["hostspec"]=>
string(9) "localhost"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["database"]=>
string(20) "my_db_name"
}
["autocommit"]=>
bool(true)
["transaction_opcount"]=>
int(0)
["_db"]=>
string(20) "my_db_name"
["mysqli_flags"]=>
array(11) {
[1]=>
string(8) "not_null"
[2]=>
string(11) "primary_key"
[4]=>
string(10) "unique_key"
[8]=>
string(12) "multiple_key"
[16]=>
string(4) "blob"
[32]=>
string(8) "unsigned"
[64]=>
string(8) "zerofill"
[512]=>
string(14) "auto_increment"
[1024]=>
string(9) "timestamp"
[2048]=>
string(3) "set"
[32768]=>
string(8) "group_by"
}
["mysqli_types"]=>
array(25) {
[0]=>
string(7) "decimal"
[1]=>
string(7) "tinyint"
[2]=>
string(3) "int"
[3]=>
string(3) "int"
[4]=>
string(5) "float"
[5]=>
string(6) "double"
[7]=>
string(9) "timestamp"
[8]=>
string(6) "bigint"
[9]=>
string(9) "mediumint"
[10]=>
string(4) "date"
[11]=>
string(4) "time"
[12]=>
string(8) "datetime"
[13]=>
string(4) "year"
[14]=>
string(4) "date"
[247]=>
string(4) "enum"
[248]=>
string(3) "set"
[249]=>
string(8) "tinyblob"
[250]=>
string(10) "mediumblob"
[251]=>
string(8) "longblob"
[252]=>
string(4) "blob"
[253]=>
string(7) "varchar"
[254]=>
string(4) "char"
[255]=>
string(8) "geometry"
[16]=>
string(3) "bit"
[246]=>
string(7) "decimal"
}
["fetchmode"]=>
int(1)
["fetchmode_object_class"]=>
string(8) "stdClass"
["was_connected"]=>
NULL
["last_query"]=>
string(513) "CREATE TABLE profile_prefs (
profile_id int not null comment 'user',
namespace varchar(191) not null comment 'namespace, like pluginname or category',
topic varchar(191) not null comment 'preference key, i.e. description, age...',
data blob comment 'topic data, may be anything',
created datetime not null comment 'date this record was created',
modified timestamp not null comment 'date this record was modified',
PRIMARY KEY (profile_id,namespace,topic)
) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_bin"
["options"]=>
array(8) {
["result_buffering"]=>
int(500)
["persistent"]=>
bool(false)
["ssl"]=>
bool(false)
["debug"]=>
int(0)
["seqname_format"]=>
string(6) "%s_seq"
["autofree"]=>
bool(false)
["portability"]=>
int(0)
["optimize"]=>
string(11) "performance"
}
["last_parameters"]=>
array(0) {
}
["prepare_tokens"]=>
array(0) {
}
["prepare_types"]=>
array(0) {
}
["prepared_queries"]=>
array(0) {
}
["_last_query_manip"]=>
bool(true)
["_next_query_manip"]=>
bool(false)
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(8) "DB_Error"
["_expected_errors"]=>
array(0) {
}
}
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(513) "CREATE TABLE profile_prefs (
profile_id int not null comment 'user',
namespace varchar(191) not null comment 'namespace, like pluginname or category',
topic varchar(191) not null comment 'preference key, i.e. description, age...',
data blob comment 'topic data, may be anything',
created datetime not null comment 'date this record was created',
modified timestamp not null comment 'date this record was modified',
PRIMARY KEY (profile_id,namespace,topic)
) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_bin"
}
}
[6]=>
array(7) {
["file"]=>
string(60) "/home/michael/gnu-social//lib/schema.php"
["line"]=>
int(535)
["function"]=>
string(5) "query"
["class"]=>
string(9) "DB_common"
["object"]=>
object(DB_mysqli)#5 (28) {
["phptype"]=>
string(6) "mysqli"
["dbsyntax"]=>
string(6) "mysqli"
["features"]=>
array(7) {
["limit"]=>
string(5) "alter"
["new_link"]=>
bool(false)
["numrows"]=>
bool(true)
["pconnect"]=>
bool(false)
["prepare"]=>
bool(false)
["ssl"]=>
bool(true)
["transactions"]=>
bool(true)
}
["errorcode_map"]=>
array(26) {
[1004]=>
int(-15)
[1005]=>
int(-15)
[1006]=>
int(-15)
[1007]=>
int(-5)
[1008]=>
int(-17)
[1022]=>
int(-5)
[1044]=>
int(-26)
[1046]=>
int(-14)
[1048]=>
int(-3)
[1049]=>
int(-27)
[1050]=>
int(-5)
[1051]=>
int(-18)
[1054]=>
int(-19)
[1061]=>
int(-5)
[1062]=>
int(-5)
[1064]=>
int(-2)
[1091]=>
int(-4)
[1100]=>
int(-21)
[1136]=>
int(-22)
[1142]=>
int(-26)
[1146]=>
int(-18)
[1216]=>
int(-3)
[1217]=>
int(-3)
[1356]=>
int(-13)
[1451]=>
int(-3)
[1452]=>
int(-3)
}
["connection"]=>
object(mysqli)#6 (19) {
["affected_rows"]=>
int(-1)
["client_info"]=>
string(6) "5.5.45"
["client_version"]=>
int(50545)
["connect_errno"]=>
int(0)
["connect_error"]=>
NULL
["errno"]=>
int(0)
["error"]=>
string(0) ""
["error_list"]=>
array(0) {
}
["field_count"]=>
int(19)
["host_info"]=>
string(25) "Localhost via UNIX socket"
["info"]=>
NULL
["insert_id"]=>
int(0)
["server_info"]=>
string(14) "5.5.45-cll-lve"
["server_version"]=>
int(50545)
["stat"]=>
string(155) "Uptime: 1143263 Threads: 13 Questions: 318899108 Slow queries: 10062 Opens: 32195 Flush tables: 1 Open tables: 10240 Queries per second avg: 278.937"
["sqlstate"]=>
string(5) "00000"
["protocol_version"]=>
int(10)
["thread_id"]=>
int(4717607)
["warning_count"]=>
int(0)
}
["dsn"]=>
array(9) {
["phptype"]=>
string(6) "mysqli"
["dbsyntax"]=>
string(6) "mysqli"
["username"]=>
string(16) "my_db_user"
["password"]=>
string(18) "password"
["protocol"]=>
string(3) "tcp"
["hostspec"]=>
string(9) "localhost"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["database"]=>
string(20) "my_db_name"
}
["autocommit"]=>
bool(true)
["transaction_opcount"]=>
int(0)
["_db"]=>
string(20) "my_db_name"
["mysqli_flags"]=>
array(11) {
[1]=>
string(8) "not_null"
[2]=>
string(11) "primary_key"
[4]=>
string(10) "unique_key"
[8]=>
string(12) "multiple_key"
[16]=>
string(4) "blob"
[32]=>
string(8) "unsigned"
[64]=>
string(8) "zerofill"
[512]=>
string(14) "auto_increment"
[1024]=>
string(9) "timestamp"
[2048]=>
string(3) "set"
[32768]=>
string(8) "group_by"
}
["mysqli_types"]=>
array(25) {
[0]=>
string(7) "decimal"
[1]=>
string(7) "tinyint"
[2]=>
string(3) "int"
[3]=>
string(3) "int"
[4]=>
string(5) "float"
[5]=>
string(6) "double"
[7]=>
string(9) "timestamp"
[8]=>
string(6) "bigint"
[9]=>
string(9) "mediumint"
[10]=>
string(4) "date"
[11]=>
string(4) "time"
[12]=>
string(8) "datetime"
[13]=>
string(4) "year"
[14]=>
string(4) "date"
[247]=>
string(4) "enum"
[248]=>
string(3) "set"
[249]=>
string(8) "tinyblob"
[250]=>
string(10) "mediumblob"
[251]=>
string(8) "longblob"
[252]=>
string(4) "blob"
[253]=>
string(7) "varchar"
[254]=>
string(4) "char"
[255]=>
string(8) "geometry"
[16]=>
string(3) "bit"
[246]=>
string(7) "decimal"
}
["fetchmode"]=>
int(1)
["fetchmode_object_class"]=>
string(8) "stdClass"
["was_connected"]=>
NULL
["last_query"]=>
string(513) "CREATE TABLE profile_prefs (
profile_id int not null comment 'user',
namespace varchar(191) not null comment 'namespace, like pluginname or category',
topic varchar(191) not null comment 'preference key, i.e. description, age...',
data blob comment 'topic data, may be anything',
created datetime not null comment 'date this record was created',
modified timestamp not null comment 'date this record was modified',
PRIMARY KEY (profile_id,namespace,topic)
) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_bin"
["options"]=>
array(8) {
["result_buffering"]=>
int(500)
["persistent"]=>
bool(false)
["ssl"]=>
bool(false)
["debug"]=>
int(0)
["seqname_format"]=>
string(6) "%s_seq"
["autofree"]=>
bool(false)
["portability"]=>
int(0)
["optimize"]=>
string(11) "performance"
}
["last_parameters"]=>
array(0) {
}
["prepare_tokens"]=>
array(0) {
}
["prepare_types"]=>
array(0) {
}
["prepared_queries"]=>
array(0) {
}
["_last_query_manip"]=>
bool(true)
["_next_query_manip"]=>
bool(false)
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(8) "DB_Error"
["_expected_errors"]=>
array(0) {
}
}
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(513) "CREATE TABLE profile_prefs (
profile_id int not null comment 'user',
namespace varchar(191) not null comment 'namespace, like pluginname or category',
topic varchar(191) not null comment 'preference key, i.e. description, age...',
data blob comment 'topic data, may be anything',
created datetime not null comment 'date this record was created',
modified timestamp not null comment 'date this record was modified',
PRIMARY KEY (profile_id,namespace,topic)
) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_bin"
}
}
[7]=>
array(7) {
["file"]=>
string(60) "/home/michael/gnu-social//lib/schema.php"
["line"]=>
int(515)
["function"]=>
string(9) "runSqlSet"
["class"]=>
string(6) "Schema"
["object"]=>
object(MysqlSchema)#7 (1) {
["conn":protected]=>
object(DB_mysqli)#5 (28) {
["phptype"]=>
string(6) "mysqli"
["dbsyntax"]=>
string(6) "mysqli"
["features"]=>
array(7) {
["limit"]=>
string(5) "alter"
["new_link"]=>
bool(false)
["numrows"]=>
bool(true)
["pconnect"]=>
bool(false)
["prepare"]=>
bool(false)
["ssl"]=>
bool(true)
["transactions"]=>
bool(true)
}
["errorcode_map"]=>
array(26) {
[1004]=>
int(-15)
[1005]=>
int(-15)
[1006]=>
int(-15)
[1007]=>
int(-5)
[1008]=>
int(-17)
[1022]=>
int(-5)
[1044]=>
int(-26)
[1046]=>
int(-14)
[1048]=>
int(-3)
[1049]=>
int(-27)
[1050]=>
int(-5)
[1051]=>
int(-18)
[1054]=>
int(-19)
[1061]=>
int(-5)
[1062]=>
int(-5)
[1064]=>
int(-2)
[1091]=>
int(-4)
[1100]=>
int(-21)
[1136]=>
int(-22)
[1142]=>
int(-26)
[1146]=>
int(-18)
[1216]=>
int(-3)
[1217]=>
int(-3)
[1356]=>
int(-13)
[1451]=>
int(-3)
[1452]=>
int(-3)
}
["connection"]=>
object(mysqli)#6 (19) {
["affected_rows"]=>
int(-1)
["client_info"]=>
string(6) "5.5.45"
["client_version"]=>
int(50545)
["connect_errno"]=>
int(0)
["connect_error"]=>
NULL
["errno"]=>
int(0)
["error"]=>
string(0) ""
["error_list"]=>
array(0) {
}
["field_count"]=>
int(19)
["host_info"]=>
string(25) "Localhost via UNIX socket"
["info"]=>
NULL
["insert_id"]=>
int(0)
["server_info"]=>
string(14) "5.5.45-cll-lve"
["server_version"]=>
int(50545)
["stat"]=>
string(155) "Uptime: 1143263 Threads: 13 Questions: 318899109 Slow queries: 10062 Opens: 32195 Flush tables: 1 Open tables: 10240 Queries per second avg: 278.937"
["sqlstate"]=>
string(5) "00000"
["protocol_version"]=>
int(10)
["thread_id"]=>
int(4717607)
["warning_count"]=>
int(0)
}
["dsn"]=>
array(9) {
["phptype"]=>
string(6) "mysqli"
["dbsyntax"]=>
string(6) "mysqli"
["username"]=>
string(16) "my_db_user"
["password"]=>
string(18) "password"
["protocol"]=>
string(3) "tcp"
["hostspec"]=>
string(9) "localhost"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["database"]=>
string(20) "my_db_name"
}
["autocommit"]=>
bool(true)
["transaction_opcount"]=>
int(0)
["_db"]=>
string(20) "my_db_name"
["mysqli_flags"]=>
array(11) {
[1]=>
string(8) "not_null"
[2]=>
string(11) "primary_key"
[4]=>
string(10) "unique_key"
[8]=>
string(12) "multiple_key"
[16]=>
string(4) "blob"
[32]=>
string(8) "unsigned"
[64]=>
string(8) "zerofill"
[512]=>
string(14) "auto_increment"
[1024]=>
string(9) "timestamp"
[2048]=>
string(3) "set"
[32768]=>
string(8) "group_by"
}
["mysqli_types"]=>
array(25) {
[0]=>
string(7) "decimal"
[1]=>
string(7) "tinyint"
[2]=>
string(3) "int"
[3]=>
string(3) "int"
[4]=>
string(5) "float"
[5]=>
string(6) "double"
[7]=>
string(9) "timestamp"
[8]=>
string(6) "bigint"
[9]=>
string(9) "mediumint"
[10]=>
string(4) "date"
[11]=>
string(4) "time"
[12]=>
string(8) "datetime"
[13]=>
string(4) "year"
[14]=>
string(4) "date"
[247]=>
string(4) "enum"
[248]=>
string(3) "set"
[249]=>
string(8) "tinyblob"
[250]=>
string(10) "mediumblob"
[251]=>
string(8) "longblob"
[252]=>
string(4) "blob"
[253]=>
string(7) "varchar"
[254]=>
string(4) "char"
[255]=>
string(8) "geometry"
[16]=>
string(3) "bit"
[246]=>
string(7) "decimal"
}
["fetchmode"]=>
int(1)
["fetchmode_object_class"]=>
string(8) "stdClass"
["was_connected"]=>
NULL
["last_query"]=>
string(513) "CREATE TABLE profile_prefs (
profile_id int not null comment 'user',
namespace varchar(191) not null comment 'namespace, like pluginname or category',
topic varchar(191) not null comment 'preference key, i.e. description, age...',
data blob comment 'topic data, may be anything',
created datetime not null comment 'date this record was created',
modified timestamp not null comment 'date this record was modified',
PRIMARY KEY (profile_id,namespace,topic)
) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_bin"
["options"]=>
array(8) {
["result_buffering"]=>
int(500)
["persistent"]=>
bool(false)
["ssl"]=>
bool(false)
["debug"]=>
int(0)
["seqname_format"]=>
string(6) "%s_seq"
["autofree"]=>
bool(false)
["portability"]=>
int(0)
["optimize"]=>
string(11) "performance"
}
["last_parameters"]=>
array(0) {
}
["prepare_tokens"]=>
array(0) {
}
["prepare_types"]=>
array(0) {
}
["prepared_queries"]=>
array(0) {
}
["_last_query_manip"]=>
bool(true)
["_next_query_manip"]=>
bool(false)
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(8) "DB_Error"
["_expected_errors"]=>
array(0) {
}
}
}
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
&array(1) {
[0]=>
string(513) "CREATE TABLE profile_prefs (
profile_id int not null comment 'user',
namespace varchar(191) not null comment 'namespace, like pluginname or category',
topic varchar(191) not null comment 'preference key, i.e. description, age...',
data blob comment 'topic data, may be anything',
created datetime not null comment 'date this record was created',
modified timestamp not null comment 'date this record was modified',
PRIMARY KEY (profile_id,namespace,topic)
) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_bin"
}
}
}
[8]=>
array(7) {
["file"]=>
string(63) "/home/michael/gnu-social//lib/installer.php"
["line"]=>
int(354)
["function"]=>
string(11) "ensureTable"
["class"]=>
string(6) "Schema"
["object"]=>
object(MysqlSchema)#7 (1) {
["conn":protected]=>
object(DB_mysqli)#5 (28) {
["phptype"]=>
string(6) "mysqli"
["dbsyntax"]=>
string(6) "mysqli"
["features"]=>
array(7) {
["limit"]=>
string(5) "alter"
["new_link"]=>
bool(false)
["numrows"]=>
bool(true)
["pconnect"]=>
bool(false)
["prepare"]=>
bool(false)
["ssl"]=>
bool(true)
["transactions"]=>
bool(true)
}
["errorcode_map"]=>
array(26) {
[1004]=>
int(-15)
[1005]=>
int(-15)
[1006]=>
int(-15)
[1007]=>
int(-5)
[1008]=>
int(-17)
[1022]=>
int(-5)
[1044]=>
int(-26)
[1046]=>
int(-14)
[1048]=>
int(-3)
[1049]=>
int(-27)
[1050]=>
int(-5)
[1051]=>
int(-18)
[1054]=>
int(-19)
[1061]=>
int(-5)
[1062]=>
int(-5)
[1064]=>
int(-2)
[1091]=>
int(-4)
[1100]=>
int(-21)
[1136]=>
int(-22)
[1142]=>
int(-26)
[1146]=>
int(-18)
[1216]=>
int(-3)
[1217]=>
int(-3)
[1356]=>
int(-13)
[1451]=>
int(-3)
[1452]=>
int(-3)
}
["connection"]=>
object(mysqli)#6 (19) {
["affected_rows"]=>
int(-1)
["client_info"]=>
string(6) "5.5.45"
["client_version"]=>
int(50545)
["connect_errno"]=>
int(0)
["connect_error"]=>
NULL
["errno"]=>
int(0)
["error"]=>
string(0) ""
["error_list"]=>
array(0) {
}
["field_count"]=>
int(19)
["host_info"]=>
string(25) "Localhost via UNIX socket"
["info"]=>
NULL
["insert_id"]=>
int(0)
["server_info"]=>
string(14) "5.5.45-cll-lve"
["server_version"]=>
int(50545)
["stat"]=>
string(155) "Uptime: 1143263 Threads: 13 Questions: 318899110 Slow queries: 10062 Opens: 32195 Flush tables: 1 Open tables: 10240 Queries per second avg: 278.937"
["sqlstate"]=>
string(5) "00000"
["protocol_version"]=>
int(10)
["thread_id"]=>
int(4717607)
["warning_count"]=>
int(0)
}
["dsn"]=>
array(9) {
["phptype"]=>
string(6) "mysqli"
["dbsyntax"]=>
string(6) "mysqli"
["username"]=>
string(16) "my_db_user"
["password"]=>
string(18) "password"
["protocol"]=>
string(3) "tcp"
["hostspec"]=>
string(9) "localhost"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["database"]=>
string(20) "my_db_name"
}
["autocommit"]=>
bool(true)
["transaction_opcount"]=>
int(0)
["_db"]=>
string(20) "my_db_name"
["mysqli_flags"]=>
array(11) {
[1]=>
string(8) "not_null"
[2]=>
string(11) "primary_key"
[4]=>
string(10) "unique_key"
[8]=>
string(12) "multiple_key"
[16]=>
string(4) "blob"
[32]=>
string(8) "unsigned"
[64]=>
string(8) "zerofill"
[512]=>
string(14) "auto_increment"
[1024]=>
string(9) "timestamp"
[2048]=>
string(3) "set"
[32768]=>
string(8) "group_by"
}
["mysqli_types"]=>
array(25) {
[0]=>
string(7) "decimal"
[1]=>
string(7) "tinyint"
[2]=>
string(3) "int"
[3]=>
string(3) "int"
[4]=>
string(5) "float"
[5]=>
string(6) "double"
[7]=>
string(9) "timestamp"
[8]=>
string(6) "bigint"
[9]=>
string(9) "mediumint"
[10]=>
string(4) "date"
[11]=>
string(4) "time"
[12]=>
string(8) "datetime"
[13]=>
string(4) "year"
[14]=>
string(4) "date"
[247]=>
string(4) "enum"
[248]=>
string(3) "set"
[249]=>
string(8) "tinyblob"
[250]=>
string(10) "mediumblob"
[251]=>
string(8) "longblob"
[252]=>
string(4) "blob"
[253]=>
string(7) "varchar"
[254]=>
string(4) "char"
[255]=>
string(8) "geometry"
[16]=>
string(3) "bit"
[246]=>
string(7) "decimal"
}
["fetchmode"]=>
int(1)
["fetchmode_object_class"]=>
string(8) "stdClass"
["was_connected"]=>
NULL
["last_query"]=>
string(513) "CREATE TABLE profile_prefs (
profile_id int not null comment 'user',
namespace varchar(191) not null comment 'namespace, like pluginname or category',
topic varchar(191) not null comment 'preference key, i.e. description, age...',
data blob comment 'topic data, may be anything',
created datetime not null comment 'date this record was created',
modified timestamp not null comment 'date this record was modified',
PRIMARY KEY (profile_id,namespace,topic)
) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_bin"
["options"]=>
array(8) {
["result_buffering"]=>
int(500)
["persistent"]=>
bool(false)
["ssl"]=>
bool(false)
["debug"]=>
int(0)
["seqname_format"]=>
string(6) "%s_seq"
["autofree"]=>
bool(false)
["portability"]=>
int(0)
["optimize"]=>
string(11) "performance"
}
["last_parameters"]=>
array(0) {
}
["prepare_tokens"]=>
array(0) {
}
["prepare_types"]=>
array(0) {
}
["prepared_queries"]=>
array(0) {
}
["_last_query_manip"]=>
bool(true)
["_next_query_manip"]=>
bool(false)
["_debug"]=>
bool(false)
["_default_error_mode"]=>
NULL
["_default_error_options"]=>
NULL
["_default_error_handler"]=>
string(0) ""
["_error_class"]=>
string(8) "DB_Error"
["_expected_errors"]=>
array(0) {
}
}
}
["type"]=>
string(2) "->"
["args"]=>
array(2) {
[0]=>
&string(13) "profile_prefs"
[1]=>
&array(4) {
["fields"]=>
array(6) {
["profile_id"]=>
array(3) {
["type"]=>
string(3) "int"
["not null"]=>
bool(true)
["description"]=>
string(4) "user"
}
["namespace"]=>
array(4) {
["type"]=>
string(7) "varchar"
["length"]=>
int(191)
["not null"]=>
bool(true)
["description"]=>
string(38) "namespace, like pluginname or category"
}
["topic"]=>
array(4) {
["type"]=>
string(7) "varchar"
["length"]=>
int(191)
["not null"]=>
bool(true)
["description"]=>
string(40) "preference key, i.e. description, age..."
}
["data"]=>
array(2) {
["type"]=>
string(4) "blob"
["description"]=>
string(27) "topic data, may be anything"
}
["created"]=>
array(3) {
["type"]=>
string(8) "datetime"
["not null"]=>
bool(true)
["description"]=>
string(28) "date this record was created"
}
["modified"]=>
array(3) {
["type"]=>
string(9) "timestamp"
["not null"]=>
bool(true)
["description"]=>
string(29) "date this record was modified"
}
}
["primary key"]=>
array(3) {
[0]=>
string(10) "profile_id"
[1]=>
string(9) "namespace"
[2]=>
string(5) "topic"
}
["foreign keys"]=>
array(0) {
}
["indexes"]=>
array(0) {
}
}
}
}
[9]=>
array(7) {
["file"]=>
string(63) "/home/michael/gnu-social//lib/installer.php"
["line"]=>
int(308)
["function"]=>
string(16) "createCoreTables"
["class"]=>
string(9) "Installer"
["object"]=>
object(WebInstaller)#1 (17) {
["sitename"]=>
string(10) "greatenemy"
["server"]=>
string(18) "www.greatenemy.com"
["path"]=>
bool(false)
["fancy"]=>
bool(true)
["siteProfile"]=>
string(6) "public"
["ssl"]=>
string(5) "never"
["host"]=>
string(9) "localhost"
["database"]=>
string(20) "my_db_name"
["dbtype"]=>
string(5) "mysql"
["username"]=>
string(16) "my_db_user"
["password"]=>
string(18) "password"
["db"]=>
NULL
["adminNick"]=>
string(7) "michael"
["adminPass"]=>
string(18) "password"
["adminEmail"]=>
string(19) "michael@codebro.org"
["skipConfig"]=>
bool(false)
["validated"]=>
bool(true)
}
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
object(DB_mysqli)#5 (28) {
["phptype"]=>
string(6) "mysqli"
["dbsyntax"]=>
string(6) "mysqli"
["features"]=>
array(7) {
["limit"]=>
string(5) "alter"
["new_link"]=>
bool(false)
["numrows"]=>
bool(true)
["pconnect"]=>
bool(false)
["prepare"]=>
bool(false)
["ssl"]=>
bool(true)
["transactions"]=>
bool(true)
}
["errorcode_map"]=>
array(26) {
[1004]=>
int(-15)
[1005]=>
int(-15)
[1006]=>
int(-15)
[1007]=>
int(-5)
[1008]=>
int(-17)
[1022]=>
int(-5)
[1044]=>
int(-26)
[1046]=>
int(-14)
[1048]=>
int(-3)
[1049]=>
int(-27)
[1050]=>
int(-5)
[1051]=>
int(-18)
[1054]=>
int(-19)
[1061]=>
int(-5)
[1062]=>
int(-5)
[1064]=>
int(-2)
[1091]=>
int(-4)
[1100]=>
int(-21)
[1136]=>
int(-22)
[1142]=>
int(-26)
[1146]=>
int(-18)
[1216]=>
int(-3)
[1217]=>
int(-3)
[1356]=>
int(-13)
[1451]=>
int(-3)
[1452]=>
int(-3)
}
["connection"]=>
object(mysqli)#6 (19) {
["affected_rows"]=>
int(-1)
["client_info"]=>
string(6) "5.5.45"
["client_version"]=>
int(50545)
["connect_errno"]=>
int(0)
["connect_error"]=>
NULL
["errno"]=>
int(0)
["error"]=>
string(0) ""
["error_list"]=>
array(0) {
}
["field_count"]=>
int(19)
["host_info"]=>
string(25) "Localhost via UNIX socket"
["info"]=>
NULL
["insert_id"]=>
int(0)
["server_info"]=>
string(14) "5.5.45-cll-lve"
["server_version"]=>
int(50545)
["stat"]=>
string(155) "Uptime: 1143263 Threads: 13 Questions: 318899111 Slow queries: 10062 Opens: 32195 Flush tables: 1 Open tables: 10240 Queries per second avg: 278.937"
["sqlstate"]=>
string(5) "00000"
["protocol_version"]=>
int(10)
["thread_id"]=>
int(4717607)
["warning_count"]=>
int(0)
}
["dsn"]=>
array(9) {
["phptype"]=>
string(6) "mysqli"
["dbsyntax"]=>
string(6) "mysqli"
["username"]=>
string(16) "my_db_user"
["password"]=>
string(18) "password"
["protocol"]=>
string(3) "tcp"
["hostspec"]=>
string(9) "localhost"
["port"]=>
bool(false)
["socket"]=>
bool(false)
["database"]=>
string(20) "my_db_name"
}
["autocommit"]=>
bool(true)
["transaction_opcount"]=>
int(0)
["_db"]=>
string(20) "my_db_name"
["mysqli_flags"]=>
array(11) {
[1]=>
string(8) "not_null"
[2]=>
string(11) "primary_key"
[4]=>
string(10) "unique_key"
[8]=>
string(12) "multiple_key"
[16]=>
string(4) "blob"
[32]=>
string(8) "unsigned"
[64]=>
string(8) "zerofill"
[512]=>
string(14) "auto_increment"
[1024]=>
string(9) "timestamp"
[2048]=>
string(3) "set"
[32768]=>
string(8) "group_by"
}
["mysqli_types"]=>
array(25) {
[0]=>
string(7) "decimal"
[1]=>
string(7) "tinyint"
[2]=>
string(3) "int"
[3]=>
string(3) "int"
[4]=>
string(5) "float"
[5]=>
string(6) "double"
[7]=>
string(9) "timestamp"
[8]=>
string(6) "bigint"
[9]=>
string(9) "mediumint"
[10]=>
string(4) "date"
[11]=>
string(4) "time"