krauth

Don’t know how to fix the plugin but I got it working by making up a sql statement with the table data using phpMyAdmin manually created the required table. The information is as follows:

CREATE TABLE wp_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));

Hope this helps someone.

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?