Division by zero in maincore.php?: PHPFusion 6 Support

Home
Search

Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.

I have noticed the following warning at the bottom of some of my pages ... Warning: Division by zero in /var/www/mucus/maincore.php on line 570

in my maincore.php this is the code that surrounds line 570, the line itself is in red... the variable $count is not found anywhere else in the page .. i even checked the version in the CVS browser here, and it matches .. so i'm not sure how $count is set to a number and why now i'm getting a division by zero warning. it may that its been there for a while, but i just noticed it now ... its not affecting anything on the page, so i guess its not crucial! i have the makepagenav function used in some other custom pages, and the warning is NOT shown on those pages ... its only on the news archive page.

like always, thanx for ur help!

Code Download source

function makepagenav($start,$count,$total,$range=0,$link=""){
   global $locale;
   if ($link == "") $link = FUSION_SELF."?";
   $res="";
   [color=red]$pg_cnt=ceil($total / $count);[/color]
   if ($pg_cnt > 1) {
      $idx_back = $start - $count;
      $idx_next = $start + $count;
      $cur_page=ceil(($start + 1) / $count);
      $res.="<table cellspacing='1' cellpadding='1' border='0' class='tbl-border'>\n<tr>\n";
      $res.="<td class='tbl2'><span class='small'>".$locale['052']."$cur_page".$locale['053']."$pg_cnt</span></td>\n";
      if ($idx_back >= 0) {
         if ($cur_page > ($range + 1)) $res.="<td class='tbl2'><a class='small' href='$link"."rowstart=0'><<</a></td>\n";
         $res.="<td class='tbl2'><a class='small' href='$link"."rowstart=$idx_back'><</a></td>\n";
      }
      $idx_fst=max($cur_page - $range, 1);
      $idx_lst=min($cur_page + $range, $pg_cnt);
      if ($range==0) {
         $idx_fst = 1;
         $idx_lst=$pg_cnt;
      }
      for($i=$idx_fst;$i<=$idx_lst;$i++) {
         $offset_page=($i - 1) * $count;
         if ($i==$cur_page) {
            $res.="<td class='tbl1'><span class='small'><b>$i</b></span></td>\n";
         } else {
            $res.="<td class='tbl1'><a class='small' href='$link"."rowstart=$offset_page'>$i</a></td>\n";
         }
      }
      if ($idx_next < $total) {
         $res.="<td class='tbl2'><a class='small' href='$link"."rowstart=$idx_next'>></a></td>\n";
         if ($cur_page < ($pg_cnt - $range)) $res.="<td class='tbl2'><a class='small' href='$link"."rowstart=".($pg_cnt-1)*$count."'>>></a></td>\n";
      }
      $res.="</tr>\n</table>\n";

   }
   return $res;
}

Admin Note: Please turn off smiley when posting code

Edited by shedrock on 26-02-2006 22:10, 18 y

0 replies

Falk

answered 26 Feb 2006 at 08:40 PM

Super Admin

News Archive?

0 replies

I think he is referring to the news_archive mod Digi. If so, then he needs to visit the MOD site for an updated version. ;)

Shedrock

0 replies

yes i was referring to the mod, and sorry i posted on the wrong site .. :(

but thanx for the heads up shedrock .... and i'll try to keep track of where im posting for next time ... ;)

0 replies

— 3 months later —

Quote

Foto albumai
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

Warning: Division by zero in /home/phpfusion/domains/php-fusion.lt/public_html/maincore.php on line 528

0 replies

this slip-up may co-located hosting

Quote

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

0 replies

error not

Quote

Warning: Division by zero in /home/phpfusion/domains/php-fusion.lt/public_html/maincore.php on line 528

though this though

http://php-fusion.lt/photogallery.php

Quote

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

0 replies

Falk

answered 15 Jun 2006 at 08:11 PM

Super Admin

Quote

riomas wrote:

Quote
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

Its difficult to diagnose, can you create a full admin account for me? pm me access info.

0 replies

it is all over bar the shouting OK thanks ;)

0 replies

Quote

TammyK wrote:
It's still something that should be protected against.

Adding:
Code Download source
 
if(empty($count)) return;
Directly above:
Code Download source
$pg_cnt=ceil($total / $count);
should keep the function from throwing that error.

This gets rid of this error:

Quote

Warning: Division by zero in /home/googleci/public_html/maincore.php on line

But this one still remains...

Quote

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

0 replies

Category Forum

Bugs and Errors - 6

Labels

None yet

Statistics

Views 0 views
Posts 9 posts
Votes 0 votes
Topic users 5 members

0 participants

Notifications

Track thread

You are not receiving notifications from this thread.

Division by zero in maincore.php?

9 posts

PHPFusion

Resources

Community

Development