Installed a plugin that allows the re-ordering of posts from any post type / category / tag using a drag/drop interface. After some time of using, my post order went haywire and new posts began to appear in a jumbled order. The plugin’s native reset button resolved this, but the old posts are still jumbled … Read more
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 after saving, only part of data appears. Do I need to use a conversion function within phpmyadmin? The row is theme_mods_[theme-name] This is a sample of data contained in the field: s:19:”thim_my_text_option” … Read more
I am trying to move my database from my usbwebserver to my online server. But I get this error, can anyone help me with this? #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ 1 Answer 1 in the export process from your server’s PhpMyAdmin select Custom options, then – be sure to tick under Object … Read more
Following the PHPMyAdmin instructions of this article fails to reset my password properly. I go into WP_Users, find my admin account, click edit, enter my password, change the dropdown to MD5, click save, but this password does not work when I try to login to WP-Admin with this username. Confused. 5 Answers 5 Here is … Read more
So yeah, I’m a genius. I managed delete all my admin capabilities (thank you very much Membership plugin). I could restore them, …if I had admin access, lol. Anywhoo, how can I give all my capabilities back to admin? I have access to the database via PHPMyAdmin but have no idea where or what to … Read more
I have a WordPress database on my local machine that I want to transfer to a hosted phpMyAdmin on cPanel. However, when I try to import the database into the environment, I keep getting this error: #1273 – Unknown collation: ‘utf8mb4_unicode_ci’ I have tried to Google around and the only solution I can find is … Read more
Emojis in posts and comments on a 500+ posts blog get converted automatically into single question marks in irregular and untraceable intervals. The respective tables wp_comments and wp_posts are configured to have a utf8mb4_unicode_ci collation, albeit in a latin1 / latin1_swedish_ci database, which (to my understanding) shouldn’t be a problem, as long as the tables … Read more
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 (A LOT) of posts don’t work, because I have made a script that takes videos from a website and publishes in mine. So, I need to find (I have search in google … Read more
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 = $wpdb->term_relationships.object_id WHERE ((post_type=”projects”) OR (post_type=”post_cost_codes”));”; $results = $wpdb->query($query); // Takes 1.5 seconds I also tried this: $query = “SELECT * FROM $wpdb->posts INNER JOIN $wpdb->postmeta ON $wpdb->posts.ID = $wpdb->postmeta.post_id INNER JOIN $wpdb->term_relationships … Read more
This question already has answers here: phpmyadmin automatic logout time (9 answers) Closed 8 years ago. I work on my wamp for localhost backend development everyday. I feel annoyed by phpmyadmin auto log out out quickly. Is there any way I could get rid of this or extend the timeout? Where can I set this … Read more