Page Statistics Module error (build 758)

[haxhax]

when i link url "http://XXXXXXX/module.php?module=pagestatistics", i got following error

Statistics
Story Title ID Views

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/waakeeco/public_html/class.template.php(674) : eval()'d code on line 19

how can i fix it, thanks!

[haxhax]

anybody who can help me?

[kbeeveer46]

haxhax, there's a bug in this code. Open /modules/page_statistics/templates/page_statistics.tpl and change line 13 to this

$sql="select link_title,link_url,link_id,pv_page_id,count(*) views from ".table_pageviews.",".table_links." where `pv_type`='story' and link_id in(select distinct link_id from pligg_links where link_id=pv_page_id) group by `pv_page_id` order by views desc";

[dollars5]

Thanks kb for fixing - we did not forsee ".table_pageviews.",".table_links." - huh!!

[kbeeveer46]

I fixed it before putting it into the SVN but I forgot to mention it here. All you did was hard code the table prefixes to use pligg_. If people don't use that prefix then it wouldn't work for them.

"table_links" is the equivalent of "theirprefix_links"

[dollars5]

Now we are getting more familiar with creating modules for Pligg - thanks for the headsup.

[haxhax]

Thanks kbeeveer46. it woks fine