Import the database on the new server. When your domain name or URLs change there are additional concerns. The files and database can be moved, however references to the old domain name or location will remain in the database, and that can cause issues with links or theme display. If you do a search and … Read more
This soluton will create a metabox on your Edit Post screen and show you four additional form fields – Name Position Publications Freetext It will then save the data in to a corrisponding DB table, with each field in it’s own column as you specified. As you have not provided a table name I have … Read more
The issue was one of mixed encoding. Some fields contained data encoded properly as UTF-8; others contained data encoded as something else, probably ISO-8859-1. When imported to a new UTF-8 database, this was causing truncation. My steps to solve this: Copy the original database, wordpress, to a new database, wordpress2. Make sure the collation of … Read more
A while ago I added a function to one of my sites to change a set of posts from one type to another. I can’t remember exactly why, but I’ve dug it out and updated it a little, and it is tested and working. The function Place this in functions.php so that it can be … Read more
user.php To modify usernames before a user is added, use the filter pre_user_login. Hope that helps.
It is not doable if you want to keep around all wordpress features. Possible casualties of such configuration are search and RSS feeds, probably also category and author pages. If you go and actually create a new DB for each 1k posts then the game ends here as there is no simple way to share … Read more
If you use those custom fields only for the company tagged posts, then it’s sufficient to retrieve the custom fields without worrying about posts and tags: $tags = array(‘Professional Rating’, ‘Efficiency Rating’, ‘Referral Rating’); foreach ($tags as $tag) { $result = $wpdb->get_col( “SELECT meta_value FROM wp_postmeta WHERE meta_key = ‘$tag'” ); $avg = empty($result) ? … Read more
What am I doing wrong here? WordPress database error
I will not worry to much about performance here, but I will optimize the code a bit by calling get_post_meta() only once. This will not increase or decrease performance as you will see in the post I have linked to later on, but it comes down to the principle of not repeating yourself. On the … Read more
Link wordpress with a SQl + MongoDB + .NET