Timeout error when viewing Contacts

[sugarhoney]

Ok, so I imported my old CRM contact list to sugarcrm using my own custom script. The originally data has over 200K rows. So, that's a lot for the contacts and accounts_contacts table. Now, when I tried to view Contacts in sugarcrm, it gives me this error:


Notice: Undefined index: in C:\Program Files\Apache2.2\htdocs\sugarce\include\Localizatio n\Localization.php on line 536

Notice: Undefined index: in C:\Program Files\Apache2.2\htdocs\sugarce\include\Localizatio n\Localization.php on line 536

Fatal error: Maximum execution time of 60 seconds exceeded in C:\Program Files\Apache2.2\htdocs\sugarce\include\database\My sqlManager.php on line 151


I tried to copy "set_time_limit(0); // No time limit for this script" in the MsqlManager.php script, but it still gives me the same error. How do I prolong the script?

[Angel]

Increase the max_execution_time setting in your PHP.ini setup. Restart your web server after the change and try again.

[sugarhoney]

That would work, but changing my PHP.ini would affect other PHP applications I have on the server. I just want to specifically run sugarcrm without any timeout.

[DragonflyMaster]

Ok, so I imported my old CRM contact list to sugarcrm using my own custom script. The originally data has over 200K rows.

Hi,
have you tried importing just a few of your previous CRM data?
I bet you would get the same error, If you tried with about 10.
I think there is something with that "Undefined index" notice.

[Angel]

You might be able to do it via an .htaccess file. See the following: http://php.net/manual/en/configuration.changes.php