Active
Project:
DB Tuner
Version:
6.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
11 Dec 2010 at 23:28 UTC
Updated:
9 Mar 2013 at 22:33 UTC
i get the following error on the dbtuner tab with both release and dev version
warning: Division by zero in /home/xxxxx/public_html/sites/all/modules/dbtuner/dbtuner.mysqltuner.inc(84) : eval()'d code on line 1
Comments
Comment #1
virtuali1151 commentedI am getting this error as well... Any fix avail..??
Comment #2
sdsheridanThis seems to be coming from expressions using the MySQL Status value of uptime_since_flush_status. However, apparently uptime_since_flush_status is only available on 5.0 COMMUNITY servers from 5.0.35 - not on ENTERPRISE servers and not in any other major branch than 5.0 and also not in 5.0.x before 5.0.35, and then again from what I can tell from the MySQL bug issue where this arose (http://bugs.mysql.com/bug.php?id=24822), not necessarily consistently in all versions (see 6 May 2009 22:23 Bugs System entry where is says it was pushed into 5.0.82).
The way I got around this was to insert the following after the 'else' on line 76 of dbtuner.mysqltuner.inc:
My division by zero warnings have gone away, and I have more information than I did before on a bunch of things. Not sure if this is the 'right' thing to do, but it seems reasonable.
Shawn
Comment #3
virtuali1151 commentedtried this.. but still get this error:
Type: php
Division by zero in /home/site/public_html/sites/all/modules/dbtuner/dbtuner.mysqltuner.inc(87) : eval()'d code on line 1.
Backtrace:
eval(NULL)[dbtuner.mysqltuner.inc:87];
.dbtuner_mysqltuner_process_data(array)[dbtuner.mysqltuner.inc:14];
..dbtuner_mysqltuner_page(a:0:{})[?:?];
...call_user_func_array(a:2:{i:0;s:23:"dbtuner_mysqltuner_page";i:1;a:0:{}})[menu.inc:348];
....menu_execute_active_handler(a:0:{})[index.php:18];
.....index.php
Comment #4
sdsheridanYou'll want to look for a variable that is used in the configuration file and in particular in a division that does not exist on your MySQL installation.
Comment #5
gateway69 commentedIm not getting the lines you are.. but In my admin area for db tuner mysqltuner option im seeing this error
Comment #6
robit8deb commentedI get these too. using drupal 6 php 5.3
Comment #7
mattwmc commentedGetting it too after upgrading to php 5.3 (D6).