Quick Create or Import to Sugar causes internal serve error

[computerlady911]

I have a fresh install of Sugar 5.0 on a Windows 2003 server. I can add users, accounts, contacts and cases manually. I have setup and successfully received email, but when I try to "Import to Sugar" or "quick create" a case I get an error: Exception occurred... Internal Server Error.

I have looked in the logs but have not found anything usefull there. What things can I check?

[andopes]

Hi Lady

Which version of PHP and MySQL are you using?
Do you have Apache or IIS?
Do you have access to the error_log of web server?

Cheers

[computerlady911]

I am using the Apache 2, php and mysql that comes with the Windows stack installer. The error.log in the Apache2 folders has this on the first line:

[notice] Apache/2.0.59 (Win32) mod_ssl/2.0.59 OpenSSL/0.9.8e PHP/5.2.5 configured

So perhaps that answers that question.

Here are the last several lines of the error log.

[Thu Aug 21 17:16:29 2008] [error] [client 192.168.10.16] File does not exist: C:/Program Files/sugarcrm-5.0.0g/htdocs/sugarcrm/themes/Shred/images/blank.gif, referer: http://jedi:8888/sugarcrm/index.php?module=Emails&action=index
 [Thu Aug 21 17:18:27 2008] [error] [client 192.168.10.16] File does not exist: C:/Program Files/sugarcrm-5.0.0g/htdocs/sugarcrm/themes/Shred/images/blank.gif, referer: http://jedi:8888/sugarcrm/index.php?module=Administration&action=index 
[Thu Aug 21 17:18:38 2008] [error] [client 192.168.10.16] File does not exist: C:/Program Files/sugarcrm-5.0.0g/htdocs/sugarcrm/themes/Shred/images/blank.gif, referer: http://jedi:8888/sugarcrm/index.php?module=InboundEmail&action=index 
[Thu Aug 21 17:18:41 2008] [error] [client 192.168.10.16] File does not exist: C:/Program Files/sugarcrm-5.0.0g/htdocs/sugarcrm/themes/Shred/images/blank.gif, referer: http://jedi:8888/sugarcrm/index.php?action=DetailView&module=InboundEmail&record=c701b79b-7222-739e-cbd9-48ae00ad5338 [Thu Aug 21 17:18:45 2008] [error] [client 192.168.10.16] File does not exist: C:/Program Files/sugarcrm-5.0.0g/htdocs/sugarcrm/themes/Shred/images/blank.gif, referer: http://jedi:8888/sugarcrm/index.php
 [Thu Aug 21 17:18:57 2008] [error] [client 192.168.10.16] File does not exist: C:/Program Files/sugarcrm-5.0.0g/htdocs/sugarcrm/themes/Shred/images/blank.gif, referer: http://jedi:8888/sugarcrm/index.php?module=InboundEmail&action=DetailView&record=c701b79b-7222-739e-cbd9-48ae00ad5338 
[Thu Aug 21 17:19:04 2008] [error] [client 192.168.10.16] File does not exist: C:/Program Files/sugarcrm-5.0.0g/htdocs/sugarcrm/themes/Shred/images/blank.gif, referer: http://jedi:8888/sugarcrm/index.php?module=Emails&action=index
 [Thu Aug 21 17:19:46 2008] [error] [client 192.168.10.16] File does not exist: C:/Program Files/sugarcrm-5.0.0g/htdocs/sugarcrm/themes/Shred/images/blank.gif, referer: http://jedi:8888/sugarcrm/index.php?module=Home&action=index 
[Thu Aug 21 17:19:52 2008] [error] [client 192.168.10.16] File does not exist: C:/Program Files/sugarcrm-5.0.0g/htdocs/sugarcrm/themes/Shred/images/blank.gif, referer: http://jedi:8888/sugarcrm/index.php?module=Emails&action=index 
[Thu Aug 21 17:30:58 2008] [error] [client 192.168.10.16] File does not exist: C:/Program Files/sugarcrm-5.0.0g/htdocs/sugarcrm/themes/Shred/images/arrow, referer: http://jedi:8888/sugarcrm/index.php?module=Accounts&action=Popup&mode=single&create=true&metadata=undefined

