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. Where are available Roles Defined in the wp_ database?
  42. How do I transition multiple installations to a single Multisite installation?
  43. Give to site admin the option to “skip confirmation email” when adding new user
  44. WP Multisite: Adding pages on blog creation by default
  45. Generate a user list per site to communicate upgrade plans
  46. Get all terms inside a specific taxonomy in a multisite
  47. Getting a blog language (site “lang_id” field vs the WPLANG setting)
  48. wp-admin slow in multisite
  49. Subdomain multisite gives 404 on sub sites
  50. Add New Sub Site from the WordPress back end then in sub site options table option_value must be with https
  51. WordPress Multisite – is it possible to put the main site in a subdirectory?
  52. W3 Total Cache – How to disable “Performance” menu under multisite? [closed]
  53. Multisite without .htaccess
  54. How to prevent first post and first comment on WP MU?
  55. Multisite installation on IIS gives 404 trying to access the admin dashboard
  56. Is Partial SSL Possible? ( multisite )
  57. In Multisite “Sites” list, what do “deactivate” and “archive” really do?
  58. Why does the My Site dropdown show only a single domain?
  59. Display site administrator’s id by current blog id inside link
  60. Switch MultiSite main site with another (multilingual sites) – with subfolder – no subdomain
  61. WordPress Multisite’s in subdirectory not redirecting to dashboard settings
  62. Multisite: How can I have the admin bar (toolbar) use the language of the user instead of the language of the sub-site being viewed?
  63. Multisite install on subdomain w/ subdomains change siteURL
  64. Make uploads live outside of the WP folder
  65. Multi-Site Subfolder User Permission Issue
  66. why there is a large file named core in wpmu’s directory?
  67. WordPress multi-site, developing locally and syncing live changes
  68. wp_get_attachment_image_src on multisite
  69. Problem with parked domain for my mutisite
  70. Error : Cookies are blocked or not supported by your browser
  71. How To Run Multiple Multi-Site Networks On Same Box [closed]
  72. Changed sub-site to its own domain trigger 302 redirects for all page links
  73. Page Builders and WP Multisite
  74. Which is the correct way to migrate content from single WP to WP multisite
  75. How to have one installation at blog.example.com and multiple blogs in sub folders such as blog.example.com/userA?
  76. Is a multisite install what I need?
  77. Infamous admin login redirect
  78. Create link preview for theme wordpress
  79. Bitnami multisite change URL of secondary blog
  80. Domain not redirected correctly with WordPress Multisite
  81. No debug log for WP multisite is created
  82. How to show theme on front end before sign up for multisite
  83. How to connect existing subdomains to new wordpress multisite?
  84. WordPress Multisite with cPanel Addon Domains and SSL
  85. Multisites with different root directory
  86. Using www along with non-www for main domain in multisite installation
  87. Multisite “Skip Confirmation Email” Log Out Problem
  88. Page Template Dropdown – Missing In WordPress MultiSite
  89. How can I display all Multisite blogs where this user is administrator?
  90. Multisite and users being listed on network administration dashboard and not main site dashboard
  91. How to remove index.php from a tag or archive page URL in the root blog?
  92. Post migration from one site to another site in a network
  93. Multisite Primary Domain Broken All Subsites Work
  94. FromName –> ReplyTo Name wordpress multisite contact form
  95. Using WordPress multisite is there a way to force HTTPS on specific subsites and not others?
  96. WordPress Multisite Medial Library not working for .online domain
  97. Make multisite non-existing subdomains go to homepage instead of Index of/ page
  98. Development time to Install and Configure WPML (https://wpml.org/) [closed]
  99. WordPress Multisite Network – Site Administrators Can’t Access wp-admin
  100. Multisite, but wp_kses_allowed_html only for one subsite?