"Products Viewed" stats have stopped updating

[schwimwastaken]

Howdy,

A client contacted us today and let us know that the "products viewed stats have stopped updating. I went to the stats page and clicked one of the products on the page. On stats page refresh, no numbers updated.

Either it's been broken or the stats don't update in real time.

If it's broken, could someone tell me where this code is usually located?

If it's not immediately updated, that would be nice to know too ;)

thanks,
json

[DrByte]

They are updated in real time.
/includes/modules/pages/product_info/main_template_vars.php

    $sql = "update " . TABLE_PRODUCTS_DESCRIPTION . "
            set        products_viewed = products_viewed+1
            where      products_id = '" . (int)$_GET['products_id'] . "'
            and        language_id = '" . (int)$_SESSION['languages_id'] . "'";

    $res = $db->Execute($sql);