MySQL version 4.1.20 is not supported. Only MySQL 4.0.x and higher is supported.

[Airs]

I am getting this error during Step 3 of the SugarCRM Setup Wizard:

Please enter your database configuration information below. If you are unsure of what to fill in, we suggest that you use the default values.

Please fix the following errors before proceeding:

MySQL version 4.1.20 is not supported. Only MySQL 4.0.x and higher is supported.

Seems odd since 4.1 is higher than 4.0.x....Any ideas?

PHP version Unsupported (ver 4.3.9) <----- this is green however
MySQL Database OK
XML Parsing OK
cURL Library OK
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 (/var/lib/php/session) OK
PHP Safe Mode Turned Off OK
PHP Allow Call Time Pass Reference Turned On OK
PHP Memory Limit >= 32M OK (32M)

[ruchida]

This is strange. I've tried SugarCRM installation with MySQL 4.1.20 on FC4, Apahche 2.0.54, PHP 5.0.4, and have not had any problem.

If you have a sql client or phpMyadmin, please try a query;

 select version(); 
  

and see what is returned.

[Airs]

I was using CentOS...I reformatted and installed Fedora. Going to give it a shot again...

[redyor01]

I am having the exact same issue i tryed the SQL query and found out my version is 4.1.19 , is there anyway arround this ??

[redyor01]

Hi Guy ,
I just don't know what happened , but when i came back to check the install , the not Available in red for Mysql became OK in Green , i when though the install , and everything seems to work just fine
Thanks Anyway

[thesaint]

/************************************/
Update,

Found bugreport on this, bug 6304

Sorry for not checking bugs before posting on forum

/***************************************/

Hello, im kind of new to sugarcrm.
I´ve installed it yesterday on
mysql version 5.0.21
php 5.1.4
apache 2.0.58

and installation process went just fine, no errors. I began adding som contacts and noticed that an error occurs, first when im adding contacts,
Query Failed: AND users.id = '4ec01cfc-ff50-808b-fe3e-44a11eb89733'::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 'AND users.id = '4ec01cfc-ff50-808b-fe3e-44a11eb89733'' at line 1

but when im trying to list the contacts they are added into the database, Then when im trying to get the details of the contact the same error occurs.

Query Failed: AND users.id = '4ec01cfc-ff50-808b-fe3e-44a11eb89733'::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 'AND users.id = '4ec01cfc-ff50-808b-fe3e-44a11eb89733'' at line 1