Your message dated Sat, 14 Jun 2008 11:45:09 +0100
with message-id <[EMAIL PROTECTED]>
and subject line Now in unstable
has caused the Debian Bug report #485633,
regarding movabletype-opensource: fails to install with Postgresql8.3
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [EMAIL PROTECTED]
immediately.)
--
485633: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=485633
Debian Bug Tracking System
Contact [EMAIL PROTECTED] with problems
--- Begin Message ---
Package: movabletype-opensource
Version: 4.1-6
Severity: important
Tags: patch
Hi,
During the database creation I got this error:
undefined type: at /usr/share/perl5/MT/Upgrade.pm line 1316
I the code, I got:
$defs => mt_tbping.tbping_junk_score: float
$db_defs => mt_tbping.tbping_junk_score: undef
in PostgreSQL => mt_tbping.tbping_junk_score: double precision
MT scans the database to find the tables and columns that need to be fix or
created. It fails to identify that PostgreSQL uses the 'double precision' type
as a float.
ObjectDriver/Driver/DBD/Pg.pm return type==6 for the 'double precision'.
Type 6 is also know by DBD::Pg as SQL_FLOAT but ObjectDriver/DDL.pm doesn't
know SQL_FLOAT and return 'undef' instead.
This is a patch that fix the problem. I'll test is with PostgrSQL 8.2.
Index: lib/MT/ObjectDriver/DDL/Pg.pm
===================================================================
--- lib/MT/ObjectDriver/DDL/Pg.pm.orig
+++ lib/MT/ObjectDriver/DDL/Pg.pm
@@ -204,7 +204,7 @@
} elsif ($type eq 'text') {
return 'text';
} elsif ($type eq 'float') {
- return 'float';
+ return 'double precision';
}
Carp::croak("undefined type: " . $type);
}
Index: lib/MT/ObjectDriver/DDL.pm
===================================================================
--- lib/MT/ObjectDriver/DDL.pm.orig
+++ lib/MT/ObjectDriver/DDL.pm
@@ -385,6 +385,8 @@
return 'smallint';
} elsif ($type == SQL_TINYINT) {
return 'boolean';
+ } elsif ($type == SQL_FLOAT) {
+ return 'float';
} elsif ($type == SQL_DECIMAL) {
return 'float';
} elsif ($type == SQL_DOUBLE) {
-- System Information:
Debian Release: lenny/sid
APT prefers unstable
APT policy: (500, 'unstable'), (1, 'experimental')
Architecture: i386 (i686)
Kernel: Linux 2.6.25-1-686 (SMP w/1 CPU core)
Locale: LANG=fr_FR.UTF-8, LC_CTYPE=fr_FR.UTF-8 (charmap=UTF-8) (ignored: LC_ALL
set to fr_FR.UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages movabletype-opensource depends on:
ii dbconfig-common 1.8.38 common framework for packaging dat
ii debconf 1.5.22 Debian configuration management sy
ii libclass-accessor-perl 0.31-2 Automated accessor generator
ii libdata-objectdriver-perl 0.05-2 Simple, transparent data interface
ii libdbd-mysql-perl 4.007-1 A Perl5 database interface to the
ii libdbd-pg-perl 2.8.0-1 Perl DBI driver for the PostgreSQL
ii libimage-size-perl 3.1.1-2 determine the size of images in se
ii libjcode-pm-perl 2.06-1 Perl extension interface to conver
ii libjson-perl 2.07-1 Perl module to parse and convert t
ii libmime-encwords-perl 1.010.101-1 deal with RFC-1522 encoded words
ii libnet-openid-consumer-per 0.14-2 library for consumers of OpenID id
ii libtheschwartz-perl 1.04-1 reliable job queue
ii liburi-perl 1.35.dfsg.1-1 Manipulates and accesses URI strin
ii libwww-perl 5.812-1 WWW client/server library for Perl
ii libxml-atom-perl 0.28-1 Atom feed and API implementation
ii libxml-sax-perl 0.16+dfsg-3 Perl module for using and building
ii libxml-xpath-perl 1.13-6 Perl module for processing XPath
ii libyaml-tiny-perl 1.29-1 Read/Write YAML files with as litt
ii nbsmtp [mail-transport-age 1.00-4 Simple MTA to send your mails to a
ii perl-modules 5.10.0-10 Core Perl modules
ii ucf 3.007 Update Configuration File: preserv
Versions of packages movabletype-opensource recommends:
ii libsoap-lite-perl 0.710.05-1 Client and server side SOAP implem
ii perl-modules [libar 5.10.0-10 Core Perl modules
ii perlmagick 7:6.3.7.9.dfsg1-2+b2 Perl interface to the libMagick gr
-- debconf information:
movabletype-opensource/purge: false
movabletype-opensource/remote/host:
movabletype-opensource/dbconfig-upgrade: true
movabletype-opensource/pgsql/authmethod-admin: ident
movabletype-opensource/db/dbname: movabletypeopensource
movabletype-opensource/umask_warn:
movabletype-opensource/pgsql/manualconf:
movabletype-opensource/mysql/admin-user: root
* movabletype-opensource/database-type: pgsql
movabletype-opensource/pgsql/no-empty-passwords:
movabletype-opensource/mysql/method: unix socket
movabletype-opensource/upgrade-error: abort
movabletype-opensource/internal/reconfiguring: false
movabletype-opensource/missing-db-package-error: abort
movabletype-opensource/pgsql/admin-user: postgres
movabletype-opensource/pgsql/changeconf: false
movabletype-opensource/pgsql/method: unix socket
movabletype-opensource/remote/newhost:
movabletype-opensource/upgrade-backup: true
movabletype-opensource/internal/skip-preseed: false
* movabletype-opensource/pgsql/authmethod-user: ident
movabletype-opensource/db/basepath:
* movabletype-opensource/passwords-do-not-match:
movabletype-opensource/dbconfig-reinstall: false
movabletype-opensource/dbconfig-remove:
* movabletype-opensource/dbconfig-install: true
movabletype-opensource/install-error: abort
* movabletype-opensource/admin_account_warn: true
movabletype-opensource/db/app-user: movabletypeopensource
movabletype-opensource/remove-error: abort
movabletype-opensource/remote/port:
signature.asc
Description: Digital signature
--- End Message ---
--- Begin Message ---
4.2~rc2 has been uploaded to unstable.
Dominic.
--
Dominic Hargreaves | http://www.larted.org.uk/~dom/
PGP key 5178E2A5 from the.earth.li (keyserver,web,email)
--- End Message ---
