XAMPP and Sugar Installation MySQL Error

[darylcrouse]

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

Is there something that I need to do differently?

Daryl

[kbrill]

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

Is there something that I need to do differently?

Daryl

are you using the beta version of xampp? That version isn't compatible with SugarCRM.

[Oracledarren]

I had this problem with Xampp. All I had to do is use the php-switch.bat which will revert php back to php4.

Once done everything works fine. If you still get problems you could try using easyphp which is currently at version 1.8 which works straight from the download.

Hope this helps

[kbrill]

I had this problem with Xampp. All I had to do is use the php-switch.bat which will revert php back to php4.

Once done everything works fine. If you still get problems you could try using easyphp which is currently at version 1.8 which works straight from the download.

Hope this helps

But was the version of xampp you used the current beta version (1.51) or the current production version (1.50)?

[Oracledarren]

It was the stable version. I should say though that I decided to settle with easyphp in the end though, just through personal choice.

[dnaton]

Hi,

I've the same problem (unable to create the bugs table with the same message you describe) with Wamp5 1.5.0 :
----------------------------------------------------------------------------------
Configuration Serveur
Version de Apache:
Apache/1.3.33 (Win32)

Version de PHP:
5.1.1

Extensions chargées:
bcmath, calendar, com_dotnet, ctype, date, ftp, iconv, odbc, pcre, session, libxml, standard, tokenizer, zlib, SimpleXML, dom, SPL, wddx, xml, apache, mbstring, gd, mysql, mysqli, PDO, pdo_sqlite, SQLite

Version de MySQL:
5.0.16-nt
Outils
phpinfo( )
PHPmyadmin 2.6.4-pl4
SQLitemanager 1.1.3
-----------------------------------------------------------------------------------

Is there a know problem withe recent version of Mysql ?

Damien