While I think I've resolved the problems, this time same things happens for taxonomies. While I check my taxonomy related tables (of all multi-site databases), I see that there is no any unique keys, indexes, primary keys, Auto Increment fields etc in my database.. … [Read more...] about Is it possible to fix/repair all Index, Primary Key, Unique (and all other) structure of a WordPress MS Database
Drop primary key sql server
Warning: mysqli_real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it. in E:\foldername\wp-includes\wp-db.php on line 1538 Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in E:\foldername\wp-includes\wp-db.php on line 1569 Warning: mysql_connect(): No connection could be made because the target machine actively refused it. in E:\foldername\wp-includes\wp-db.php on line 1569 Error establishing a database connection What is weird about the error is that it is coming from WP_Includes folder where there is another wp-db.php. This folder came with the WordPress downloaded files. … [Read more...] about How do I configure WordPress to talk to a Microsoft SQL Server database?
wp_options ( option_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, option_name varchar(64) NOT NULL DEFAULT '', option_value longtext NOT NULL, autoload varchar(20) NOT NULL DEFAULT 'yes', PRIMARY KEY (option_id), UNIQUE KEY option_name (option_name) ) ENGINE=InnoDB AUTO_INCREMENT=1402 DEFAULT CHARSET=utf8; … [Read more...] about WordPress and SQL
[24-Nov-2018 06:25:10 UTC] WordPress database error Duplicate entry 'gaming-laptops' for key 'slug' for query INSERT INTO `wp_terms` (`name`, `slug`, `term_group`) VALUES ('Gaming Laptops', 'gaming-laptops', 0) made by do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, _wp_batch_split_terms, _split_shared_term I have done some research about repairing the database, which I am happy to do but I am just a little nervous about causing further damage. If anyone has experience in this type of issue and could point me in the right direction, I would really appreciate it. … [Read more...] about WordPress database error Duplicate entry for key ‘slug’
I am trying to create new WordPress plugin with object oriented programming.I want to create database when plugin activation and delete database when plugin deleting.Below is my code its not working for me.I have two files one is main plugin file other one is plugin functions included files. … [Read more...] about How to Create database table when Plugin installed/activated, and delete database when Plugin deleted