Phrase changes are not saving

Hi lfh,

Could you please deactivate and activate wpDiscuz again? Also if it's possible, please check in WordPress database and see if _wc_phrases table exists.

I tried deactivating and reactivating the plugin, still is not working.    I also confirmed that the table _wc_phrases does not exist.

I even tried installing a new, seperate Wordpress install, thinking maybe it was the theme I am using or another plugin conflicting.   Even with a plain WP install, it still happens, it will not save my Phrases changes.

This is server MySQL version issue. For some reason it has not executed database table creation SQLs. Please execute this SQL in website database:

DROP TABLE IF EXISTS `wp_wc_comments_subscription`;
CREATE TABLE IF NOT EXISTS `wp_wc_comments_subscription` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `subscribtion_id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `subscribtion_type` varchar(255) NOT NULL,
  `activation_key` varchar(255) NOT NULL,
  `confirm` tinyint(4) DEFAULT '0',
  `subscription_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscribe_unique_index` (`subscribtion_id`,`email`),
  KEY `subscribtion_id` (`subscribtion_id`),
  KEY `post_id` (`post_id`),
  KEY `confirm` (`confirm`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


DROP TABLE IF EXISTS `wp_wc_phrases`;
CREATE TABLE IF NOT EXISTS `wp_wc_phrases` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `phrase_key` varchar(255) NOT NULL,
  `phrase_value` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `phrase_key` (`phrase_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


DROP TABLE IF EXISTS `wp_wc_users_voted`;
CREATE TABLE IF NOT EXISTS `wp_wc_users_voted` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) NOT NULL,
  `comment_id` int(11) NOT NULL,
  `vote_type` int(11) DEFAULT NULL,
  `is_guest` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `comment_id` (`comment_id`),
  KEY `vote_type` (`vote_type`),
  KEY `is_guest` (`is_guest`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

I tried running this against the WP database using SQL Executioner plugin, and I get the following error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `wp_wc_comments_subscription` ( `id` int(11) NOT N' at line 2

Please advise, or is there another way I should run it?

Your server MySQL server is something unusual. it seems the version is very old. It even can't understand simple "CREATE TABLE IF NOT EXISTS" SQL query.

Please provide with WordPress table prefix and MySQL version to allow adapt this query especially for your server.

BTW. This kind of MySQL server may cause many issue for other software and plugins too.

I checked and it seems the version of MySQL running is 5.6

it it is hosted by Network Solutions.

Table prefix please

/**
* WordPress Database Table prefix.
$table_prefix = 'wp_';

Good morning,

any ideas? I am in need of getting this up and running for this site.

Thanks!

Brandon

The SQL I've provided as no any syntax error, we've tested on all MySQL version. Are you sure you copy all correctly?

Try those separate:

CREATE TABLE  `wp_wc_comments_subscription` (
  `id` int NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `subscribtion_id` int NOT NULL,
  `post_id` int NOT NULL,
  `subscribtion_type` varchar(255) NOT NULL,
  `activation_key` varchar(255) NOT NULL,
  `confirm` tinyint DEFAULT 0,
  `subscription_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscribe_unique_index` (`subscribtion_id`,`email`),
  KEY `subscribtion_id` (`subscribtion_id`),
  KEY `post_id` (`post_id`),
  KEY `confirm` (`confirm`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE  `wp_wc_phrases` (
  `id` int NOT NULL AUTO_INCREMENT,
  `phrase_key` varchar(255) NOT NULL,
  `phrase_value` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `phrase_key` (`phrase_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `wp_wc_users_voted` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) NOT NULL,
  `comment_id` int NOT NULL,
  `vote_type` int DEFAULT NULL,
  `is_guest` tinyint DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `comment_id` (`comment_id`),
  KEY `vote_type` (`vote_type`),
  KEY `is_guest` (`is_guest`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;