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 »
  • Installing CiviCRM »
  • Windows and IIS installations »
  • PHP / MYSQL Death
Pages: [1]

Author Topic: PHP / MYSQL Death  (Read 2845 times)

co-operatives uk

  • I’m new here
  • *
  • Posts: 29
  • Karma: 0
  • CiviCRM version: 4.2.0
  • CMS version: Drupal 7.15
  • MySQL version: 5
  • PHP version: 5
PHP / MYSQL Death
September 27, 2011, 03:43:51 pm
Trying to set up a CIVICRM/Drupal 7 install to replace existing database. Installed both onto a IIS server with PHP 5.3.8 (memory 256M) and MYSQL 5.1.30.

Imported around 13,000 organizations onto the system via SQL from existing MYSQL DB without any significant errors, but then lost the ability to edit the admin individual contact record. PHP seems to kill MYSQL, resulting in the error:

"PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 276481 bytes) in F:\Websites\[online]\Co-operatives UK [v002]\html\sites\all\modules\civicrm\CRM\Core\Error.php on line 386"

Can still however edit organization records without problem. Can also edit the civicrm record for the admin account through the link on the drupal account edit page.

Any help on why this is happening would be much appreciated: I can only assume that saving an individual record somehow tries to pass a query of all organizations through MYSQL?

co-operatives uk

  • I’m new here
  • *
  • Posts: 29
  • Karma: 0
  • CiviCRM version: 4.2.0
  • CMS version: Drupal 7.15
  • MySQL version: 5
  • PHP version: 5
Re: PHP / MYSQL Death
September 27, 2011, 03:51:08 pm
Strangely, it seems I can still import Individuals via SQL. Just not edit the records once they're in.

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: PHP / MYSQL Death
September 27, 2011, 03:56:56 pm

can u do either of the following:

1. Check the queries being fired by mysql in the mysql query log

2. Install and enable drupal devel module. Enable query logging and see the queries generated when editing an individual. this will give us a clue as to whats happening

if you dont know how to do either of the above, please do a google search. lots of info there

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

co-operatives uk

  • I’m new here
  • *
  • Posts: 29
  • Karma: 0
  • CiviCRM version: 4.2.0
  • CMS version: Drupal 7.15
  • MySQL version: 5
  • PHP version: 5
Re: PHP / MYSQL Death
September 28, 2011, 05:00:47 am
Hi: tried both of those - Devel doesn't seem to log civi-crm queries, just Drupal queries. The MYSQL log isn't recording anything for the queries, so I suspect it's dying before the log records why.

co-operatives uk

  • I’m new here
  • *
  • Posts: 29
  • Karma: 0
  • CiviCRM version: 4.2.0
  • CMS version: Drupal 7.15
  • MySQL version: 5
  • PHP version: 5
Re: PHP / MYSQL Death
September 28, 2011, 06:31:15 am
Have upgraded to 4.0.6 and the problem has gone. Must have been a bug somewhere that someone picked up.

CarolMandy

  • I’m new here
  • *
  • Posts: 1
  • Karma: 0
  • I am an inovative person.
  • CiviCRM version: don't know
  • CMS version: SMF
  • MySQL version: don't know
  • PHP version: don't know
Re: PHP / MYSQL Death
October 21, 2011, 12:51:40 am
Yes! You can edit organization records without problem.  ;D
It's an easy process.
web design miami

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Windows and IIS installations »
  • PHP / MYSQL Death

This forum was archived on 2017-11-26.