Error on SugarSuite 3.5.1 : unable to create table 'bugs'

[dnaton]

Hi,

I try to install SugarSuite 3.5.1 on my PC (Win XP Pro - SP2 - 512 Mo Ram - Mysql 5.0.16-nt, Php 5.1.1, Apache 1.3.33, PhpMyAdmin 2.6.4 pl4, Firefox 1.07)

The install process is good exept when at the creation of the table 'bug' : install freeze and i've this message in my browser :

------------------------------------------------------------------------------------------------------------------------------------
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 don't find a .sql file with the sql command to make the right coorection.

Please what's wrong with my install ? What can I do ?

Thanks

Sincerly,
Damien

[macscr]

im having the exact same problem, but im running this on a linux box, but same version of mysql, but im only using php 5.0.4

[tdab]

Same error here with WAMP Server v1.5.0 here are my details :

Apache/1.3.33 (Win32)
PHP 5.1.1
MySQL 5.0.16-nt

Any help ?

[andydreisch]

Hi everyone,

Sugar Suite 351x does not support MySQL 5.

Sugar Suite 4, due shortly, will support MySQL 5.

Andy

[modeerf]

hmm, I get that error when I try to install the 4.0 beta on a mysql 5 installation...but that's a post for another forum.