When I try to create a view using a tested and working LDAP Query located in /admin/config/people/ldap/query

I get the following

under fields it says Broken / missing handler

and in the view UI it says
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM ldap_query_entity ldap_query_entity LIMIT 11 OFFSET 0' at line 1: SELECT FROM {ldap_query_entity} ldap_query_entity LIMIT 11 OFFSET 0; Array ( )

If I try and go the view page I get "The website encountered an unexpected error. Please try again later."

And in error reports in then says
Drupal\Core\Database\DatabaseExceptionWrapper: Exception in test[test]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM ldap_query_entity ldap_query_entity LIMIT 11 OFFSET 0' at line 1: SELECT FROM {ldap_query_entity} ldap_query_entity LIMIT 11 OFFSET 0; Array ( ) in Drupal\views\Plugin\views\query\Sql->execute() (line 1488 of /data/www-root/kingkong/core/modules/views/src/Plugin/views/query/Sql.php).

Any advise would be appreciated.

Comments

mrdrill created an issue. See original summary.

grahl’s picture

grahl
he/him
Location Zürich
CreditAttribution: grahl as a volunteer commented
Assigned: Unassigned » grahl
Category: Support request » Bug report
Priority: Normal » Major

ldap_views is still marked as partially ported but the current state is currently less than easily usable. I'll reprioritize ldap_views, expect another beta in a week or two with at least improvements to this.

mrdrill’s picture

mrdrill CreditAttribution: mrdrill commented

Thank you for your response and hard work, will keep my eye out for the next beta.

  • grahl committed 48d8875 on 8.x-3.x 
    Issue #2876076 by grahl: Broken/missing handler when creating view with...
grahl’s picture

grahl
he/him
Location Zürich
CreditAttribution: grahl as a volunteer commented

This took a bit longer than expected. Partial port available in DEV, filters/sort not yet available. ldap_views was moved into ldap_query and removed.

  • grahl committed a2eee2d on 8.x-3.x 
    Issue #2876076 by grahl: Broken/missing handler when creating view with...
grahl’s picture

grahl
he/him
Location Zürich
CreditAttribution: grahl as a volunteer commented
Status: Active » Fixed
Related issues: +#2887127: Ldap Query Views does not handle filter groups

Okay, so DEV is now in fairly good shape and should solve most users' issues, though testing with a limited dataset is a bit unreliable here.

Please file separate issues if you encounter follow-up issues with the Views integration.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.