#7 createDatabaseSchema doesn't create all tables

[Anonymous]

When running createDatabaseSchema.sh the following errors are returned:

Connecting to the database with jdbc:mysql://localhost:3306/gswing ...
Driver is MySQL-AB JDBC Driver. Version: mysql-connector-java-3.1.12 ( $Date: 2005-11-17 15:53:48 +0100 (Thu, 17 Nov 2005) $, $Revision$ )
*** ERROR: Unable to create index connection statement: java.sql.SQLException: BLOB/TEXT column 'constituency' used in key specification without a key length
*** ERROR: Unable to create index connection statement: java.sql.SQLException: BLOB/TEXT column 'party' used in key specification without a key length
*** ERROR: Unable to create index connection statement: java.sql.SQLException: BLOB/TEXT column 'first_name' used in key specification without a key length
*** ERROR: Unable to create index connection statement: java.sql.SQLException: BLOB/TEXT column 'surname' used in key specification without a key length
*** ERROR: Unable to create index connection statement: java.sql.SQLException: BLOB/TEXT column 'party' used in key specification without a key length
*** ERROR: Unable to create index, table leadership doesn't exist
*** ERROR: Unable to create index, table leadership doesn't exist
*** ERROR: Unable to create index, table leadership doesn't exist

This results in only the candidate, constituency, leadership, party, vote and vote_list tables being created. Which obviously means that the Inserter and Importer won't work either, on account of the election table missing.

I wanted to check out this project to see if I could help you with the GUI you want to have, but this makes it rather hard. ;)

jens@bremmekamp.com

[Nobody/Anonymous]

Logged In: NO

Forgot to add, this happened with Mysql 4 & 5. Haven't tried Postgres, I guess it's working there.