I am getting an sql error when I try to enable the extension.
Code: Select all
SQL ERROR [ mysql4 ]
Specified key was too long; max key length is 1000 bytes [1071]
SQL
CREATE TABLE phpbb_namesuggestions_events ( event_name varchar(255) DEFAULT '' NOT NULL, input_selector varchar(255) DEFAULT '' NOT NULL, description varchar(255) DEFAULT '' NOT NULL, suggest_users tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, suggest_groups tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, enabled tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, PRIMARY KEY (event_name, input_selector) ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 999
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysql.php
LINE: 191
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 1064
CALL: phpbb\db\driver\mysql->sql_query()
FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 444
CALL: phpbb\db\tools\tools->_sql_run_sql()
FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 489
CALL: phpbb\db\tools\tools->sql_create_table()
FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\tools\tools->perform_schema_changes()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 711
CALL: call_user_func_array()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 658
CALL: phpbb\db\migrator->run_step()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 400
CALL: phpbb\db\migrator->process_data_step()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 288
CALL: phpbb\db\migrator->try_apply()
FILE: [ROOT]/phpbb/db/migrator.php
LINE: 241
CALL: phpbb\db\migrator->update_do()
FILE: [ROOT]/phpbb/extension/base.php
LINE: 78
CALL: phpbb\db\migrator->update()
FILE: [ROOT]/phpbb/extension/manager.php
LINE: 190
CALL: phpbb\extension\base->enable_step()
FILE: [ROOT]/ext/boardtools/upload/includes/functions/extensions.php
LINE: 333
CALL: phpbb\extension\manager->enable_step()
FILE: [ROOT]/ext/boardtools/upload/acp/upload_module.php
LINE: 173
CALL: boardtools\upload\includes\functions\extensions::enable()
FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: boardtools\upload\acp\upload_module->main()
FILE: [ROOT]/adm/index.php
LINE: 82
CALL: p_master->load_active()
ext version 1.0.1