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 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

#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 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 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 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

$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 = $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

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 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