Add following in WHERE condition of your SQL query. WHERE t1.meta_key = “<?php echo $wpdb->prefix; ?>capabilities” AND ( t1.meta_value LIKE ‘%ROLE_YOU_WANT_TO_FILTER%’) Let me know if it works for you or not.
Somethings wrong with your permission setting. Login to your server via SSH. You can login using your terminal. I’ve created a blog about how to connect to your server via SSH if you’re using windows. Run the following commands: chown www-data:www-data -R * # Let Apache be owner find . -type d -exec chmod 755 … Read more
In general, things that are not content, better not be in the DB in the first place. Site header images should be in you CSS, making them part of your code which you manage with GIT. This is obviously easier said than done with the way wordpress core and many plugins geared towards storing everything … Read more
Adding wordpress posts using phpmyadmin
You can try this plugin see this This plugin adds a simple post-type drop-down to the post editor interface, allowing you to reassign any post to a new post type. It allows you to switch post’s type while editing your post. Post Type Switcher
An SQL query to find orphaned image attachments and their meta
duplicate wordpress site on same bdd
I think I found out where the problem was. the datatype for check_in and check_out in the database was set to DATETIME Instead of DATE yet the code $check_in_db=date(“Y-m-d”,strtotime($check_in)); was converting it to date. I don’t know why it prevented entry of the other data, but after changing that, it is working now. to use … Read more
you need to see below post to move word-press site one server to other Ref :- WordPress link some simple steps follow and change site location you can update your database using following queries UPDATE wp_options SET option_value = replace(option_value, ‘https://www.oldurl’, ‘https://www.newurl’) WHERE option_name=”home” OR option_name=”siteurl”; UPDATE wp_posts SET guid = replace(guid, ‘https://www.oldurl’,’https://www.newurl’); UPDATE wp_posts … Read more
That will work – as long as you’re the only user. If other users have access to the site you’d also have to port over their work to the other database. If that’s the case, you may want to copy your entire website to a staging site, make the changes there, and once changes are … Read more