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 Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • DB Error: unknown error | shows up when added 11th contact
Pages: [1]

Author Topic: DB Error: unknown error | shows up when added 11th contact  (Read 1423 times)

markjohan

  • I post occasionally
  • **
  • Posts: 102
  • Karma: 0
  • ..
  • CiviCRM version: 4.4.2
  • CMS version: Wordpress 3.6.1
  • MySQL version: 5.1.66-0+squeeze1
  • PHP version: 5.3.27
DB Error: unknown error | shows up when added 11th contact
October 13, 2013, 11:08:06 am
Hello everyone.

I am new here, and like the CiviCRM! But i have a strange error.
When i add the 11th contact my search (upper left in the screen) won't work anymore..

Does enyone knows how i can solve this?

Thanx!

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: DB Error: unknown error | shows up when added 11th contact
October 13, 2013, 11:25:57 am
Can you provide more detail about your DB error?

There is nothing magic about the first 10 contacts.

What other changes have you made?
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

markjohan

  • I post occasionally
  • **
  • Posts: 102
  • Karma: 0
  • ..
  • CiviCRM version: 4.4.2
  • CMS version: Wordpress 3.6.1
  • MySQL version: 5.1.66-0+squeeze1
  • PHP version: 5.3.27
Re: DB Error: unknown error | shows up when added 11th contact
October 14, 2013, 04:14:56 am
nothing. If i delete all the contacts, and just create new persons. 1 new, everything is ok, 2 ok, 3-10 ok. when i create a new person now (11th person) ERROR..

I've had a warning at the install:
XCache is installed and there are known compatibility issues between XCache and CiviCRM. Consider using an alternative PHP caching mechanism or disable PHP caching altogether

Changed this because of a error: HttpClient.php
    curl_setopt($ch, CURLOPT_FOLLOWLOCATION, FALSE);

Changed this because of an erro with imports: Controller.php
    // lets get around the time limit issue if possible, CRM-2113
  //  if (!ini_get('safe_mode')) {
 //     set_time_limit(0);
//    }

I hope you can help me..

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: DB Error: unknown error | shows up when added 11th contact
October 14, 2013, 01:45:15 pm
sorry out of my league but yes supply these types of problems with the original post so forum users can try and answer the fundamental problem
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

markjohan

  • I post occasionally
  • **
  • Posts: 102
  • Karma: 0
  • ..
  • CiviCRM version: 4.4.2
  • CMS version: Wordpress 3.6.1
  • MySQL version: 5.1.66-0+squeeze1
  • PHP version: 5.3.27
Re: DB Error: unknown error | shows up when added 11th contact
October 14, 2013, 11:23:38 pm
I think i have found whats the reason of the error.

If i change the value from "Search Preferences"
Default Contact Search Profile = -select-
I chage it for example to Name and Adress.

Result: NO   DB ERROR

If i change it, i will miss the fields adres, phonenumber, etc.

Has someone the solution for this problem? I really want to use the search option.. And with all fields visible..

Thanks!
« Last Edit: October 15, 2013, 01:54:12 am by markjohan »

markjohan

  • I post occasionally
  • **
  • Posts: 102
  • Karma: 0
  • ..
  • CiviCRM version: 4.4.2
  • CMS version: Wordpress 3.6.1
  • MySQL version: 5.1.66-0+squeeze1
  • PHP version: 5.3.27
Re: DB Error: unknown error | shows up when added 11th contact
October 16, 2013, 01:30:49 am
I have deleted the installation, and installed the version 4.3.6
Everything is now ok...

Does someone knows what is the difference?? And what cause this error in 4.3.7?


Thanks!

markjohan

  • I post occasionally
  • **
  • Posts: 102
  • Karma: 0
  • ..
  • CiviCRM version: 4.4.2
  • CMS version: Wordpress 3.6.1
  • MySQL version: 5.1.66-0+squeeze1
  • PHP version: 5.3.27
Re: DB Error: unknown error | shows up when added 11th contact
October 16, 2013, 03:41:09 am
After a import there also is a error.