[andopes]

Hi Lady.

Check if the file phperror.log exists in the same folder of the error.log and check the last lines.

Cheers

[computerlady911]

Just error.log and access.log.

[computerlady911]

In the sugarcrm folder I found a sugarcrm.log.

HTTP/1.1 500 Internal Server Error
Date: Fri, 22 Aug 2008 00:37:30 GMT
Server: Apache
X-Powered-By: PHP/5.1.6
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Pragma: no-cache
Status: 500 Internal Server Error
X-SOAP-Server: NuSOAP/0.7.1 (13205)
Content-Length: 1181
Connection: close
Content-Type: text/xml; charset=ISO-8859-1

<br />
<b>Warning</b>:  session_start() [<a href='function.session-start'>function.session-start</a>]: The session id contains illegal characters, valid characters are a-z, A-Z, 0-9 and '-,' in <b>/var/www/depot.sugarcrm.com/depot/SugarDepot.php</b> on line <b>70</b><br />
<br />
<b>Warning</b>:  session_destroy() [<a href='function.session-destroy'>function.session-destroy</a>]: Session object destruction failed in <b>/var/www/depot.sugarcrm.com/depot/SugarDepot.php</b> on line <b>82</b><br />
<?xml version="1.0" encoding="ISO-8859-1"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
  xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/">
<SOAP-ENV:Body><SOAP-ENV:Fault><faultcode xsi:type="xsd:string">Server</faultcode><faultactor xsi:type="xsd:string"></faultactor><faultstring xsi:type="xsd:string">A valid SugarCRM.com User Name and Password are required</faultstring><detail xsi:type="xsd:string"></detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope>
08/21/08 17:37:30,724 [3248] FATAL SugarCRM - XML error parsing SOAP payload on line 2: Invalid document end
08/21/08 17:37:30,724 [3248] FATAL SugarCRM - HTTP/1.1 500 Internal Server Error
Date: Fri, 22 Aug 2008 00:37:30 GMT
Server: Apache
X-Powered-By: PHP/5.1.6
Set-Cookie: PHPSESSID=; path=/
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Pragma: no-cache
Status: 500 Internal Server Error
X-SOAP-Server: NuSOAP/0.7.1 (13205)
Content-Length: 1142
Connection: close
Content-Type: text/xml; charset=ISO-8859-1

<br />
<b>Warning</b>:  session_start() [<a href='function.session-start'>function.session-start</a>]: The session id contains illegal characters, valid characters are a-z, A-Z, 0-9 and '-,' in <b>/var/www/depot.sugarcrm.com/depot/SugarDepot.php</b> on line <b>145</b><br />
<br />
<b>Warning</b>:  session_destroy() [<a href='function.session-destroy'>function.session-destroy</a>]: Session object destruction failed in <b>/var/www/depot.sugarcrm.com/depot/SugarDepot.php</b> on line <b>147</b><br />
<?xml version="1.0" encoding="ISO-8859-1"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
  xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/">
<SOAP-ENV:Body><SOAP-ENV:Fault><faultcode xsi:type="xsd:string">Server</faultcode><faultactor xsi:type="xsd:string"></faultactor><faultstring xsi:type="xsd:string">Invalid Session</faultstring><detail xsi:type="xsd:string"></detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope>

[computerlady911]

It appears that, even though it is timing out, cases are being created. It seems to take them a while to show up though.

[computerlady911]

Okay. I did a fresh install. Previously I had installed sugar under Program Files and this was making the scheduling script have to be more complicated than necessary and i thought this might be causing other problems as well. So I did a fresh install into a directory at the root that had no spaces. I was able to get the cron job scheduled and working.

As far as the problem with creating cases, I have discovered the following. There is a place in the inbound email settings where you can set the possible actions for these emails. If I have it set to only create cases, then when I get an email and I click on quick create, nothing happens, no error nothing. If I have it set to Any, then when I go and click on the quick create I get the option to create a case and that works.

Import to Sugar will bring up the box asking what to relate it to. but the action errors out. In IE there is an Error on page warning in the lower right. That error is attached.