Error Creating DB (MyISAM )

[rwoody]

I'm attempting to do a fresh install - Php 5.3.10 MySql - 5.5.19 - All the installation checks are passed; however when going to the next step to create the db, I receive the following 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 AUTO_INCREMENT=1' at line 21.

Please advise. I'm actually moving my Blesta install from one platform to another - and have had a lot of issues getting this done, so I'm trying to do a fresh install and then import my existing db. I really need to get this done, but I can't even get a fresh install completed, very frustrating.

Ruth Woody

[Paul]

I believe we resolved this via email (Or are on the way to!). The issue with this error is something that was patched is version 2.5.2, and you appeared to be running 2.4.x. Essentially the newer version of MySQL doesn't like the old install queries, due to a deprecated argument. In v2.5.2 the queries were changed.

[Johnny Suzuki]

Hello.
I'm receiving the following error at step 2.database creation in a fresh install with wampserv, with apache 2.2.22, php 5.3.1 and mysql 5.5.24 with blesta 2.5.4 /sourceguardian 5.3ts:
<br /><b>Notice</b>: Undefined variable: vars in <b>D:wampwwwblestainstall.php</b> on line <b>2104</b><br />localhost
in all fields. When I try to continue, give the error>
Invoice IDs must be an Integer larger than 0.

Can anyone help me?

Thank's in advance?

[rwoody]

Originally Posted by Paul

I believe we resolved this via email (Or are on the way to!). The issue with this error is something that was patched is version 2.5.2, and you appeared to be running 2.4.x. Essentially the newer version of MySQL doesn't like the old install queries, due to a deprecated argument. In v2.5.2 the queries were changed.

Paul, I finally got the system moved and installed on a new server. All is good. You can close this issue finally for me.

Thanks a ton

Ruth