In the users table the primary key should be ID (auto-increment) and the user_login, user_nicename and user_email fields should be indexed. In the usermeta table the umeta_id should be primary key (auto-increment) and the umeta_id and meta_key fields should be indexed.
This Should Work? ALTER TABLE wp_usermeta ADD COLUMN old_user_id bigint(20) unsigned; INSERT INTO wp_usermeta (old_user_id) SELECT u.id FROM wp_users AS u; INSERT INTO wp_usermeta (user_id, meta_key, meta_value) SELECT u.id, ‘wp_2_capabilities’, meta_value JOIN wp_users AS u ON u.user_id = u.old_user_id; ALTER TABLE wp_users DROP COLUMN old_user_id;
I don’t see any reason for this not to work. I have done similar transfers few times, and if you transfer all data correctly, and if posts in the wp_posts are well formed, with all data present (status, type…), it will work. The tricky part might be the data that can’t fit into wp_posts, and … Read more
Using a taxonomy is probably the best way. Creating a CPT will be the second option. The problem with CPTs is that you will need to store data in the mesta table which will most likely have some performance impact on other things being done on the site. Taxonomy term meta data is less bloated … Read more
Yes, WP Cron won’t run if nobody visits your site. You can also run into the PHP execution time limits There are ways to mitigate this however: Manually ping the cron URLs via a real cron job using curl Run cron via WP CLI on a real cron job, letting cron jobs run arbitrarily Use … Read more
The quickest fix would be to go to sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf and remove the: “requiresecuretransport = on” Then restart via: sudo systemctl restart mysql
I found this solution : here So… class MainClassAddon{ public function __construct(){ register_activation_hook( __FILE__, array( $this, ‘install’ ) ); } public function install(){ $row = $wpdb->get_results( “SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name=”wp_t” AND column_name=”c”” ); if(empty($row)){ $wpdb->query(“ALTER TABLE wp_t ADD c INT(1) NOT NULL DEFAULT 1”); } } } new MainClassAddon(); register_uninstall_hook( __FILE__, array( ‘PluginNamespace\MainClassAddon’, … Read more
UPDATE wp_postmeta SET post_id = 6219 WHERE post_id = 4319
Here’s the SQL query: $simplelist = $wpdb->get_results(“SELECT `Row1`, `Row2` FROM `table` WHERE `Row1` = ” . $atts[text] . ” ORDER BY `Row1` ASC”); Lets pretend we’re the computer and run it in our heads, and the first thing that happens is: $atts[text] // fatal error! text isn’t defined, you’re missing quotes, but lets fix that … Read more
No, a theme’s .php files are not stored in the database. Themes should not be hardcoding URLs in their files. However, it’s totally possible for this to happen, particularly with a custom theme or plugins whose developer did not follow best practices. I’d suggest using a search utility such as grep (grepwin is nice for … Read more