Thread: Empty table

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;