anyone using win2008r2 + MySQL 5.5?

[buliwyfa]

I am trying to install WHMC on windows 2008 R2 with PHP 5.2 (version that is installed by MS web platform installed) and MySQL 5.5.

 

However, beside the lack of explanation on the official WHMCS manual, I keep getting the error "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 'TYPE=MyISAM' at line 1" or 13 if I use install.sql directly on the MySQL.

 

According to:

http://forum.whmcs.com/showthread.php?t=5119&highlight=error+SQL+syntax%3B+check+manual+corresponds+MySQL+server+version+syntax+%27TYPE%3DMyISAM%27+line

 

It is caused by having Strict Mode enable. However, it makes no difference if enable or disable. Or the character set used.

 

Also, support told me that magic_runtime_quotes should be disabled, and they are by default on the installation.

 

Any idea why it happens?

Should I use an older MySQL version?

 

 

Thanks

[buliwyfa]

Ok, I found why this is happenings.

 

I am using the lasts stable MySQL 5.5.8 and the Windows 2008 R2.

 

If I change on files install.sql and upgrade330.sql the following:

“Type=”

to

“Engine=”

the issue is fixed.

 

I was lucky because I run into similar problem with SMF.

http://www.simplemachines.org/community/index.php?topic=398369.0