I tried to install this plugin today and keep getting the following error:
WordPress database error: [Table ‘xxxxxxxxxxxx.wp_pre_publish_reminders’ doesn’t exist]
SELECT * FROM wp_pre_publish_reminders ORDER BY Reminder_Order ASC
I am not a php programmer but it appears that the plug in install is not doing the following code:
function install() {
global $wpdb;
if( self::$version != get_option( 'nfoppr_ver' ) ) {
if( $wpdb->get_var( "show tables like '" . $wpdb->prefix . 'pre_publish_reminders' . "'" ) != $wpdb->prefix . 'pre_publish_reminders' ) {
$query = "CREATE TABLE " . $wpdb->prefix . 'pre_publish_reminders' . " (
Reminder_ID INT(9) NOT NULL AUTO_INCREMENT,
Reminder_Text VARCHAR(255) NOT NULL,
Reminder_Background_Color VARCHAR(6) DEFAULT 'FFFFFF' NOT NULL,
Reminder_Text_Color VARCHAR(6) DEFAULT '000000' NOT NULL,
Reminder_Order INT(9) NOT NULL,
Is_Bold BOOL NOT NULL,
Is_Italic BOOL NOT NULL,
PRIMARY KEY (Reminder_ID));";
require_once(ABSPATH . 'wp-admin/upgrade-functions.php');
dbDelta($query);
update_option( 'nfoppr_ver', self::$version, 'The version number of the Pre-Publish Reminder List Plugin' );
}
}
}
Any ideas on how to fix this?