Installation error

biggspeed

Fatal error: mysqlt 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 'TYPE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci' at line 6] in EXECUTE("CREATE TABLE modules ( name VARCHAR(128) NOT NULL, version INTEGER NOT NULL, priority INTEGER NOT NULL DEFAULT 0, PRIMARY KEY (name) ) TYPE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci") in C:\xampp\htdocs\epesi-1.1.4-rev7454\libs\adodb\adodb-errorhandler.inc.php on line 77

I get this error when trying to install using the zip package.
Running Vista for a test and the latest xampp
When I try to use the easyinstaller I get a:

Directory is writeable
OK

PHP version: 5.3.5
OK

WARNING ! Curl extension not found - Please uncomment ;extension=php_curl.dll line in your php.ini

What am I doing incorrectly?

ethnar

Hello,

There's nothing wrong with this SQL query, it should be working properly.
Could you please provide what version of mysql server you are running or what package/hosting you're using?

Kind regards,
Arek

veyyon

epesi has compatibility issues with mysql 5.5.X downgrade it to 5.1.x ll work fine..

ethnar

Thank you for the report. The issue was fixed and you can expect epesi to work properly with latest MySQL version with next epesi release.

Kind regards,
Arek

jasiek

Hi,
The new epesiBIM version we are preparing for release before the end of April will have this problem fixed. If you need to install it now to a server with the latest MySQL database server please change the following file:
/include/database.php line 80:
from TYPE=InnoDB to ENGINE=InnoDB

$def_opts = array('postgres'=>' WITH OIDS','mysql' => ' TYPE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci');

to:

$def_opts = array('postgres'=>' WITH OIDS','mysql' => ' ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci');

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge