#20 SQL problems on install

[Anonymous]

My server info:
Windows Server 2003
IIS 6.0
PHP 5.0.3
MySQL 4.1.7

When I attempt to install the schema to create the DB
tables on the setup.php page, I get an error:

Setting up database

1. Setting up table Campuses...
2. Setting up table Changelog...
3. Setting up table Computers...
4. Setting up table Departments...
5. Setting up table Employees...
6. Setting up table Groups...
7. Setting up table Installations...
8. Setting up table KBCategories...
9. Setting up table KnowledgeBase...
DB Error: unknown error

Upon checking the DB, it has all the tables created up
until the KnowledgeBase table. I decided to download
the SQL files from the downloads page and manually
create the tables myself. However, MySQL complains
about the syntax of one line of code while creating the
KnowledgeBase table... The item it is having a problem
with is:

FULLTEXT KEY `Keywords` (`Keywords`)

What should be the proper syntax for this line under
PHP 5.03 and MySQL 4.1.7?????

I have tried installation of both 1.4 and the beta with
the same results

[JoshEaton]

Logged In: YES
user_id=1273610

fixed

update your sql file from these directions

http://openit.greybook.org/OpenIT%20installer%20doc.htm

[Aaron C]

Logged In: YES
user_id=600225

no response or way of contacting reporter, I'm assuming this
fixed the problem