CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Error in Full-Text Search
Pages: [1] 2

Author Topic: Error in Full-Text Search  (Read 3803 times)

vshura

  • I post occasionally
  • **
  • Posts: 59
  • Karma: 1
  • CiviCRM version: 4.6.0
  • CMS version: Wordpress 4.1.1
Error in Full-Text Search
June 05, 2009, 07:49:51 am
Hi.

I couldn't see this mentioned anywhere or a bug report for it.

There seems to be an error in the full-text search in 2.2.5 on drupal.  I get the error both on my own installation and on the drupal demo site.  

Whenever I enter any text in the full-text search box and hit 'Go' I get the following:

Code: [Select]
Sorry. A non-recoverable error has occurred.

Could not get details for custom search.

Return to home page.

The backtrace code for the demo is:

Code: [Select]
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/Core/Error.php, backtrace, 258
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/Contact/Form/Search/Custom.php, fatal, 54
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/Core/Form.php, preProcess, 312
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/Core/QuickForm/Action/Display.php, buildForm, 98
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/Core/Controller.php, handle, 245
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/CRM/Core/Invoke.php, run, 205
/var/www/drupal-6.civicrm.org/public/sites/drupal.demo.civicrm.org/modules/civicrm/drupal/civicrm.module, invoke, 342
, civicrm_invoke,
/var/www/drupal-6.civicrm.org/public/includes/menu.inc, call_user_func_array, 348
/var/www/drupal-6.civicrm.org/public/index.php, menu_execute_active_handler, 18

The full-text search is a great idea, good to see it there. Hopefully it'll be working soon.

x
VS

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Error in Full-Text Search
June 05, 2009, 09:23:54 am
Full-text search is a "custom search" and needs to be registered under Administer CiviCRM >> Manage Custom Searches.  The 2.2.3+ upgrade scripts should have added that to your site automatically, so not sure why that didn't happen (did you run the upgrade script?).

On demo, the DB is reset periodically and evidently the saved copy doesn't have the necessary entry in it. I've added it back in on demo.

You can manually fix the problem on your site by clicking New Custom Search and entering CRM_Contact_Form_Search_Custom_FullText as the Custom Search Path, Full-text Search as the Search Title.

However, if you have upgraded the codebase files on your site w/o running the upgrade script, I would read / follow the upgrade instructions here:
http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrade+Drupal+Sites+to+2.2
« Last Edit: June 05, 2009, 09:27:12 am by Dave Greenberg »
Protect your investment in CiviCRM by  becoming a Member!

vshura

  • I post occasionally
  • **
  • Posts: 59
  • Karma: 1
  • CiviCRM version: 4.6.0
  • CMS version: Wordpress 4.1.1
Re: Error in Full-Text Search
June 05, 2009, 09:40:31 am
Quote from: Dave Greenberg on June 05, 2009, 09:23:54 am
Full-text search is a "custom search" and needs to be registered under Administer CiviCRM >> Manage Custom Searches.  The 2.2.3+ upgrade scripts should have added that to your site automatically, so not sure why that didn't happen (did you run the upgrade script?).


Actually, I did get the following when I ran the script:

Code: [Select]
Your database has already been upgraded to CiviCRM 2.2.5
despite the fact that I was updating from 2.2.2 and followed instructions exactly.  (This also happened when I updated previous from 2.2.0 to 2.2.2.)  Have you any ideas what's happening here?

Quote
On demo, the DB is reset periodically and evidently the saved copy doesn't have the necessary entry in it. I've added it back in on demo.

You can manually fix the problem on your site by clicking New Custom Search and entering CRM_Contact_Form_Search_Custom_FullText as the Custom Search Path, Full-text Search as the Search Title.

However, if you have upgraded the codebase files on your site w/o running the upgrade script, I would read / follow the upgrade instructions here:
http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrade+Drupal+Sites+to+2.2

I'll try manually fixing the problem, as you suggest.

Thanks,
VS.

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Error in Full-Text Search
June 05, 2009, 10:13:20 am
Not sure what's happening on your site, but this is how the upgrade script determines what needs to happen:

* When you download a new version and untar it, it includes a new instance of the file civicrm-version.txt in the root directory of the codebase. This contains the version of the code you've just downloaded. For 2.2.5 the contents are:

Code: [Select]
2.2.5 Drupal PHP5 21546
* The current version of your DB is stored in the civicrm_domain table - version column.

The upgrade compares the two versions and determines what incremental steps are needed to get your DB to the latest (downloaded) revision. The upgrade script should update civicrm_domain.version with the new version number.

NOTE: If you are updating your site from SVN rather than downloading tarballs - you need to manually update the civicrm-version.txt file since it is generated by the distribution scripts - and not part of the SVN repository.

HTH.
Protect your investment in CiviCRM by  becoming a Member!

vshura

  • I post occasionally
  • **
  • Posts: 59
  • Karma: 1
  • CiviCRM version: 4.6.0
  • CMS version: Wordpress 4.1.1
Re: Error in Full-Text Search
June 08, 2009, 10:02:19 am
Hi Dave.

Thanks for that.  This means there's something odd going on with my database.  The contents of civicrm-version-txt is

Code: [Select]
2.2.5 Drupal PHP5 21546
but when I look in the civicrm_doman table the number under version is
Code: [Select]
2.11
I update by downloading tarballs.  Don't think it should make any difference, but I untar them on my local computer, delete the old online content and then upload the files, rather than uploading them and then untarring them as per instructions.  I don't use SVN (which I'm guessing means using some automatic software version number software?).

Any ideas what's going on here?  I've had at least two instances now of the structures of tables and scripts not being updated when I upgrade in the past while...

Thanks,
VS.

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Error in Full-Text Search
June 08, 2009, 04:06:17 pm
VS - no idea what's going on there :-(

If you're pretty sure what version your DB state represents, I guess you could experiment on a test copy of that DB:
- set civicrm_domain.version to that value (e.g. 2.2.2 for example)
- run the upgrade
- review civicrm_domain.version to verify that has been updated to 2.2.5
- dump the structure of the upgraded site and compare it to pristine 2.2.5 install dump - the DB Tools utility developed by Dharmatech might help you verify the integrity / state of your upgraded DB as well - http://wiki.civicrm.org/confluence/display/CRMDOC/Database+Troubleshooting+Tools

« Last Edit: June 08, 2009, 04:09:26 pm by Dave Greenberg »
Protect your investment in CiviCRM by  becoming a Member!

vshura

  • I post occasionally
  • **
  • Posts: 59
  • Karma: 1
  • CiviCRM version: 4.6.0
  • CMS version: Wordpress 4.1.1
Re: Error in Full-Text Search
June 09, 2009, 07:19:51 am
Great, thanks Dave.

Will try that out.

VS.

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Error in Full-Text Search
June 10, 2009, 02:46:16 pm
Getting error msg on the demo site when i try full-text search  :-\
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Error in Full-Text Search
June 10, 2009, 02:48:46 pm
Manually added CRM_Contact_Form_Search_Custom_FullText back in as a Custom Search
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Error in Full-Text Search
June 10, 2009, 03:10:20 pm
So when I run a search on a site using 2.2.3 I don't get Memberships or Contributions returned, on a 2.2.5 site I do. Were there changes between the two releases, or does this suggest problems with the 2.2.3 site (which is a test site of a major upgrade from 2.0 to 2.2)
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Error in Full-Text Search
June 10, 2009, 08:53:31 pm
Above statement may be wrong. Or I may just be unsure about the intention of what the search will show.

If I run a search for with a unique name of someone who is a paid up member, I get a result that only lists Activities, within which it shows

Membership Signup   Individual - Waged - - Status: Grace      Graeme XXX         View
Membership Renewal   Individual - Waged - Online...      Graeme XXX         View
Contribution   $ 10.00 - Offline membership renewal...      Graeme XXX         View

but there are no results box for Contributions/Membership - and if I limit the search to 'Memberships' the above person is not returned in any way shape or form though the person clearly has a Membership.

If I search for my name (as an Admin person), then I see the following 'blocks'
- Activities
- Contributions (where Davis is only listed in the Source column eg Offline membership renewal (by Peter Davis))

In fact all the results that I get in Activities are Contributions - and repeat what I see in the Contributions section.
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Error in Full-Text Search
June 11, 2009, 06:20:01 pm
I confirmed this one the 2.2 demo - searching for Memberships w/ 'Zope' - I don't get results even though I know there's a membership record for Paula Zope.

Please go ahead a file a bug report on this. thx!
Protect your investment in CiviCRM by  becoming a Member!

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Error in Full-Text Search
June 11, 2009, 07:37:25 pm
Sure 0 http://issues.civicrm.org/jira/browse/CRM-4624
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Error in Full-Text Search
June 15, 2009, 02:29:56 am
Dave - i see the ticket is 'fixed' = can I QA this on demo or sandbox?
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Error in Full-Text Search
June 15, 2009, 10:48:17 am
The fix is in 2.3. I've updated sandbox and did a quick check and it seems to be picking up memberships. So give it a whirl and post a comment to the issue if you find any problems.
Protect your investment in CiviCRM by  becoming a Member!

Pages: [1] 2
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Error in Full-Text Search

This forum was archived on 2017-11-26.