Forum Statistics Extension Error Message

Oreganoflow

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

Minisweeper

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...

Oreganoflow

the attribues are 644 already.

Minisweeper

My bad. Try 666.

Oreganoflow

Aha! Thanks.

SlashedZero

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.

bugsmi0

i get the same error, anyone find a fix ?

bugsmi0

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

bugsmi0

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

Minisweeper

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.

SlashedZero

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.

bugsmi0

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

SlashedZero

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.

robb

I also get this error on my vanilla install, so I've decided to stop using Forum Statistics for now.

bugsmi0

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";