Skip to content

Additional QA testing on routerconfigs sorting #126

Description

@jdcoats

Sorting of "Backup Time" "Last Change" or "Changed By" gives below I think this is related to spaces. because the sort by filename works properly without a space.

2023/01/30 16:29:58 - CMDPHP SQL Backtrace: (/plugins/routerconfigs/router-backups.php[45]:show_devices(), /plugins/routerconfigs/router-backups.php[143]:db_fetch_assoc_prepared(), /lib/database.php[697]:db_execute_prepared())
2023/01/30 16:29:58 - CMDPHP ERROR: A DB Row Failed!, Error: Unknown column 'backup' in 'order clause'

2023/01/30 16:39:01 - CMDPHP SQL Backtrace: (/plugins/routerconfigs/router-backups.php[45]:show_devices(), /plugins/routerconfigs/router-backups.php[143]:db_fetch_assoc_prepared(), /lib/database.php[697]:db_execute_prepared())
2023/01/30 16:39:01 - CMDPHP ERROR: A DB Row Failed!, Error: Unknown column 'change' in 'order clause'

2023/01/30 16:40:15 - CMDPHP SQL Backtrace: (/plugins/routerconfigs/router-backups.php[45]:show_devices(), /plugins/routerconfigs/router-backups.php[143]:db_fetch_assoc_prepared(), /lib/database.php[697]:db_execute_prepared())
2023/01/30 16:40:15 - CMDPHP ERROR: A DB Row Failed!, Error: Unknown column 'change_by' in 'order clause'

additionally, If you go to Devices and click Backups for any device you get no backup found for the filter. No errors thrown.
image
Clear the filter and type in search box it works

image

Additionally on Device tab, try to sort by hostname and this does not work. They are also not sorted Alphabetically or anything not sure what that logic is.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions