The Support Forums will be in read-only mode for a scheduled maintenance window on 01 September 2016 14:00 UTC - 20:00 UTC. More information.

Track That Stat
SQL error on stats page (1 post)

  1. don_alejandro
    Posted 3 years ago #

    While running on a testing server (set to show errors) I am seeing SQL errors caused by an un-slashed aprostrophe in an SQL statement (see error message below).

    The problem is data that has not been through addslashes:
    'where's hillary hosta'
    should have been
    'where\'s hillary hosta'

    The problem can be fixed by adding
    $keywordData = addslashes($keywordData);
    just above
    if($keyword_interval == "today")
    which is line 131 in keyword stats.php.

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's hillary hosta' AND stat_visitor_id not in('')' at line 1]
    select keyword,stat_visitor_id,visitor_id from wp_tts_keyword_stats where keyword='where's hillary hosta' AND stat_visitor_id not in('')


Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic