Author Topic: Duplicate check Query Empty Error (Read 1007 times)

bchoc · January 27, 2008, 02:43:30 pm

I'm importing data into a fresh CiviCRM 1.9 install. Trying to run the duplicate check, I end up with this:

     Sorry. A non-recoverable error has occurred.

    Database Error Code: Query was empty, 1065

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] =>  [nativecode=1065 ** Query was empty]
    [type] => DB_Error
    [user_info] =>  [nativecode=1065 ** Query was empty]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info=" [nativecode=1065 ** Query was empty]"]
)

So far, this install has been configured, synced with Drupal, and some email addresses imported. I tried to import some individuals and that's when I noticed duplicate checking was failing.

bc
[/code]

bchoc · January 30, 2008, 05:48:23 pm

After poking around, I managed to answer my own question.

I thought I'd post it here in case anyone else is curious.

The 1.9 duplicate check will die if any of the rules references a field empty for all records. In my case, I'd just imported some email lists with no names. Since the default rules include first/last name, the duplicate check freaked out at my email-only database. I removed first/last name from the rules and it ran without a hitch.

I verified this is still the case in the Alpha 2.0 sandbox, so I posted a bug report:
http://issues.civicrm.org/jira/browse/CRM-2604

Brian

CiviCRM Community Forums (archive)

News:

Author Topic: Duplicate check Query Empty Error (Read 1007 times)

bchoc

Duplicate check Query Empty Error

bchoc

Re: Duplicate check Query Empty Error