I am having trouble installingIMathAS

Avatar
  • updated
  • Answered

When I try to run the database setup program as part of IMathAS, I get the following error:


Query failed : CREATE TABLE `imas_users` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, `SID` VARCHAR(50) NOT NULL, `password` VARCHAR(32) NOT NULL, `rights` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0', `FirstName` VARCHAR(20) NOT NULL, `LastName` VARCHAR(20) NOT NULL, `email` VARCHAR(100) NOT NULL, `lastaccess` INT(10) UNSIGNED NOT NULL DEFAULT '0', `groupid` INT(10) UNSIGNED NOT NULL DEFAULT '0', `msgnotify` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `qrightsdef` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `deflib` INT(10) UNSIGNED NOT NULL DEFAULT '0', `usedeflib` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `remoteaccess` VARCHAR(10) NOT NULL, INDEX (`lastaccess`), INDEX (`rights`), UNIQUE (`SID`) ) TYPE = innodb COMMENT = 'User Information'; 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 COMMENT = 'User Information'' at line 1


Here are the installation instructions: imathas.com/imathas/readme.html


What am I doing wrong?


Thanks.

Avatar
nthomthom
I am replying to this because the other answer below is incorrect. You are not seeing this error because you have db connection permission issues. If you read the last line you will notice that it is a syntax issue.

MySQL longer accepts TYPE = innodb, rather all instances must be changed to ENGINE = innodb

You can do this by changing ALL instances of TYPE = innodb to ENGINE = innodb within dbsetup.php
Though you can do this manually, you will need to do this around 40 times which isn't the most efficient method, but it CAN be done if you prefer.

Alternatively, for simplicity run a command

sed -i 's/TYPE = innodb/ENGINE = innodb/g' /pathtoimathas/dbsetup.php

if done correctly, this command will change all instances of TYPE = innodb to ENGINE = innodb within dbsetup.php. After completing this you must delete the config.php file and restart the installation process.
Avatar
Arn

Hello,

Sorry for the problem with installing IMathAS. The issue has to do with having sufficient rights to run the database setup program. You will need to submit a verified support ticket to our live technical support team. As a user on a shared server account, you will have only limited access. The systems team will need to look and see if the application can be installed for you. Apologies that we can't directly resolve the issue for you.

If you have any further questions or comments, please let us know.

Regards,

Arnel C.