How to add virtual column in wpdb get_result statement
How to add virtual column in wpdb get_result statement
Database
set_transient fails if the value has more than 60.000 characters
I found the problem! Everything was ok with the transient, the problem was that I’m using php’s substr() to cut an object property value if exceeds maximum characters. When in that string there was an accented character there was a problem with the encoding. So the serialized collection had an encoding issue at character 60000… … Read more
SQL database import #1046 error
SQL database import #1046 error
How would I see which wordpress posts have a revision history without opening each one?
From the Revisions documentation page: Revisions are stored in the posts table. Revisions are stored as children of their associated post (the same thing we do for attachments). They are given a post_status of inherit, a post_type of revision, and a post_name of {parent ID}- revision(-#) for regular revisions and {parent ID}-autosave for autosaves. So … Read more
generate PDF from member information
generate PDF from member information
pre_get_posts causings DB error when using ( ‘posts_per_page’, -1)?
pre_get_posts causings DB error when using ( ‘posts_per_page’, -1)?
How do you enable scripts on a WordPress installation in Softaculous?
If you check the wp-config.php you can identify which database is being used: // ** MySQL settings – You can get this info from your web host ** // /** The name of the database for WordPress */ define(‘DB_NAME’, ‘this_here’); Then, use phpMyAdmin or Adminer to export the data into an .sql and move it … Read more
How can I find user role in Mysql?
I’ve decided to use plain Key according to @TomJNowell ‘s comments. If I would like to search a key in serialized data, I would get those serialized array from DB and use maybe_unserialize() in PHP OR use WP_User_Query in PHP. Thank you @TomJNowell
Find locations of all featured images of draft posts via SQL
Alright this worked for me: First run the bellow script to generate the file locations of all files used for draft posts. SELECT voybp_posts.guid FROM voybp_posts WHERE voybp_posts.ID IN (SELECT voybp_postmeta.meta_value FROM voybp_postmeta WHERE voybp_postmeta.post_id IN ( SELECT voybp_posts.ID FROM voybp_posts WHERE voybp_posts.post_status=”draft”) AND voybp_postmeta.meta_key=”_thumbnail_id”) Export this as a CSV file and save it to … Read more
Why theme settings lost when I installed https
It seems no connection technically but you might break the serialized data in the database. Can you please try again with the Better Search Replace plugin https://wordpress.org/plugins/better-search-replace/ and see if it still breaks? If it’s not then you are breaking the serialize data.