Results 1 to 3 of 3

Thread: Empty table

  1. #1
    Thread Starter
    Junior Member ldopi's Avatar
    Join Date
    Jan 2011
    Location
    France
    Posts
    30
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Empty table

    The theme don't work. Pepsi said a problem during installation ... ?
    I try more than 10 fresh install always the same issue.

    The installation create 8 Tables ni Database (MySQL) but some table are empty. The records are not create.

    I Use Apache and Windows 2008

    wp_cp_ad_fields => 0 record
    wp_cp_ad_forms => 0 record
    wp_cp_ad_meta => 0 record
    wp_cp_ad_packs => 1 record (pack_name : 30 days for only $5)
    wp_cp_ad_pop_daily => 0 record
    wp_cp_ad_pop_total => 0 record
    wp_cp_coupons => 0 record
    wp_cp_order_info => 0 record

    I made more than 10 fresh install (news DB) (US / FR / WP 3.0,3.01,.3.04,WP 3.1 RC1, RC 2) Always the same issue; I have a big headhache now

    Always the template said installation OK, The Tables are create, the seems to be ok, but impossible to add ads etc.

    Do you have an idea ? Or do you have a the SQL query to create the record in all table ?


    You will found above the table in my Database

    -- Table "wp_cp_ad_fields" DDL

    CREATE TABLE `wp_cp_ad_fields` (
    `field_id` int(10) NOT NULL auto_increment,
    `field_name` varchar(255) NOT NULL,
    `field_label` varchar(255) NOT NULL,
    `field_desc` longtext,
    `field_type` varchar(255) NOT NULL,
    `field_values` longtext,
    `field_tooltip` longtext,
    `field_search` varchar(255) default NULL,
    `field_perm` int(11) NOT NULL,
    `field_core` int(11) NOT NULL,
    `field_req` int(11) NOT NULL,
    `field_owner` varchar(255) NOT NULL,
    `field_created` datetime NOT NULL default '0000-00-00 00:00:00',
    `field_modified` datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY (`field_id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;



    -- Table "wp_cp_ad_forms" DDL

    CREATE TABLE `wp_cp_ad_forms` (
    `id` int(10) NOT NULL auto_increment,
    `form_name` varchar(255) NOT NULL,
    `form_label` varchar(255) NOT NULL,
    `form_desc` longtext,
    `form_cats` longtext NOT NULL,
    `form_status` varchar(255) default NULL,
    `form_owner` varchar(255) default NULL,
    `form_created` datetime NOT NULL default '0000-00-00 00:00:00',
    `form_modified` datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;


    -- Table "wp_cp_ad_meta" DDL

    CREATE TABLE `wp_cp_ad_meta` (
    `meta_id` int(10) NOT NULL auto_increment,
    `form_id` int(10) NOT NULL,
    `field_id` int(10) NOT NULL,
    `field_req` varchar(255) NOT NULL,
    `field_pos` int(10) NOT NULL,
    PRIMARY KEY (`meta_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;



    -- Table "wp_cp_ad_packs" DDL

    CREATE TABLE `wp_cp_ad_packs` (
    `pack_id` int(10) NOT NULL auto_increment,
    `pack_name` varchar(255) NOT NULL,
    `pack_desc` longtext,
    `pack_price` decimal(10,2) unsigned NOT NULL default '0.00',
    `pack_duration` int(5) NOT NULL,
    `pack_images` int(5) unsigned NOT NULL default '0',
    `pack_status` varchar(50) NOT NULL,
    `pack_owner` varchar(255) NOT NULL,
    `pack_created` datetime NOT NULL default '0000-00-00 00:00:00',
    `pack_modified` datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY (`pack_id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;



    -- Table "wp_cp_ad_pop_daily" DDL

    CREATE TABLE `wp_cp_ad_pop_daily` (
    `id` mediumint(9) NOT NULL auto_increment,
    `time` date NOT NULL default '0000-00-00',
    `postnum` int(11) NOT NULL,
    `postcount` int(11) NOT NULL default '0',
    UNIQUE KEY `id` (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;



    -- Table "wp_cp_ad_pop_total" DDL

    CREATE TABLE `wp_cp_ad_pop_total` (
    `id` mediumint(9) NOT NULL auto_increment,
    `postnum` int(11) NOT NULL,
    `postcount` int(11) NOT NULL default '0',
    UNIQUE KEY `id` (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;



    -- Table "wp_cp_coupons" DDL

    CREATE TABLE `wp_cp_coupons` (
    `coupon_id` int(10) NOT NULL auto_increment,
    `coupon_code` varchar(100) NOT NULL,
    `coupon_desc` longtext,
    `coupon_discount` decimal(10,2) unsigned NOT NULL default '0.00',
    `coupon_discount_type` varchar(50) NOT NULL,
    `coupon_start_date` datetime NOT NULL default '0000-00-00 00:00:00',
    `coupon_expire_date` datetime NOT NULL default '0000-00-00 00:00:00',
    `coupon_status` varchar(50) NOT NULL,
    `coupon_use_count` int(11) NOT NULL default '0',
    `coupon_max_use_count` int(11) NOT NULL default '0',
    `coupon_owner` varchar(255) NOT NULL,
    `coupon_created` datetime NOT NULL default '0000-00-00 00:00:00',
    `coupon_modified` datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY (`coupon_id`),
    UNIQUE KEY `coupon_code` (`coupon_code`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;



    -- Table "wp_cp_order_info" DDL

    CREATE TABLE `wp_cp_order_info` (
    `id` mediumint(9) NOT NULL auto_increment,
    `ad_id` int(10) NOT NULL,
    `first_name` varchar(100) NOT NULL default '',
    `last_name` varchar(100) NOT NULL default '',
    `payer_email` varchar(100) NOT NULL default '',
    `street` varchar(255) NOT NULL default '',
    `city` varchar(255) NOT NULL default '',
    `state` varchar(255) NOT NULL default '',
    `zipcode` varchar(100) NOT NULL default '',
    `residence_country` varchar(255) NOT NULL default '',
    `transaction_subject` varchar(255) NOT NULL default '',
    `memo` varchar(255) default NULL,
    `item_name` varchar(255) default NULL,
    `item_number` varchar(255) default NULL,
    `quantity` char(10) default NULL,
    `payment_type` varchar(50) NOT NULL default '',
    `payer_status` varchar(50) NOT NULL default '',
    `payer_id` varchar(50) NOT NULL default '',
    `receiver_id` varchar(50) NOT NULL default '',
    `parent_txn_id` varchar(30) NOT NULL default '',
    `txn_id` varchar(30) NOT NULL default '',
    `txn_type` varchar(10) NOT NULL default '',
    `payment_status` varchar(50) NOT NULL default '',
    `pending_reason` varchar(50) default NULL,
    `mc_gross` varchar(10) NOT NULL default '',
    `mc_fee` varchar(10) NOT NULL default '',
    `tax` varchar(10) default NULL,
    `exchange_rate` varchar(25) default NULL,
    `mc_currency` varchar(20) NOT NULL default '',
    `reason_code` varchar(20) NOT NULL default '',
    `custom` varchar(255) NOT NULL default '',
    `test_ipn` varchar(20) NOT NULL default '',
    `payment_date` datetime NOT NULL default '0000-00-00 00:00:00',
    `create_date` datetime NOT NULL default '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

  2. #2
    Thread Starter
    Junior Member ldopi's Avatar
    Join Date
    Jan 2011
    Location
    France
    Posts
    30
    Thanks
    1
    Thanked 0 Times in 0 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  3. #3
    pepsi's Avatar
    Join Date
    Mar 2009
    Location
    New Zealand
    Posts
    14,881
    Thanks
    91
    Thanked 806 Times in 721 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    Please help our moderating team work more efficiently by not sending us support questions via PM. You can read more about how AppThemes support works here. Thank you.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [MOD NEEDED] I need to put a table on my site...
    By autohub in forum ClassiPress General Discussion
    Replies: 1
    Last Post: January 1st, 2011, 07:34 AM
  2. Plugin table
    By jean5774 in forum Help Using ClassiPress
    Replies: 1
    Last Post: November 12th, 2010, 09:23 AM