Mambo 4.5.3 and Sugar 4.0.1 integration

[ejliao]

SugarCRM 4.0.1 installation and Mambo 4.5.3 with the SugarPortal integration version for 4.0.1.

After following the setup instruction Sugar_Portal_Installation published in July 2005, still can't seem to get it to work.
This is the error message received.

"

Connection Error

Response not of type text/xml

"

Attached the detailed error message in the txt file.

[bcurlee]

Same for me. I can login with the newly created user but once I create a case it gets the connection error you are. Bug Tracker is also no working right. I can create a but but it never apears in the mambo portal yet I can see it in Sugar. Have you found any thing about this yet?

[virtuallin]

man, I was so close! I'm having the exact same issue here. Please help great sugar gods!!!

[virtuallin]

Is there anyone at all who can help us get this to work????? Four days with no response - please, anyone at all?

[ss173b]

May I know Which version of PHP are you running? I'm running php5 on windows and IIS. After some minor modifications on php tags, it works well and as expected.

[emphasis1]

What changes did you make?

[ss173b]

I was able to load the modules in Mambo but can not configure the Issue/Cases parameter. Thus i edited the *.html.php file. For example, for sugar bugs, i edited sugarbugs.html.php in "components\com_sugarbugs" folder and replace all php tags <? with <?php. Do the same for cases.

[Skye]

I edited all the documents that you stated above, made the changes, and initially it worked, however cases shifted back to the same error once I hit the "home" link.

I haven't been able to get the tasks / cases / bugs to actually show in mambo, as stated in an earlier post, and unsure why, I don't really have a need for the cases and bugs, my need is for tasks and for that one I can't get it to work at all - If anyone else is working on this problem and has come up with a solution i would be ALL ears

I have now tried Mambo, Joomla, and I'm looking at other CMSs to see if there is any integration with Sugar - I saw that there was one for Tribal, anyone know if that one works?

[ss173b]

Managed to replicate you error on my setup and it si due to the wrong column specified for soert order in the query.

Solution:
i) locate augarApp.php in \components\com_sugarcases\sugarapp
ii) Amend line 47 from "var $sortBy = array('number'=>'desc');" to "var $sortBy = array('case_number'=>'desc');"

that's all and you can now get all cases reflected in Mambo...

[rsanka]

Managed to replicate you error on my setup and it si due to the wrong column specified for soert order in the query.

Solution:
i) locate augarApp.php in \components\com_sugarcases\sugarapp
ii) Amend line 47 from "var $sortBy = array('number'=>'desc');" to "var $sortBy = array('case_number'=>'desc');"

that's all and you can now get all cases reflected in Mambo...

I had the problem of not being able to see the cases after creating a case. But, after making the changes mentioned above, I am able to see cases.
But I still don't see any bugs.