-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Subject: vlogger: mysql_create.sql fix
Package: vlogger
Version: 1.3-4
Severity: normal
Dear Maintainer,
the sample schema database (mysql_create.sql) uses UPPERCASE table name
and fields
that produce these errors on my system (Apache error.log):
DBD::mysql::st execute failed: Table 'vlogger.wwwusage' doesn't exist at
/usr/sbin/vlogger line 517, <STDIN> line 2102.
DBD::mysql::db do failed: Table 'vlogger.wwwusage' doesn't exist at
/usr/sbin/vlogger line 524, <STDIN> line 2102.
after changed table name and fields in lovercase all seems works fine ;-)
I suggest to change mysql_create.sql into:
=======================================================================
CREATE TABLE wwwusage (
vhost VARCHAR(128) NOT NULL,
ldate INT(8) UNSIGNED NOT NULL,
bytes INT(32) UNSIGNED NOT NULL DEFAULT '0'
);
=======================================================================
TIA
Alessandro De Zorzi - lota
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
iQEcBAEBAgAGBQJUoWZdAAoJEMH4AagsOpqywyoIALhAMf9PFNaAVwNL8TJQhD78
nYyb7hG7QDeVezfyOgp0cWW7fCLrAga7+rUguez4E8/kmyiCa73QWC4grw62dWO3
V7Lqn+uHHZg1es0CTQ7cvD+nOs4BDIHPrNuEUosS5TZ27rCzuX1iLvh/RLgAGqOA
VBosqReGxbYwr77KE/BMz+Z5sX7U9RhqHExFDtFWM6Vx2wixhc1dLW0w6TlFVcto
1Ax5ZZyhgMk/3S3IXT6h02QrJqXQnVRvk2SxU+0RYGmGL9vCw0MoSTCjziwo4yGB
3CM2oMVt15QOOS7x4x9omb2tZg5MXR7HY1qd4gZXOAWSSVI9usoYNwj/NnIG1iw=
=IqZ9
-----END PGP SIGNATURE-----
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
