Sugar CRM on XP / MySQL / Apache (No IIS)

[play4god]

Hello, everyone...

I'm attempting a Sugar CRM installation on XP + MySQL + Apache.

I've seen info on how to set up on Windows with IIS, but we'd like to use Apache, since we don't have IIS.

The installation seems to run fine, creating a bunch of Sugar CRM tables, etc., but then it fails. The log of progress is listed at the bottom of this posting...

Here is what the detection phase of install finds, before installation - but all are Green (no red items).
Any tips?

Thanks.
Jeff
---
Component Status

PHP Version Unsupported PHP Version Installed: ( ver 5.2.2 )
MySQL Database OK
MB Strings Module OK
XML Parsing OK
PHP Safe Mode Turned Off OK
PHP Allow Call Time Pass Reference Turned Off OK
PHP Memory Limit >= 32M OK (64M)
Writable SugarCRM Configuration File (config.php) OK
Writable Custom Directory OK
Writable Modules Sub-Directories and Files OK
Writable Data Sub-Directories OK
Writable Cache Sub-Directories OK
Writable Session Save Path (C:\DOCUME~1\Jeff\LOCALS~1\Temp\php\session) OK
Optional Components Status
IMAP Module OK
cURL Module OK
ZLIB Compression Module OK

ERROR LOG

Creating Sugar configuration file (config.php)

Creating Sugar application tables, audit tables, and relationship metadata...
relationships... relationship meta ... done
acl_roles... creating / relationship meta ... done
acl_actions... creating / relationship meta ... done
leads... creating / audit table / relationship meta ... done
contacts... creating / audit table / relationship meta ... done
accounts... creating / audit table / relationship meta ... done
opportunities... creating / audit table / relationship meta ... done
cases... creating / audit table / relationship meta ... done
notes... creating / relationship meta ... done
email_templates... creating / relationship meta ... done
emailman... creating / relationship meta ... done
calls... creating / relationship meta ... done
emails... creating / relationship meta ... done
meetings... creating / relationship meta ... done
iframes... creating / relationship meta ... done
tasks... creating / relationship meta ... done
users... creating / relationship meta ... done
currencies... creating / relationship meta ... done
tracker... creating / relationship meta ... done
import_maps... creating / relationship meta ... done
files... creating / relationship meta ... done
users_last_import... creating / relationship meta ... done
config... creating / relationship meta ... done
upgrade_history... creating / relationship meta ... done
vcals... creating / relationship meta ... done
bugs... creating / audit table / relationship meta ... done
versions... creating / relationship meta ... done
releases... creating / relationship meta ... done
feeds... creating / relationship meta ... done
project... creating / relationship meta ... done
project_task... creating / audit table / relationship meta ... done
roles... creating / relationship meta ... done
email_marketing... creating / relationship meta ... done
campaigns... creating / audit table / relationship meta ... done
prospect_lists... creating / relationship meta ... done
prospects... creating / relationship meta ... done
documents... creating / relationship meta ... done
document_revisions... creating / relationship meta ... done
fields_meta_data... Error creating table: fields_meta_data: Query Failed:CREATE TABLE fields_meta_data (id varchar(255) NOT NULL ,name varchar(255) NULL ,label varchar(255) NULL ,help varchar(255) NULL ,custom_module varchar(255) NULL ,data_type varchar(255) NULL ,max_size int(11) NULL ,required_option varchar(255) NULL ,default_value varchar(255) NULL ,date_modified datetime NULL ,deleted bool DEFAULT '0' NULL ,audited bool DEFAULT '0' NULL ,mass_update bool DEFAULT '0' NULL ,duplicate_merge smallint DEFAULT '0' NULL ,ext1 varchar(255) DEFAULT '' NULL ,ext2 varchar(255) DEFAULT '' NULL ,ext3 varchar(255) DEFAULT '' NULL ,ext4 text DEFAULT '' NULL , PRIMARY KEY (id), KEY idx_meta_id_del (id, deleted)) CHARACTER SET utf8 COLLATE utf8_general_ci::MySQL error 1101: BLOB/TEXT column 'ext4' can't have a default value


