Purchase OIOpublisher now for just $47.

Take control of your ad space.

Click here to purchase

    • CommentAuthornyunyu
    • CommentTimeJan 13th 2009
     

    I got this error on the stat tracker page.
    How can I fix it?

    http://www.image-host-script.com/image-D70D_496D09CA.jpg

    Need help?  Quick start guide | Troubleshooting | All help topics
    • CommentAuthorSimon
    • CommentTimeJan 13th 2009
     
    Project Admin

    Is it a fresh install? If not, is there any data in the oiopub_tracker_archive database table?

    Need help?  Quick start guide | Troubleshooting | All help topics
    • CommentAuthornyunyu
    • CommentTimeJan 13th 2009
     

    Yes, its a fresh install.

    Need help?  Quick start guide | Troubleshooting | All help topics
    • CommentAuthornyunyu
    • CommentTimeJan 14th 2009
     

    The error like the one in screenshot is
    Warning: Invalid argument supplied for foreach() in /home3/adnetcen/public_html/modules/tracker/oiopub-load.php on line 705

    Simon, what do I need to do?

    Need help?  Quick start guide | Troubleshooting | All help topics
    • CommentAuthornyunyu
    • CommentTimeJan 14th 2009
     

    I looked into PHPmyadmin, there are 6 tables and there is no "oiopub_tracker_archive" like what you said earlier.

    oiopub_affiliates
    oiopub_affiliates_hits
    oiopub_affiliates_sales
    oiopub_config
    oiopub_purchases
    oiopub_purchases_history

    Need help?  Quick start guide | Troubleshooting | All help topics
    • CommentAuthorSimon
    • CommentTimeJan 14th 2009 edited
     
    Project Admin

    At least we know the problem then. Looks like the tracker database tables haven't installed themselves at all (I presume just a freak occurence at this stage).

    Enter this information into the "SQL" tab of phpmyadmin:

    CREATE TABLE IF NOT EXISTS `oiopub_tracker_clicks` (
    `id` int(10) NOT NULL auto_increment,
    `pid` int(10) NOT NULL default '0',
    `time` bigint(20) NOT NULL default '0',
    `date` date NOT NULL,
    `ip` bigint(20) NOT NULL default '0',
    `agent` text NOT NULL,
    `referer` text NOT NULL,
    `status` int(10) NOT NULL default '0',
    PRIMARY KEY (`id`)
    ) TYPE=MyISAM;
    CREATE TABLE IF NOT EXISTS `oiopub_tracker_visits` (
    `id` int(10) NOT NULL auto_increment,
    `pids` text NOT NULL,
    `time` bigint(20) NOT NULL default '0',
    `date` date NOT NULL,
    `ip` bigint(20) NOT NULL default '0',
    `agent` text NOT NULL,
    `referer` text NOT NULL,
    `status` int(10) NOT NULL default '0',
    PRIMARY KEY (`id`)
    ) TYPE=MyISAM;
    CREATE TABLE IF NOT EXISTS `oiopub_tracker_archive` (
    `id` int(10) NOT NULL auto_increment,
    `pid` int(10) NOT NULL default '0',
    `time` bigint(20) NOT NULL default '0',
    `date` date NOT NULL,
    `unique_clicks` int(10) NOT NULL default '0',
    `total_clicks` int(10) NOT NULL default '0',
    `unique_visits` int(10) NOT NULL default '0',
    `total_visits` int(10) NOT NULL default '0',
    PRIMARY KEY (`id`),
    KEY `pid` (`pid`),
    KEY `date` (`date`)
    ) TYPE=MyISAM;

    If you are still testing things and haven't completed setup, you could also simply press the uninstall button in the admin settings area, then re-install.

    Need help?  Quick start guide | Troubleshooting | All help topics
    • CommentAuthornyunyu
    • CommentTimeJan 14th 2009
     

    Thanks! the error is now gone.
    Then the doubt came....
    If I use html banners such as adsense, clicksor, adbrite, will it reflect on the stats when people clicking on the ads?

    Need help?  Quick start guide | Troubleshooting | All help topics
    • CommentAuthorSimon
    • CommentTimeJan 14th 2009
     
    Project Admin

    No, it can't track 3rd party ad networks. It may be possible in the future, but it isn't something I've looked into yet.

    Need help?  Quick start guide | Troubleshooting | All help topics
    • CommentAuthornyunyu
    • CommentTimeJan 14th 2009
     

    Ok, looking forward to see that happen. :)

    Need help?  Quick start guide | Troubleshooting | All help topics