Auto-Complete Search not working

Hi @tschak89

Could you give us more info about your installation?
What plugins do you use etc?

Could be a plugin conflict:
https://docs.pods.io/faqs/plugin-theme-conflicts/

Cheers, Jory

hi jory, thx for the quick reply.
i don′t know if there is a plugin conflict since it worked just fine a couple of days ago. here is a full report.

cheers, andreas

### wp-core ###

version: 5.6
site_language: de_DE
user_language: de_DE
timezone: Europe/Vienna
permalink: /%year%/%monthnum%/%day%/%postname%/
https_status: false
multisite: false
user_registration: 1
blog_public: 1
default_comment_status: open
environment_type: production
user_count: 12
dotorg_communication: true

### wp-paths-sizes ###

wordpress_path: /var/www/wordpress
wordpress_size: 51,31 MB (53799870 bytes)
uploads_path: /var/www/wordpress/wp-content/uploads
uploads_size: 11,50 MB (12062669 bytes)
themes_path: /var/www/wordpress/wp-content/themes
themes_size: 2,06 MB (2164408 bytes)
plugins_path: /var/www/wordpress/wp-content/plugins
plugins_size: 156,53 MB (164128485 bytes)
database_size: 39,61 MB (41533440 bytes)
total_size: 261,01 MB (273688872 bytes)

### wp-active-theme ###

name: Hello Elementor (hello-elementor)
version: 2.3.0
author: Elementor Team
author_website: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash
parent_theme: none
theme_features: core-block-patterns, menus, post-thumbnails, automatic-feed-links, title-tag, html5, custom-logo, editor-style, woocommerce, wc-product-gallery-zoom, wc-product-gallery-lightbox, wc-product-gallery-slider
theme_path: /var/www/wordpress/wp-content/themes/hello-elementor
auto_update: Deaktiviert

### wp-themes-inactive (2) ###

Hello Elementor Child: version: 1.0.1, author: Elementor Team, Automatische Aktualisierungen deaktiviert
Twenty Twenty: version: 1.6, author: WordPress-Team, Automatische Aktualisierungen deaktiviert

### wp-mu-plugins (1) ###

Health Check Troubleshooting Mode: author: (undefined), version: 1.7.2

### wp-plugins-active (29) ###

