Export - CSV (All fields)
Export - CSV (Current fields)
PHPBB-17337
Transaction begin is missing from mysqli driverPHPBB-17232
Improve MySQL error messages in PHP 8.1+
PHP 8.x Deprecation in postgres driver
Extensions Can't Be Installed
sql_freeresult not working for mysqli & PHP 8
some phpbb database tables do not have a primary key
Use exceptions to handle errors in sqlite3PHPBB-16819
Dynamic Postgres Primary/Standby Failover
Postgres search_path inproperly set
PostgreSQL backups are missing constraint declarationsPHPBB-16741
Migrate DB Tools to Doctrine
Type error with MySql > 8.0.21
Simplify get_database_size() SQL query for PostgreSQL
SQL error in ACP if database name contains a dash
Migrate the installer to Doctrine DBAL
Oracle DBAL driver uses obsoleted PHP OCI8 aliases and functions
Database backup generates a general error with PostgreSQL 12+
Add index to improve acl_get_list database performance
Emoji's in topic title cause errors
Incorrect SQL / PHP time when debug.sql_explain is enabled
Remove deprecated phpbb\db\tools
Incorrect installation path for SQLite3
Support for utf8mb4 encoding
Migrator never drops unique indexesPHPBB-16051
Remove mysql driver as it's unsupported
Invalid UTF-8 encoding on mssqlnative driver
mssqlnative driver object incompatible with PHP 7.2
mssql_odbc does not store utf8 stings as unicode
mssqlnative does not handle unicode text
Unable to install in Oracle 11R2 Express
Constraint on table sessions_keys solves memory leak
MSSQL implementation crashes when upload directory > 2GB
Config-text does not cache values
DbDriver->sql_build_query cant cope with sub-selects
revert_schema() steps not executed in correct order
Database update v310\style_update_p2 fails to drop sequences
Characters with more than 3 bytes in its default UTF-8
Fatal error on SQLite/Oracle database update
Remove SQL Server 2000 support
phpbb_login_attempts and some other tables without a PRIMARY index
CLI command db:migrate does not include 3.1.x migrations in 3.2.x
PHP 7.2 compatibility: wrong sizeof/count parameter type
SQL PostgreSQL blocking errors during DB update installation
sql_like_expression() doesn't handle underscores correctly
Extension migration file fails
"A non-numeric value encountered" PHP warning on PHP 7.1+
Remove old SQLite 2.8.х database driver
DB Tools sql_column_exists() broken in postgresql
2 same tables in sql_build_query
MySQL 5.7.* compatibility
{"searchers":{"groups":[{"searchers":[{"name":"Project","id":"project","key":"issue.field.project","isShown":true,"lastViewed":1732205050791},{"name":"Summary","id":"summary","key":"issue.field.summary","isShown":true},{"name":"Type","id":"issuetype","key":"issue.field.issuetype","isShown":true,"lastViewed":1732205050800},{"name":"Status","id":"status","key":"issue.field.status","isShown":true,"lastViewed":1732205050823},{"name":"Priority","id":"priority","key":"issue.field.priority","isShown":true},{"name":"Resolution","id":"resolution","key":"issue.field.resolution","isShown":true},{"name":"Creator","id":"creator","key":"issue.field.creator","isShown":true},{"name":"Affects Version","id":"version","key":"issue.field.affectsversions","isShown":true},{"name":"Fix Version","id":"fixfor","key":"issue.field.fixversions","isShown":true},{"name":"Component","id":"component","key":"issue.field.components","isShown":true,"lastViewed":1732205050835},{"name":"% Limits","id":"workratio","key":"issue.field.workratio","isShown":true},{"name":"Link types","id":"issue_link_type","key":"issue.field.issuelinks","isShown":true},{"name":"Environment","id":"environment","key":"issue.field.environment","isShown":true},{"name":"Description","id":"description","key":"issue.field.description","isShown":true},{"name":"Comment","id":"comment","key":"issue.field.comment","isShown":true},{"name":"Label","id":"labels","key":"issue.field.labels","isShown":true},{"name":"Query","id":"text","key":"text","isShown":true},{"name":"Development","id":"customfield_10440","key":"com.atlassian.jira.plugins.jira-development-integration-plugin:devsummary","isShown":true},{"name":"Epic Color","id":"customfield_10245","key":"com.pyxis.greenhopper.jira:gh-epic-color","isShown":false},{"name":"Epic Link","id":"customfield_10242","key":"com.pyxis.greenhopper.jira:gh-epic-link","isShown":true},{"name":"Epic Name","id":"customfield_10244","key":"com.pyxis.greenhopper.jira:gh-epic-label","isShown":true},{"name":"Epic Status","id":"customfield_10243","key":"com.pyxis.greenhopper.jira:gh-epic-status","isShown":false},{"name":"Fix URL","id":"customfield_10030","key":"com.atlassian.jira.plugin.system.customfieldtypes:url","isShown":true},{"name":"Flagged","id":"customfield_10540","key":"com.atlassian.jira.plugin.system.customfieldtypes:multicheckboxes","isShown":true},{"name":"GitHub Pull Request URL","id":"customfield_10020","key":"com.atlassian.jira.plugin.system.customfieldtypes:url","isShown":true},{"name":"Labels","id":"customfield_10040","key":"com.atlassian.jira.plugin.system.customfieldtypes:labels","isShown":true},{"name":"Original story points","id":"customfield_10644","key":"com.atlassian.jpo:jpo-custom-field-original-story-points","isShown":true},{"name":"Parent Link","id":"customfield_10641","key":"com.atlassian.jpo:jpo-custom-field-parent","isShown":false},{"name":"Rank","id":"customfield_10240","key":"com.pyxis.greenhopper.jira:gh-lexo-rank","isShown":true},{"name":"Sprint","id":"customfield_10241","key":"com.pyxis.greenhopper.jira:gh-sprint","isShown":true},{"name":"Story Points","id":"customfield_10246","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"Team","id":"customfield_10640","key":"com.atlassian.teams:rm-teams-custom-field-team","isShown":true},{"name":"phpBB Import Key","id":"customfield_10000","key":"com.atlassian.jira.plugin.system.customfieldtypes:importid","isShown":true},{"name":"phpBB Import Key","id":"customfield_10140","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"phpBB Import Key","id":"customfield_10141","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"phpBB Import Key","id":"customfield_10142","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"phpBB Import Key","id":"customfield_10143","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"phpBB Import Key","id":"customfield_10144","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"phpBB Import Key","id":"customfield_10145","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"phpBB Import Key","id":"customfield_10146","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false}],"type":"DETAILS","title":"Details"},{"searchers":[{"name":"Created Date","id":"created","key":"issue.field.created","isShown":true},{"name":"Updated Date","id":"updated","key":"issue.field.updated","isShown":true},{"name":"Resolution Date","id":"resolutiondate","key":"issue.field.resolution.date","isShown":true},{"name":"Due Date","id":"duedate","key":"issue.field.duedate","isShown":true},{"name":"Target end","id":"customfield_10643","key":"com.atlassian.jpo:jpo-custom-field-baseline-end","isShown":true},{"name":"Target start","id":"customfield_10642","key":"com.atlassian.jpo:jpo-custom-field-baseline-start","isShown":true}],"type":"DATES","title":"Dates"},{"searchers":[{"name":"Assignee","id":"assignee","key":"issue.field.assignee","isShown":true,"lastViewed":1732205050832},{"name":"Reporter","id":"reporter","key":"issue.field.reporter","isShown":true}],"type":"PEOPLE","title":"People"}]},"values":{"issuetype":{"name":"Type","editHtml":"\n\n\n\n <div class=\"field-group aui-field-issuetype\" >\n <label for=\"searcher-type\">Type</label> <select class=\"select js-default-checkboxmultiselect\"\n id=\"searcher-type\"\n multiple=\"multiple\"\n name=\"type\"\n data-max-inline-results-displayed=\"100\"\n data-placeholder-text=\"Find Issue Types...\">\n <optgroup>\n \n <option class=\" \"\n id=\"type_-2\"\n title=\"All Standard Issue Types\"\n value=\"-2\">All Standard Issue Types</option>\n \n <option class=\" \"\n id=\"type_-3\"\n title=\"All Sub-Task Issue Types\"\n value=\"-3\">All Sub-Task Issue Types</option>\n </optgroup>\n\n <optgroup label=\"Standard Issue Types\">\n \n <option class=\" imagebacked 10262 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12123&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_1\"\n title=\"Bug\"\n value=\"1\">Bug</option>\n \n <option class=\" imagebacked 10262 \"\n data-icon=\"/images/icons/issuetypes/epic.svg\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_10100\"\n title=\"Epic\"\n value=\"10100\">Epic</option>\n \n <option class=\" imagebacked 10262 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12130&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_4\"\n title=\"Improvement\"\n value=\"4\">Improvement</option>\n \n <option class=\" imagebacked 10262 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12131&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_2\"\n title=\"New Feature\"\n value=\"2\">New Feature</option>\n \n <option class=\" imagebacked 10262 \"\n data-icon=\"/images/icons/issuetypes/exclamation.png\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_10001\"\n title=\"Security Issue\"\n value=\"10001\">Security Issue</option>\n \n <option class=\" imagebacked 10262 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12138&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_3\"\n title=\"Task\"\n value=\"3\">Task</option>\n </optgroup>\n\n <optgroup label=\"Sub-Task Issue Types\">\n \n <option class=\" imagebacked 10262 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12136&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_5\"\n title=\"Sub-task\"\n value=\"5\">Sub-task</option>\n </optgroup>\n </select>\n </div>\n ","validSearcher":true,"isShown":true},"component":{"name":"Component","viewHtml":" <div class=\"searcherValue\">\n \n <label class=\"fieldLabel\" for=\"fieldcomponent\">Component:</label><span id=\"fieldcomponent\" class=\"fieldValue\">\n \n Database Abstraction Layer (DBAL) </span></div>\n","editHtml":"\n <div class=\"field-group aui-field-projectconstant\" >\n <label for=\"searcher-component\">Component</label> <select class=\"select js-default-checkboxmultiselectcomponent\"\n id=\"searcher-component\"\n multiple=\"multiple\"\n name=\"component\"\n data-max-inline-results-displayed=\"100\"\n aria-label=\"Search for components\">\n <optgroup label=\"\">\n <option value=\"-1\" title=\"No Component\">No Component</option>\n <option value=\"id:ACP\" title=\"ACP\">ACP</option>\n <option value=\"id:Attachments\" title=\"Attachments\">Attachments</option>\n <option value=\"id:Authentication\" title=\"Authentication\">Authentication</option>\n <option value=\"id:BBCode Engine\" title=\"BBCode Engine\">BBCode Engine</option>\n <option value=\"id:Build System\" title=\"Build System\">Build System</option>\n <option value=\"id:Caching (ACM)\" title=\"Caching (ACM)\">Caching (ACM)</option>\n <option value=\"id:CLI\" title=\"CLI\">CLI</option>\n <option value=\"id:Continuous Integration (CI)\" title=\"Continuous Integration (CI)\">Continuous Integration (CI)</option>\n <option value=\"id:Cron\" title=\"Cron\">Cron</option>\n <option selected=\"selected\" value=\"id:Database Abstraction Layer (DBAL)\" title=\"Database Abstraction Layer (DBAL)\">Database Abstraction Layer (DBAL)</option>\n <option value=\"id:Dependency Management\" title=\"Dependency Management\">Dependency Management</option>\n <option value=\"id:Documentation\" title=\"Documentation\">Documentation</option>\n <option value=\"id:Events\" title=\"Events\">Events</option>\n <option value=\"id:Extensions\" title=\"Extensions\">Extensions</option>\n <option value=\"id:Group Management\" title=\"Group Management\">Group Management</option>\n <option value=\"id:Installation system\" title=\"Installation system\">Installation system</option>\n <option value=\"id:IPB 1.x convertor\" title=\"IPB 1.x convertor\">IPB 1.x convertor</option>\n <option value=\"id:IPB 2.x convertor\" title=\"IPB 2.x convertor\">IPB 2.x convertor</option>\n <option value=\"id:JavaScript / AJAX\" title=\"JavaScript / AJAX\">JavaScript / AJAX</option>\n <option value=\"id:Language pack\" title=\"Language pack\">Language pack</option>\n <option value=\"id:Login\" title=\"Login\">Login</option>\n <option value=\"id:Memberlist/viewing profiles\" title=\"Memberlist/viewing profiles\">Memberlist/viewing profiles</option>\n <option value=\"id:Migrations\" title=\"Migrations\">Migrations</option>\n <option value=\"id:Moderator Control Panel (MCP)\" title=\"Moderator Control Panel (MCP)\">Moderator Control Panel (MCP)</option>\n <option value=\"id:Node.js\" title=\"Node.js\">Node.js</option>\n <option value=\"id:Notification System\" title=\"Notification System\">Notification System</option>\n <option value=\"id:OAuth\" title=\"OAuth\">OAuth</option>\n <option value=\"id:Other\" title=\"Other\">Other</option>\n <option value=\"id:Permissions\" title=\"Permissions\">Permissions</option>\n <option value=\"id:phpBB 2.0 convertor\" title=\"phpBB 2.0 convertor\">phpBB 2.0 convertor</option>\n <option value=\"id:Posting\" title=\"Posting\">Posting</option>\n <option value=\"id:Private Messages (PM)\" title=\"Private Messages (PM)\">Private Messages (PM)</option>\n <option value=\"id:Search\" title=\"Search\">Search</option>\n <option value=\"id:Sessions\" title=\"Sessions\">Sessions</option>\n <option value=\"id:Storage\" title=\"Storage\">Storage</option>\n <option value=\"id:Styles\" title=\"Styles\">Styles</option>\n <option value=\"id:Template Engine\" title=\"Template Engine\">Template Engine</option>\n <option value=\"id:Test Suite\" title=\"Test Suite\">Test Suite</option>\n <option value=\"id:Unified Convertor Framework (UCF)\" title=\"Unified Convertor Framework (UCF)\">Unified Convertor Framework (UCF)</option>\n <option value=\"id:Update system\" title=\"Update system\">Update system</option>\n <option value=\"id:User Control Panel (UCP)\" title=\"User Control Panel (UCP)\">User Control Panel (UCP)</option>\n <option value=\"id:Version control\" title=\"Version control\">Version control</option>\n <option value=\"id:Viewing forums\" title=\"Viewing forums\">Viewing forums</option>\n <option value=\"id:Viewing posts\" title=\"Viewing posts\">Viewing posts</option>\n </optgroup>\n </select>\n </div>\n \n","jql":"component = \"Database Abstraction Layer (DBAL)\"","validSearcher":true,"isShown":true},"project":{"name":"Project","viewHtml":" <div class=\"searcherValue\">\n \n <label class=\"fieldLabel\" for=\"fieldpid\">Project:</label><span id=\"fieldpid\" class=\"fieldValue\">\n \n <a data-pid=\"10010\" data-issue-type-ids=\"\" href=\"/browse/PHPBB\" title=\"Browse phpBB project\">phpBB</a> </span></div>\n","editHtml":" \n <div class=\"field-group aui-field-project\" >\n <label for=\"searcher-pid\">Project</label> <select class=\"js-project-checkboxmultiselect\"\n data-placeholder-text=\"Find Projects...\"\n id=\"searcher-pid\"\n multiple=\"multiple\"\n name=\"pid\">\n <optgroup label=\"Recent Projects\">\n </optgroup>\n <optgroup label=\"All Projects\" >\n <option data-icon=\"/secure/projectavatar?pid=10010&size=small\"\n selected=\"selected\" title=\"phpBB\"\n value=\"10010\">\n phpBB (PHPBB)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10042&size=small\"\n title=\"Extension Security\"\n value=\"10042\">\n Extension Security (EXTSEC)\n </option>\n <option data-icon=\"/secure/projectavatar?pid=10040&size=small\"\n title=\"Incident Investigation\"\n value=\"10040\">\n Incident Investigation (INCIDENT)\n </option>\n <option data-icon=\"/secure/projectavatar?pid=10041&size=small\"\n title=\"phpBB Security\"\n value=\"10041\">\n phpBB Security (SECURITY)\n </option>\n <option data-icon=\"/secure/projectavatar?pid=10045&size=small\"\n title=\"Website\"\n value=\"10045\">\n Website (WEBSITE)\n </option>\n </optgroup>\n </select>\n </div>\n \n\n","jql":"project = PHPBB","validSearcher":true,"isShown":true},"assignee":{"name":"Assignee","editHtml":"\n \n <div class=\"field-group aui-field-userlist\" >\n <label for=\"searcher-assigneeSelect\">Assignee</label> <fieldset rel=\"assignee\" class=\"hidden user-group-searcher-params\">\n </fieldset>\n <select class=\"js-usergroup-checkboxmultiselect\" multiple=\"multiple\" id=\"assignee\" name=\"assignee\" data-placeholder-text=\"Enter username or group\">\n <optgroup>\n <option class=\"headerOption\" data-icon=\"https://tracker.phpbb.com/secure/useravatar?size=xsmall&avatarId=10143\" value=\"empty\" title=\"Unassigned\">Unassigned</option>\n </optgroup>\n <optgroup>\n </optgroup>\n </select>\n <input type=\"hidden\" name=\"check_prev_assignee\" value=\"true\">\n </div>\n \n","validSearcher":true,"isShown":true},"status":{"name":"Status","editHtml":"\n <div class=\"field-group aui-field-constants\" >\n <label for=\"searcher-status\">Status</label> <select class=\"select js-default-checkboxmultiselectstatuslozenge\"\n data-placeholder-text=\"Find Statuses...\"\n id=\"searcher-status\"\n multiple=\"multiple\"\n name=\"status\"\n data-max-inline-results-displayed=\"100\"\n data-footer-text=\"-92 more options. Continue typing to refine further.\" data-status-lozenge=\"true\">\n <optgroup >\n <option class=\"imagebacked\" data-icon=\"/images/icons/phpbb-open.png\" value=\"1\" title=\"Open\" data-simple-status=\"{"id":"1","name":"Open","description":"The issue is open and ready for the assignee to start work on it.","iconUrl":"/images/icons/phpbb-open.png","statusCategory":{"id":2,"key":"new","colorName":"default"}}\">Open</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/phpbb-unverified-fix.png\" value=\"5\" title=\"Unverified Fix\" data-simple-status=\"{"id":"5","name":"Unverified Fix","description":"A resolution has been taken, and it is awaiting verification by reporter. From here issues are either reopened, or are closed.","iconUrl":"/images/icons/phpbb-unverified-fix.png","statusCategory":{"id":3,"key":"done","colorName":"success"}}\">Unverified Fix</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/phpbb-closed.png\" value=\"6\" title=\"Closed\" data-simple-status=\"{"id":"6","name":"Closed","description":"The issue is considered finished, the resolution is correct. Issues which are closed can be reopened.","iconUrl":"/images/icons/phpbb-closed.png","statusCategory":{"id":3,"key":"done","colorName":"success"}}\">Closed</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/phpbb-awaiting-info.png\" value=\"10001\" title=\"Awaiting Information\" data-simple-status=\"{"id":"10001","name":"Awaiting Information","description":"Further information from the reporter is required to commence work.","iconUrl":"/images/icons/phpbb-awaiting-info.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"inprogress"}}\">Awaiting Information</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/phpbb-unreviewed-patch.png\" value=\"10002\" title=\"Patch Awaiting Review\" data-simple-status=\"{"id":"10002","name":"Patch Awaiting Review","description":"A patch solving the issue has been proposed, but is awaiting review by a development team members.","iconUrl":"/images/icons/phpbb-unreviewed-patch.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"inprogress"}}\">Patch Awaiting Review</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/phpbb-awaiting-info.png\" value=\"10004\" title=\"Patch Needs Work\" data-simple-status=\"{"id":"10004","name":"Patch Needs Work","description":"A patch has been reviewed but needs further work before it can be merged.","iconUrl":"/images/icons/phpbb-awaiting-info.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"inprogress"}}\">Patch Needs Work</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10205\" title=\"Confirmed\" data-simple-status=\"{"id":"10205","name":"Confirmed","description":"A bug which has been confirmed","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":2,"key":"new","colorName":"default"}}\">Confirmed</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10206\" title=\"Have regression test\" data-simple-status=\"{"id":"10206","name":"Have regression test","description":"A regression test has been implemented, committed and disabled","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"inprogress"}}\">Have regression test</option>\n </optgroup>\n</select>\n </div>\n \n","validSearcher":true,"isShown":true}}}
[{"id":-1,"name":"My open issues","jql":"assignee = currentUser() AND resolution = Unresolved order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true},{"id":-2,"name":"Reported by me","jql":"reporter = currentUser() order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true},{"id":-4,"name":"All issues","jql":"order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-5,"name":"Open issues","jql":"resolution = Unresolved order by priority DESC,updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-9,"name":"Done issues","jql":"statusCategory = Done order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-3,"name":"Viewed recently","jql":"issuekey in issueHistory() order by lastViewed DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-6,"name":"Created recently","jql":"created >= -1w order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-7,"name":"Resolved recently","jql":"resolutiondate >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-8,"name":"Updated recently","jql":"updated >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false}]
0.3
0