MySQL is an open-source, relational database management system.

learn more… | top users | synonyms

2
votes
1answer
3k views

How to get a Google maps SQL->XML->map marker tutorial to work in WordPress

I have been trying to figure out what is wrong with my code for a couple days now, and I can't seem to crack it. I am trying to follow this tutorial I tried all three of the suggested methods to ...
1
vote
1answer
42 views

How to prevent/delay MySQL connections when an object cache is used?

We are using an object cache backed by memcached, however I think that WordPress will still connect to MySQL on every page load, which shouldn't be needed if all queries can be handled by the object ...
1
vote
1answer
202 views

Wordpress database import: Row size too large

I've done a dump of my Wordpress database using Windows's command prompt: mysqldump -u username -p databasename > filename.sql Then, on a different server, imported it using: mysql -u username ...
1
vote
1answer
128 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
66 views

Getting categories from DataBase & WP Favorite Post

I am trying to create a shortcode that pull the most saved posts (using WP Favorite Post) and displaying them by YEAR, MONTH or CATEGORY. So far I have been able to get the year and month working ...
0
votes
0answers
41 views

Get a list of the last posts grouped by author and filtered by category

i need a list of the latest post published by various authors, but filtered by category, like for example the latest posts of author that write about music. i wrote this query and looks like working ...
0
votes
0answers
83 views

Writing directly to WP_Posts table

We directly add posts to WP_Posts table using filemaker. Once the post has been published, however, wordpress seems to be disregarding the existence of certain fields. For example, we have data in ...
0
votes
0answers
58 views

Does Anyone Know How To Shard A MYSQL Database With HypderDB?

I have a woocommerce site with 80,000 products. It's on pretty speedy VPS (8GB RAM, 4CPUs, SD hard drives) and it's configured pretty well (nginx, php-opcode caching, w3 total cache, etc.) but when ...
0
votes
0answers
39 views

How to fetch post and related information from post and postmeta table in WordPress?

I want to fetch post information and its related meta information in WordPress setup. Is it possible from single SQL Query? Post table columns: ID, post_title, post_content Post Meta columns: meta_id, ...
0
votes
0answers
74 views

Importing data from database to WP_list_table

How can I import data from a table where Ive got : ID, Name, LastName, Adress and class and by the way, how do I create this plug-in? Any examples?
0
votes
0answers
76 views

Is MySQL query cache useful for WordPress?

Starting from MySQL 5.6, if you use InnoDB as the default engine, the query cache is now officially disabled. We've a quite moderate traffic WordPress site and experience a major downtime when we ...
0
votes
0answers
139 views

call stored procedure without parameters

I asked this question last week, but then I deleted it because it was stated to be off-topic because I use a function within buddypress. However, I am convinced that whatever I am doing wrong is more ...
0
votes
0answers
56 views

Populating a form with SQL queries

Being a 'learning by example' kind of guy, I've populated a form using this code; <?php $meta_key1 = 'area'; $postids = $wpdb->get_col( $wpdb->prepare( " SELECT ...
0
votes
0answers
84 views

Change post category via MySQL

I'm currently building a management program that works separately from Wordpress but interacts directly with the Wordpress MySQL database. I have it working updating, adding and deleting posts and ...
0
votes
0answers
42 views

How to create and display survey and its statistics?

I am making a new website which will basically have 5 questions of Consumer Confidence Index. So my task is to create a survey which should display in homepage take answers for each 5 key questions, ...
0
votes
0answers
173 views

Would manually deleting the dumping data fix a “#1062 - Duplicate entry '1' for key 'PRIMARY'” phpMyAdmin error?

I'm new to PHP! I'm trying to import an SQL database file into myPhpAdmin for a WordPress I'm migrating, but I keep getting this error message: SQL query: `-- -- Dumping data for table ...
0
votes
0answers
37 views

Whats the Mysql Query to Find each display_name stored in wp_postmeta.meta_value, grouped by username?

I created a custom content type that contains some fieds tos store user names (display name), thru a meta.key that is called 'opr'. Now i want a mysql query to find all custom postss date ...
0
votes
0answers
39 views

Long query apache error from spam comments

My hosting company recently turned on the error reporting for slow queries in php/apache and we have seen the error logs get flooded with errors all from queries requesting spam comments on the front ...
0
votes
0answers
23 views

Unable to run wordpress site in WebMatrix after database credential change (db_name, db_user, db_password)

