Package: phpwiki Version: 1.3.12p2-1 Severity: normal (This one might be considered 'important', as it will break an upgrade and is slightly nontrivial to correct, but it only affects Postgresql users upgrading, so I leave it to your discretion.)
Upgrading PHPWiki installed against Postgresql did not update any of the tables (adding new rows, or in some cases, entire tables where necessary), and no upgrade SQL scripts were provided to do this by hand. I hacked up the initialization script to do what I needed, but in a very dirty way (if you want it, let me know, and I can send it to you anyway, but I wouldn't want to toss it out as it stands to users). The ideal way of handling this is to create SQL scripts that update from one version to the next for each stage at which there was a schema change, and for each database, and then make them available in the schemas directory for users to run on their own. Potentially, the could be run automatically based on the old version number during the postinst, as well, if the scripts are idempotent (i.e. they would just throw error messages if run on an already-updated database, rather than corrupting the tables). -- System Information: Debian Release: 3.1 APT prefers unstable APT policy: (500, 'unstable'), (500, 'testing') Architecture: i386 (i686) Kernel: Linux 2.6.13.1.erdos Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1) (ignored: LC_ALL set to en_US) Versions of packages phpwiki depends on: ii apache [httpd] 1.3.33-6sarge1 versatile, high-performance HTTP s ii debconf 1.5.0 Debian configuration management sy ii php4 4:4.3.10-16 server-side, HTML-embedded scripti ii php4-pear 4:4.3.10-16 PEAR - PHP Extension and Applicati ii php4-sqlite 1.0.2-7 PHP4 bindings to SQLite, a file-ba ii sqlite 2.8.16-1 command line interface for SQLite ii ucf 1.17 Update Configuration File: preserv -- debconf information: * phpwiki/system/documentroot: /wiki phpwiki/system/localnet: 10.0.0.0/24 phpwiki/webservers: apache * phpwiki/system/accessible: global * phpwiki/system/purgepages: false * phpwiki/notes/configupgrade: * phpwiki/notes/introduction: -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
