I am trying to install Mantis-1.0.8 on a Linux Ubuntu (7.04 - Feisty Fawn) server.
I have mysql-server version 5.0.38-0ubuntu1 and php 5.2.1-0ubuntu1.2.
I have downloaded the tarball for mantis 1.0.8 and have Apache working to the point where I can successfully load the admin/install.php file.
After filling in the form provided by install.php, I get the following output and error:
Code: Select all
[ Back to Administration ] Check and Install Database
Setting Database Hostname GOOD
Setting Database Type GOOD
Checking PHP support for database type GOOD
Setting Database Username GOOD
Setting Database Password GOOD
Setting Database Name GOOD
Setting Admin Username GOOD
Setting Admin Password GOOD
Attempting to connect to database as admin GOOD
Checking Database Server Version
Running mysql version GOOD
Installing Database
Create database if it does not exist GOOD
Attempting to connect to database as user GOOD
Create Schema ( CreateTableSQL on mantis_config_table ) BAD
CREATE TABLE mantis_config_table ( config_id VARCHAR(64) NOT NULL, project_id INTEGER NOT NULL DEFAULT 0, user_id INTEGER NOT NULL
DEFAULT 0, access_reqd INTEGER DEFAULT 0, type INTEGER DEFAULT 90, value XS NOT NULL, PRIMARY KEY (config_id, project_id, user_id)
)TYPE=MyISAM
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
'XS NOT NULL, PRIMARY KEY (config_id, project_id, user_id) )TYPE' at line 7
Checks Failed...
Please correct failed checks
Retry
Thanks!
H.