This really has almost nothing to do with WordPress. You probably haven’t created a primary key for your shops table, which should probably be shopid (assuming you’re using normal column naming conventions)
First, you shouldn’t use NOW() in select queries since NOW() returns the current date and time to the split second. In other words: This query will never land in the cache. And you can use the WP_Query with filter of posts_where eg: function filter_event_where( $where=”” ) { $date = date(‘Y-m-d’); $where .= ” AND posts.post_date … Read more
When you call the database directly rather then using the $wpdb object its faster for a simple reason which is you only call the database, and the when you use $wpdb it loads extra functions and basically most of WordPress before you can use the $wpdb object. What you should try is to use the … Read more
The last part of the URL is being treated as part of the page value.. /wp-admin/admin.php?page=user-feedback/user-feedback.php/page/2/ The bold part is your plugin page, so when you go adding parts onto that URL it’s considered to be part of that URL. If you use this instead it should work no problem. /wp-admin/admin.php?page=user-feedback/user-feedback.php&paged=2 Note: You can actually … Read more
Try stripslashes. See the php documentation. To clarify, the slashes are inserted to escape the content prior to insertion into the database. You should use the above function when you want to display the content.
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
The problem is a conflict with the plug-in Role Scoper. Deactivating the plug-in resolves the issue. As an alternative to Role Scoper, (I do not offer this as a recommendation, simply a suggestion), there is the plug-in Members.
You can’t shouldn’t hardcode table names into queries, especially with multisite. Swap $wpdb->postmeta for wp_postmeta and it’ll likely work. edit- technically you can, edited for clarity.
my suggesting is going for a different way by using get_pages() for example $args = array( ‘meta_key ‘ => ‘Partner_Level’, ‘meta_value’ => ‘Gold’ ); $pageslist = get_pages( $args ); $pageslist should have all your posts in the “gold” level.
Then “autoSearch.php” has this code: If that’s all there is, no wonder you get an error – WP isn’t even loaded! Add this to your functions.php isset( $_POST[‘autoSearch’] ) && add_action( ‘after_setup_theme’, ‘wpse_60353_autosearch’ ); function wpse_60353_autosearch() { // The autoSearch.php code you posted in your question exit; // All done, stop WP continuing } Now … Read more