WordPress stores user generated content, along with other configurable information, in a a database (typically MySQL).

learn more… | top users | synonyms

2
votes
2answers
105 views

WordPress for a very large website

I've searched and searched but I did not find an answer online. Also, I've posted this on StackOverflow and apparently it wasn't ok and I reposted this here. I hope it's ok. I have this website which ...
0
votes
0answers
109 views

Collaborate on wordpress local website, share files via dropbox?

How can one share and sync files of a WordPress website with users that can edit (collaborate on) the website locally on their own instance? Can Dropbox be used to share the WordPress website files ...
0
votes
0answers
20 views

Queries gone haywire since update to 3.8.1 [duplicate]

I have a WordPress install on a dedicated server with decent memory (upwards of 8GB) Since upgrading to 3.8, I started getting mysql disconnects/timeouts, better known as MySQL server has gone ...
0
votes
1answer
47 views

Wordpress where clauses in db select

I'm currently struggling with implementing a feature for wordpress site. I would like to get the count of all users which have the key pending_approval='true' and is_photographer='true' (located in ...
0
votes
2answers
1k views

How to return number of found rows from SELECT query

I wrote a function which is supposed to return the number of rows found in a SELECT query but it always either seems to return 0 or an array. I have been messing around with this for about an hour now ...
1
vote
1answer
100 views

How to determine what is generating large amount of database queries?

