Resetting menu_order to 0 for posts in PHPmyAdmin?
Installed a plugin that allows the re-ordering of posts from any post type / category / tag using a drag/drop interface. After some … Read more
phpmyadmin
How to replace values in WordPress DB using phpMyAdmin
I am trying to save a value in a cg_option row/field using phpmyadmin, however data is not stored correctly and when loaded again … Read more
#1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
I am trying to move my database from my usbwebserver to my online server. But I get this error, can anyone help me … Read more
Reseting admin password through PHPMyadmin fails
Following the PHPMyAdmin instructions of this article fails to reset my password properly. I go into WP_Users, find my admin account, click edit, … Read more
How can I restore admin capabilities?
So yeah, I’m a genius. I managed delete all my admin capabilities (thank you very much Membership plugin). I could restore them, …if … Read more
#1273 – Unknown collation: ‘utf8mb4_unicode_ci’ cPanel
I have a WordPress database on my local machine that I want to transfer to a hosted phpMyAdmin on cPanel. However, when I … Read more
Emojis getting converted to “?”
Emojis in posts and comments on a 500+ posts blog get converted automatically into single question marks in irregular and untraceable intervals. The … Read more
How to delete posts that does not have a thumbnail?
I have a problem with my blog. The thing is this, all the posts have a thumbnail in this address: wpbv_postmeta–>meta_key–>thumb And several … Read more
$wpdb->query() vs. $wpdb->get_results() vs. phpMyAdmin
I have this code: $query = “SELECT * FROM $wpdb->posts INNER JOIN $wpdb->postmeta ON $wpdb->posts.ID = $wpdb->postmeta.post_id INNER JOIN $wpdb->term_relationships ON $wpdb->posts.ID = … Read more
How to set my phpmyadmin user session to not time out so quickly? [duplicate]
This question already has answers here: phpmyadmin automatic logout time (9 answers) Closed 8 years ago. I work on my wamp for localhost … Read more