Tag: Wordpress

wp-downloadmanager bug fix 1.68.1

So if you want a WordPress plugin for managing downloads and to be capable of working with external URLs you can choose this plugin(wp-downloadmanager). Unfortunately on the WordPress plugin directory, there aren’t so many plugins that have in their design external URLs, of course, external URLs aren’t what you would want most of the time but there are some cases where such URLs are preferred and this was my case too.

After installing this plugin I detected that it had a bug exactly when working with external URLs. I had notified the author and he said that he might fix this bug.
The bug consists of unusable external download links saved in the database, this happens when the remote download URL is a bit ugly, and it contains characters like &,? View full article

How to convert a MyISAM WordPress database easily

If you have an old WordPress database is possible that the engine for the MySQL/Maria tables to be MyISAM, and I don’t know if you heard but the MySQL will drop MyISAM in the future. So we know that we can use the SQL query:

ALTER TABLE table_name ENGINE=InnoDB;
So we just need the name of our tables and then do a search and replace(I used notepad++).
so we can get all the names if we use optimize tables from PHPMyAdmin, so do a select all optimize from PHPMyAdmin and then you can copy that query that looks like:
ALTER TABLE `wp_cbnetpo_ping_optimizer`, `wp_commentmeta`, `wp_comments`, `wp_links`, `wp_mts_wp_reviews`, `wp_nxs_log`, `wp_options`, `wp_pingpressfm`, `wp_postmeta`, `wp_posts`, `wp_termmeta`, `wp_terms`, `wp_term_relationships`, `wp_term_taxonomy`, `wp_usermeta`, `wp_users`, `wp_wp_rp_tags`  ENGINE=InnoDB;


Then use nodpad++ find replace feature with the following, find:

,
replace:
 ENGINE=InnoDB;\n ALTER TABLE

.(watch View full article