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) »
  • DB Error unknown error
Pages: [1]

Author Topic: DB Error unknown error  (Read 1483 times)

turagittech

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4.3.5
  • CMS version: Drupal 7
  • MySQL version: 5.6.12 Amazon RDS
  • PHP version: 5.3.27
DB Error unknown error
September 18, 2013, 07:59:51 pm
Hi
I am running a CiviCRM environment on AWS. I am trying to identify the cause of the error as above that appears shortly after clicking on import to import contacts from a csv. There is only about 100 contacts. This is a single user instance at present, I see things in my New Relic monitoring that suggest issues 

I have been trying various things however nothing is  really showing anything useful

I bumped up my RDS  MySQL instance size to a medium instance with no discernible effect.


I have an error from the messages file but the forum thinks its a link until i strip it down to meaningless, Not sure how to post that

I have some experience with CMS, mainly with Joomla and Wordpress, much less with Drupal and know my way around Linux so if you have a away to identify the cause I would love to know

CiviCRM 4.3.5
Drupal 7
PHP 5.3.27
Amazon AMI (Linux Micro Instance) Amazon Linux AMI release 2013.03


Cheers

Peter
« Last Edit: September 18, 2013, 08:02:53 pm by turagittech »

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: DB Error unknown error
September 18, 2013, 08:29:41 pm

Enable CiviCRM debugging and then check the CiviCRM.*.log file in the plugins/files/civicrm/ directory of your install

you should have a backtrace of the query causing the error.

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

turagittech

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4.3.5
  • CMS version: Drupal 7
  • MySQL version: 5.6.12 Amazon RDS
  • PHP version: 5.3.27
Re: DB Error unknown error
September 19, 2013, 07:46:10 am
Thanks for the pointer lobo

Apparently something went wrong and I have no functions, in particular the civicrm_strip_non_numeric does not exist.

How does one go about getting hold of all the sql other than build an additional environment? is not all the SQL created in the SQL folder or should it be and how would I recreate that other than going through the steps to create a new database after exporting my current data?

Thanks for any assistance

Cheers
Peter

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: DB Error unknown error
September 19, 2013, 09:06:22 am

Try the recipe here:

http://forum.civicrm.org/index.php/topic,28751.msg123097.html#msg123097

u'll need to have admin permissions to rebuild the menu and triggers)

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

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • DB Error unknown error

This forum was archived on 2017-11-26.