Your message dated Fri, 28 Jul 2006 22:02:30 -0700 with message-id <[EMAIL PROTECTED]> and subject line Bug#367426: fixed in phpwiki 1.3.12p3-1 has caused the attached Bug report 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 I am talking about this indicates a serious mail system misconfiguration somewhere. Please contact me immediately.) Debian bug tracking system administrator (administrator, Debian Bugs database)
--- Begin Message ---Package: phpwiki Version: 1.3.12p2-1 Severity: normal When attempting to add the sess_ip column, it attempts to use the following command: ALTER TABLE session ADD sess_ip CHAR(15) NOT NULL The only problem is that Postgresql doesn't allow adding the NOT NULL flag at the same time a new column is created. It has to be done this way: ALTER TABLE session ADD sess_ip CHAR(15); ALTER TABLE session ALTER sess_ip SET NOT NULL; Also, the detection of whether or not sess_ip already exists is broken -- the script will attempt to create it (thus bombing out with an error) even if it already exists. The problem stems from lib/upgrade.php. Unfortunately, I don't have time to fix it; my solution was to comment out the offending lines. This itself wasn't sufficient to get it working, however. The next breakage was on "check for ACCESS_LOG_SQL passwords in POST requests ...", generating the following error: lib/WikiDB/backend/PearDB.php:1027: Error: wikidb_backend_peardb_pgsql: fatal database error * DB Error: syntax error * (UPDATE accesslog SET request_args=CONCAT(left(request_args, LOCATE("s:6:\"passwd\"",request_args)+12),"...") WHERE LOCATE("s:6:\"passwd\"", request_args) AND NOT(LOCATE("s:6:\"passwd\";s:15:\"<not displayed>\"", request_args)) AND request_method="POST" [nativecode=ERROR: syntax error at or near "passwd" at character 75]) And unfortunately, I have not had time to try to deal with this at all. I am starting to wonder if it wouldn't be faster to just try to migrate my data to MediaWiki, except that the most recent version in Debian is still one revision out of date on that, too. :( -- 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.1 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:
--- End Message ---
--- Begin Message ---Source: phpwiki Source-Version: 1.3.12p3-1 We believe that the bug you reported is fixed in the latest version of phpwiki, which is due to be installed in the Debian FTP archive: phpwiki_1.3.12p3-1.diff.gz to pool/main/p/phpwiki/phpwiki_1.3.12p3-1.diff.gz phpwiki_1.3.12p3-1.dsc to pool/main/p/phpwiki/phpwiki_1.3.12p3-1.dsc phpwiki_1.3.12p3-1_all.deb to pool/main/p/phpwiki/phpwiki_1.3.12p3-1_all.deb phpwiki_1.3.12p3.orig.tar.gz to pool/main/p/phpwiki/phpwiki_1.3.12p3.orig.tar.gz A summary of the changes between this version and the previous one is attached. Thank you for reporting the bug, which will now be closed. If you have further comments please address them to [EMAIL PROTECTED], and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Matt Brown <[EMAIL PROTECTED]> (supplier of updated phpwiki package) (This message was generated automatically at their request; if you believe that there is a problem with it please contact the archive administrators by mailing [EMAIL PROTECTED]) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Format: 1.7 Date: Sun, 23 Jul 2006 14:57:04 +1200 Source: phpwiki Binary: phpwiki Architecture: source all Version: 1.3.12p3-1 Distribution: unstable Urgency: low Maintainer: Matt Brown <[EMAIL PROTECTED]> Changed-By: Matt Brown <[EMAIL PROTECTED]> Description: phpwiki - informal collaborative website manager Closes: 361337 366892 366995 367000 367422 367426 377304 Changes: phpwiki (1.3.12p3-1) unstable; urgency=low . * New upstream release - New configuration option DATABASE_OPTIMISE_FREQUENCY set to 0, nightly cron scripts will handle any required vacumning. * Clarified usage instructions for migrate-phpwiki-config (Closes: #367000). * Removed /dev/tty redirects which broke non-interactive upgrades and add --debconf-ok option to ucf calls. (Closes: #377304, Closes: #366995) * Require admin to run the upgrade wizard to complete upgrades * Improve robustness of the upgrade wizard - Remove MySQL specific SQL syntax (Closes: #367426) - Disable automatic schema updates for non MySQL database types * The 'user' table is deprecated in favour of the 'pref' table since 1.3.12 was released, don't try and create it in the upgrade wizard (Closes: #367422). * Backup databases before performing any upgrade tasks (Closes: #361337) * Added patch to base64_decode stored page version data if required. (Closes: #366892). * Tweaked debconf templates to avoid lintian warnings * Fixed a bug in postinst that prevented new configuration defaults being installed during an upgrade. Files: 2d32a2234fdda37e03842be517a2cab1 621 web optional phpwiki_1.3.12p3-1.dsc 7073885a9a3993db0e1820315a224e54 3651174 web optional phpwiki_1.3.12p3.orig.tar.gz db6441f671bbff59bafd693b54048679 46553 web optional phpwiki_1.3.12p3-1.diff.gz dedd85590bb6a7eeaf482f14888c37bc 2851408 web optional phpwiki_1.3.12p3-1_all.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (GNU/Linux) iD8DBQFEyuQl01u8mbx9AgoRApXPAJ0W/6g9kamr9/KegBuGWPkj5Wfw/gCgsTOI OdoLPqiipNsP9vTtU/hcPmM= =Jc4Q -----END PGP SIGNATURE-----
--- End Message ---
