Commenting out the line innodb_force_recovery = 1 in /etc/my.cnf thus: # innodb_force_recovery = 1 made the mysql innodb tables in the database accessible. Apparently this setting causes innodb to become read-only. I hope this helps someone in the future. If you don’t have access to /etc/my.cnf on shared hosting, ask your host to fix it … Read more
The WP importer should do the job for you. You may need to install it first. Backup. Backup. Backup. Then, from your current single site: Tools > Export > All Content > Download Then from the new location on your multi-site, Tools > Import > locate the export file and adjust options to your needs. … Read more
Ok, the first-thing I wanted to double-check is that rather than make any modifications to parent PHP, you simply create one with a duplicate name in the child directory which completely overrides the parent file? No. You don’t create a theme with the same name. You create a theme with whatever name you choose and … Read more
jdm2112 identified the issue as being caused by missing tables as part of the migration process within the comments for the original question: You imported just the single table into another WordPress DB? THAT is the problem. Post IDs are unique between sites… I would avoid working with individual tables unless absolutely necessary After migrating … Read more
rawurldecode fixes the issue. $src = media_sideload_image(rawurldecode($url), $post_id, $desc, $return);
You can try my favourite import/export plugin WP All Import and WP All Export http://www.wpallimport.com / http://www.wpallimport.com/export/ Or User Meta Pro http://user-meta.com/documentation/export-import/ You can use WP-CLI for an import too… wp user import-csv /path/to/users.csv http://wp-cli.org/commands/user/import-csv/
Import can be used for adding new “items” to wordpress, but not changing existing ones. If you want to update anything you should use the xml-rpc protocol with the relevant commands https://codex.wordpress.org/XML-RPC_WordPress_API, or if you need it only locally wpcli http://wp-cli.org/ might be even better (never used it for your specific type of change but … Read more
To add product, you need to add an entry in posts table, with post_type=”product”, post_title=”product_name”, post_excerpt=”product_description”. This will give you the post ID. with the post ID, you will be able to add meta datas in the post_metas table._product_type, _visibility, _price, _sale_price…. use terms tables to add category related to the product You can see … Read more
Off the top of my head, you’d have to either: (a) bypass the import functionality in WP and do it direct to the database, so the term IDs stay the same (i.e. export/import from phpMySQL). or (b) write a “run once” data migration function to update your term IDs once they’re imported, using a reference … Read more
UPDATE SOLVED I change my code to wp_insert_user beside bp_core_user_signup $user_id = wp_insert_user(array( ‘user_login’ => $user_login, ‘user_pass’ => wp_hash_password( $email ), ‘first_name’ => $first_name, ‘last_name’ => $last_name, ‘display_name’ => $first_name . ‘ ‘ . $last_name, ‘user_email’ => $email, ‘user_nicename’ => $first_name