Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Options

Forum Statistics Extension Error Message

Whenever I enable Forum Statistics, I get this: Any ideas??? I downloaded the recent one Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/virtual/site448/fst/var/www/html/extensions/Statistics/default.php on line 83 Warning: Invalid argument supplied for foreach() in /home/virtual/site448/fst/var/www/html/extensions/Statistics/default.php on line 85 Warning: fopen(/home/virtual/site448/fst/var/www/html/extensions/Statistics/options.inc): failed to open stream: Permission denied in /home/virtual/site448/fst/var/www/html/extensions/Statistics/default.php on line 58 Warning: fwrite(): supplied argument is not a valid stream resource in /home/virtual/site448/fst/var/www/html/extensions/Statistics/default.php on line 59 Warning: fclose(): supplied argument is not a valid stream resource in /home/virtual/site448/fst/var/www/html/extensions/Statistics/default.php on line 60

Comments

  • Options
    Does the options.inc file exist and if so what are the permissions on it? Up them to 644 (and create it) if they arent already. That should wipe out atleast one of the errors...
  • Options
    the attribues are 644 already.
  • Options
    My bad. Try 666.
  • Options
    Aha! Thanks.
  • Options
    edited October 2006
    I get the same kind of error:

    Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in ../extensions/Statistics/default.php on line 83
    Warning: Invalid argument supplied for foreach() in ../extensions/Statistics/default.php on line 85

    I've tried to change permissions to 777 (it was already at 666) and it still happens each time there is a new comment made.

    Does somebody have an idea how to fix this? The problem seems to be located here:
    if($this->Statistics[$data][0] == 1) { $tmpData = mysql_fetch_assoc($this->Context->Database->Execute($value, '', '', '', '')); $i=1; foreach($tmpData AS $tmptmpdata) { $this->Statistics[$data][$i] = $tmptmpdata; $i++; }

    I don't have this problem on local with a fresh install, so it may be related to an extension conflict.
  • Options
    i get the same error, anyone find a fix ?
  • Options
    this is getting annoying, had to disable the statistic extension, have all the right file permissions and the error msg still shows wish they would really test these things out before adding them (runs into a corner and cries) lol wah wah, worked perfectly on localhost
  • Options
    sure thing :-) this is the error msg Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in ../extensions/Statistics/default.php on line 83 Warning: Invalid argument supplied for foreach() in ../extensions/Statistics/default.php on line 85 and msql version is 4.0.27
  • Options
    Do you guys know which statistics it is and isnt managing to get? What the line in question actually does depends on how far through the array of queries the extension gets before erroring.
  • Options
    In my case it seems to work with everything except the newest user's name. For some reason, the name is gilliu00_ , and none of my user is called like that.
  • Options
    Warning: mysql_fetch_assoc() seems to be about the mysql version being used ? not sure it doesn't show on local only on live server the two msyql are different versions is admin the only one who can see this error is can users see it too
  • Options
    edited October 2006
    Dunno, but I get this error only on my live site, and its MySQL version is 4.0.25. It doesn't appear on my local site, which runs on 4.1.something.
  • Options
    I also get this error on my vanilla install, so I've decided to stop using Forum Statistics for now.
  • Options
    edited October 2006
    this one here fixed the mysql error, in the statistics default.php around line 76

    This SHOULD be equilivent
    
    $this->StatisticsSQL['newest_user'] = "SELECT $USER_TABLE.$USERNAME FROM `$USER_TABLE` ORDER BY $USERID DESC LIMIT 0, 1";
This discussion has been closed.