We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 26182
    • 164 Posts
    Hi,

    I’m having some problems with the NowBrowsing snippet. I get this error when I try to load the page.

    « MODx Parse Error »
    MODx encountered the following error while attempting to parse the requested resource:
    « Execution of a query to the database failed - Table 'modx.modx_log_access' doesn't exist »
          SQL: SELECT DISTINCT(visitor) AS visitor, MAX(timestamp) AS lasthit FROM `modx`.modx_log_access WHERE timestamp > 1173231587 GROUP BY visitor ORDER BY lasthit DESC
          [Copy SQL to ClipBoard]
     
    Parser timing
      MySQL: 	0.0226 s	(11 Requests)
      PHP: 	0.0449 s	 
      Total: 	0.0674 s


    I’ve checked through the tables in the modx database and modx.modx_log_access does not exist. Do I need to create this table? How then does this table receive its’ data?

    Any help you could provide would be greatly appreciated.

    Thankyou.

    Sarah smiley
      • 18397
      • 3,250 Posts
      That release was for MODx 0.9.2.2 or earlier which had visitor tracking.... It is no longer supported.
        • 26182
        • 164 Posts
        Oh ok. So is there a replacement? I have tried installing the webanalyse snippet but I am having difficulties. What tables are used to store the user login details and count how many users are curretly logged in?