Debian Bug report logs -
#647042
Bad installation sql script for the pma_history table
Reported by: David Santamaría Rogado <howl.nsp@gmail.com>
Date: Sat, 29 Oct 2011 17:27:01 UTC
Severity: normal
Found in version 4:3.3.7-6
Fixed in version phpmyadmin/4:3.4.0-2
Done: Michal Čihař <nijel@debian.org>
Bug is archived. No further changes may be made.
Toggle useless messages
Report forwarded
to debian-bugs-dist@lists.debian.org, Thijs Kinkhorst <thijs@debian.org>:
Bug#647042; Package phpmyadmin.
(Sat, 29 Oct 2011 17:27:04 GMT) (full text, mbox, link).
Acknowledgement sent
to David Santamaría Rogado <howl.nsp@gmail.com>:
New Bug report received and forwarded. Copy sent to Thijs Kinkhorst <thijs@debian.org>.
(Sat, 29 Oct 2011 17:27:04 GMT) (full text, mbox, link).
Message #5 received at submit@bugs.debian.org (full text, mbox, reply):
Package: phpmyadmin
Version: 4:3.3.7-6
The sql creation script
"/usr/share/dbconfig-common/data/phpmyadmin/install/mysql" for the
pma_history table has an invalid parameter lenght for timestamp time,
as it's defined as timestamp(14).
Since MySQL 4.1 timestamp should be defined as timestamp(n) and it's
no longer supported in MySQL 5.5. And in MariaDB 5.3 the max precision
is 6 so it causes an error "mysql said: ERROR 1426 (42000) at line 72:
Too big precision 14 specified for 'timevalue'. Maximum is 6.".
Changing timestamp(14) to timestamp makes it possible to install under
MySQL 5.5 and MariaDB 5.3 and previous versions of both.
Information forwarded
to debian-bugs-dist@lists.debian.org, Thijs Kinkhorst <thijs@debian.org>:
Bug#647042; Package phpmyadmin.
(Sat, 29 Oct 2011 17:48:03 GMT) (full text, mbox, link).
Acknowledgement sent
to David Santamaría Rogado <howl.nsp@gmail.com>:
Extra info received and forwarded to list. Copy sent to Thijs Kinkhorst <thijs@debian.org>.
(Sat, 29 Oct 2011 17:48:03 GMT) (full text, mbox, link).
Message #10 received at 647042@bugs.debian.org (full text, mbox, reply):
Typo: "Since MySQL 4.1 timestamp shouldN'T be defined as timestamp(n)..."
Reply sent
to Michal Čihař <nijel@debian.org>:
You have taken responsibility.
(Mon, 31 Oct 2011 09:21:33 GMT) (full text, mbox, link).
Notification sent
to David Santamaría Rogado <howl.nsp@gmail.com>:
Bug acknowledged by developer.
(Mon, 31 Oct 2011 09:21:38 GMT) (full text, mbox, link).
Message #15 received at 647042-done@bugs.debian.org (full text, mbox, reply):
[Message part 1 (text/plain, inline)]
Package: phpmyadmin
Version: 4:3.4.0-2
Hi
Dne Sat, 29 Oct 2011 19:25:05 +0200
David Santamaría Rogado <howl.nsp@gmail.com> napsal(a):
> Package: phpmyadmin
> Version: 4:3.3.7-6
>
> The sql creation script
> "/usr/share/dbconfig-common/data/phpmyadmin/install/mysql" for the
> pma_history table has an invalid parameter lenght for timestamp time,
> as it's defined as timestamp(14).
>
> Since MySQL 4.1 timestamp should be defined as timestamp(n) and it's
> no longer supported in MySQL 5.5. And in MariaDB 5.3 the max precision
> is 6 so it causes an error "mysql said: ERROR 1426 (42000) at line 72:
> Too big precision 14 specified for 'timevalue'. Maximum is 6.".
>
> Changing timestamp(14) to timestamp makes it possible to install under
> MySQL 5.5 and MariaDB 5.3 and previous versions of both.
This has been already fixed in 4:3.4.0-2.
--
Michal Čihař | http://cihar.com | http://blog.cihar.com
[signature.asc (application/pgp-signature, attachment)]
Bug archived.
Request was from Debbugs Internal Request <owner@bugs.debian.org>
to internal_control@bugs.debian.org.
(Tue, 29 Nov 2011 07:36:48 GMT) (full text, mbox, link).
Send a report that this bug log contains spam.
Debian bug tracking system administrator <owner@bugs.debian.org>.
Last modified:
Sat Jan 13 16:55:35 2018;
Machine Name:
beach
Debian Bug tracking system
Debbugs is free software and licensed under the terms of the GNU
Public License version 2. The current version can be obtained
from https://bugs.debian.org/debbugs-source/.
Copyright © 1999 Darren O. Benham,
1997,2003 nCipher Corporation Ltd,
1994-97 Ian Jackson,
2005-2017 Don Armstrong, and many other contributors.