Thread

On my client site Seoul Selection search is not working correctly.

When someone enters a search they get the message that “your search did not return any results” despite that term being 100% in the system.

My search form is as follows:

{exp:search:simple_form id="search-form"  search_in="everywhere" show_future_entries="yes" weblog="articles|blog|podcast|design-publishing|newsletter" }
            
                <input type="text" name="keywords" id="keywords" value="Search Here" class="txt" size="18" maxlength="100" /> <input type="submit" value="" class="searchbtn" />
            
        {/exp:search:simple_form}

Interestingly when I perform a search logged in as superadmin I see the following error (replaced my ip address with ***):

MySQL ERROR:

Error Number: 1033

Description: Incorrect information in file: ‘exp_search_log.frm’

Query: INSERT INTO `exp_search_log` (`id`, `member_id`, `screen_name`, `ip_address`, `search_date`, `search_type`, `search_terms`, `site_id`) VALUES (’‘, ‘1’, ‘Web Developer’, ‘***.***.***.34’, ‘1274202049’, ‘site’, ‘Joseon Dynasty’, ‘1’)

Sean,

Are you able to visit

CP Home ›  Admin ›  System Preferences ›  Search Term Log Configuration

and here without any error?

CP Home ›  Admin ›  Utilities ›  View Search Term Log

In the latter has anything been logged?

What version and build of EE are you using?
Do you have any extensions installed?

John,

I have no problem going to the first page but the second page brings up this error:

MySQL ERROR:

Error Number: 1033

Description: Incorrect information in file: ‘exp_search_log.frm’

Query: SELECT COUNT(*) as count FROM exp_search_log

Did you change any db or configurations settings recently? That error message points to a somehow corrupted database. Have you tried to repair it yet?

Ingmar,

When I repair the database I get the following message:

exp_search   repair   Error   Incorrect information in file: ‘exp_search.frm’
exp_search   repair   error   Corrupt
exp_search_log   repair   Error   Incorrect information in file: ‘exp_search_log.frm’
exp_search_log   repair   error   Corrupt

I’ve contacted the host about this and am awaiting a response. I haven’t made any changes but maybe they did.

That does sound like a more serious database issue that your host should take care of. I would suggest ASAP as a precaution going ahead and performing a full database export as it stands. Can never be too safe :-D

Keep us posted.

Brandon,

Thanks for confirming that. I have emailed my client to talk to his host (managed dedicated server) about this.

Very good; let us know.

My clients host was unable to fix this and the client has asked me to remove the search bar from the site, but I don’t think he’s happy about this. Is there some other way to fix this?

Sean

Sean, you didn’t mention which version/build of EE you’re on.

Sue,

1.6.8 build 20100121

Sean,

Using phpMyAdmin to have a look at your database. Do you see any rows returned when you browse exp_search_log?

Also a search of Google brings up a lot of posts similar to this and this suggesting permissions on a /tmp folder may be incorrect. Maybe suggest this to your host?

If you switch off search term logging for now doe syour search work as intended?
CP Home ›  Admin ›  System Preferences ›  Search Term Log Configuration

John,

I don’t have access to phpmyadmin

I get the following error when running it with the logging off I get this error:

MySQL ERROR:

Error Number: 1033

Description: Incorrect information in file: ‘./seoulselection/exp_search.frm’

Query: INSERT INTO `exp_search` (`search_id`, `search_date`, `member_id`, `keywords`, `ip_address`, `total_results`, `per_page`, `query`, `custom_fields`, `result_page`, `site_id`) VALUES (‘7dd4a86d2af9af7f34dd51b756f47aa7’, ‘1277797585’, ‘1’, ‘patriots’, ‘116.125.118.34’, ‘4’, ‘50’, ‘s:1616:\“SELECT DISTINCT(t.entry_id), t.entry_id, t.weblog_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.dst_enabled, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.allow_trackbacks, t.sticky, t.entry_date, t.year, t.month, t.day, t.entry_date, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.trackback_total, t.sent_trackbacks, t.recent_trackback_date, t.site_id as entry_site_id,\n w.blog_title, w.blog_name, w.search_results_url, w.search_excerpt, w.blog_url, w.comment_url, w.tb_return_url, w.comment_moderate, w.weblog_html_formatting, w.weblog_allow_img_urls, w.weblog_auto_link_urls, w.enable_trackbacks, w.trackback_use_url_title, w.trackback_field, w.trackback_use_captcha, w.trackback_system_enabled, \n   m.username, m.email, m.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,\n   md.*,\n   wd.*\n   FROM MDBMPREFIXweblog_titles   AS t\n   LEFT JOIN MDBMPREFIXweblogs AS w ON t.weblog_id = w.weblog_id \n   LEFT JOIN MDBMPREFIXweblog_data   AS wd ON t.entry_id = wd.entry_id \n   LEFT JOIN MDBMPREFIXmembers   AS m ON m.member_id = t.author_id \n   LEFT JOIN MDBMPREFIXmember_data   AS md ON md.member_id = m.member_id \n   WHERE t.entry_id IN (157,278,292,293) ORDER BY entry_date desc\”;’, ‘a:16:{s:7:\"article\";a🔢{i:0;s💯\"7\";i:1;s💯\"y\";}s:11:\“page_images\”;a🔢{i:0;s💯\"8\";i:1;s💯\"n\";}s:10:\“newsletter\”;a🔢{i:0;s🔢\"14\";i:1;s💯\"y\";}s:3:\“mp3\”;a🔢{i:0;s🔢\"15\";i:1;s💯\"n\";}s:7:\“pod-pic\”;a🔢{i:0;s🔢\"16\";i:1;s💯\"n\";}s:8:\“keywords\”;a🔢{i:0;s🔢\"18\";i:1;s💯\"n\";}s:14:\“episode_length\”;a🔢{i:0;s🔢\"19\";i:1;s💯\"n\";}s:19:\“episode_description\”;a🔢{i:0;s🔢\"20\";i:1;s💯\"y\";}s:16:\“episode_subtitle\”;a🔢{i:0;s🔢\"21\";i:1;s💯\"n\";}s:12:\“episode_size\”;a🔢{i:0;s🔢\"22\";i:1;s💯\"n\";}s:12:\“episode_name\”;a🔢{i:0;s🔢\"23\";i:1;s💯\"n\";}s:10:\“show_links\”;a🔢{i:0;s🔢\"24\";i:1;s💯\"n\";}s:10:\“post-image\”;a🔢{i:0;s🔢\"26\";i:1;s💯\"n\";}s:11:\“sub_heading\”;a🔢{i:0;s🔢\"31\";i:1;s💯\"n\";}s:10:\“top-credit\”;a🔢{i:0;s🔢\"32\";i:1;s💯\"n\";}s:8:\“dp-entry\”;a🔢{i:0;s🔢\"39\";i:1;s💯\"y\";}}’, ‘search/results’, ‘1’)

Sean, I assume you have FTP access, right?

http://www.phptools4u.com/scripts/eskuel/?lang=english is one tool I use instead of PHPMyAdmin. See it that one will help.