WordPress stores user generated content, along with other configurable information, in a a database (typically MySQL).
0
votes
2answers
90 views
Wordpress page title repeated in SOME pages
I have created a Wordpress site and titles were working just fine. Then, some time and plugins installed later, I noticed that in SOME pages I get the title repeated 2 times.
Example of wrong page ...
1
vote
1answer
53 views
Why does WordPress rely on an fully qualified site_url with a 15-step plan for moving a site?
From the Moving WordPress codex page (emphasis mine):
When your domain name or URLs change there are additional concerns. The files
and database can be moved, however references to the old ...
0
votes
1answer
56 views
Does WordPress cache get_user_meta() results?
If I call get_user_meta() to retrieve a value, does WordPress cache the value? If I call get_user_meta() to retrieve the same value, does WordPress have to query the database again or is it stored in ...
2
votes
0answers
225 views
comment_post_ID 0 (cannot remove from dashboard)
Ran across something a bit odd that I haven't seen before. A client has a pretty active blog and uses Akismet (paid) to protect against spam. At least once a day, they're reporting a spam comment that ...
2
votes
3answers
220 views
Best way to import users, post and categories from an external database
I need to migrate an existing website to WordPress. This website already has a basic database containing users and posts (with a category), but it also has a high number of records so it's not ...
0
votes
2answers
121 views
Subscribe to author?
Basically, I want to follow the author by other WordPress users. Whenever an author posts new post subscribed users need to get notification by email.
If it's not already there, I can create a plugin ...
-1
votes
1answer
116 views
Simple subscribe widget form
Im looking over internet for some simple solution of email subscription widget but no luck.
Or they are too complicated and paid, or they are relaying on some external email functions.
Im no ...
3
votes
1answer
137 views
How is custom menu hierarchy output handled?
I'm looking to pass custom nav_menus through an RSS feed so I can grab them on other sites to create the same custom menu on multiple sites.
What I can't figure out by looking through the database is ...
4
votes
2answers
432 views
Count & Display Database Queries
I'm looking for an solution how I can count and display all queries in a WordPress site.
Does anybody know, if there is an good plugin?
Otherwise it would be an solution to check the queries on the ...
0
votes
0answers
8 views
What would make a MySQL database create tables in a different collation other than its default? [duplicate]
Possible Duplicate:
Using wpdb to connect to a separate database
am adding tables to a Wordpress database on my localhost and it is changing my collation from utf8_general_ci to ...
0
votes
1answer
111 views
How to use remote db tables in current config? [duplicate]
Possible Duplicate:
Shared Members between two different wordpress installations with different databases
For example I have 2 different wordpress installations with different domains and ...
2
votes
2answers
274 views
Shared Members between two different wordpress installations with different databases
I have two wordpress installations with same host with different folders. Each installation uses its own database. I mean, database are separated. I am not using one database for two wordpress ...
1
vote
5answers
308 views
Moving WP from local server to live, error establishing a db connection
Not sure what's going on here 'cos I've done it already a couple of times and it always worked. Basically I'm moving a testing site from my local machine (MAMP) to a live server by:
zipping the ...
2
votes
1answer
80 views
Importing Multiple DB to one MU database
I have three databases associated with three different WP sites. I set up one MU site, with one database. How should I import each of the three databases?
4
votes
2answers
2k views
WooCommerce with thousands of products - site is very slow - optimize db queries?
So far I've got around 8,000 products in my WooCommerce and the product page on the front end takes several seconds to load, even after caching.
My VPS host says that I should have multiple ...
2
votes
2answers
137 views
What is an efficient way to query based on post_meta?
The problem I am having is when I allow users to filter posts it overpowers the database and things run extremely slow. I am unsure what the best way to query posts using meta values is. My site has a ...
1
vote
1answer
1k views
How can I check email exists via a jquery keyup()?
I have setup a jQuery keyup delay function to check the email typed into an input field.
It works fine after testing with an alert('Key pressed!');
But I want it to say, for example, 'Yes this ...
0
votes
2answers
106 views
Widget queries even when there are no sidebars?
I'm trying to reduce my database queries. I don't have any sidebars or widgets set but I noticed the following query
SELECT option_value FROM wp_options WHERE option_name = 'widget_pages' LIMIT 1
...
0
votes
1answer
210 views
Integrating Custom Database with Wordpress
I Have a Wordpress Site with few users who are my college students
They Registered using their RollNumbers/HallTicket Numbers as their usernames in Wordpress site
Now I Have Another Database with ...
0
votes
1answer
305 views
Check if post id exist in table than only update instead of inserting new row
I am trying to add simple view counter for my advert and everything seems works fine with below code but only it is inserting each time new row on post "Update". What I want if the post id is exists ...
1
vote
1answer
221 views
WP_Query Performance Issues with meta_query
I'm working on a custom template for a new theme that uses a WP_Query instance to select posts from 2 post types with 2 custom fields that are NOT empty. Depending on the section of the site, a ...
1
vote
1answer
32 views
Building an email signup form. Where should the information be saved in the DB?
I would like to try build a simple plugin that collects and stores the name and email address of the person who filled in the form. I realize there are probably dozens of plugins out there that do ...
2
votes
1answer
74 views
Is it wise to delete post revisions and autosaves from database?
I'm just wondering is it wise to delete all post revisions and autosaves from database every once in a while?
I mean they take a lot of database space and apparently have no use after the post has ...
0
votes
2answers
49 views
Detail explanation of wordpress database fields and metatag list [closed]
I am trying to understand the fields of various table and default list of metatags for the tables, currently being used in wordpress. Though google is showing up various results , but I need a ...
0
votes
1answer
137 views
Wordpress choose wrong database
I have 2 databases. When I include the database connection (with a include('filename.php');) wordpress acts really strange.
I can't login, the wordpress username and password is right but it tries to ...
2
votes
2answers
329 views
Display data from a non wordpress database on a page template
I am using a sql query to access information to display on a wordpress page by adding the below code to a page template. I know the query works as I've tested it in phpmyadmin.
$rows = ...
1
vote
1answer
256 views
Multiple multisite instances connecting to the same database
I like the idea of making developers connect their copies to the same database and just set WP_HOME and WP_SITEURL to configure the domain name as they like it. In this model, we don't need to keep ...
0
votes
1answer
36 views
different theme in one website
Assume this is my site name : www.example.com.
I saw different websites have different themes in a site. For example I want to have different themes for www.example.com and ...
5
votes
2answers
196 views
WordPress database scalability from the code perspective
I have read through multiple questions here on StackExchange that concern WordPress scaling and the common opinion is that WordPress is indeed highly scalable provided you have the infrastructure to ...
1
vote
1answer
134 views
Most recent post from another database
I am trying to add the most recent post from another Wordpress database (on the same server in all actuality), but am getting the following error:
Fatal error: Call to undefined method ...
1
vote
1answer
94 views
Should a child theme share the same theme options row as the parent, or should it have it's own options row?
I'm developing a theme which uses the NHP Theme Options Framework to add some theme options. Naturally, the theme options framework creates a single row in the database to store the theme's options ...
0
votes
3answers
138 views
How to empty wordpress custom post Database table
I have around 2000 custom posts. And 7 regular wp pages. I want to delete all those custom post without effecting the pages. I thought the easiest way would be to empty the custom post table but I ...
0
votes
1answer
79 views
Fast worpress backup/clone
i have a problem with 2 websites. I have for example
site1.com
site2.com
How can i make a perfect clone of site1.com for site2.com? i mean i want a method that i can do this in minutes, not ...
1
vote
2answers
170 views
when I fetch data from remote mysql database in wordpress built in wordpress function is not working?
In one of my page I have to fetch data from remote mysql database. We have connection to remote mysql database by creating new instance of $wpdb class.
$mydb = new wpdb(DB_USER2, DB_PASSWORD2, ...
0
votes
2answers
128 views
Does post_meta data need to be unserialzed?
Is it possible to unserialize data in the mysql query at the run time? i don't want to use unserialize() function of php.
I need to fetch the value "mathematics" from the below serialized value ...
0
votes
1answer
300 views
How To Find Out Wordpress Category Table in MYSQL?
I know WordPress stores all post data in 'wp_posts' table. But here WordPress not define any category id or reference related with it.
Please let me know, how 'wp_posts' table find out exact ...
1
vote
2answers
225 views
How to create and work with custom data / tables (i.e., for arbitrary data)?
Getting started on Wordpress just today. I noticed that Wordpress created tables in a mySql database (with name *.wrdp1) when I first set it up. These tables cover comments, posts, users, and some ...
0
votes
2answers
639 views
How to use multiple database in wordpress?
I want to fetch some post from another wordpress site which is hosted in the same server. How can I fetch those post?
Is multiple database connection is possible in wordpress?
1
vote
1answer
43 views
cross-site custom menu
i have a multisite whice i want to separate because its unneccery as two of my sites are on the same DATABASE and all i need is actually the dynamic custom menus which i have built in the main site(to ...
0
votes
1answer
70 views
why there are so many posts whoes post_type is revision? will these records waste too much database space?
from the following data we may know there are only 30 records which are meaningful, and there are 92 records of revision post_type which can not be shown on the blog.
so will these records waste too ...
0
votes
1answer
27 views
why the posts queried from sql is more than those showed on the page?
i am using WordPress multisite, the issue i face is that the posts queried from sql is more than those showed on the page, the details is as follows:
mysql> select count(*) from wp_137_posts where ...
3
votes
1answer
155 views
Showing content from another wordpress installation database in the page template loop?
I am just wondering if it is possible to show just the page content of another wordpress database on wordpress pages with the same pageID within the content loop in my page template. To be more ...
0
votes
1answer
99 views
Merge two databases: OLD SITE -> NEW SITE
I am working to a restyle of a website.
I made DB dump from remote server and made local installation, then started to work on my local machine.
While i've been working other post have been added to ...
4
votes
1answer
146 views
WP Multisite: load content from site X on site Y
I'm running a WP multisite-network on my professional website (http://mydomain.com). I'd like to play around with jQuery Mobile and deliver a different website and web experience to mobile users, so I ...
0
votes
2answers
626 views
Database migration issues - Error #1046 No database selected
i need to get my clients website online and have been able to figure everything out except of course the most crucial part which is the database upload. i can't figure out what i'm doing wrong since ...
3
votes
2answers
512 views
How to change option recently_edited?
WP recently_edited option can be very useful - it tracks last 5 files that you've made changes to. Only problem is - well, that's all, 5 files.
What if I've been made numerous changes to Wordpress ...
0
votes
1answer
117 views
Creating and Using Tables in the Wordpress Database
I plan on having over 2,000 pages per subject on my WordPress website and since each subject will require custom page types I would like to create tables for each subject in the WordPress Database. ...
1
vote
0answers
43 views
Copy post to separate database with “add_action(…)”
I'm basically trying to have a copy of a post be sent to another database's table when it's published. I've gotten it to add a new row in the new table, with my own static arguments, but I'm not sure ...
1
vote
2answers
272 views
How do I copy a wordpress database?
I'm trying to migrate my wordpress site from an old host to a new host. The Wordpress Codex says "you can move by just copying your files and database." Copying the files is easy enough, but how do I ...
2
votes
1answer
44 views
How to log database changes during an upgrade?
I have Wordpress installed in a classical LAMP configuration.
Is there any way to, in a protected environment (like staging), automatically log all database changes (i.e. drop indexes or alter tables) ...
