importing data from non-wordpress mysql db
you need to get the ID back from your post insertion and use that with add_post_meta: $post_id = wp_insert_post($post); add_post_meta($post_id, ‘thumbnail’, $yourvalue, true);
database
WordPress will not operate correctly
You probably messed up with the config on the DB I would like the dump of the config table please, that way i can see the paths to your wp install (i had a similar problem which i solved by manually correcting the fields in DB) EDIT Run this sql query and let me know … Read more
Have multiple local wordpress installs share a wp-content folder and database
For wp-content folder you need to add WP_CONTENT_DIR with path to this folder to each wp-config.php file of each your sites. All of these WP_CONTENT_DIR constants should have the same path to one folder. Read more about it here: http://codex.wordpress.org/Editing_wp-config.php#Moving_wp-content To share the same database, you just need to setup the same database settings in … Read more
What is the advantage of separating wp_users and wp_usermeta table?
The meta table is build to allow custom user meta. If anything would be in just one table a plugin developer had to add a new column to the table for each meta data or the data had to be stored as serialized arrays/objects which would made them unsearchable. Short: Performance and flexibility.
Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
I would suggest inserting your tours as posts (or custom posts) and using a custom reference table with the id matching the post id of the Tour post. You could use WordPress’s built in meta box functions to be able to edit each Tour in the edit posts page. You could update your reference table … Read more
WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
This is really a server question and not particularly WordPress. You’re running into a MySQL server speed bottleneck at 1and1. Sorry, but they’re well known as a slow shared host, and for that reason I doubt their VPSs are any better. Caching and a CDN will only do so much for you. You need more … Read more
Plugin Not Working, But Only On GoDaddy Hosted site
I was able to recreate this, but it was a CDN (edge cache) and/or browser cache in my configuration that was bypassing your query. For the browser cache to be a problem, the searches had to occur as the result of a link click. For example, if you clicked a link to ?s=term, it would … Read more
Bad Request (Invalid Hostname) on working server, database problem
Be sure you have updated your database to reflect the correct URL. You can do this in phpmyadmin with a bit of SQL. Good article about it here: http://codex.wordpress.org/Changing_The_Site_URL#Changing_the_URL_directly_in_the_database
Database location in WordPress
You can find the database information by looking at your wp-config.php (which will be in your WordPress root folder). Your wp-config.php will probably tell you then that your database host is “localhost” (DB_HOST) and since you are using XAMPP locally, the location of your DB would be wherever you are running MySQL basis your XAMPP … Read more
wp_options table value
The only really interesting (and very important) part of the 3rd query is this: ‘project_location_children’, ‘a:7:{i:22;a:1:{i:0;i:23;}…etc…}}’ The a:n:{i:n; etc } stuff is a serialized PHP array. WordPress – for some historical reason – keeps track of term children in one option entry per taxonomy term. The painful thing is, that a lot of people don’t … Read more