Repository navigation
QueryBuilder output columns incorrect #48521
Description
⚠️ This issue respects the following points: ⚠️
- This is a bug, not a question or a configuration/webserver/proxy issue.
- This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
- Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
- I agree to follow Nextcloud's Code of Conduct.
Bug description
Use master
Steps to reproduce
- Use master
- try to update your SSE password
"File": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"Line": 217,
"message": "More than 30 characters for an output column name are not allowed on Oracle.",
"query": "SELECT `c`.*, `r`.`id` as `node_rel_id`, `r`.`node_id`, `r`.`node_type`, `r`.`permissions`, `p`.`id` as `page_id`, `p`.`page_type`, `pc`.`id` as `content_id`, `pc`.`order`, `n`.`display_mode` as `display_mode_default`, `s`.`id` as `share_id`, `s`.`receiver`, `s`.`receiver_type`, `n2`.`display_mode` FROM `*PREFIX*tables_contexts_context` `c` LEFT JOIN `*PREFIX*tables_shares` `s` ON (`c`.`id` = `s`.`node_id`) AND (`s`.`node_type` = :dcValue6) AND ((`s`.`sender` = :dcValue1) OR ((`s`.`receiver_type` = :dcValue2) AND (`s`.`receiver` = :dcValue3)) OR ((`s`.`receiver_type` = :dcValue4) AND (`s`.`receiver` IN (:dcValue5)))) LEFT JOIN `*PREFIX*tables_contexts_page` `p` ON `c`.`id` = `p`.`context_id` LEFT JOIN `*PREFIX*tables_contexts_rel_context_node` `r` ON `c`.`id` = `r`.`context_id` LEFT JOIN `*PREFIX*tables_contexts_navigation` `n2` ON (`s`.`id` = `n2`.`share_id`) AND (`n2`.`user_id` = :dcValue8) LEFT JOIN `*PREFIX*tables_contexts_navigation` `n` ON (`s`.`id` = `n`.`share_id`) AND (`n`.`user_id` = :dcValue9) LEFT JOIN `*PREFIX*tables_contexts_page_content` `pc` ON `p`.`id` = `pc`.`page_id` WHERE ((`owner_id` = :dcValue7) OR (`s`.`receiver` IS NOT NULL)) AND ((`pc`.`node_rel_id` = `r`.`id`) OR (`pc`.`node_rel_id` IS NULL)) ORDER BY `pc`.`order` ASC",
"columns": [
"display_mode as display_mode_default"
],
Expected behavior
No error.
Nextcloud Server version
master
Operating system
None
PHP engine version
None
Web server
None
Database engine version
None
Is this bug present after an update or on a fresh install?
None
Are you using the Nextcloud Server Encryption module?
None
What user-backends are you using?
- Default user-backend (database)
- LDAP/ Active Directory
- SSO - SAML
- Other
Configuration report
No response
List of activated Apps
No response
Nextcloud Signing status
No response
Nextcloud Logs
No response
Additional info
No response
Activity
[-][Bug]: encryption app: More than 30 characters for an output column name are not allowed[/-][+]More than 30 characters for an output column name are not allowed[/+]provokateurin commentedon Oct 2, 2024
The column length is actually fine, just the error is wrong as it includes the whole
... as ...and not just the real column name which is only the last part.[-]More than 30 characters for an output column name are not allowed[/-][+]QueryBuilder output columns incorrect[/+]