Bugzilla Bug 195843

Switching from 2.10.1 to 2.11.i I get now everey time I clicked onto a table
name :

Page number:

Warning: Division by zero in
/var/www/localhost/htdocs/phpmyadmin/libraries/common.lib.php on line 2165

Warning: Division by zero in
/var/www/localhost/htdocs/phpmyadmin/libraries/common.lib.php on line 2166
>
Warning: Division by zero in
/var/www/localhost/htdocs/phpmyadmin/libraries/common.lib.php on line 2185

Reproducible: Always




tfoerste@n22 ~ $ emerge --info
Portage 2.1.3.9 (default-linux/x86/2007.0, gcc-4.1.2, glibc-2.6.1-r0,
2.6.22-gentoo-r8-pppoe i686)
=================================================================
System uname: 2.6.22-gentoo-r8-pppoe i686 Intel(R) Pentium(R) M processor
1700MHz
Timestamp of tree: Sun, 14 Oct 2007 13:20:01 +0000
ccache version 2.4 [enabled]
app-shells/bash:     3.2_p17
dev-java/java-config: 1.3.7, 2.0.33-r1
dev-lang/python:     2.4.4-r5
dev-python/pycrypto: 2.0.1-r6
dev-util/ccache:     2.4-r7
sys-apps/baselayout: 1.12.9-r2
sys-apps/sandbox:    1.2.17
sys-devel/autoconf:  2.13, 2.61-r1
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10
sys-devel/binutils:  2.18-r1
sys-devel/gcc-config: 1.3.16
sys-devel/libtool:   1.5.24
virtual/os-headers:  2.6.22-r2
ACCEPT_KEYWORDS="x86"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-O2 -march=pentium-m -fomit-frame-pointer -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config
/usr/kde/3.5/shutdown /usr/share/X11/xkb /usr/share/config"
CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/gconf
/etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/
/etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/terminfo
/etc/udev/rules.d"
CXXFLAGS="-O2 -march=pentium-m -fomit-frame-pointer -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="ccache distlocks metadata-transfer parallel-fetch sandbox sfperms
strict unmerge-orphans userfetch"
GENTOO_MIRRORS="http://gentoo.mneisen.org/ ftp://ftp.mneisen.org/gentoo
http://213.186.33.37/gentoo-distfiles/ http://gentoo.mirror.solnet.ch"
LINGUAS="de en"
MAKEOPTS="-j2"
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress
--force --whole-file --delete --delete-after --stats --timeout=180
--exclude=/distfiles --exclude=/local --exclude=/packages
--filter=H_**/files/digest-*"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage"
SYNC="rsync://rsync.de.gentoo.org/gentoo-portage"
USE="X a52 aac acl acpi alsa apache2 arts asf berkdb bitmap-fonts bzip2 cairo
cddb clamav cli cracklib crypt css cups dri dvd dvdr dvdread dynamicplugin
encode exif fam fastbuild fortran gdbm gif gpm gtk i8x0 iconv ipv6 isdnlog jai
java javascript jimi jpeg kde logrotate mad madwifi mbox midi mikmod mmap mmx
mmxext mp3 mp4 mpeg mudflap mysql ncurses nls nntp no-seamonkey nptl nptlonly
nsplugin opengl openmp pam pcre pdf perl png pppd python readline real
reflection samba session spl sse sse2 ssl subversion svg tcpd tiff tk truetype
truetype-fonts type1-fonts unicode userlocales wifi win32codecs workbench x86
xcomposite xml xorg xpm zlib" ALSA_CARDS="intel8x0 intel8x0m"
ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file
hooks iec958 ioplug ladspa lfloat linear meter mulaw multi null plug rate route
share shm softvol" ELIBC="glibc" INPUT_DEVICES="keyboard mouse joystick evdev"
KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001
mtxorb ncurses text" LINGUAS="de en" USERLAND="GNU" VIDEO_CARDS="vga radeon"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS,
PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS

I gave the code a short check in order to see if it might have had anything to
do with the security issue I patched in 2.11.1. But I don't think it is related
and this looks more like an issue in their release.

Please report the bug upstream at

http://sourceforge.net/tracker/?atid=377408&group_id=23067

They also have a help forum here:

http://sourceforge.net/forum/forum.php?forum_id=72909

Might be wise to inquire at the forum first. Maybe somebody else has had the
issue too.

The error comes from the fact that a number of items that should be displayed
equals to zero. Why this is the case I don't know though.

http://sourceforge.net/forum/message.php?msg_id=4568637

Hhm, that issue went away today - I neither able to reproduce this at my user
mode linux image nor at my host system ? Version 2.11.1 seems to be working w/o
that issue. I've no clue whether a reboot did the trick or not...
:-o

