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 »
  • Using Import (Moderator: Yashodha Chaku) »
  • Can't search all members after import
Pages: [1]

Author Topic: Can't search all members after import  (Read 2542 times)

airwaves

  • I post occasionally
  • **
  • Posts: 40
  • Karma: 1
Can't search all members after import
October 10, 2009, 12:54:52 pm
Hi there,

I can't search all members anymore after import of 90 contacts.
When I want to make a group of all members in civi I put the cursor in the search box (upper left) and hit enter.
Normaly civi gives the whole list of all members/indu/organisation, but after the import it is broken.

I get an error:

Sorry. A non-recoverable error has occurred.
Could not find valid Key
Return to home page.

Before the import it worked fine.

The import csv is realy straight forward.

firstname, lastname, email and dob.
It are only 90 record and import proces is without any errors.

I checked the csv file and it is normal UTF-8 coded.
Strange thing is, when I search for a member that has just been imported, civi vinds it and I can edit the contact.


I'm using:

Joomla 1.5.14
PHP 5.2.6
MySQL 5.0.45
Civi 3.0.1 (Problem is also in 3.0)


Edwin

airwaves

  • I post occasionally
  • **
  • Posts: 40
  • Karma: 1
Re: Can't search all members after import
October 12, 2009, 03:35:08 am
This is the debug info.

backTrace

/var/www/qb103170/data/www/in2xc.nl/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php, backtrace, 256
/var/www/qb103170/data/www/in2xc.nl/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php, fatal, 211
/var/www/qb103170/data/www/in2xc.nl/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php, key, 145
/var/www/qb103170/data/www/in2xc.nl/administrator/components/com_civicrm/civicrm/CRM/Contact/Controller/Search.php, __construct, 59
/var/www/qb103170/data/www/in2xc.nl/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(205) : eval()'d code, __construct, 1
/var/www/qb103170/data/www/in2xc.nl/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php, eval, 205
/var/www/qb103170/data/www/in2xc.nl/administrator/components/com_civicrm/admin.civicrm.php, invoke, 45
/var/www/qb103170/data/www/in2xc.nl/administrator/components/com_civicrm/admin.civicrm.php, civicrm_invoke, 22
/var/www/qb103170/data/www/in2xc.nl/libraries/joomla/application/component/helper.php, require_once, 162
/var/www/qb103170/data/www/in2xc.nl/administrator/includes/application.php, renderComponent, 136
/var/www/qb103170/data/www/in2xc.nl/administrator/index.php, dispatch, 67
/var/www/qb103170/data/www/in2xc.nl/administrator/index2.php, include, 14


unrecoverable error
    Sorry. A non-recoverable error has occurred.

    Could not find valid Key

    Return to home page.


I deleted the 90 members in phpmyadmin.
As soon As I do so, I can search agian (put cursor in upperleft searchbox and hit enter)

Edwin

airwaves

  • I post occasionally
  • **
  • Posts: 40
  • Karma: 1
Re: Can't search all members after import
October 12, 2009, 02:44:12 pm
New info:

Today I did a fresh install of civi 3.0.1 on joomla.
All went oke but after import, the search box (upper left). Is still giving me a:

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    Could not find valid Key

    Return to home page.


It is driving me crazy!   :(

airwaves

  • I post occasionally
  • **
  • Posts: 40
  • Karma: 1
Re: Can't search all members after import
October 12, 2009, 03:01:13 pm
New info:

When I search for a " " (space) I get the error below:

Error Details:

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

       
Code: [Select]
=> -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => SELECT DISTINCT UPPER(LEFT(contact_a.sort_name, 1)) as sort_name  FROM civicrm_contact contact_a LEFT JOIN civicrm_email ON (contact_a.id = civicrm_email.contact_id AND civicrm_email.is_primary = 1)  WHERE  (  (  )  )  AND  ( 1 )     [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')  )  AND  ( 1 )' at line 1]
    [type] => DB_Error
    [user_info] => SELECT DISTINCT UPPER(LEFT(contact_a.sort_name, 1)) as sort_name  FROM civicrm_contact contact_a LEFT JOIN civicrm_email ON (contact_a.id = civicrm_email.contact_id AND civicrm_email.is_primary = 1)  WHERE  (  (  )  )  AND  ( 1 )     [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')  )  AND  ( 1 )' at line 1]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT DISTINCT UPPER(LEFT(contact_a.sort_name, 1)) as sort_name  FROM civicrm_contact contact_a LEFT JOIN civicrm_email ON (contact_a.id = civicrm_email.contact_id AND civicrm_email.is_primary = 1)  WHERE  (  (  )  )  AND  ( 1 )     [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')  )  AND  ( 1 )' at line 1]"]
)


So all functionality work oke, but after import It goes crazy.

Edwin.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Can't search all members after import
October 12, 2009, 07:30:16 pm

i suspect there is something wrong with your settings or setup

your best bet might be to hire someone from http://civicrm.org/professional/ and see if they can help/troubleshoot this

alternatively you can try to "scramble" your input csv and try to reproduce the issue on our demo servers (http://joomla.demo.civicrm.org/)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

airwaves

  • I post occasionally
  • **
  • Posts: 40
  • Karma: 1
Re: Can't search all members after import
October 12, 2009, 10:11:51 pm
Hi Lobo,

Can I delete users in mysql without loosing the integrety of the DB? I mean table 'civicrm_users'.


Edwin.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Can't search all members after import
October 13, 2009, 08:03:40 am

civicrm does not have a table called civicrm_users. Are you referring to the drupal users table? not sure how this is relevant to this thread?

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

airwaves

  • I post occasionally
  • **
  • Posts: 40
  • Karma: 1
Re: Can't search all members after import
October 13, 2009, 08:10:58 am
Your right. I ment civicrm_contacts.

I don't know what was wrong with my setup. I created a new subdomain over here and installed J and civi 3.0.1. After import the 90 contacts, the problem wasn't there anymore.

It must have had to do with my install of J.
The bad thing, is that it was on my production website. If only I could get more detail in the error. What key can't the script find.

So I made a work-arround with a new sub-domain, but it still worries me.

Edwin
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Can't search all members after import

This forum was archived on 2017-11-26.