-----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