On Tue, 2005-10-04 at 17:38 -0500, Zed Pobre wrote: > Package: phpwiki > Version: 1.3.10-1 > Severity: important > > Session handling gets broken on upgrade by default. The following SQL > is required to correct: > > ALTER TABLE session ADD COLUMN sess_ip char(15); > ALTER TABLE session ALTER COLUMN sess_ip SET NOT NULL; > > You may want to try to to add a call to check to see if the sess_ip > column is missing when a session SQL call fails, and if so, do this > automatically.
This should already be handled by the postinst script. When an upgrade of a SQLite database is detected the SQL script it /usr/share/doc/phpwiki/schemas is executed on the existing database. Of course this upgrade will only occur for the database managed by the default PHPwiki installation, not any others that you have configured on the machine. I'll fix the bugs relating to this use case as a part of #331709. Can you check whether the prefs table exists in your database(s)? This table is new in 1.3.10 and is also created by the SQLlite upgrade script. Thanks for the report. -- Matt Brown [EMAIL PROTECTED] Mob +64 275 611 544 www.mattb.net.nz -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]