InMotion Hosting Support Center

I am having trouble installingIMathAS

Category: Databases

InMotionFans
n/a Points
Asked:
2015-03-13 2:39 pm EST

Hits: 125
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: http://www.imathas.com/imathas/readme.html

What am I doing wrong?
Thanks.

You must login before you can ask a follow up question.

You must login before you can submit an answer.

OTHER ANSWERS

1

Arn
Staff
40,336 Points
2015-03-13 3:06 pm EST
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.

You must login before you can post a comment about this answer.

1

nthomthom
2016-02-18 7:07 am EST
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.

You must login before you can post a comment about this answer.

Like this Question?

Support Center Login

Our Login page has moved, Click the button below to be taken to the login page.

Social Media Login

   
Social Login Joomla

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!