false, 'cache_dir' => 'cache/', 'calculate_response_time' => true, 'create_default_user' => false, 'currency' => '', 'dashlet_display_row_options' => array ( 0 => '1', 1 => '3', 2 => '5', 3 => '10', ), 'date_formats' => array ( 'Y-m-d' => '2006-12-23', 'm-d-Y' => '12-23-2006', 'd-m-Y' => '23-12-2006', 'Y/m/d' => '2006/12/23', 'm/d/Y' => '12/23/2006', 'd/m/Y' => '23/12/2006', 'Y.m.d' => '2006.12.23', 'd.m.Y' => '23.12.2006', 'm.d.Y' => '12.23.2006', ), 'datef' => 'Y-m-d', 'dbconfig' => array ( 'db_host_name' => 'localhost', 'db_host_instance' => '', 'db_user_name' => 'sugarcrm', 'db_password' => '4gsltw', 'db_name' => 'sugarcrm', 'db_type' => 'mysql', ), 'dbconfigoption' => array ( 'persistent' => true, 'autofree' => false, 'debug' => 0, 'seqname_format' => '%s_seq', 'portability' => 0, 'ssl' => false, ), 'default_action' => 'index', 'default_charset' => 'UTF-8', 'default_currencies' => array ( 'AUD' => array ( 'name' => 'Austrailian Dollars', 'iso4217' => 'AUD', 'symbol' => '$', ), 'BRL' => array ( 'name' => 'Brazilian Reais', 'iso4217' => 'BRL', 'symbol' => 'R$', ), 'GBP' => array ( 'name' => 'British Pounds', 'iso4217' => 'GBP', 'symbol' => '£', ), 'CAD' => array ( 'name' => 'Candian Dollars', 'iso4217' => 'CAD', 'symbol' => '$', ), 'CNY' => array ( 'name' => 'Chinese Yuan', 'iso4217' => 'CNY', 'symbol' => '元', ), 'EUR' => array ( 'name' => 'Euro', 'iso4217' => 'EUR', 'symbol' => '€', ), 'HKD' => array ( 'name' => 'Hong Kong Dollars', 'iso4217' => 'HKD', 'symbol' => '$', ), 'INR' => array ( 'name' => 'Indian Rupees', 'iso4217' => 'INR', 'symbol' => '₨', ), 'KRW' => array ( 'name' => 'Korean Won', 'iso4217' => 'KRW', 'symbol' => '₩', ), 'YEN' => array ( 'name' => 'Japanese Yen', 'iso4217' => 'JPY', 'symbol' => '¥', ), 'MXM' => array ( 'name' => 'Mexican Pesos', 'iso4217' => 'MXM', 'symbol' => '$', ), 'SGD' => array ( 'name' => 'Singaporean Dollars', 'iso4217' => 'SGD', 'symbol' => '$', ), 'CHF' => array ( 'name' => 'Swiss Franc', 'iso4217' => 'CHF', 'symbol' => 'SFr.', ), 'THB' => array ( 'name' => 'Thai Baht', 'iso4217' => 'THB', 'symbol' => '฿', ), 'USD' => array ( 'name' => 'US Dollars', 'iso4217' => 'USD', 'symbol' => '$', ), ), 'default_currency_iso4217' => 'USD', 'default_currency_name' => 'US Dollars', 'default_currency_significant_digits' => '2', 'default_currency_symbol' => '$', 'default_date_format' => 'Y-m-d', 'default_decimal_seperator' => '.', 'default_email_charset' => 'ISO-8859-1', 'default_email_client' => 'sugar', 'default_email_editor' => 'html', 'default_export_charset' => 'CP1252', 'default_language' => 'en_us', 'default_locale_name_format' => 's f l', 'default_max_subtabs' => '12', 'default_max_tabs' => '12', 'default_module' => 'Home', 'default_navigation_paradigm' => 'm', 'default_number_grouping_seperator' => ',', 'default_password' => '', 'default_subpanel_links' => false, 'default_subpanel_tabs' => true, 'default_swap_last_viewed' => false, 'default_swap_shortcuts' => false, 'default_theme' => 'Sugar', 'default_time_format' => 'H:i', 'default_user_is_admin' => false, 'default_user_name' => '', 'disable_export' => false, 'disable_persistent_connections' => 'false', 'display_email_template_variable_chooser' => false, 'display_inbound_email_buttons' => false, 'dump_slow_queries' => false, 'email_default_client' => 'sugar', 'email_default_delete_attachments' => true, 'email_default_editor' => 'html', 'export_delimiter' => ',', 'history_max_viewed' => 10, 'host_name' => 'localhost', 'i18n_test' => false, 'import_dir' => 'cache/import/', 'import_max_execution_time' => 3600, 'installer_locked' => true, 'js_custom_version' => '', 'js_lang_version' => 1, 'languages' => array ( 'en_us' => 'US English', ), 'large_scale_test' => false, 'list_max_entries_per_page' => 20, 'list_max_entries_per_subpanel' => 10, 'lock_default_user_name' => false, 'lock_homepage' => false, 'lock_subpanels' => false, 'log_dir' => '.', 'log_file' => 'sugarcrm.log', 'log_memory_usage' => false, 'login_nav' => false, 'max_dashlets_homepage' => '15', 'require_accounts' => true, 'rss_cache_time' => '10800', 'save_query' => 'all', 'session_dir' => '', 'site_url' => 'http://localhost/CRM', 'slow_query_time_msec' => '100', 'sugar_version' => '4.5.1c', 'sugarbeet' => true, 'time_formats' => array ( 'H:i' => '23:00', 'h:ia' => '11:00pm', 'h:iA' => '11:00PM', 'H.i' => '23.00', 'h.ia' => '11.00pm', 'h.iA' => '11.00PM', ), 'timef' => 'H:i', 'tmp_dir' => 'cache/xml/', 'translation_string_prefix' => false, 'unique_key' => 'ff230fc006018e37c9725477c9242996', 'upload_badext' => array ( 0 => 'php', 1 => 'php3', 2 => 'php4', 3 => 'php5', 4 => 'pl', 5 => 'cgi', 6 => 'py', 7 => 'asp', 8 => 'cfm', 9 => 'js', 10 => 'vbs', 11 => 'html', 12 => 'htm', ), 'upload_dir' => 'cache/upload/', 'upload_maxsize' => 3000000, 'use_php_code_json' => true, 'verify_client_ip' => true, ); ?>

[Angel]

This could be happening because of the version of PHP that you are using. Note the installer indicates it is an unsupported version.

I've seen very similar things happen when attempting to install using unsupported versions. I'd recommend you grab XAMPP with PHP 5.2.1 and try it again. You can download XAMPP from here: http://www.apachefriends.org/en/xampp-windows.html#641

Not sure if you are familiar with XAMPP, but it is one of the easiest ways to get the necessary stack installed on Windows.

[TakeMarket]

FYI: you have IIS if you have XP (Pro) - but you need to fire up for your installation CD and install it. But note that the IIS version for Windows XP Pro can service only 10 simultaneous client connections, so basicly you can have up to 10 employees working on that machine with sugar installed - if that suites your needs....

For more information on that part - jump over to ms website here --> Running Internet Information Services IIS on Windows XP Professional

[MilSp3c]

Can definately understand not using IIS.

I use Apache and MySql 5.2.0 on windows. No problems there.

Try replacing the current version of mysql and things should go just fine.

Good luck.