Your message dated Sat, 26 Jul 2008 15:02:07 +0000
with message-id <[EMAIL PROTECTED]>
and subject line Bug#482777: fixed in phpwiki 1.3.14-3
has caused the Debian Bug report #482777,
regarding phpwiki: SQL error during sqlite install
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.)
--
482777: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=482777
Debian Bug Tracking System
Contact [EMAIL PROTECTED] with problems
--- Begin Message ---
Package: phpwiki
Version: 1.3.14-2
Severity: normal
When installing and selecting sqlite, installation gets an SQL error:
populating database via sql... CREATE TABLE pref (
userid CHAR(48) NOT NULL PRIMARY KEY,
prefs MEDIUMTEXT NULL DEFAULT '',
passwd CHAR(48) DEFAULT '',
groupname CHAR(48) DEFAULT 'users',
);
SQL error: near ")": syntax error
Complete installation log attached.
-- System Information:
Debian Release: lenny/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.21-2-486
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages phpwiki depends on:
ii apache2 2.2.8-4~lenny1 Next generation, scalable, extenda
ii apache2-mpm-prefork [http 2.2.8-4~lenny1 Traditional model for Apache HTTPD
ii dbconfig-common 1.8.38 common framework for packaging dat
ii debconf [debconf-2.0] 1.5.21 Debian configuration management sy
ii libapache2-mod-php5 5.2.5-3 server-side, HTML-embedded scripti
ii php-db 1.7.13-2 PHP PEAR Database Abstraction Laye
ii php5-mysql 5.2.5-3 MySQL module for php5
ii php5-sqlite 5.2.5-3 SQLite module for php5
ii ucf 3.006 Update Configuration File: preserv
Versions of packages phpwiki recommends:
ii mysql-client 5.0.51a-6 MySQL database client (meta packag
ii mysql-client-5.0 [mysql-clien 5.0.51a-6 MySQL database client binaries
ii postgresql-client-8.3 [postgr 8.3.1-2+b1 front-end programs for PostgreSQL
ii sqlite 2.8.17-4 command line interface for SQLite
-- debconf information:
* phpwiki/system/documentroot:
phpwiki/pgsql/authmethod-user:
phpwiki/upgrade-error: abort
phpwiki/pgsql/manualconf:
phpwiki/mysql/method: unix socket
phpwiki/upgrade-backup: true
phpwiki/dbconfig-upgrade: true
phpwiki/dbconfig-remove:
phpwiki/remote/newhost:
phpwiki/remote/port:
phpwiki/db/basepath: /var/lib/dbconfig-common/sqlite/phpwiki
phpwiki/remote/host:
phpwiki/purge: false
phpwiki/system/localnet: 10.0.0.0/24
phpwiki/pgsql/admin-user: postgres
phpwiki/internal/skip-preseed: false
phpwiki/install-error: abort
phpwiki/db/app-user:
phpwiki/system/accessible: localhost only
phpwiki/passwords-do-not-match:
phpwiki/mysql/admin-user: root
phpwiki/dbconfig-reinstall: false
phpwiki/pgsql/method: unix socket
* phpwiki/database-type: sqlite
phpwiki/pgsql/changeconf: false
phpwiki/db/dbname: phpwiki
phpwiki/notes/configupgrade:
phpwiki/pgsql/no-empty-passwords:
phpwiki/missing-db-package-error: abort
phpwiki/remove-error: abort
phpwiki/notes/introduction:
phpwiki/internal/reconfiguring: false
* phpwiki/dbconfig-install: true
phpwiki/pgsql/authmethod-admin: ident
[EMAIL PROTECTED]:/$ sudo apt-get install phpwiki
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages were automatically installed and are no longer required:
gnome-keyring libsmbiosxml1 aspell-en libts-0.0-0 libglib-perl
shared-mime-info libqt4-opengl xsltproc libenchant1c2a notification-daemon
libgnomevfs2-0
libgail18 libqt4-assistant libneon27 libgnome2-0 libgtop2-common aspell
libdjvulibre15 djvulibre-plugin libgnomeui-common libgail-common
libgnome-keyring0 libart-2.0-2 app-install-data libavahi-common-data
libdbus-1-3 libqt4-test libdbus-glib-1-2 libqt4-sql-mysql libqt4-dbus
libopenexr2ldbl scrollkeeper docbook-xml libpam-gnome-keyring
libqt4-qt3support libx86-1 libbonoboui2-common gconf2 libbonoboui2-0
libwnck-common
libgnome2-perl libqt4-core libnspr4-0d esound-common libnotify1 libsmbios1
libdirectfb-extra libcwidget1 libgnome-menu2 libsmbclient libfam0
libsmbios-bin libeel2-data libdirectfb-1.0-0 libwnck22 libsexy2 vbetool
libgconf2-4 iceape-gnome-support iceape-browser libxres1 dbus djview4
libhunspell-1.1-0 libgnome2-common powermgmt-base libstartup-notification0
fam libhunspell-1.2-0 libqt4-gui libhal1 hal libqtcore4 libgnome2-vfs-perl
libesd0 libgnomecanvas2-0 deborphan dictionaries-common libvte9 libgnomeui-0
libgtk2-perl libhal-storage1 libidl0 libbonobo2-0 libglade2-0 pm-utils
libqt4-sql libqt4-svg libeel2-2.20 xdg-utils libaudiofile0
libgnomecanvas2-common libqt4-xml libgnomevfs2-extra gconf2-common uswsusp
libqt4-network
libgtop2-7 libqt4-designer synaptic gksu gnome-mime-data libavahi-client3
libqtgui4 liborbit2 libbonobo2-common libgksu2-0 sgml-data libsysfs2 radeontool
libavahi-glib1 hal-info libcairo-perl mozilla-browser esound-clients
libqt4-script dbus-x11 libsplashy1 libnautilus-extension1 libaudio2 gnome-mount
libavahi-common3 portmap libvte-common libscrollkeeper0 libnss3-1d
libaspell15 libmng1 libgnome2-canvas-perl qt4-qtconfig libgnomevfs2-common
Use 'apt-get autoremove' to remove them.
Suggested packages:
php5-imap php5-ldap
The following NEW packages will be installed
phpwiki
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
Need to get 0B/3206kB of archives.
After this operation, 14.9MB of additional disk space will be used.
Preconfiguring packages ...
Configuring phpwiki
-------------------
phpwiki must have a database installed and configured before it can be used.
If you like, this can be handled with dbconfig-common.
If you are an advanced database administrator and know that you want to perform
this configuration manually, or if your database has already been installed
and configured, you should refuse this option. Details on what needs to be
done should most likely be provided in /usr/share/doc/phpwiki.
Otherwise, you should probably choose this option.
Configure database for phpwiki with dbconfig-common? y
phpwiki can be configured to use one of many database types. Below, you will be
presented with the available choices.
1. mysql 2. pgsql 3. sqlite
Database type to be used by phpwiki: 3
Where should the web-accessible location of the PHPWiki be?
This is the directory of your website that people should use to access the
PHPWiki. By default, this is http://yourserver/phpwiki, but you can change it
to
be anything within your server. Enter just the directory portion below.
Web-accessible location of the PHPWiki:
Selecting previously deselected package phpwiki.
(Reading database ... 53814 files and directories currently installed.)
Unpacking phpwiki (from .../phpwiki_1.3.14-2_all.deb) ...
Setting up phpwiki (1.3.14-2) ...
dbconfig-common: writing config to /etc/dbconfig-common/phpwiki.conf
Creating config file /etc/dbconfig-common/phpwiki.conf with new version
Creating config file /etc/phpwiki/dbconf.tmp with new version
creating database phpwiki: success.
verifying database phpwiki exists: success.
populating database via sql... CREATE TABLE pref (
userid CHAR(48) NOT NULL PRIMARY KEY,
prefs MEDIUMTEXT NULL DEFAULT '',
passwd CHAR(48) DEFAULT '',
groupname CHAR(48) DEFAULT 'users',
);
SQL error: near ")": syntax error
done.
Creating config file /etc/phpwiki/config.ini with new version
Creating config file /etc/phpwiki/apache.conf with new version
Reloading web server config: apache2[Sat May 24 15:42:57 2008] [warn] The Alias
directive in /etc/apache2/sites-enabled/phpwiki at line 1 will probably never
match because it overlaps an earlier Alias.
[Sat May 24 15:42:57 2008] [warn] The Alias directive in
/etc/apache2/sites-enabled/phpwiki at line 2 will probably never match because
it overlaps an earlier Alias.
[Sat May 24 15:42:57 2008] [warn] The ScriptAlias directive in
/etc/apache2/sites-enabled/pywiki at line 1 will probably never match because
it overlaps an earlier Alias.
.
--- End Message ---
--- Begin Message ---
Source: phpwiki
Source-Version: 1.3.14-3
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.14-3.diff.gz
to pool/main/p/phpwiki/phpwiki_1.3.14-3.diff.gz
phpwiki_1.3.14-3.dsc
to pool/main/p/phpwiki/phpwiki_1.3.14-3.dsc
phpwiki_1.3.14-3_all.deb
to pool/main/p/phpwiki/phpwiki_1.3.14-3_all.deb
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.8
Date: Sat, 26 Jul 2008 15:38:49 +0100
Source: phpwiki
Binary: phpwiki
Architecture: source all
Version: 1.3.14-3
Distribution: unstable
Urgency: low
Maintainer: Matt Brown <[EMAIL PROTECTED]>
Changed-By: Matt Brown <[EMAIL PROTECTED]>
Description:
phpwiki - informal collaborative website manager
Closes: 450310 482777 489818 492073
Changes:
phpwiki (1.3.14-3) unstable; urgency=low
.
* Remove extraneous comma in sqlite-initialize.sql. (Closes: #482777)
* Include updated watch file thanks to Raphael Geissert. (Closes: #450310)
* Updated pt translation thanks to Ricardo Silva. (Closes: #489818)
* Updated nl translation thanks to Thijs Kinkhorst. (Closes: #492073)
Checksums-Sha1:
1da0d3a23094fe7dfada5af38e582f7ab40c729d 1016 phpwiki_1.3.14-3.dsc
999bd26ca90854d98fb3742c5556f40827cc514e 52856 phpwiki_1.3.14-3.diff.gz
610cc4723f9be5c35de10518abb8767f11802d64 3208096 phpwiki_1.3.14-3_all.deb
Checksums-Sha256:
69add1804fddca27b1dbfdc44a23d4bc42e99900beb52b6d509e4612223d5eef 1016
phpwiki_1.3.14-3.dsc
f461bc33bc10fa8a4f3b61501a4aceb661fb1980d01f954113a43822ca7d4fd5 52856
phpwiki_1.3.14-3.diff.gz
c45a30cfe2d2d2715aa8ac68c87921750c950b70ea0b8c9b4813a7363faffcf5 3208096
phpwiki_1.3.14-3_all.deb
Files:
bd031e30b57d969a22db2552817980c5 1016 web optional phpwiki_1.3.14-3.dsc
b054b629f728d76fd4ee6da1a7fcec8c 52856 web optional phpwiki_1.3.14-3.diff.gz
0a86a0d6f87f163cbb5c651c3da48a93 3208096 web optional phpwiki_1.3.14-3_all.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFIizq6Ptn8gzaTPqMRAjwlAJ4+zvFdME50NR8CQTjJh3YEW1uGLQCdFyA2
Q0OPaPnplQw7PyHVXIQ8EFU=
=cbrG
-----END PGP SIGNATURE-----
--- End Message ---
