Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 5.0.0
-
Fix Version/s: 5.0.4
-
Component/s: Staff Interface
-
Labels:None
Description
The "Package Name" filter option under Packages (click filter icon) no longer works as of 5.0, because of the removal of the package_names column. The following error is produced:
[2021-03-29T17:02:53.598867+00:00] general.ERROR: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'package_names' in /home/blestau/public_html/501/vendors/minphp/db/src/PdoConnection.php:196 Stack trace: #0 /home/blestau/public_html/501/vendors/minphp/db/src/PdoConnection.php(196): PDOStatement->execute(Array) #1 /home/blestau/public_html/501/vendors/minphp/record/src/Record.php(793): Minphp\Db\PdoConnection->query('SELECT COUNT(*)...', Array) #2 /home/blestau/public_html/501/vendors/minphp/record/src/Record.php(892): Minphp\Record\Record->fetch() #3 /home/blestau/public_html/501/app/models/services.php(229): Minphp\Record\Record->numResults() #4 /home/blestau/public_html/501/app/controllers/admin_billing.php(494): Services->getListCount(NULL, 'active', false, NULL, Array) #5 /home/blestau/public_html/501/vendors/minphp/bridge/src/Lib/Dispatcher.php(142): AdminBilling->services() #6 /home/blestau/public_html/501/index.php(21): Dispatcher::dispatch('/501/admin/bill...') #7 {main}
Activity
Paul Phillips
created issue -
Paul Phillips
made changes -
| Field | Original Value | New Value |
|---|---|---|
| Rank | Ranked higher |
| Sprint | 5.1.0 Sprint 3 [ 127 ] |
| Rank | Ranked higher |
| Assignee | Jonathan Reissmueller [ jonathan ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Remaining Estimate | 0 minutes [ 0 ] | |
| Time Spent | 15 minutes [ 900 ] | |
| Worklog Id | 14834 [ 14834 ] |
| Status | In Progress [ 3 ] | In Review [ 5 ] |
| Resolution | Fixed [ 1 ] |
| Status | In Review [ 5 ] | Closed [ 6 ] |
