windows 2008 R2 installation

[mrcola]

Hi All,

 

I'm trying to install WHMCS 4.4.2 on to a Windows 2008 R2 box

 

I have

 

PHP 5.3.6

MySQL 5.5.11 X64

 

I have CURL and ionCube Loader installed and passed the system requirements checks

 

When I typed in all SQL credentials and going to next step

 

I am having

 

File: install.sql

0Line 1 - 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

Line 2 - 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

Line 3 - 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

Line 4 - 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

Line 5 - 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

Line 6 - 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

Line 7 - 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

Line 8 - 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

Line 9 - 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

Line 10 - 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

Line 11 - 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

 

What is possible going wrong, I have turned off strict mode and no luck.

 

I have seen there are some other guying raising the similar post and seems no solutions

 

Cheers Ruoyu

[malfunction]

That's related to the use of MySQL5.5 and deprecated database engine names. If you change:

 

TYPE=MyISAM

 

throughout the database creation script to:

 

ENGINE=MyISAM

 

you should find it will run to completion without any trouble.

[mrcola]

That's related to the use of MySQL5.5 and deprecated database engine names. If you change:

 

TYPE=MyISAM

 

throughout the database creation script to:

 

ENGINE=MyISAM

 

you should find it will run to completion without any trouble.

 

Thank you.

 

You are a star.

 

There is one in upgrade330.sql which needs changing as well

 

Thanks again