User: sits
Date: 08/01/12 20:25:34
Modified: bin install.pl
lib/Codestriker/DB Database.pm MySQL.pm
Log:
Support larger text sizes under MySQL
Index: install.pl
===================================================================
RCS file: /cvsroot/codestriker/codestriker/bin/install.pl,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -r1.13 -r1.14
--- install.pl 9 Jan 2008 06:16:05 -0000 1.13
+++ install.pl 13 Jan 2008 04:25:33 -0000 1.14
@@ -675,7 +675,7 @@
$database->add_field('project', 'state', $INT16);
# If we are using MySQL, and we are upgrading from a version of the database
-# which used "text" instead of "mediumtext" for certain fields, update the
+# which used "text" instead of "longtext" for certain fields, update the
# appropriate table columns.
if ($Codestriker::db =~ /^DBI:mysql/i) {
# Check that document field in topic is up-to-date.
Index: Database.pm
===================================================================
RCS file: /cvsroot/codestriker/codestriker/lib/Codestriker/DB/Database.pm,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -r1.10 -r1.11
--- Database.pm 7 Aug 2006 02:14:48 -0000 1.10
+++ Database.pm 13 Jan 2008 04:25:34 -0000 1.11
@@ -64,6 +64,9 @@
RaiseError=>$raise_error,
LongReadLen=>10240000});
+ # To see debugging from the DBI driver.
+ # $self->{dbh}->{TraceLevel} = 1;
+
# Return the new connection.
return $self->{dbh};
}
Index: MySQL.pm
===================================================================
RCS file: /cvsroot/codestriker/codestriker/lib/Codestriker/DB/MySQL.pm,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -r1.8 -r1.9
--- MySQL.pm 10 Jun 2006 07:45:30 -0000 1.8
+++ MySQL.pm 13 Jan 2008 04:25:34 -0000 1.9
@@ -18,7 +18,7 @@
# Type mappings.
my $_TYPE = {
- $Codestriker::DB::Column::TYPE->{TEXT} => "mediumtext",
+ $Codestriker::DB::Column::TYPE->{TEXT} => "longtext",
$Codestriker::DB::Column::TYPE->{VARCHAR} => "varchar",
$Codestriker::DB::Column::TYPE->{INT32} => "int",
$Codestriker::DB::Column::TYPE->{INT16} => "smallint",
@@ -56,6 +56,7 @@
$dbh->do("SET NAMES 'utf8'");
$dbh->do("SET character_set_results='utf8'");
}
+ $dbh->do("SET max_allowed_packet=128000000");
return $dbh;
}
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Codestriker-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/codestriker-commits
