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