misc/104534: wrong dependency versions listed for sugarcrm port

[Greg Grothj]

>Number:         104534
>Category:       misc
>Synopsis:       wrong dependency versions listed for sugarcrm port
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          doc-bug
>Submitter-Id:   current-users
>Arrival-Date:   Wed Oct 18 13:40:15 GMT 2006
>Closed-Date:
>Last-Modified:
>Originator:     Greg Grothj
>Release:        6.1
>Organization:
>Environment:
>Description:
from the following url:  

http://www.freebsd.org/cgi/ports.cgi?query=sugarcrm&stype=all

sugarcrm-3.5.1 

"Requires: expat-2.0.0_1, fontconfig-2.3.2_6,1, freetype2-2.2.1_1, jpeg-6b_4, libdrm-2.0.2, libiconv-1.9.2_2, libxml2-2.6.26, mysql-client-5.0.24a_1, php5-5.1.6_2, php5-gd-5.1.6_2, php5-mysql-5.1.6_2, php5-pcre-5.1.6_2, php5-session-5.1.6_2, php5-xml-5.1.6_2, pkg-config-0.21, png-1.2.12_1, t1lib-5.1.0_1,1, xorg-libraries-6.9.0"

After many hours of trying to get the port to install, I spent a lot of time digging around the help forums at sugarcrm.com, there I discovered that version 3.5.1 is incompatible with mysql 5+ because of issues of reserved keywords used as table names.  This issue has been corrected in sugarcrm 4+

Also from the forums:
All versions of sugarcrm are incompatible with php 5, and will only install with php 4.


>How-To-Repeat:
Try to install the port using mysql 5 & php 5
>Fix:
Update the port to include version 4+ of sugarcrm, change documentation to display that port is only compatible with php4.
>Release-Note:
>Audit-Trail:
>Unformatted: