Search returns “Nothing Found” on a sub directory

Ok, well this is not exactly to do with subdirectories as such, but there is something mixing up the queries between the subsites…

As you can see the error is saying wp_posts.post_title is not found – because the table selected is actually FROM wp_2_posts… showing the different table prefixes for site 1 wp_ and site 2 wp_2_… so one will not be found within the other.

It could be the form action destination perhaps, try replacing home_url("https://wordpress.stackexchange.com/") with get_site_url(null, "https://wordpress.stackexchange.com/"), and hopefully the search form will post to the correct site. Not sure if that will fix it though.

Otherwise it could be a plugin that doesn’t support multisite messing up the search query somehow by not using $wpdb->prefix instead of wp_ when creating the query. If that’s the case try disabling any plugins that might be doing that…

Related Posts:

  1. find a random blogid across my multisite network that has at least one post published
  2. Built to scale, or worry later?
  3. BP Multi Network & Members Directory [closed]
  4. SQL Query to Get list of all users along with their blogs
  5. Multisite Installation: how do I setup global search?
  6. Using $wpdb Class to Pull Recent Comments Across a Network
  7. Creating a better multi-site search experience
  8. Split a database will improve performance?
  9. Global searchin multisite but only with one subsite
  10. Make WordPress Search for Both Main Domain and Subdomain
  11. Multi Site Search Pagination is Broken
  12. Within the database, where is the flag which says that a user has Super Admin rights?
  13. Performance on WPMS
  14. Bulk activate a theme on multisite
  15. Removing a wordpress multisite installation and preserving the database before migrate to nginx
  16. Database Tables Lost Indexes? How to Recover?
  17. Pushing stored procedure to a multisite database in WordPress
  18. Query to import data from one MultiSite table to another (pages/sub-pages)
  19. How can I use WP_Site_Query to find a blog by blog name?
  20. Will changing the folder name two directories above a fresh wordpress installation break the site?
  21. Obtaining user table for one site on multisite set up
  22. new multisite, old db
  23. Renaming admin user on multisite install by MySQL
  24. Set up Network Locally on a Flash Drive
  25. Delete all user’s meta without knowing all the ‘key’
  26. WP MultiSite: Can’t select database error after changing to new domain
  27. add_blog_option blog ID
  28. How to unindex a single blog in Multisite?
  29. How to create a blogs category page with Blog-Types Plugin
  30. Can I use the main Multisite as a backend only?
  31. How To Upload Existing WordPress Site To WordPress Multisite Using SSH
  32. WordPress Multisite with thousands of blog
  33. Get multisite count without php?
  34. WordPress and SQL – Update and Insert from another table if column value doesn’t exist
  35. MySql Database In WordPress Multisite
  36. Multisite Tables the same as Single Install?
  37. Plugin data shared in Multisite
  38. Merging versions of wp_posts based on post_title
  39. Is there a full explanation on how to share a database with two WordPress sites on same server?
  40. Too much slow queries with my multisite
  41. Multisite: merging two subsites in the main site
  42. How to use WordPress Multisite With Different Domain Names?
  43. How To Add Custom Form Fields To The User Profile Page?
  44. Where are available Roles Defined in the wp_ database?
  45. restore_current_blog() vs switch_to_blog()
  46. Can i merge 2 new WP_Query($variable) ‘s?
  47. How to disable a network enabled plugin for just one site?
  48. How to reliably flush rewrite rules on multisite?
  49. Site Redirecting to wp-signup.php
  50. Moving a WP Multisite to a subdirectory
  51. Cookies in multisite where network sites have their own domain name
  52. Convert a Multisite WordPress install into a Single site
  53. WordPress MultiSite Active Directory integration and site privacy
  54. WordPress Job Interview Preparation
  55. How to add Custom Blog Options to new blog setup form?
  56. How can I trust switch_to_blog()?
  57. Remove the blog slug from WordPress Multisite root node
  58. Why are my roles not visible in a Multi-site/Network?
  59. Site admin in a network install can’t edit users?
  60. How to use same email for multiple users
  61. How to run an activation function when plugin is network activated on multisite?
  62. Specific upload folder for PDFs in custom Post type in WP multisite
  63. What is the correct way to map multiple domains in a WordPress 4.1 multisite install?
  64. Where can I find documentation on what characters are allowed in user names and why?
  65. How to migrate subsite from dev multisite to production multisite
  66. How can I un-reserve a pending username registration?
  67. How do I remove/delete an old super admin user?
  68. DB connection error after copying a WordPress Multisite instance to a second location
  69. Redirect Main Site to Subsite in Multisite WordPress
  70. Is there a is_user_logged_in() for multisite?
  71. Switching MultiSite installation from HTTP to HTTPS
  72. Allow user to select a theme to install when they signup
  73. Setting up a wordpress network with third level domains
  74. Get upload URL by blog ID in multisite
  75. What’s the difference between get_site_option and get_blog_option?
  76. Need help sorting “My Sites” Alphabetically
  77. How to delete post revisions?
  78. Create mobile site with same content just different theme
  79. Add additional Network constants to wp-config.php dynamically
  80. Multisite stuck at 1MB for max file size
  81. How to get blog name, when using WordPress Multisite
  82. What are options are there to implement a multi language site
  83. Switching primary site in WordPress Multisite
  84. Multisite Network Port Num Issues?
  85. Convert existing site to network
  86. Where is the robots.txt stored for a WordPress Multisite install?
  87. Settings API in Multisite – Missing update message
  88. Add WordPress MU Network Admin via Database
  89. How to get current site id? (WPMU)
  90. Multisite on Windows with wildcard subdomains
  91. Why is WordPress Multisite redirecting to wp-signup.php and how to fix it?
  92. Which asset URLs are acceptable in a “vanilla” MU install?
  93. $wpdb->base_prefix not get parent site prefix in multisite
  94. How to tell which database tables belongs to which multisite site
  95. what are pmxi tables? [closed]
  96. Using wp_insert_post() with Networking enabled
  97. Are nested subdomains possible with a subdomain multisite?
  98. Sharing Dynamic Sidebars across Multisite Blogs
  99. I want to develop locally with Multisite, then migrate each site to separate remote WP installs
  100. Password Reset for Users on a Multisite Subsite
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)