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:
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
