PHP / MYSQL Death

[co-operatives uk]

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]

Strangely, it seems I can still import Individuals via SQL. Just not edit the records once they're in.

[Donald Lobo]

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

[co-operatives uk]

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]

Have upgraded to 4.0.6 and the problem has gone. Must have been a bug somewhere that someone picked up.

[CarolMandy]

Yes! You can edit organization records without problem. 
It's an easy process.