For some reason, my Wordpress site is using a lot of memory (spiking at 72MB) and generating a huge amount of database queries (76923 according to Wp-Memory-Usage. I'm really not sure why this would ...
0
votes
1answer
189 views

Add row to custom database Table and delete all rows older than 1 day

I'm editing a view counter plugin so that it logs the IP of every user that viewed a post. This is to prevent them from refreshing the page and thus creating artificial views. The part I'm having ...
0
votes
1answer
81 views

How can I safely delete data related to wp_post table manually from the mysql database?

Recently I downloaded a plugin that had a bug that orphaned its custom post type items in the wp_post table rather than deleting them. Being new to wordpress, it wasn't apparent to me that the ...
0
votes
0answers
66 views

Get fatal error when using wpdb in jQuery.post target URL

Why am I getting a Fatal error whenever I use wpdb in the target URL of my jQuery.post? Here is my code so far. My process.php is this: <?php $to = 'myemail@gmail.com'; $subject = ...
0
votes
1answer
270 views

insert image alongwith with custom data via a frontend form

I use wordpress as a cms. I wanted to insert custom data via a form from the frontend in my wordpress site and then echo it on a page somewhere. After learning from here and there I am able to put ...
0
votes
0answers
24 views

Every time I update or install a plugin I get “Error Establishing a Database Connection in WordPress”

At first I thought it was a resource issue because I'm only using the lowest AWS ec2 instance, but now I think it might be something else. I Google'd about a bit as it seems to be a common problem ...
0
votes
0answers
56 views

Perform database function in target URL using jQuery.post

I have a popup which gets the users input (name and email) and sends it to a process.php so I can send an email. I pretty much have that done. But I need to add a functionality wherein it will also ...
0
votes
0answers
77 views

Querying the DB to get sum of column from custom meta box (only published posts)

I am trying to get the SUM total of a custom meta box, from all published posts, from a custom post type. By using $wpdb I am able to get the sum from all of the posts (published and otherwise), but ...
0
votes
1answer
43 views

Plugins in WP_Options but not Active

Just completed a WordPress host migration. I had to disable plugins by deleting them in the WP_Options table. I have just added the correct plugins back into the db. However, the plugins are not ...
0
votes
0answers
33 views

Moving WordPress site to a new server - Admin not loading

I'm trying to move a WordPress Database from one server to another. I've done this a few times with other sites and servers and I use Sublime to do the find and replace and I've had no issues up to ...
0
votes
1answer
39 views

Why do mass updates to post_content shows in front end, but not in edit screen?

We had someone migrate several blogs in Movable Type to Wordpress recently, but we just realized they missed some of the content that was in a database field in MT labeled *entry_text_more*. For ...
0
votes
2answers
36 views

Make changes of wp-db.php file persistent against updates

I've added $this->query("set session wait_timeout=600"); into wp-includes/wp-db.php file because of "MySQL has gone away" errors in every query and I need to find some way to do the changes in file ...
0
votes
1answer
545 views

“MySQL server has gone away” since update to 3.8

I have a WordPress install on a dedicated server with decent memory (upwards of 8GB). The WordPress install includes many plugins - 50 active plugins. Most important to note is the WPML plugin to ...
2
votes
1answer
61 views

Is there a shortcut to change bulk BMP images to JPG images in a site?

Images in WordPress posts, as I understand, are uploaded manually. They are uploaded by default to uploads folder. A client of mine reported that, in one of his site, he uploaded all the images in BMP ...
0
votes
1answer
85 views

How can I create blog specific database table in multisite?

I am creating a plugin, that supposed to work on WP multisite yesterday. I've installed WP multisite on my server. While testing I found out that register_activation_hook created 1 table on the main ...
0
votes
1answer
21 views

WP Posts Not Adding Up

My WP is hosted at Yahoo I am running WP 3.5.2 and the Posts Page does not add up All (4,356) | Published (629) | Sticky (1) | Drafts (265) | Private (88) WP seems to have an extra 3373 posts. I ...
1
vote
0answers
41 views

Move out of sync posts from one database to another

I have an issue where the following has occurred: WP install is pointing to database server 1. Database server 1 is backed up. Database from DB server 2 is restored onto DB server 1. I need to get ...
1
vote
1answer
92 views

Query Wordpress database by registered date and role

I would like to get the display name and email address for all users who have registered to my multisite today with the role of subscriber. It needs to be an SQL query as it's used outside of the WP ...
0
votes
0answers
41 views

Blog Not Loading, Can't Access Admin Page, No Trace of WordPress on Server

I recently took over as the webmaster for a small company, and I was asked to figure out what's going on with the company's blog, which uses WordPress. Essentially, the blog won't load, and this ...
0
votes
0answers
33 views

How Can I Put Meta_Compare in the Database-Query?

Yes, I know that this can easily be done with built in wp_query but I need this in Wpdb query. I have a custom field and I need to display posts where this field does not exist. By the way can I get ...
0
votes
1answer
32 views

Image link issues after importing a database backup to my local web server

I am pretty new in WP (I came from Joomla) and I have the following problem trying to import an old WP blog (made using WP 3.5) on my local web server. I have put the old blog foder into my www ...
1
vote
2answers
161 views

Why does $wpdb return strings for mysql integer values?

I find it very inconvenient and hard to understand that the default behavior of the Wordpress db-interface is to convert all integer (and float?) types to strings. e.g $wp_posts = ...
0
votes
1answer
352 views

what is the use of /wp-includes/SimplePie?

I have this location on my server. /home/localhost/public_html/wp-includes/SimplePie. I have not installed samplepie plugin. What is it used for since it is not associated with samplepie plugin. The ...
1
vote
1answer
42 views

How to interact with another wordpress install on same database?

I am trying to figure out how I can have two WordPress installations on same database with different prefixes ( wp_ and wp2_ ) and I need them to interact with each other. For example I have a Blog ...
5
votes
1answer
287 views

Slow wp_term_relationships query

I'm running a large WP instance (currently has 28,000+ posts in custom types) and have been experiencing some odd slowdowns. Upon analyzing the MySQL slow query log, one of the problem queries is: ...
0
votes
2answers
259 views

Search and replace special characters (å,ä,ö) for image attachments only in database

I need to replace the special characters å,ä,ö (with a or o) in my WP database for all image attachments. How can I apply this search and replace only to affect these links? Edit: Solved
0
votes
1answer
92 views

Using custom post types WordPress network

Working on a project I am setting up a WordPress network containing sites/blogs for small shops. I would like to use 2 custom post types in the following way: A location post type; The blog admin can ...
0
votes
1answer
102 views

multiple wordpress installs w/shared user database but separate content databases

Is it possible to have two wordpress installs, one at the main address and one at a subdomain, with a shared user database but totally different/separate content databases? For example: ...
0
votes
1answer
54 views

Size article thumbnails and retrieve them directly from database

I've integrated the Wordpress database directly with my .NET application. What I want is to set the featured image of a post. This featured image must be maximum 800pixels wide, and automatically ...
0
votes
1answer
49 views

How to change images size after theme modification?

The images in the previous theme were using a height and width listed in the source html. The new theme will resize the images using percentages, so I need to remove all the height and width in the ...
0
votes
1answer
677 views

Images are not showing after moving Wordpress installation from server to localhost?

I moved my wordpress installation from server to localhost on my pc using the instructions in the following link ...
1
vote
1answer
37 views

How to disable (get rid of) home page main loop entirely?

I'm using a custom theme, the index page doesn't depend on the main loop for home (which by default get the latest 10 posts for example). How can I get rid of the home loop entirely, so the index ...
0
votes
0answers
54 views

Why does my WordPress front-end categories plugin gives me a database error with my SQL syntax?

A few years back I created a plugin based off of an answer here: How do I create a way for users to assign categories to a post from the frontend? Here's a pastebin of the modified plugin: ...
1
vote
2answers
37 views

WordPress Backup

I'm learning how to backup right now and I'd like some validation. From what I understood, to fully backup my Wordpress I need two things. One backup for my database and another for theme files. The ...
0
votes
0answers
37 views

Download user generated data from Wordpress

I have created a Wordpress site which I allow users to enter information about themselves such as name, age, sex and address etc. Now that I have this n formation I would like to know the steps I ...
1
vote
0answers
130 views

How to track a users progress through pages by inserting data into Wordpress Database?

My website users can learn British Sign Language through Video Tuts, Quizzes and games etc. I would like to track the users progress through the pages of the course and add that data to a Wordpress ...
-1
votes
1answer
42 views

how to add limit records in wordpress query

I have this query which is returning the all records from database whose type is equal to 'quote2'. No I want to know how to limit the record. I mean I just want to show last 10 records added in the ...
0
votes
1answer
45 views

Querying multiple meta_keys in Wordpress SQL query

Here's my Query... I'm looking to narrow this query down to users of one specific role ("meta_key = 'wp_capabilities' AND meta_value = 'employee'")...how do I add that additional conditional to this ...
0
votes
1answer
120 views

How to display data from db in select list [closed]

I wonder what it's wrong in my code. I can't get all of data in column "adres". In result I only have the lest record. Thanks for help. global $wpdb; $result = $wpdb->get_results ("SELECT ...
0
votes
0answers
30 views

How do I authenticate/turn off a plugin remotely for plugin SaaS like functionality?

I have a client whom we created a custom plugin for. We are charging monthly for access to this plugin but the only way we have to disable it is manually in the Wordpress admin. How would I go about ...
0
votes
0answers
43 views

Broken Images After DB Name Change

I have a problem I have been unsuccessful in troubleshooting or finding other questions and answers for. My site was displaying fine. I changed the name of my database from "mydomain_beta" to ...
0
votes
1answer
63 views

Getting data from a table using a query

I’m starting with WordPress and I have a lot of problems and doubts. I’m trying to display on a page data stored in a table of my database. I have a table named Customers (id, name, surname, phone). ...
0
votes
0answers
36 views

Customize wordpress search query

Would this method parse_query of the WP_Query class allow a custom search query to a custom table? WP_Query I ask because the Codex says " To customize the query append additional arguments to ...
1
vote
0answers
224 views

How to populate custom field dropdown box based on prior selection?

I have two dropdown boxes for a search that uses custom fields and I need the second dropbown box to be populated depending on the results of the first box. So far I have: <form role="search" ...
0
votes
1answer
30 views

Should I use custom taxonomies or not?

I'm building a plugin which features an custom post type Events. Now I would like to add functionality to support venues. I think a custom taxonomy could do, but I'm not so sure, because I would like ...