The way you’re using $wpdb->prepare doesn’t help anything. You have to properly prepare the values and then add them like with sprintf as %s or %d. Oh, and I don’t believe “working with WP ajax for over a year.”. In this case you would also know about the nopriv hooks for public usage 🙂 add_action( … Read more
Open the WXR in a text editor and see if it contains posts from later years. If not, you will need to revisit your export settings from WP.com to make sure you’re pulling all posts. If it does contain posts from these years, there might be a non UTF8 character breaking the import. You should … Read more
I would approach that problem slightly differently. The entire bar does not need to reload. Instead it needs to stay “current”. So to do that you load your initial value…let’s say $100.00 Then you use Javascript to see if new values have been added and then you update it client side. You could even do … Read more
I would setup your Website B, add a user through the control panel, then view what tables in the database they were added to and what extra fields were set. Then use Navicat or phpmyadmin to dump users from Website B into excel, combine the users from Website A, set any missing fields then import … Read more
There are some instances of serialized data in the database, notably in things like widget options, that become invalidated if you do a blind search-and-replace without accounting for different string lengths. You might try a tool like this one to do a search and replace that also handles serialized data: https://interconnectit.com/products/search-and-replace-for-wordpress-databases/
The database user name/password is not stored in the database; it is only used to access the database. Change the username (and password, too) to the new values in wp-config.php. And the problem might be access to the database via phpmyadmin; check your username/password in Cpanel or some other hosting control panel.
If you are not moving to a different domain name, the file path shouldn’t really matter. Try these first: Made a copy of your original backup bd Open the new copy and search/replace example.com/ to example.com/blog/ This should get you going no matter what server setup you have. If it doesn’t, and you already have … Read more
You can use wp_insert_post to insert a physical page, though I would suggest creating one page for the plugin and then using a rewrite rule to give all of your items a URL with that single page as the base. EDIT quick rewrite example with added query var: function wpa55546_rewrites(){ $page_slug = ‘your-page’; // urls … Read more
Your SQL command is invalid. The error says: WordPress database error: [Incorrect table definition; there can be only one auto column and it must be defined as a key] CREATE TABLE to_issues ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(125) NOT NULL ) Try: $sql =”CREATE TABLE {$wpdb->prefix}to_issues ( id int(11) unsigned NOT NULL auto_increment, … Read more
Adding a column to the posts table is a bad idea, this is indeed what Custom Fields (Post Meta) are for. Query and sort your posts based on the values of your custom field with WP_Query and a post meta (custom field) query: $query = new WP_Query( array( ‘meta_key’ => ‘counter’, ‘meta_value’ => 0, ‘meta_compare’ … Read more