Error Installing Database

[MarkN]

I am trying to install allocPSA on a Windows 2003 server. I am following the installation directions posted here: http://www.cybersource.com.au/users/conz/alloc/installing_alloc_under_windows.html.

I have successfully completed every step. But when I try to install the database (step 33) I get the errors shown below. Can anyone help me please?

Thanks much,
Mark

Query failed: BLOB/TEXT column 'expenseFormComment' can't have a default value

CREATE TABLE expenseForm ( expenseFormID int(11) NOT NULL auto_increment, clientID int(11) DEFAULT NULL, expenseFormModifiedUser int(11) DEFAULT NULL, expenseFormModifiedTime datetime DEFAULT NULL, paymentMethod varchar(255) default NULL, reimbursementRequired tinyint(4) NOT NULL default '0', expenseFormCreatedUser int(11) DEFAULT NULL, expenseFormCreatedTime datetime DEFAULT NULL, transactionRepeatID int(11) NOT NULL default '0', expenseFormFinalised tinyint(4) NOT NULL default '0', seekClientReimbursement int(1) NOT NULL default 0, expenseFormComment text default "", PRIMARY KEY (expenseFormID) ) TYPE=MyISAM PACK_KEYS=0;

Query failed: Data too long for column 'tokenAction' at row 1

INSERT INTO tokenAction (tokenAction,tokenActionType,tokenActionMethod) VALUES ("Add Comments to Task (via a comment)","comment","add_comment_from_email");

[Con Zymaris]

Mark, did Stephen's response/suggestion also work for your error?

[Con Zymaris]

Mark,

is this still a problem?

[Anonymous]

I am getting this error also. Is there a fix?

Stephen

[Anonymous]

I changed the SQL in db_structure.sql to:

LINE 569 WAS
tokenAction VARCHAR(32) NOT NULL DEFAULT '',

LINE 569 NOW
tokenAction VARCHAR(40) NOT NULL DEFAULT '',

LINE 111 WAS
expenseFormComment text default "" ,

LINE 111 NOW
expenseFormComment text NOT NULL,

And at least got past this hurdle

Stephen