PageActivity Plugin Support

1. Rating: +2

   
   
   

   What version of PHP or MySQL is required for this plugin? I keep getting this error when I activate. (This is only the beginning of a string of errors)

   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 'DEFAULT CHARSET=latin1' at line 11]
   CREATE TABLE `naatan_pageactivity` ( `ip` varchar(25) default NULL, `agent` varchar(255) NOT NULL default ”, `referer` varchar(255) NOT NULL default ”, `name` varchar(100) default NULL, `email` varchar(100) default NULL, `website` varchar(255) default NULL, `watching` mediumtext, `url` mediumtext NOT NULL, `timeout` varchar(10) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

   I’m currently running MySQL version 5.0.24a but the plugin was developed on MySQL 4.x, you can try running the following query manually on your database

   CREATE TABLE `naatan_pageactivity` (
     `ip` varchar(25) default NULL,
     `agent` varchar(255) NOT NULL default '',
     `referer` varchar(255) NOT NULL default '',
     `name` varchar(100) default NULL,
     `email` varchar(100) default NULL,
     `website` varchar(255) default NULL,
     `watching` mediumtext,
     `url` mediumtext NOT NULL,
     `timeout` varchar(10) default NULL
   ) ENGINE=MyISAM;

2. Rating: +0

   
   
   

   The mySQL query ran successfully and now I’m getting this error:

   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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=7' at line 7]
   CREATE TABLE `naatan_pageactivity_findreplace` ( `id` smallint(6) NOT NULL auto_increment, `strfind` mediumtext NOT NULL, `strreplace` mediumtext NOT NULL, `type` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
   
   WordPress database error: [Table 'sou073503415178.naatan_pageactivity_findreplace' doesn't exist]
   INSERT INTO naatan_pageactivity_findreplace VALUES (1, '/wp-admin/cat-js.php', '', 'exclude')
   
   WordPress database error: [Table 'sou073503415178.naatan_pageactivity_findreplace' doesn't exist]
   INSERT INTO naatan_pageactivity_findreplace VALUES (2, '/wp-includes/js/tinymce/tiny_mce_gzip.php', '', 'exclude')
   
   WordPress database error: [Table 'sou073503415178.naatan_pageactivity_findreplace' doesn't exist]
   INSERT INTO naatan_pageactivity_findreplace VALUES (3, '/wp-admin/inline-uploading.php', '', 'exclude')
   
   WordPress database error: [Table 'sou073503415178.naatan_pageactivity_findreplace' doesn't exist]
   INSERT INTO naatan_pageactivity_findreplace VALUES (4, '/?feed=rss2', '', 'exclude')
   
   WordPress database error: [Table 'sou073503415178.naatan_pageactivity_findreplace' doesn't exist]
   INSERT INTO naatan_pageactivity_findreplace VALUES (5, '/wp-stats.php', 'Wordpress Statistics', 'replacement')
   
   WordPress database error: [Table 'sou073503415178.naatan_pageactivity_findreplace' doesn't exist]
   INSERT INTO naatan_pageactivity_findreplace VALUES (6, '/notifyme.php', 'Plugin: Naatan.com NotifyMe', 'replacement')
   
   WordPress database error: [Table 'sou073503415178.naatan_pageactivity_findreplace' doesn't exist]
   SELECT * FROM naatan_pageactivity_findreplace
   
   Warning: Cannot modify header information - headers already sent by (output started at /home/content/s/f/d/sfdaily/html/wp-includes/wp-db.php:121) in /home/content/s/f/d/sfdaily/html/wp-includes/pluggable.php on line 275

   Run the following query manually on your database

   CREATE TABLE `naatan_pageactivity_findreplace` (
     `id` smallint(6) NOT NULL auto_increment,
     `strfind` mediumtext NOT NULL,
     `strreplace` mediumtext NOT NULL,
     `type` varchar(50) NOT NULL default '',
     PRIMARY KEY  (`id`)
   ) ENGINE=MyISAM AUTO_INCREMENT=0 ;

   Sorry about that, will fix this in future versions, thanks for reporting.

3. Rating: +0

   
   
   

   PageActivity is not compatible with WP version after 2.3.

   It make selection from wp_categories table that dosn’t exist anymore.

   Regards,
   Emu
   

   Thank you, this has been fixed in the latest version.

4. Rating: +1

   
   
   

   Is it possible to list activity for longer than 10-15 minutes?
   I want to view my page activity for the last two days…

   Thanks!

   Sure it is, but keep in mind that the plugin was not designed for this, such a long period may cause side effects.

   Just edit “naatan_pageactivity.php” in your favourite text editor and search for the following line

   $timeout = time()-900;

   Replace the number “900″ with the time you want entries to remain in your database, note that these are seconds, so for one day, this amount would be “86400″ and for two days “172800″

   So in your case, you would put

   $timeout = time()-172800;

5. Rating: +0

   
   
   

   Now that my database keeps info for the last week, it says things like “2880 minutes ago”. Is it possible to change that to “2 days ago”?

   Tanks in advance,
   Pim

   Like I said the plugin was not designed for tracking statistics over such a long period, but it should be fairly easy to accomplish this if you know a couple of things about PHP.

   There are plenty of people sharing usefull functions on the following page:

   http://uk.php.net/time

   Goodluck, I’ll keep this in mind for the next update, but my main target with this plugin is real-time tracking rather than a historical view of visitors..

Subscribe to Updates for this Plugin