Installation Problems

[zodell]

I am having trouble getting SugarCRM installed.

This is the output.


Creating the database sugarcrm on localhost...done
Creating the db username and password...Creating the db username and password for localhost...done
Creating the table relationships...done
Processing relationship meta for relationships...done
Creating the table leads...done
Creating audit table leads_audit...Processing relationship meta for leads...done
Creating the table contacts...done
Creating audit table contacts_audit...Processing relationship meta for contacts...done
Creating the table accounts...done
Creating audit table accounts_audit...Processing relationship meta for accounts...done
Creating the table opportunities...done
Creating audit table opportunities_audit...Processing relationship meta for opportunities...done
Creating the table cases...done
Creating audit table cases_audit...Processing relationship meta for cases...done
Creating the table notes...done
Processing relationship meta for notes...done
Creating the table email_templates...done
Processing relationship meta for email_templates...done
Creating the table emailman...done
Processing relationship meta for emailman...done
Creating the table calls...done
Processing relationship meta for calls...done
Creating the table emails...done
Processing relationship meta for emails...done
Creating the table meetings...done
Processing relationship meta for meetings...done
Creating the table iframes...done
Processing relationship meta for iframes...done
Creating the table tasks...done
Processing relationship meta for tasks...done
Creating the table users...done
Processing relationship meta for users...done
Creating the table currencies...done
Processing relationship meta for currencies...done
Creating the table tracker...done
Processing relationship meta for tracker...done
Creating the table import_maps...done
Processing relationship meta for import_maps...done
Creating the table files...done
Processing relationship meta for files...done
Creating the table users_last_import...done
Processing relationship meta for users_last_import...done
Creating the table config...done
Processing relationship meta for config...done
Creating the table upgrade_history...done
Processing relationship meta for upgrade_history...done
Creating the table vcals...done
Processing relationship meta for vcals...done
Creating the table bugs...Error creating table: bugs: Query Failed:create table bugs (id char(36) NOT NULL ,bug_number int(11) NOT NULL auto_increment,date_entered datetime NOT NULL ,date_modified datetime NOT NULL ,modified_user_id char(36) NOT NULL ,assigned_user_id char(36) ,deleted bool DEFAULT 0 NOT NULL ,name varchar(255) ,status varchar(25) ,priority varchar(25) ,description text ,created_by char(36) ,resolution varchar(255) ,release varchar(255) ,type varchar(255) ,fixed_in_release varchar(255) ,work_log text ,source varchar(255) ,product_category varchar(255) , PRIMARY KEY (id), KEY bug_number (bug_number), KEY idx_bug_name (name))::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'release varchar(255) ,type varchar(255) ,fixed_in_release varchar(255) ,wo' at line 1


I assume this is a MySQL problem, but I don't know what to try and do to fix this.

Any help?

[kbrill]

what version of mysql are you using?

[zodell]

mysql-5.0.16-r3

Gentoo 2005.0

[kbrill]

mysql-5.0.16-r3

Gentoo 2005.0

See this Thread.

[dnaton]

Hi,

How to apply the patch you talk on the thread above ? For applying the patche, you must have SugarSuite installed and then go to the administration......but I can't finish the install of SugarSuite and I can't go to the Administration af SugarSuite

How can I do ?

sincerly,

Damien

[tdab]

Damien,

Use the files in the patch file provided and replace the one in you sugar installation directories. Do not use the sqp.php stuff, just lauch the install process again.

++