Author Topic: no database entries [RESOLVED]  (Read 2971 times)

0 Members and 1 Guest are viewing this topic.

RalphGL

  • Newbie
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
no database entries [RESOLVED]
« on: October 11, 2012, 03:45:49 PM »
I´m using WordPress 3.4.2. and StatComm version 1.7.50 on WP Multisite environment. StatComm is working fine on 4 of my sites, but on a 5. it does not do anything. No entries anywhere, database table size:0,00 MB (0 records). I have checked all but have not found any extraordinary settings there. Any idea?
« Last Edit: October 18, 2012, 07:42:28 AM by RalphGL »

forumadmin

  • Administrator
  • Jr. Member
  • *****
  • Posts: 92
  • Karma: +1/-0
    • View Profile
    • Wordpress Ready
Re: no database entries
« Reply #1 on: October 15, 2012, 06:48:54 AM »
First idea check if the plugin created the table wp_statcomm (or the prefix you are currently using).
Some database restriction could apply in this scenario, even the plugin it's doing its best to check problems like these.

I apologize for the late answer, some alerts are not getting into my mail box.

RalphGL

  • Newbie
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
Re: no database entries [RESOLVED]
« Reply #2 on: October 18, 2012, 07:41:58 AM »
Thx for your helpful advice!

There was NO wp_statcomm table for this site. There are wp_XXX_statcomm tables for some of my sites - even sites which have not activated Statcomm. But not for this one.

So i dumped the empty table of another site end edited it. I changed the site number to the number of my site (i have marked it with XXX in the following dump) and executed the sql on my database. After creating the table on this way statcomm works.

Code: [Select]
CREATE TABLE IF NOT EXISTS `wp_XXX_statcomm` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `date` varchar(8) NOT NULL,
  `time` varchar(8) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `urlrequested` text,
  `agent` text,
  `referrer` text,
  `search` text,
  `nation` tinytext,
  `os` tinytext,
  `browser` tinytext,
  `searchengine` tinytext,
  `spider` varchar(30) NOT NULL DEFAULT '',
  `feed` varchar(7) NOT NULL DEFAULT '',
  `user` tinytext,
  `timestamp` tinytext,
  `language` tinytext,
  `threat_score` smallint(6) DEFAULT '0',
  `threat_type` smallint(6) DEFAULT '0',
  `statuscode` smallint(6) DEFAULT '0',
  UNIQUE KEY `id` (`id`),
  KEY `index_ip` (`ip`) USING BTREE,
  KEY `index_date` (`date`) USING BTREE,
  KEY `index_feed` (`feed`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

I suppose the developer to check how it is possible that a new site can be registered without creating the table wp_statcomm for it.

forumadmin

  • Administrator
  • Jr. Member
  • *****
  • Posts: 92
  • Karma: +1/-0
    • View Profile
    • Wordpress Ready
Re: no database entries [RESOLVED]
« Reply #3 on: October 18, 2012, 08:12:36 AM »
I'm glad you find it!
However, there is something odd on the scenario. Something went wrong and the plugin was unable to warn you.
I'm going to review this area in the next iteration.

Thanks for you feedback!
Fernando