Bug: username with ' sample ol'chous generate цarning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /.../extensions/Statistics/default.php on line 192

I had that same problem with this extension installed. Is there any fix for this?

The solution to the missing link on the new user link is very simpel.

Just open the default.php from your \extention\statistics page and scroll down to the "function GetUserLink($Username) {"
aprox line 192

between the line that says "function GetUserLink($Username) {" and "$USER_TABLE = (isset($this->Context->DatabaseTables['User']))"......
add the following:

$Username=trim($Username);


So your lines should look like:

function GetUserLink($Username) {

$Username=trim($Username);

$USER_TABLE = (isset($this->Context->DatabaseTables['User'])) ? $this->Context->DatabaseTables['User'] : $Context->DatabaseTables['User'];



This should do the trick.

Would this be caused by the apostrophe?

Posted: Tuesday, 24 June 2008 at 5:02PM

replace the line "$Username=trim($Username);" in my previous bug fix with


$Username=mysql_escape_string(trim($Username));


I think that will fix the bug with the apostrophe, and the userlink!

Vincent:

If you bring an update pls dont forget to update the "Version: 0.4.6" in "default.php"

else the update routine will not check that the newest version is installed and will ask anytime to get the latest.