Export - CSV (All fields)
Export - CSV (Current fields)
PHPBB-17369
Permanently deleting soft-deleted topics returns incorrect forum in redirect linkPHPBB-17350
Add user IP address to log when installing extensions on fresh installsPHPBB-17349
Log captcha attempts in the ACP
Enlarge session_browser field in sessions table to detect Googlebot
SQL query taking way too long, locking up other queries
some phpbb database tables do not have a primary key
Dynamic Postgres Primary/Standby Failover
Postgres search_path inproperly set
PostgreSQL backups are missing constraint declarations
Database backup generates a general error with PostgreSQL 12+
Search times out on a medium size forum
Add two indexes to posts table
Topic Resynchronization Problem
Constraint on table sessions_keys solves memory leak
DbDriver->sql_build_query cant cope with sub-selects
SQL Error in PostgreSQL Fulltext search when results displayed as topics
Database table phpbb_posts keeps crashing and corrupting even after many repairs
Database update from 3.1.10 to 3.2.1 broken (postgreSQL)
<t></t> bug in database?
Error migrating from 3.0.12 to 3.2. MS SQL Server
{"searchers":{"groups":[{"searchers":[{"name":"Project","id":"project","key":"issue.field.project","isShown":true,"lastViewed":1732205282580},{"name":"Summary","id":"summary","key":"issue.field.summary","isShown":true},{"name":"Type","id":"issuetype","key":"issue.field.issuetype","isShown":true,"lastViewed":1732205282591},{"name":"Status","id":"status","key":"issue.field.status","isShown":true,"lastViewed":1732205282605},{"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},{"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,"lastViewed":1732205282610},{"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":false},{"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":false},{"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":1732205282608},{"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 10260 \"\n data-icon=\"/images/icons/issuetypes/exclamation.png\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_10000\"\n title=\"Incident\"\n value=\"10000\">Incident</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 10263 \"\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},"project":{"name":"Project","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 \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=10010&size=small\"\n title=\"phpBB\"\n value=\"10010\">\n phpBB (PHPBB)\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","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=\"-82 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-progress.png\" value=\"3\" title=\"In Progress\" data-simple-status=\"{"id":"3","name":"In Progress","description":"This issue is being actively worked on at the moment by the assignee.","iconUrl":"/images/icons/phpbb-progress.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"inprogress"}}\">In Progress</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=\"10007\" title=\"Awaiting Team Input\" data-simple-status=\"{"id":"10007","name":"Awaiting Team Input","description":"Input from other team members is required.","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"inprogress"}}\">Awaiting Team Input</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10008\" title=\"Reviewed\" data-simple-status=\"{"id":"10008","name":"Reviewed","description":"This issue has been reviewed and a solution provided. The ticket will remain open for a short period of time before closing.","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"inprogress"}}\">Reviewed</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10009\" title=\"Support Request\" data-simple-status=\"{"id":"10009","name":"Support Request","description":"This issue should be directed to the support forums and is not appropriate for this tracker.","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":3,"key":"done","colorName":"success"}}\">Support Request</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/closed.png\" value=\"10010\" title=\"Done\" data-simple-status=\"{"id":"10010","name":"Done","description":"","iconUrl":"/images/icons/statuses/closed.png","statusCategory":{"id":3,"key":"done","colorName":"success"}}\">Done</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/open.png\" value=\"10011\" title=\"To Do\" data-simple-status=\"{"id":"10011","name":"To Do","description":"","iconUrl":"/images/icons/statuses/open.png","statusCategory":{"id":2,"key":"new","colorName":"default"}}\">To Do</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10012\" title=\"Review Later\" data-simple-status=\"{"id":"10012","name":"Review Later","description":"This issue will be reviewed at a later date.","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":2,"key":"new","colorName":"default"}}\">Review Later</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10105\" title=\"Blocked\" data-simple-status=\"{"id":"10105","name":"Blocked","description":"","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":2,"key":"new","colorName":"default"}}\">Blocked</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10106\" title=\"In Progress by OSUOSL\" data-simple-status=\"{"id":"10106","name":"In Progress by OSUOSL","description":"","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"inprogress"}}\">In Progress by OSUOSL</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10107\" title=\"In Progress By Us\" data-simple-status=\"{"id":"10107","name":"In Progress By Us","description":"","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"inprogress"}}\">In Progress By Us</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},"labels":{"name":"Label","viewHtml":" <div class=\"searcherValue\">\n \n <label class=\"fieldLabel\" for=\"fieldlabels\">Label:</label><span id=\"fieldlabels\" class=\"fieldValue\">\n \n database\n</span></div>\n","editHtml":"\n <div class=\"field-group aui-field-labels\" >\n <label for=\"searcher-labels\">Labels</label> <select class=\"js-label-checkboxmultiselect\" multiple=\"multiple\" id=\"searcher-labels\" name=\"labels\" data-placeholder-text=\"Find Labels...\">\n <option value=\"database\" title=\"database\" selected=\"selected\">database</option>\n </select>\n </div>\n \n","jql":"labels = database","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