User roles aren’t stored in the user or user meta table, they have their own table, and they’re on a per site basis so reusing them isn’t so simple for setups like this. In your case it would be significantly easier to use a multisite install using subdirectories rather than subdomains, then all of this … Read more
In wp-config.php for your second site, define the following two constants: define(‘CUSTOM_USER_TABLE’, ‘yourfirstprefix_users’); define(‘CUSTOM_USERMETA_TABLE’, ‘yourfirstprefix_usermeta’); You’ll have to add some custom logic to your second site limiting logins by user role.
This Should Work? ALTER TABLE wp_usermeta ADD COLUMN old_user_id bigint(20) unsigned; INSERT INTO wp_usermeta (old_user_id) SELECT u.id FROM wp_users AS u; INSERT INTO wp_usermeta (user_id, meta_key, meta_value) SELECT u.id, ‘wp_2_capabilities’, meta_value JOIN wp_users AS u ON u.user_id = u.old_user_id; ALTER TABLE wp_users DROP COLUMN old_user_id;
I don’t see any reason for this not to work. I have done similar transfers few times, and if you transfer all data correctly, and if posts in the wp_posts are well formed, with all data present (status, type…), it will work. The tricky part might be the data that can’t fit into wp_posts, and … Read more
Using a taxonomy is probably the best way. Creating a CPT will be the second option. The problem with CPTs is that you will need to store data in the mesta table which will most likely have some performance impact on other things being done on the site. Taxonomy term meta data is less bloated … Read more
The quickest fix would be to go to sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf and remove the: “requiresecuretransport = on” Then restart via: sudo systemctl restart mysql
I found this solution : here So… class MainClassAddon{ public function __construct(){ register_activation_hook( __FILE__, array( $this, ‘install’ ) ); } public function install(){ $row = $wpdb->get_results( “SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name=”wp_t” AND column_name=”c”” ); if(empty($row)){ $wpdb->query(“ALTER TABLE wp_t ADD c INT(1) NOT NULL DEFAULT 1”); } } } new MainClassAddon(); register_uninstall_hook( __FILE__, array( ‘PluginNamespace\MainClassAddon’, … Read more
UPDATE wp_postmeta SET post_id = 6219 WHERE post_id = 4319
The problem turned out to be a Lightbox plugin: Simple Lightbox. I used another plugin: Query Monitor to find it, as suggested in the comments by Jacob.
You don’t need to write your own queries, just use wordpress functions. For instance, to get post by id; use get_post <form method=”POST”> <select name=”post_ID”> <option value=”21″>21</option> <option value=”22″>22</option> </select> <input type=”submit” value=”Get Selected Value” /> </form> <?php $post_id = $_POST[‘post_ID’]; if ( is_int( $post_id ) && !empty ($post_id ) ){ $post = get_post( $post_id … Read more