Geeklog Forums

Since this month the GUS "Pages Viewed" option (pages.php) returns a blank page.

I placed some echo commands inside pages.php in order to find in which line the script is stopping. Here is the line after which the script stops displaying my echo commands:

$rec = DB_query( "SELECT COUNT(*) AS count, page FROM {$_TABLES['gus_userstats']}
WHERE {$date_compare}
GROUP BY page ORDER BY count DESC" );

I changed the timout setting for the server and in php.ini with no success. Any idea what could be happening?

If you have a lot of data in this table then it is most likely a timeout issue. I have to empty mine every couple of weeks. You could also try repairing and optimizing the table through phpmyadmin to see if that helps.

---

One of the Geeklog Core Developers.

Thanks Laugh, gl_gus_userstats is an InnoDB type table. I cannot repair or optimize it. If I empty it I assume I will loose the general statistics for the past year?

Apparently though, it may be the only solution.