I shall try to find out what the problem is..

markjohan

  • I post occasionally
  • **
  • Posts: 102
  • Karma: 0
  • ..
  • CiviCRM version: 4.4.2
  • CMS version: Wordpress 3.6.1
  • MySQL version: 5.1.66-0+squeeze1
  • PHP version: 5.3.27
Re: DB Error: unknown error | shows up when added 11th contact
October 17, 2013, 06:41:53 am
Hello everyone,

After a lot of tests, i have found the problem.
It is something in the emailadres.

Can somebody tell me what are the rules for the emailadress.

For example can you use aaa.aa@a.b.nl

markjohan

  • I post occasionally
  • **
  • Posts: 102
  • Karma: 0
  • ..
  • CiviCRM version: 4.4.2
  • CMS version: Wordpress 3.6.1
  • MySQL version: 5.1.66-0+squeeze1
  • PHP version: 5.3.27
Re: DB Error: unknown error | shows up when added 11th contact
October 17, 2013, 07:04:22 am
The error will start to appear if you use a "-" in a emailadres.
For example: aaa@bb-11.nl will give a error.

Can someone tell me how to fix this in some code? because i will need this.

Thanks

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 | shows up when added 11th contact
October 17, 2013, 12:20:02 pm

r u sure u r on PHP 5.3.27? seems like this was an issue (with website urls) in earlier versions of php

the email rule is here: CRM/Utils/Rule.php (search for function email)

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

markjohan

  • I post occasionally
  • **
  • Posts: 102
  • Karma: 0
  • ..
  • CiviCRM version: 4.4.2
  • CMS version: Wordpress 3.6.1
  • MySQL version: 5.1.66-0+squeeze1
  • PHP version: 5.3.27
Re: DB Error: unknown error | shows up when added 11th contact
October 17, 2013, 12:55:56 pm
Hello Lobo!

Thanks for your anwser. I have checked it with <?php phpinfo() ?> And it should be 5.3.27

About the Rule.php
I've searched for the function but there is nothing special about this. Do you have a idea to fix this?

Thanks

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 | shows up when added 11th contact
October 17, 2013, 01:42:38 pm

that function basically just use the php validate function, so maybe a bug in there? Might want to try with a different version of php (if not too hard)

sorry, no more ideas.

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

markjohan

  • I post occasionally
  • **
  • Posts: 102
  • Karma: 0
  • ..
  • CiviCRM version: 4.4.2
  • CMS version: Wordpress 3.6.1
  • MySQL version: 5.1.66-0+squeeze1
  • PHP version: 5.3.27
Re: DB Error: unknown error | shows up when added 11th contact
October 17, 2013, 02:03:34 pm
Hello Lobo,

Thanks for your reply. I have a solution.. after i go to phpmyadmin and see for the structure of the table, i did this: OPTIMIZETABLE`civicrm_email` after that the search is perfect.. I don't know what did the trick But tomorrow or this weekend i shall erase everything and start a new fresh installation. So i let you know if this is the solution for me..

GreeZ,
Mark

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 | shows up when added 11th contact
October 17, 2013, 04:07:54 pm

wow, that is wierd :( i dont think anyone would have guessed doing that would fix things. wonder why?

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

markjohan

  • I post occasionally
  • **
  • Posts: 102
  • Karma: 0
  • ..
  • CiviCRM version: 4.4.2
  • CMS version: Wordpress 3.6.1
  • MySQL version: 5.1.66-0+squeeze1
  • PHP version: 5.3.27
Re: DB Error: unknown error | shows up when added 11th contact
October 17, 2013, 11:59:47 pm
Yes it is strange, but i have done the same thing at another site.

and... It works.. it is indeed wierd.

You've told me about the problem with php(version) and i tought it meby would me something with the type of the database table. So i tried to find something. i tought maybe this would help.. And it was. So this problem is solved for now  ;)

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • DB Error: unknown error | shows up when added 11th contact

This forum was archived on 2017-11-26.