Well, I assumed this would be much easier. I set up wordpress using the Web Platform Installer. It ran with the database it automatically created for me (DB_NAME: wordpress960, DB_USER: ...
0
votes
0answers
65 views

Splash pages on a high traffic site

Could use some advice here. We have a fairly high traffic site web site using WordPress. Currently we have two VPS servers managing the site, one that holds WP, one that holds MySQL. The WP servers ...
0
votes
0answers
92 views

wp_insert_post another database with custom field

wp_insert_post with the command you want to transfer the contents to another database, I use the following command <?php require('wp-config.php'); $conn = mysql_connect($dbHost, $dbUser, ...
0
votes
0answers
79 views

Import posts into SQL

Is there a way to bulk import posts directly into the database? like from csv into sql database. I don't want to use those csv import plugins since they don't always work they either only import half ...
0
votes
0answers
118 views

SQL query to remove first image in all posts

I've built a site up over a few years (3,500+ posts) where I've inserted images using the traditional method into the post content itself. I'm now moving to a different theme, and have made the first ...
0
votes
0answers
70 views

Best way to execute custom page-specific mysql queries

I would like to query a secondary mysql database (not the Wordpress mysql database) with page-specific queries. I've seen many answers / tutorials on setting up a secondary mysql database, like: ...
0
votes
0answers
21 views

Archive list with only years and months belonging to a category

I need to generate a list of years and months belonging to a category. For example I have two main categories (A and B). I need a list of years and months of post published only of the category A and ...
0
votes
0answers
42 views

wp_term_relationships has term_relationship_id of 0, causing issues with backup

After bulk tagging posts via mysql, I may have inserted a bunch of rows into my wp_term_relationships table that have a term_taxonomy_id of 0. I believe this causing issues when i try to backup the ...
0
votes
0answers
103 views

Using the same shortcode to show any table from the database

I have a little question for you. I want to create a shortcode that makes a table with data that I have stored in a database. But i want to send the shortcode an attribute, to specify which table ...
0
votes
0answers
73 views

Choosing the right server for a big WordPress site with buddypress

I started working in a WordPress site with buddypress and I need to choose a server. They have 1.9 million users in the database and they are estimating to have like 250,000 views every month. The ...
0
votes
0answers
37 views

Writing into MySQL Table

I'm trying to write some data from the frontend into a custom database table. As long there is no value in the input field this script creates an empty line in the database table, but if the input ...
0
votes
0answers
37 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
0answers
139 views

Unable to install WordPress on Plesk 11 Windows based machine

I am trying to install WordPress on a Windows server. The install was not able to create wp-config.php itself, so I created it and put in the database values. Now I get errors like this table doesn't ...
0
votes
0answers
295 views

SQL Query to select post thumbnail, post title, post content from a category

I use the db of my wordpress blog to develop a mobile application in Java. For this, I need the SQL query to display the thumbnail of a post, the title and the content in a selected category. I think ...
0
votes
0answers
26 views

After importing data to new DB with new name, receiving a constant MySQL warning

I've just spent several hours trying to understand why a WP install is really slow, I tracked it down to the database and realised everything in the db was just running super slow with the debug bar ...
0
votes
0answers
114 views

Self-added mysql column as custom fields value

I am trying to add a value from a column that I've added myself to the wp_posts table as a custom field. So right now there is a column called 'shares' which holds an int value and I want that int ...
0
votes
0answers
58 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: ...
0
votes
0answers
88 views

MYSQL Join on meta key value?

I have very basic mysql knowledge (able to update and join tables) and am using phpMYAdmin but I am trying something just beyond my level now. I have looked at many other questions and answers but ...
0
votes
0answers
146 views

Why are my WordPress post queries so slow?

I'm working on a larger WordPress site and trying to troubleshoot why my site is so slow. I've installed W3 Total Cache and have run multiple page speed and plugin tests with no luck. What's strange ...
0
votes
0answers
103 views

why is $wpdb->update() causing a DB error from within wp_set_password()

I have a page-template for my custom theme that enables the user to reset their password from the front-end. I'm calling wp_set_password() and everything runs but the password is not changed in the ...
0
votes
0answers
254 views

Custom Post Type or Custom Tables?

I am trying to build an application that takes 2 pieces of input from a user and saves it to the database. This is how users enter these two pieces of input; this form will be displayed using ...
0
votes
0answers
70 views

Delete junk text from all the post using my sql command

Because of an autoblog plugin, my site has got junk text in every post! The text format is as below .. funny-pictures/funny-pictures-of-the-day-30-pics/attachment/funny-pictures-41-2/" ...
0
votes
0answers
34 views

Wordpress Update Links

I just need a little help in WordPress query or a plugin which can update all internal links used as hyper link or directly with pages to WordPress normal url i.e ?page_id=69 I have created a website ...
0
votes
0answers
104 views

featured image not showing up with mysql_connect

i noticed a certain problem with the featured image issue, i had everything work nicely until i added a mysql connection to another database to retrieve certain information, the featured image stop ...
0
votes
0answers
132 views

One-time bulk MySQL copy post_date values to Advanced Custom Field (date field)

Disclaimer First of all let me say this is probably mostly MySQL related and unfortunately I'm nearly a total newbie on database language and commands. The problem Situation is a site running ...
0
votes
0answers
175 views

Import Excel (or csv) Table with user-data as subscribers to wordpress

i have a tough problem. From an existing database with user-data I need to transfer those users as subscribers to my wordpress database. My user-profiles have various additional custom fields that I ...
0
votes
0answers
129 views

WordPress 3.6 generating empty database

I wanted to migrate my local WordPress i use for theme development to 3.6, but the generated tables in the database are empty. WordPress creates all tables, but only wp_options is being filled, but ...
0
votes
0answers
287 views

Using mysql queries to delete custom post types based on meta_value

I am trying to create a cron job to run on my server which deletes a custom post_type (post_type = event) from my databse based on a meta_key (st_date) and a meta_value (the date the event took place ...
0
votes
0answers
92 views

Wordpress post saves until Apostrophe (’) is used

I've installed wordpress onto a fresh VPS with nginx + php-fpm, the installation works fine apart from whenever I post something with a ’ the post ends there. It's looks to be some sort of escape ...
0
votes
0answers
142 views

Custom query on Wordpress custom table

I am working with a custom table where some values will be inserted or updated if they already exists, I have checked and rechecked the syntax and it seems to be working fine, if I run the same query ...
-1
votes
0answers
25 views

How to select posts with categories by SQL select

Im trying to show some post from a specific category ( from a custom post type) by sql select, I manage to show all post by: <?php $post_date = get_the_date('Y-m-d'); $start_date = date("Y-m-01", ...
-2
votes
0answers
35 views

Already has more than 'max_user_connections' active connections wp-db.php

ERROR : mysql_connect() [function.mysql-connect]: User already has more than 'max_user_connections' active connections in /nfs/c09/h01/mnt/12345/domains/domain_name/html/wp-includes/wp-db.php on ...