Plugin Name: WPCoreSys - Database Prefix Issue - Categories and Tags Missing

[sanyamjain]

The database prefix has been hard coded in the line between 330 to 340. Due to this the categories have gone missing and we were not able to create new categories in Wordpress.

		if (!empty($excerpt))
		{
			$cats = $wpdb->get_col(
						"SELECT key1.term_id FROM wp_term_taxonomy key1
						INNER JOIN bct_term_relationships key2 ON key2.term_taxonomy_id = key1.term_taxonomy_id AND key1.taxonomy = 'category'
						INNER JOIN wp_posts key3 ON key3.id = key2.object_id AND key3.post_excerpt LIKE '%{$excerpt}%'"
						);

			$clauses['where'] .= " AND t.term_id NOT IN(" . implode(",", $cats) . ")";
		}

Once the prefix was changed, the issue was resolved.

[ocean90]

Hello @sanyamjain, welcome to WordPress Trac!

This Trac is used for enhancements and bug reporting for the WordPress core software, not in third-party plugins.

I couldn't really find a real plugin that's called WPCoreSys (it's nothing official by the WordPress team). The only thing I have found is that this plugin is used to ​inject malware in your site.

I suggest to take a look at ​https://codex.wordpress.org/FAQ_My_site_was_hacked.