Ajax Search Pro: version: 4.20.2, author: Ernest Marcinko, Automatische Aktualisierungen deaktiviert
bbPress: version: 2.6.6, author: The bbPress Contributors, Automatische Aktualisierungen deaktiviert
bbp style pack: version: 4.7.1, author: Robin Wilson, Automatische Aktualisierungen deaktiviert
BuddyBuilder – BuddyPress Builder for Elementor: version: 1.3.1, author: StaxWP, Automatische Aktualisierungen deaktiviert
BuddyBuilder Pro: version: 1.3.0, author: StaxWP, Automatische Aktualisierungen deaktiviert
BuddyDrive: version: 2.1.2, author: mrpritchett, Automatische Aktualisierungen deaktiviert
BuddyMeet: version: 1.8.0, author: Themis Dakanalis <tdakanalis@cytech,gr>, Automatische Aktualisierungen deaktiviert
BuddyPress: version: 7.0.0, author: The BuddyPress Community, Automatische Aktualisierungen deaktiviert
Elementor: version: 3.0.14, author: Elementor.com, Automatische Aktualisierungen deaktiviert
Elementor Pro: version: 3.0.8, author: Elementor.com, Automatische Aktualisierungen deaktiviert
JetBlog For Elementor: version: 2.2.12, author: Crocoblock, Automatische Aktualisierungen deaktiviert
JetElements For Elementor: version: 2.5.3, author: Crocoblock, Automatische Aktualisierungen deaktiviert
JetEngine: version: 2.6.2, author: Crocoblock, Automatische Aktualisierungen deaktiviert
JetGridBuilder: version: 1.1.0, author: Crocoblock, Automatische Aktualisierungen deaktiviert
JetMenu: version: 2.0.8, author: Crocoblock, Automatische Aktualisierungen deaktiviert
JetSearch For Elementor: version: 2.1.9, author: Crocoblock, Automatische Aktualisierungen deaktiviert
JetThemeCore: version: 1.2.1, author: Crocoblock, Automatische Aktualisierungen deaktiviert
LDAP/Active Directory Login for Intranet sites: version: 23.0, author: miniorange, Automatische Aktualisierungen deaktiviert
LuckyWP Table of Contents: version: 2.1.4, author: LuckyWP, Automatische Aktualisierungen deaktiviert
miniOrange LDAP Buddypress Integration Add-On: version: 1.1, author: miniorange, Automatische Aktualisierungen deaktiviert
NTLM SSO: version: 1.0, author: miniorange, Automatische Aktualisierungen deaktiviert
Pods – Custom Content Types and Fields: version: 2.7.24, author: Pods Framework Team, Automatische Aktualisierungen aktiviert
Posts Table Pro: version: 2.3.1, author: Barn2 Plugins, Automatische Aktualisierungen deaktiviert
Posts Table Pro – EU/AU Date Format: version: 1.1, author: Barn2 Plugins, Automatische Aktualisierungen deaktiviert
PowerPack Pro for Elementor: version: 2.2.1, author: Team IdeaBox – PowerPack Elements, Automatische Aktualisierungen deaktiviert
PublishPress Capabilities: version: 1.10.1, author: PublishPress, Automatische Aktualisierungen deaktiviert
PublishPress Capabilities Pro: version: 1.10.1, author: PublishPress, Automatische Aktualisierungen deaktiviert
PublishPress Permissions Pro: version: 3.4, author: PublishPress, Automatische Aktualisierungen deaktiviert
Require Post Category: version: 2.1, author: Josh Hartman, Automatische Aktualisierungen deaktiviert

### wp-plugins-inactive (12) ###

Admin Columns: version: 4.2.2, author: AdminColumns.com (latest version: 4.2.5), Automatische Aktualisierungen deaktiviert
Akismet Anti-Spam: version: 4.1.7, author: Automattic, Automatische Aktualisierungen deaktiviert
Attachment Taxonomies: version: 1.1.1, author: Felix Arntz, Automatische Aktualisierungen deaktiviert
Classic Editor: version: 1.6, author: WordPress Contributors, Automatische Aktualisierungen deaktiviert
Directory Sync Plugin: version: 1.0, author: miniorange, Automatische Aktualisierungen deaktiviert
Enhanced Media Library: version: 2.8.2, author: wpUXsolutions, Automatische Aktualisierungen deaktiviert
Health Check & Troubleshooting: version: 1.4.5, author: The www.remarpro.com community, Automatische Aktualisierungen deaktiviert
Hello Dolly: version: 1.7.2, author: Matt Mullenweg, Automatische Aktualisierungen deaktiviert
JetSmartFilters: version: 2.0.6, author: Crocoblock, Automatische Aktualisierungen deaktiviert
Max Mega Menu: version: 2.9.2, author: megamenu.com, Automatische Aktualisierungen deaktiviert
Sidebars for Hello Elementor Theme: version: 1.0.0, author: Amer Ali, Automatische Aktualisierungen deaktiviert
View Admin As: version: 1.8.6, author: Jory Hogeveen, Automatische Aktualisierungen deaktiviert

### wp-media ###

image_editor: WP_Image_Editor_GD
imagick_module_version: Nicht verfügbar
imagemagick_version: Nicht verfügbar
file_uploads: File uploads is turned off
post_max_size: 8M
upload_max_filesize: 100M
max_effective_size: 8 MB
max_file_uploads: 20
gd_version: 2.2.5
ghostscript_version: not available

### wp-server ###

