I am having trouble installingIMathAS
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.
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.