I think that that there is no need to create another table for restaurant, but I don’t know the entire structure of your site. Once Restaurants are already a CPT, they are saved into posts table, and with information you share that seems enough. Autocreate a Restaurant post when a Company post is created and … Read more
WordPress Provides a native functions to query these kind of things very easily like WP_User_Query $args = array( ‘meta_query’ => array( ‘relation’ => ‘AND’, array( ‘key’ => $meta_key1, ‘value’ => $search1, ‘compare’ => ‘LIKE’ ), array( ‘key’ => $meta_key2, ‘value’ => $search2, ‘compare’ => ‘=’ ) ) ); $user_query = new WP_User_Query( $args );
There are $wpdb->charset and $wpdb->collate. I am not sure if or when one of these values might be empty, so it is better to prepare for empty values … From my DB class: /** * Get table charset and collation. * * @since 2012.10.22 * @return string */ protected static function get_wp_charset_collate() { global $wpdb; … Read more
Download user generated data from WordPress
To change values inside the content can you search/replace in the database, but it is hard to update all values, if the values are different. For a search/replace can you use a plugin or helper. The helper is very good for all ToDos in Search/Replace context. The plugin is useful for search/replace in different tables.
Definitely time for an upgrade. 🙂 Try logging into your admin and following the link below. Just make sure to change ‘yoururl.com’ to whatever your website name is. If you have posts in the trash, that should take you to your trash to see them. http://yoururl.com/wp-admin/edit.php?post_status=trash&post_type=post
Every time I update or install a plugin I get “Error Establishing a Database Connection in WordPress”
As you already deleted all the posts in the table, this is going to be quite a bit of work manually. For the next time you do something like that, use wp_delete_post( $postid, $force_delete ); (Codex) while looping through all the posts with that posttype, as this function deletes all the data associated with that … Read more
Fixed this by setting max_allowed_packet = 16M in my.cnf and restarting mysql
Collaborate on wordpress local website, share files via dropbox?