server_architecture: Linux 5.4.0-58-generic x86_64
httpd_software: nginx/1.18.0
php_version: 7.4.3 64bit
php_sapi: fpm-fcgi
max_input_variables: 1000
time_limit: 360
memory_limit: 256M
max_input_time: 60
upload_max_filesize: 100M
php_post_max_size: 8M
curl_version: 7.68.0 OpenSSL/1.1.1g
suhosin: false
imagick_availability: false
pretty_permalinks: true

### wp-database ###

extension: mysqli
server_version: 10.3.25-MariaDB-0ubuntu0.20.04.1
client_version: mysqlnd 7.4.3

### wp-constants ###

WP_HOME: https://wordpress.zai.cna.at
WP_SITEURL: https://wordpress.zai.cna.at
WP_CONTENT_DIR: /var/www/wordpress/wp-content
WP_PLUGIN_DIR: /var/www/wordpress/wp-content/plugins
WP_MAX_MEMORY_LIMIT: 256M
WP_DEBUG: true
WP_DEBUG_DISPLAY: false
WP_DEBUG_LOG: wp-errors.log
SCRIPT_DEBUG: false
WP_CACHE: false
CONCATENATE_SCRIPTS: undefined
COMPRESS_SCRIPTS: undefined
COMPRESS_CSS: undefined
WP_LOCAL_DEV: undefined
DB_CHARSET: utf8mb4
DB_COLLATE: undefined

### wp-filesystem ###

wordpress: writable
wp-content: writable
uploads: writable
plugins: writable
themes: writable
mu-plugins: writable

### luckywp-table-of-contents ###

domVersion: 20031129
libxmlVersion: 2.9.10
intlVersion: 7.4.3
icuVersion: 66.1
settings: {“lwptoc_general”:{“min”:”2″,”depth”:”6″,”hierarchical”:true,”numeration”:”none”,”numerationSuffix”:”none”,”title”:”Inhalte”,”toggle”:true,”labelShow”:”Anzeigen”,”labelHide”:”Verbergen”,”hideItems”:false,”smoothScroll”:true,”smoothScrollOffset”:”24″},”lwptoc_appearance”:{“width”:”auto”,”float”:”none”,”titleFontSize”:”default”,”titleFontWeight”:”bold”,”itemsFontSize”:”90%”,”colorScheme”:”light”,”backgroundColor”:null,”borderColor”:null,”titleColor”:null,”linkColor”:null,”hoverLinkColor”:null,”visitedLinkColor”:null},”lwptoc_autoInsert”:{“enable”:false,”position”:”beforefirstheading”,”postTypes”:[“post”]},”lwptoc_processingHeadings”:{“postTypes”:null},”lwptoc_misc”:{“skipHeadingLevel”:null,”skipHeadingText”:null,”hashFormat”:”asheading”,”hashConvertToLowercase”:false,”hashReplaceUnderlinesToDashes”:false,”wrapNoindex”:false,”useNofollow”:false,”showMetaboxPostTypes”:null,”listMarkupTags”:”div”,”containerClass”:null}}

### buddypress ###

version: 7.0.0
active_components: Community Mitglieder, Erweiterte Profile, Aktivit?tsverlauf, Benachrichtigungen, Benutzergruppen
template_pack: BuddyPress Nouveau 7.0.0
! hide-loggedout-adminbar: Ja
! bp-disable-account-deletion: Nein
! bp-disable-avatar-uploads: Ja
! bp-disable-cover-image-uploads: Ja
! bp-disable-profile-sync: Nein
! bp_restrict_group_creation: Ja
! bp-disable-group-avatar-uploads: Ja
! bp-disable-group-cover-image-uploads: Ja
! bp-disable-blogforum-comments: Nein
_bp_enable_heartbeat_refresh: Ja

### pods ###

