Purchase OIOpublisher now for just $47.

Take control of your ad space.

Click here to purchase

    • CommentAuthornyunyu
    • CommentTimeSep 2nd 2009
     

    My adserver has been running fine since it first established. Just a few minutes ago I logged in to change a few settings and I was shown this error saying my database is missing.

    It asked me to run this query.

    CREATE TABLE IF NOT EXISTS `oiopub_config` (
    `id` int(10) NOT NULL auto_increment,
    `name` varchar(64) NOT NULL,
    `value` longtext NOT NULL,
    `api_load` int(10) NOT NULL default '0',
    PRIMARY KEY (`id`),
    KEY `api_load` (`api_load`)
    ) TYPE=MyISAM;

    CREATE TABLE IF NOT EXISTS `oiopub_purchases` (
    `item_id` int(10) NOT NULL auto_increment,
    `item_channel` int(10) NOT NULL,
    `item_type` int(10) NOT NULL,
    `item_status` int(10) NOT NULL default '0',
    `item_duration` int(10) NOT NULL default '0',
    `item_subscription` int(10) NOT NULL default '0',
    `item_nofollow` int(10) NOT NULL default '0',
    `item_url` varchar(255) NOT NULL,
    `item_tooltip` varchar(128) NOT NULL,
    `item_page` varchar(255) NOT NULL,
    `item_notes` text NOT NULL,
    `link_exchange` varchar(255) NOT NULL,
    `category_id` int(10) NOT NULL default '0',
    `direct_link` int(10) NOT NULL default '0',
    `post_id` int(10) NOT NULL default '0',
    `post_author` int(10) NOT NULL default '0',
    `post_phrase` varchar(64) NOT NULL,
    `adv_name` varchar(128) NOT NULL,
    `adv_email` varchar(128) NOT NULL,
    `submit_time` bigint(20) NOT NULL default '0',
    `submit_api` int(10) NOT NULL default '0',
    `payment_txid` varchar(32) NOT NULL,
    `payment_processor` varchar(32) NOT NULL,
    `payment_currency` varchar(8) NOT NULL,
    `payment_amount` decimal(10,2) NOT NULL default '0.00',
    `payment_time` bigint(20) NOT NULL default '0',
    `payment_next` bigint(20) NOT NULL default '0',
    `payment_status` int(10) NOT NULL default '0',
    `payment_log` text NOT NULL,
    `published_status` int(10) NOT NULL default '0',
    `affiliate_id` varchar(16) NOT NULL,
    `rand_id` varchar(64) NOT NULL,
    PRIMARY KEY (`item_id`),
    KEY `item_channel` (`item_channel`,`item_status`,`payment_status`),
    KEY `rand_id` (`rand_id`)
    ) TYPE=MyISAM;

    CREATE TABLE IF NOT EXISTS `oiopub_purchases_history` (
    `ID` int(10) NOT NULL auto_increment,
    `item` int(10) NOT NULL default '0',
    `processor` varchar(16) NOT NULL,
    `currency` varchar(8) NOT NULL,
    `amount` decimal(10,2) NOT NULL default '0.00',
    `time` bigint(20) NOT NULL default '0',
    `subscription` int(10) NOT NULL default '0',
    PRIMARY KEY (`ID`),
    KEY `item` (`item`),
    KEY `time` (`time`)
    ) TYPE=MyISAM;

    I ran it and nothing changed except the problem seems to be fixed. Still, I want to know what was with that error. What is it means?

    Need help?  Quick start guide | Troubleshooting | All help topics
    • CommentAuthorSimon
    • CommentTimeSep 2nd 2009
     
    Project Admin

    If you're logged in as admin, there is a check that's run to make sure the database tables exists. If they don't, then that message comes up.

    However, since you haven't reported any data loss, it seems unlikely that the database tables had actually disappeared. It's more likely that there was a temporary problem accessing the database or scanning for the tables.

    Need help?  Quick start guide | Troubleshooting | All help topics
    • CommentAuthornyunyu
    • CommentTimeSep 2nd 2009
     

    Ok, that's explained the error.
    I was indeed logged as admin when I saw that error popup.

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