Blank page on Save

[jzalewski]

Here's a weird one

I'm running 4.5.0b on ms-sql and iis 6.0

When logged in as a particular user (our most active one) If I schedule a call and click save it saves the call but does not return to the Lead (or account, opportunity....) that I was editing? It also is SLOWWWWW

If I log in as that user at a different machine same problem.

If I log in as any other user it works fine. It also saves very fast and returns me to the page I was adding a call too.

It used to work fine for this user (she is an admin) as well.

Any thoughts???

Thanks in advance

John

[jzalewski]

Ok still trying to figure this out

I turned the php show errors on and I received this message

Fatal error: Maximum execution time of 30 seconds exceeded in d:\orthmatch\Sugarcrm\include\TimeDate.php on line 149

The line number varies, but I'm guessing it's because it makes it to differnt spots in the file when it timesout

This users settings for date/time config in the admin section are the same as evryone elses?

02/28/2007
11:00 PM

Just can't figure out why just this user?

Also can't figure out where these user admin changes get saved??

I'll attempt an upgrade to 4.5.1a if someone feels it will solve this problem but looking thru the release notes I dod not see it listed??

Thanks

John

[andydreisch]

Hi jzalewski, what's the server response time for that user? (See Jacob's CTO Series blog-thread for info regarding this.) It could be that there is a runaway query for that user.

How many Accounts/Contacts, etc., do you have?

Also, although I don't know of a specific fix in a later release, it's advisable to move to it anyway.

Andy

[jzalewski]

Andy

Thanks for the response.

I perused thru the CTO threads but did not find anything specific to "server response time". You mentioned server response time for this user. Is that a setting somewhere? Or did you mean it more generically like does this user have good/bad server response time?

The user logs each call that she makes to a Lead and the error happens when she saves the call. We have approximately 2000 leads but I tried the same function in Opportunities and Accounts, where we only have 30-40 and I get the same result. Only for this user though. One difference with this user is she has alot of calendar data as she logs each call she makes and schedules each call she needs to make. Wondering if that plays in to this somehow.

Any thoughts greatly appreciated.

John

[andydreisch]

This Wiki article covers Slow Query Logging. Maybe using it we can rule in/out databse stuff, although the numbers you provided are well within the OK range, for sure.

Andy

[jzalewski]

Andy

Again many thanks for the help

I turned on slow query logging and here is what I found

02/28/07 15:17:27,560 [2324] FATAL SugarCRM - Incorrect syntax near 'mu'.: UPDATE calls_users mu SET mu.accept_status = 'accept' WHERE mu.deleted = 0 AND mu.call_id = '273b2177-f9fa-ff72-e2e7-45de10104482' AND mu.user_id = 'b5b66b66-a2b6-9e92-740b-45745b431235'

Turns out there is a ton of these pretty much back to December when this user started, though she says "it just started happening"

The problems seem to be related to date/time issues.

At this point I think I need to get upgraded to the latest release?

Thanks again!

John

[dsga1]

hello -- per my experience, this has been a long-standing problem...

detailed with specific fix ...
http://www.sugarcrm.com/forums/showthread.php?t=17314

you must comment out line in ...
./www/sugar/data/SugarBean.php

[andydreisch]

Hi dsga1, thanks for the pointer ... I'm hunting this one down right now.

Andy

[jzalewski]

dsga1...thanks for the tip. I had just run across that thread this morning but did not try the fix. Just tried it but no change?

I have fixed my problem and will detail below in the hopes it helps some other poor soul like myself. In fact as I scoured the forum I see many users with a similiar problem but not this solution? Maybe it only manifests itself in certain configs?

BTW I'm running 4.5.0b, MS-SQL, IIS and after spending the last week on the board I am now scared to death to upgrade.

To recap my problem when saving either calls or meeting our largest users (and the only user with a lot of calls and meetings scheduled...about 20 each day for the last 3 months) would timeout and the return a blank page. I turned on show errors and could see it was bombing in the timedate.php module.

The first fix was I set the max_execution_time in the php.ini file to 60 rather than the default 30. (found this on the board somewhere...thanks) Now my correct screen would return but it still took forever (actually about 32 seconds)

I then found this CTO Series thread

where jnassi responded to someone with a similar problem suggesting to flag var $update_vcal to false in the calls.php module. (also in the meetings.php if applicable)

My call and meeting saves now take less than a second rather than 32 seconds.

Apparantly there is an old bug # 6639 posted for this which does not look to be resolved? Though I'm too new to know how to check that.

Thanks to all !

John

[jzalewski]

Correction

Actually Andy responded in a previous post in this thread over a week ago. The first time thru I did not catch the vCal fix though it did help me get slow_query logging turned on.

Thanks Andy!