WassUp Forums

• Forums
• WassUp

1. 

   fym
   Member

   Hi,

   are there any requirements (e.g. sql-wise) for the display of the graphical chart? Cause locally things are fine, the chart shows up. But online at my blog, the chart (as well as its whole div-area "placeholder") won't display.

   MySQL 5.0.51b is locally installed
   5.0.51a is used on the webspace of the blog

   Any ideas?

   Posted 3 years ago #
2. 

   Michele
   Key Master

   Have you select from the options page to display the chart? could you send a screenshot or the html code?
   Thank you

   Michele - WassUp Project

   Posted 3 years ago #
3. 

   fym
   Member

   Screenshot: Here
   The html, where the chart is supposed to be:

   <div class='main-tabs'>
<div id='usage'>

   • <span style="border-bottom:2px solid #0077CC;">389</span> <small>Besucher</small>
   • <span style="border-bottom:2px dashed #FF6D06;">1192</span> <small>Seitenansichten</small>
   • <span>3.06</span> <small>Seiten/Besucher</small>
   • <span>2</span> <span>(0.17%)</span> <small>davon Spam</small>

   </div>
</div>


   Posted 3 years ago #
4. 

   fym
   Member

   Also: which selectable option do you mean? There's only an option to display a small chart on the dashboard.

   Posted 3 years ago #
5. 

   fym
   Member

   Okay, so I tried to narrow it down a bit. It seems, that the "problem" lies somewhere with the SQL-Query in the "TheChart"-function (main.php). Up until the definition of $aitems it seems to work, but something in that query is bothering. If I try for debugs sake to echo $aitems in pre tags right after its definition, nothing shows up (??).

   Maybe it's in fact related to my webhost's MySQL-Version? Wasn't there some bug in 5.0.51a?

   Posted 3 years ago #
6. 

   fym
   Member

   Well, it's related to the SQL-query, which returns no data. So with count($aitems) == 0 the generation of the chart within the if statement is disregarded. Any idea what about the sql query isn't functioning with MySQL 5.0.51a?

   Posted 3 years ago #
7. 

   fym
   Member

   4th time's the cha... well, now the graph shows up.

   It seems, that the CAST... clause within the DATE_FORMAT statement caused the error on my webspace. So I changed
   [...] DATE_FORMAT(FROM_UNIXTIME(CAST((timestamp-$UTCoffset) AS UNSIGNED)), '$x_axes_label') as thedate[...]
   simply to "timestamp as thedate" and instead converted the timestamps via PHP. Also had to get rid of the CAST within the GROUP BY statement. Don't know, how this affects the graph, but this way it shows up - at least ;)

   Posted 3 years ago #
8. 

   Michele
   Key Master

   Hi fym,
   sorry for the delay, please could you send me your changes (my email is "michele AT befree DOT it") so I could look at them?
   Thank you very much

   Posted 3 years ago #

RSS feed for this topic

Reply

You must log in to post.