Ok, I managed to reproduce this under Linux after all. I have modified
all the email fields in install.pl to be length 200, and this fixes the
issue. I have uploaded 1.9.2rc3 to SF. I have also attached the patch
to install.pl to this email if you just want to apply that (after
zapping your codestrikerdb database).
I'll actually be away from email for the next two weeks on holidays, but
Jason will be able to help you out if you still have issues.
Thanks for the report.
Cheers,
David
Index: bin/install.pl
===================================================================
RCS file: /cvsroot/codestriker/codestriker/bin/install.pl,v
retrieving revision 1.10
diff -u -u -r1.10 install.pl
--- bin/install.pl 15 Jun 2006 06:46:18 -0000 1.10
+++ bin/install.pl 21 Jul 2006 06:23:03 -0000
@@ -339,7 +339,7 @@
my $topic_table =
table(name => "topic",
columns => [col(name=>"id", type=>$INT32, pk=>1),
- col(name=>"author", type=>$VARCHAR, length=>255),
+ col(name=>"author", type=>$VARCHAR, length=>200),
col(name=>"title", type=>$VARCHAR, length=>255),
col(name=>"description", type=>$TEXT),
col(name=>"document", type=>$TEXT),
@@ -361,7 +361,7 @@
my $topichistory_table =
table(name => "topichistory",
columns => [col(name=>"topicid", type=>$INT32, pk=>1),
- col(name=>"author", type=>$VARCHAR, length=>255),
+ col(name=>"author", type=>$VARCHAR, length=>200),
col(name=>"title", type=>$VARCHAR, length=>255),
col(name=>"description", type=>$TEXT, length=>255),
col(name=>"state", type=>$INT16),
@@ -371,7 +371,7 @@
col(name=>"projectid", type=>$INT32),
col(name=>"reviewers", type=>$TEXT),
col(name=>"cc", type=>$TEXT, mandatory=>0),
- col(name=>"modified_by_user", type=>$VARCHAR, length=>255,
mandatory=>0)
+ col(name=>"modified_by_user", type=>$VARCHAR, length=>200,
mandatory=>0)
],
indexes => [dbindex(name=>"th_idx", column_names=>["topicid"])]);
@@ -379,7 +379,7 @@
my $topicviewhistory_table =
table(name => "topicviewhistory",
columns => [col(name=>"topicid", type=>$INT32),
- col(name=>"email", type=>$VARCHAR, length=>255,
mandatory=>0),
+ col(name=>"email", type=>$VARCHAR, length=>200,
mandatory=>0),
col(name=>"creation_ts", type=>$DATETIME)
],
indexes => [dbindex(name=>"tvh_idx", column_names=>["topicid"])]);
@@ -389,7 +389,7 @@
my $topicusermetric_table =
table(name => "topicusermetric",
columns => [col(name=>"topicid", type=>$INT32, pk=>1),
- col(name=>"email", type=>$VARCHAR, length=>255, pk=>1),
+ col(name=>"email", type=>$VARCHAR, length=>200, pk=>1),
col(name=>"metric_name", type=>$VARCHAR, length=>80, pk=>1),
col(name=>"value", type=>$FLOAT)
],
@@ -422,7 +422,7 @@
table(name => "commentdata",
columns => [col(name=>"commentstateid", type=>$INT32),
col(name=>"commentfield", type=>$TEXT),
- col(name=>"author", type=>$VARCHAR, length=>255),
+ col(name=>"author", type=>$VARCHAR, length=>200),
col(name=>"creation_ts", type=>$DATETIME)
],
indexes => [dbindex(name=>"comment_idx",
@@ -465,14 +465,14 @@
col(name=>"metric_value", type=>$VARCHAR, length=>80),
col(name=>"version", type=>$INT32, pk=>1),
col(name=>"modified_ts", type=>$DATETIME),
- col(name=>"modified_by_user", type=>$VARCHAR, length=>255)
+ col(name=>"modified_by_user", type=>$VARCHAR, length=>200)
]);
# Indicate what participants there are in a topic.
my $participant_table =
table(name => "participant",
columns => [col(name=>"topicid", type=>$INT32, pk=>1),
- col(name=>"email", type=>$VARCHAR, length=>255, pk=>1),
+ col(name=>"email", type=>$VARCHAR, length=>200, pk=>1),
col(name=>"type", type=>$INT16, pk=>1),
col(name=>"state", type=>$INT16),
col(name=>"modified_ts", type=>$DATETIME),
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Codestriker-user mailing list
Codestriker-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/codestriker-user