pods-server-software: nginx/1.18.0
pods-user-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36
pods-session-save-path: /var/lib/php/sessions
pods-session-save-path-exists: Yes
pods-session-save-path-writable: Yes
pods-session-max-lifetime: 1440
pods-opcode-cache-apc: No
pods-opcode-cache-memcached: No
pods-opcode-cache-opcache: Yes
pods-opcode-cache-redis: No
pods-object-cache-apc: No
pods-object-cache-apcu: No
pods-object-cache-memcache: No
pods-object-cache-memcached: No
pods-object-cache-redis: No
pods-memory-current-usage: 30,162M
pods-memory-current-usage-real: 6,000M
pods-network-wide: No
pods-install-location: /var/www/wordpress/wp-content/plugins/pods/
pods-developer: No
pods-tableless-mode: No
pods-light-mode: No
pods-strict: Yes
pods-allow-deprecated: No
pods-api-cache: Yes
pods-shortcode-allow-evaluate-tags: No

`

Hi,
I disabled every plugin except for pods and still the error remained.
I made a screenshot showing that multi-select works fine but somehow auto complete doesn′t. Health check shows 2 errors with the rest api, i don′t know, if they are connected to my problem (see screenshot).

autocomplete pods

has anybody an idea 4 a solution?

best regards,
andreas

Hi @tschak89

This might be some kind of server issue. Do you see any errors in your browser console after you search for relationships in the autocomplete field?

Cheers, Jory

Hi, i am new to all this console stuff, but i tried a bit with Chrome console in tab Network – Preview and there are some responses in admin-ajax.php?pods_ajax=1 followed by a red line with “failed to load response data” – the black lines look like this:

“Database Error; SQL: SELECT DISTINCT t.ID, t.post_title, geschaeftszahl.meta_value AS geschaeftszahl, t.post_type FROM wp1_posts AS t LEFT JOIN wp1_postmeta AS geschaeftszahl ON geschaeftszahl.meta_key = ‘geschaeftszahl’ AND geschaeftszahl.post_id = t.ID WHERE ( ( t.post_status IN ( “publish” ) ) AND ( t.geschaeftszahl LIKE ‘%BMASGK%’ OR t.post_title LIKE ‘%BMASGK%’ OR t.post_name LIKE ‘%BMASGK%’ OR t.post_content LIKE ‘%BMASGK%’ OR t.post_excerpt LIKE ‘%BMASGK%’ ) AND ( t.post_type = “erlaesse” ) ) ORDER BY (t.geschaeftszahl LIKE ‘%BMASGK%’ ) DESC, t.geschaeftszahl, t.ID, t.menu_order, t.post_title, t.post_date LIMIT 0, 15; Response: Unknown column ‘t.geschaeftszahl’ in ‘where clause'”

I understand that there is something wrong with the function “Display Field in Selection ListProvide the name of a field on the related object to reference, example: {@post_title}”, because when i leave that field empty it works. But thats the problem i want to use another custom field and they don′t work.

what is the correct syntax for that field? because i had just the name of the field and it worked, is the correct syntax “{@posttype_fieldname}”?

Cheers Andreas

• This reply was modified 3 years, 11 months ago by tschak89.

Hi @tschak89

Ah right, now I get the issue ??

You could try {@field_name.meta_value} but I believe only WP core object fields are supported, you should try it though.

Cheers, Jory

Thx @keraweb for your support so far, but i fear that i need your help or from the community once more:

What do you mean by .meta_value? The custom field i want to display is a plain text field. the bi-directional relationship is within the same pod.

I don′t think that only wp_core object are supported, bc i am pretty sure everything worked just fine a week or so ago, when the display field in selection list value was just the plain field name.

greets, Andreas

Hi @tschak89

I’m sorry, just tested this locally and just using the field name should work fine.
Please file a complete bug report so we can try to reproduce your issue and provide a patch:
https://github.com/pods-framework/pods/issues/new?template=bug_report.md

Cheers, Jory