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}
