Hi,

I have some trouble to configure LDAP query module.

The error message is,

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drupal-og.ldap_query' doesn't exist: SELECT t__0.* FROM {ldap_query} t__0; Array ( ) in ctools_export_load_object()

How can I solve this problem?

Comments

johnbarclay’s picture

johnbarclay commented
Component: SimpleTests » Code
Status: Active » Postponed (maintainer needs more info)

What urls/paths do you go through before and when you get this error?

noah’s picture

noah commented

I'm not the OP, but I see this error whenever I visit admin/config/people/ldap/query. I've been through all of the LDAP config screens at one point or another before seeing this.

johnbarclay’s picture

johnbarclay commented
Category: support » bug
Status: Postponed (maintainer needs more info) » Active

I'll mark this as a bug and get back to you on it. Can you have the OP uninstall ldap_query and ldap_og and reinstall them?

noah’s picture

noah commented

I'm not running ldap_og, but I confirmed that for some reason the ldap_query table wasn't created when I installed the ldap_query module. I disabled the module (it didn't show up in the "Uninstall" list, presumably because the table didn't exist), then re-enabled the module, and the table was generated. It seems fine now.

Unfortunately I didn't notice if there was an error when I first installed it (when the table wasn't created), so I can't provide any more info than just "the table wasn't created". Disabling and re-enabling was an easy fix, though.

johnbarclay’s picture

johnbarclay commented
Title: Base table or view not found in Queries Tab » LDAP Query: Base table or view not found in Queries Tab on initial module enable, but created after reinstall
Assigned: Unassigned » johnbarclay
Priority: Normal » Minor
johnbarclay’s picture

johnbarclay commented
Status: Active » Closed (cannot reproduce)

I've installed and uninstalled ldap query several times over the last couple weeks and have not been able to reproduce this. I'm going to close this. If anyone finds this problem again, reopen this issue.

bpadaria’s picture

bpadaria commented
Issue summary: View changes

Thanks for posting fix noah.

Disabling and re-enabling Ldap query fixed the issue for me as well.