Jump to content

Archived

This topic is now archived and is closed to further replies.

balfred1345

Search throws deprecated and database error messages

Recommended Posts

balfred1345

Hi, 

 

I updated to latest DMS yesterday, and am on WP 4.0.1.

 

I'm testing a site prior to launch, and when I attempted to search the site I got this message:

 

Notice: like_escape is deprecated since version 4.0! Use wpdb::esc_like() instead. in /home/videoh6/public_html/cidev1.com/wp-includes/functions.php on line 3201

WordPress database error: [Subquery returns more than 1 row]
SELECT post_id from wpCiDev1_postmeta where meta_key = 'pl-settings' and meta_value LIKE concat( '%', ( SELECT uid FROM wpCiDev1_pl_data_sections WHERE live LIKE '%frames%' order by id DESC ), '%')

 

This happens with all plugins off except for PL plugins.

Could you please tell me what I need to do to fix the search functionality?

 

Here's the URL to the site: http://whub34.webhostinghub.com/~videoh6/cidev1.com

 

Thanks,

Bruce

Share this post


Link to post
Share on other sites
Danny

HI Bruce,

 

That is a notice, simply configure WP_DEBUG to false, instead of true.


Please search our forums, before posting!

Share this post


Link to post
Share on other sites
balfred1345

Hi,

 

OK, I'll disregard the notice.

 

Nonetheless, "search" still doesn't work. Is there a way to get the search function to work?

 

Thanks,

Bruce

 

Share this post


Link to post
Share on other sites
Danny

Search does work, I have just this moment used it on my test site with WP_DEBUG set to true, I too receive the notice but search still works. Please set WP_DEBUG to false, you still have it set to true.

 

Also, if all your sites content is created using sections and not the WordPress post/page content editor, then you will need to enable Enhanced search in the DMS Pro Tools plugin.


Please search our forums, before posting!

Share this post


Link to post
Share on other sites
balfred1345

Hi,

 

Thanks for the response.

 

I do have Enhanced Search checked to be on: http://screencast.com/t/GYiotG5ruN

But, search only shows up for WordPress page content: http://screencast.com/t/mXl9Iasefr

 

I searched for "frames" which is mentioned many times through the site, but search only returned one result which is from WP page content. NextBox, Textbox etc are not returning results. 

 

WP_Debug is set to false. 

 

Any help on getting search to work, would of course be appreciated!

 

Thanks,

Bruce

Share this post


Link to post
Share on other sites
Simon

The section you are searching in HAS to be in the page or post 'locally' not part of a template in any way. The plugin only searches for pagelines settings at the post level then returns the post ID.

 

If the section settings are saved by way of a temple, or type then it simply wont work.

 

There is no 'fix' for it.

 

Search engines will pick up the content, if its text because they ONLY see text.

Share this post


Link to post
Share on other sites

  • Similar Content

    • John Olsson
      By John Olsson+
      Hello, i'm working on a webshop, and got this code to really boost the search within WP. But when adding this code to functions.php the front end media library search flipped totally, and not working at all, any ideas what's the problem?
      function atom_search_where($where){ global $wpdb; if (is_search()) $where .= "OR (t.name LIKE '%".get_search_query()."%' AND {$wpdb->posts}.post_status = 'publish')"; return $where; } function atom_search_join($join){ global $wpdb; if (is_search()) $join .= "LEFT JOIN {$wpdb->term_relationships} tr ON {$wpdb->posts}.ID = tr.object_id INNER JOIN {$wpdb->term_taxonomy} tt ON tt.term_taxonomy_id=tr.term_taxonomy_id INNER JOIN {$wpdb->terms} t ON t.term_id = tt.term_id"; return $join; } function atom_search_groupby($groupby){ global $wpdb; // we need to group on post ID $groupby_id = "{$wpdb->posts}.ID"; if(!is_search() || strpos($groupby, $groupby_id) !== false) return $groupby; // groupby was empty, use ours if(!strlen(trim($groupby))) return $groupby_id; // wasn't empty, append ours return $groupby.", ".$groupby_id; } add_filter('posts_where','atom_search_where'); add_filter('posts_join', 'atom_search_join'); add_filter('posts_groupby', 'atom_search_groupby');  
    • Queue-it
      By Queue-it+
      HI,
      Search function doesn't seem to work. 
      When ever searching for something it redirect to the home page and add the search string to the url.
      For example searching for "cases" it would display https://queue-it.com/?s=cases
      Do you know how to solve that? 
    • Lisa Haran
      By Lisa Haran+
      Hi 
      I have a map here http://www.iloveoffset.com/maps/
      I want to add several pointer locations to the map, but when I do they do not appear.
      On this map there are 2 pointer locations and as you can there is only one visible.
      Earlier today I added 7 and could only see 4 so there is something odd going on.
      My theme is up to date
    • MissT
      By MissT+
      Would be great to have the ability to include a search option within menus and within Splashup - is this possible?
    • balfred1345
      By balfred1345
      null When I tested Search using the search field in Navi, it throws the error as shown in pastebin: http://pastebin.com/DJ079bmy
      Is there a fix for this? If there is no fix, can you please tell me how to disable search in Navi?
      Thanks,
      Bruce
×