Hmm, I spent whole yesterday to reproduce it without success :)

(In reply to comment #4)
> Hmm, I spent whole yesterday to reproduce it without success :)
Sorry for that inconvinience - it works now w/o any issues at my systems ...

I just upgraded to 2.11 and I also get the "division by zero error". 
Unfortunately, a reboot doesn't solve the issue.

Portage 2.1.3.9 (default-linux/x86/2007.0/desktop, gcc-4.1.2, glibc-2.6.1-r0,
2.6.22-gentoo-r8 i686)
=================================================================
System uname: 2.6.22-gentoo-r8 i686 AMD Athlon(tm) 64 Processor 3500+
Timestamp of tree: Wed, 17 Oct 2007 10:50:01 +0000
app-shells/bash:     3.2_p17
dev-java/java-config: 1.3.7, 2.0.33-r1
dev-lang/python:     2.4.4-r5
dev-python/pycrypto: 2.0.1-r6
sys-apps/baselayout: 1.12.9-r2
sys-apps/sandbox:    1.2.17
sys-devel/autoconf:  2.13, 2.61-r1
sys-devel/automake:  1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10
sys-devel/binutils:  2.18-r1
sys-devel/gcc-config: 1.3.16
sys-devel/libtool:   1.5.24
virtual/os-headers:  2.6.22-r2
ACCEPT_KEYWORDS="x86"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-march=k8 -O2 -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/share/X11/xkb /var/bind"
CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/fonts/fonts.conf
/etc/gconf /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/
/etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/splash /etc/terminfo
/etc/udev/rules.d"
CXXFLAGS="-march=k8 -O2 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoclean distlocks metadata-transfer sandbox sfperms strict
unmerge-orphans userfetch"
GENTOO_MIRRORS="http://gentoo.osuosl.org/
http://distro.ibiblio.org/pub/linux/distributions/gentoo/
http://www.gtlib.gatech.edu/pub/gentoo
ftp://mirror.iawnet.sandia.gov/pub/gentoo/
ftp://ftp.ussg.iu.edu/pub/linux/gentoo http://mirrors.acm.cs.rpi.edu/gentoo/ "
LINGUAS="en_US en"
MAKEOPTS="-j2"
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress
--force --whole-file --delete --delete-after --stats --timeout=180
--exclude=/distfiles --exclude=/local --exclude=/packages
--filter=H_**/files/digest-*"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage"
SYNC="rsync://rsync.namerica.gentoo.org/gentoo-portage"
USE="X acl alsa berkdb bitmap-fonts cairo cdr cli cracklib crypt cups dbus dvd
dvdr dvdread eds emboss encode esd evo fam firefox fortran gdbm gif gnome gpm
gstreamer gtk hal iconv isdnlog jpeg mad midi mikmod mp3 mpeg mudflap ncurses
nls nptl nptlonly ogg opengl openmp oss pam pcre pdf perl png pppd python qt3
qt3support qt4 quicktime readline reflection samba sdl session spell spl ssl
svg tcpd tiff truetype truetype-fonts type1-fonts unicode vorbis win32codecs
x86 xml xorg xv zlib" ALSA_CARDS="via82xxv" ALSA_PCM_PLUGINS="adpcm alaw asym
copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat
linear meter mulaw multi null plug rate route share shm softvol" ELIBC="glibc"
INPUT_DEVICES="keyboard mouse" KERNEL="linux" LCD_DEVICES="bayrad cfontz
cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="en_US en"
USERLAND="GNU" VIDEO_CARDS="nvidia"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS,
PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS

Check this forum entry upstream:

http://sourceforge.net/forum/message.php?msg_id=4568739

Does it help?

Thanks, but no, it doesn't help.  A reboot would clear the cache anyway
wouldn't it?

OK, I removed phpmyadmin-2.11.1.1.

# mv /var/www/localhost/htdocs/phpmyadmin/config.inc.php /root/
# emerge -Cav phpmyadmin
# rm -rf /var/www/localhost/htdocs/phpmyadmin

Then reinstalled it:

# emerge phpmyadmin
# mv /root/config.inc.php /var/www/localhost/htdocs/phpmyadmin/

Then all was good again :)

*** Bug 196411 has been marked as a duplicate of this bug. ***

That fixed it for me

(In reply to comment #9)
> OK, I removed phpmyadmin-2.11.1.1.
> 
> # mv /var/www/localhost/htdocs/phpmyadmin/config.inc.php /root/
> # emerge -Cav phpmyadmin
> # rm -rf /var/www/localhost/htdocs/phpmyadmin
> 
> Then reinstalled it:
> 
> # emerge phpmyadmin
> # mv /root/config.inc.php /var/www/localhost/htdocs/phpmyadmin/
> 
> Then all was good again :)
>