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

learn more… | top users | synonyms

1
vote
0answers
233 views

Query most popular terms by taxonomy over 2 week period

I have written SQL for a query that pulls the most used taxonomy terms for selected taxonomies that are published, do not have a parent post are not in a comma separated list over the past two weeks --...
3
votes
2answers
711 views

mysql custom wp query

this code is designed to select posts with selected meta value in wordpress query <?php $values = $wpdb->get_results("SELECT DISTINCT meta_value FROM $wpdb->postmeta WHERE meta_key = 'wpcf-...
2
votes
2answers
442 views

Database slowdown after update to 3.4.1

I own a wordpress installation, and Updated to 3.4.1. After the upgrade, I got a very strange slowdown to my wordpress. After all, I used the define('SAVEQUERIES', true); in my wp-config.php with ...
2
votes
2answers
2k views

If I consider changing my WordPress DB tables to InnoDB, will it have an effect on the way WordPress works?

I found a superb post here about optimising WordPress for large installs. One of the steps refers to lighthttpd which sounds excellent but isn't currently supported by DirectAdmin. Last time I messed ...
1
vote
0answers
323 views

List authors with the last post title and order by last post date

I want to list authors with last post data and order them by last post date. Now i have this codes but i don`t know how to edit them. // Selects from tables wp_users and wp_posts, selecting published ...
4
votes
2answers
10k views

Where is the content of widgets stored in mysql table

I have the cPanel access to a website but no wordpress login info. So I wants to change a widget content in the website. How can I change it through phpmyadmin. Where are that widgets sidebar data ...
0
votes
1answer
111 views

Different sql queries count indicator on the main page [closed]

I use w3_total_cache plugin. But i can`t understand what is going on sometimes. I have enabled database caching and debug info at the bottom. Sometimes on the main page 90-96 db queries, sometimes 495-...
4
votes
3answers
5k views

Retrieve featured image

We are building an Android app based on a Wordpress mysql database. We were able to get most of the information from the datase to display on to the app. Now all we have left is to retrieve the posts ...
1
vote
0answers
76 views

How can I make wordpress suppress mysql errors?

Wordpress has two functions related to SQL queries and their errors as mentioned in What Is The Difference Between suppress_errors() And hide_errors() in $wpdb? From what I've read setting WP_DEBUG ...
3
votes
1answer
4k views

delete unused postmeta

I love the comment by s_ha_dum : http://wordpress.org/support/topic/sql-query-to-delete-postmeta and havent tried it yet, but Im wondering just how 'clever' this actually is? Does the unused postmeta ...
0
votes
2answers
404 views

Parsing External Table Arguments

I have a client project that has posts assigned to their country of origin. The client wants to be able to search the posts by continent and or region. I have a separate table that assigns each ...
0
votes
1answer
205 views

Pull post name from value of a specific meta key

I am looking for help on how to pull post name from custom field value for example in wp_posts post id = 200, and there are corresponding meta key and values with post_id= 200 in wp_postmeta I want ...
5
votes
2answers
1k views

Can i use php sql functions instead of $wpdb?

I'm new to WordPress and was wondering why in WordPress API do they tell you to use functions such as prepare(), insert(), get_col(), get_row(), query(), etc. when technically I can use the built-in ...
0
votes
2answers
3k views

Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment

I just got a new Macbook Air and I've been manually migrating my files and code over from my old Macbook (instead of using Migration Assistant, to avoid bringing cruft). I had several sites running ...
0
votes
1answer
566 views

SQL query not working in alphabetical post title/content search

I have an ajax request using wp_ajax sending one variable named "q" what I want to do is after the script get's the request to look inside the db and fetch the title and id of the corresponding posts ...
1
vote
2answers
4k views

How to Query Database for posts with certain Taxonomy Term

I want to write a select query to return data on only posts which have are associated with the taxonomy term food-and-beverage SELECT wp_postmeta . * , wp_posts.post_name FROM wp_posts, wp_postmeta, ...
5
votes
2answers
5k views

Get Previous & Next posts by Post ID

How can I go about getting the previous and next posts from outside the loop? Everything I try to do aside from the custom SELECT query (using get_posts or WP_Query) breaks stuff further down the page....
0
votes
1answer
260 views

get_var is neither a string, integer, or array …?

$vote_count = $wpdb->get_var($wpdb->prepare("SELECT votes FROM wp_mytable WHERE product = %s AND company = %s", $product, $company)); if(is_int($vote_count))...
0
votes
1answer
1k views

PHP variables in mysql query

What is the consensus on how to insert variables in a MySQL query using the $wpdb->insert syntax: ($table, array($column=>$value),$format)? I know this hasn't worked: $wpdb->update('...
0
votes
1answer
350 views

How to query / DB requests?

what is the correct way to query the a Wordpress database, meaning to pull row and column info, and then place it into a corresponding table in the Wordpress admin? I'm wanting to do a query similar ...
0
votes
1answer
781 views

Query the links Database

Hi I'm trying to convert from a "example" wp_list_table that displays an array of data on the same page, to a "real life" table the pulls data from the database. I have the code setup to where I just ...
9
votes
3answers
798 views

What's a good strategy for planning WordPress DB growth?

Hoping for some feedback on the topic of optimizing and staying on top of performance as a WordPress database grows... to paint a picture.... let's say you have a WordPress / Buddypress MU site that ...
0
votes
1answer
449 views

How to display results from a data table with an encrypted user id?

I'm trying to display a table of results for particular users who have submitted answers to quizzes. The problem is that the mysql database I am working with has a funky value for the user's ID. I'm ...
3
votes
2answers
1k views

How is the data stored in the database?

I have years of experience with PHP and MySQL, but just starting to develop plugins for WordPress and need some help. Currently, I am working on a plugin that will add extra functionality to another ...
7
votes
1answer
995 views

dbDelta support for FOREIGN KEY

On PHP 5.3.13/MySQL 5.5.21 the following code doesn't work: if($check_custom_fields_form!=1){ $sql = "CREATE TABLE IF NOT EXISTS ". $table_custom_fields_form ." ( `form_name` ...
0
votes
1answer
1k views

Most viewed posts in Wordpress

I am owner of a blog/website and I am using this code for tracking post views in site : function getPostViews($postID){ $count_key = 'post_views_count'; $count = get_post_meta($postID, $...
0
votes
1answer
635 views

Force Users To Relogin

I need a solution that i can use to force a user to logout via the admin panel of word press any help on this would be appreciated.
1
vote
1answer
1k views

the_author_meta not working

I'm trying to use the_author_meta to retrieve some links which users can set in their profile. I set up extra profile fields and they are saving to the database. On my author.php I have the ...
0
votes
1answer
277 views

Wordpress: Using the category slug get the category ID using mysql query

basically, I have a cookie with the category slug stored, using this data I want to query the database and return the ID of the category. I am new to mysql and this seems like an advanced query that ...
7
votes
5answers
5k views

the_date() not working

I am using wordpress 3.2 and I did a query post like this: <?php query_posts("posts_per_page=1post=type&page=post_parent=10");?> Then I try to echo out the date of this post I queried ...
4
votes
5answers
14k views

Will it break my site if I delete all transient records in wp_options table?

My site currently has an outrageous 500k+ transient records in the wp_options table. This causes the table to be crashed frequently and so be my site. I thought transient records will all expired ...
0
votes
1answer
649 views

Custom SELECT Query With Multiple Meta Values (Ordering Problem)

I have two custom meta values that I am using for an events list and have almost got everything working perfectly except for the ordering. I have two dates (event_date and event_enddate). One of these ...
0
votes
1answer
2k views

How to create Loop code for Menu using Wordpress?

I have created a menu called "My Menu" in wordpress using Menus feature provided under Wordpress admin panel. I have added 3 pages into it named Page A, Page B, Page C. I have applied featured image ...
0
votes
1answer
40 views

Php Mysql Terms

I have configured wordpress in local system. I came across these terms in Phpmysql database under wp_options. Can any one please tell me, what does it mean? a:2:{s:12:"twentyeleven";s:7:"/themes";s:...
4
votes
2answers
36k views

Connect to database using wordpress wp-config file

How can I connect to the database using the wp-config.php file ? I'm trying to make a script more Wordpress friendly, and I need to connect to the database, but without installing the script as a ...
1
vote
1answer
377 views

Too many pages causes Wordpress admin to be unusable

We have a Wordpress website that now has around 9k pages in it after an import of many location targeted pages. The frontend runs perfectly fine and there is no performance damage (after I replaced ...
0
votes
1answer
755 views

Site not responding error - taking long to load

I have a wordpress website which gets around 20K visits a days and with around 7pages/visit and 62 hits per visit. My server is : 8 processors --> Intel(R) Xeon(R) CPU E5405 @ 2.00GHz 8 GB ...
0
votes
2answers
5k views

How to use “TRUNCATE TABLE” MySQL statement?

I have tried dbDelta and $wpdb->query, they does not work. Does anyone has any ideas?
2
votes
1answer
341 views

How do I write this SQL statement for Posts written in last 24 hours?

Someone gave me this SQL code to count the number of posts (of post_type 'mixtapes') in the last 7 days. I tried to convert it to 'in the last 24 hours' as well, but it's giving the wrong number. ...
0
votes
2answers
104 views

Problem with admin login after deployment

I made a site for a friend and everything worked so far on my development box that we can start final deployment and testing so I decided to put it on the hosting. So I done the standard procedure ...
1
vote
1answer
2k views

Accessing WordPress MySQL Database via Data Connection in Visual Studio 2010 using C#

So I've Googled and followed countless tutorials, read documentation on MySQL, Visual Studio, WordPress, and Plesk. I try to leave posting on this site as the final option and it seems it has come to ...
0
votes
1answer
300 views

wp_insert_post - duration

i try to import a custom DB to the WP DB with about 2000 rows (custom post type). the problem is that the insert by wp_insert_post takes about a second per insert. Is this normal ? Is there a fast/...
2
votes
2answers
13k views

Get Featured Image via direct sql query

I know you can use the wordpress methods for getting a featured image, however with this particular project I need to get the featured image via mysql query. Can anyone point me in the right direction....
2
votes
2answers
591 views

sql query to put quotes around numbers in img tag

I have quite a few old posts that contain an img tag with height and width with no double quotes around the numbers. For example: <img height=319 alt="" src="http://www.example.com/images/...
0
votes
4answers
6k views

Manually delete post from database

For whatever reason, I have a post and a page with the same slug name and it causes the db to hang. I can't alter the slug on either so I need to go manually delete the posts from the database and ...
1
vote
1answer
929 views

Paypal Post IPN handeling nightmare

I'm trying to integrate paypal standard with my Wordpress site and all was going well until I wanted to do one simple thing: The user submits a paypal payment Paypal posts the IPN to my server Post ...
1
vote
2answers
2k views

Help with MySQL to $WPDB query

Here's my issue. I have three tables I'd like to query - states, points, and state_points. States contains stateid, and name. Points: pointid, pointlat, pointlng. State_points: Stateid, Pointid. ...
5
votes
2answers
346 views

Is it possible to define two databases for one installation?

Is it possible to define 2 database for one wp installation, I have searched but there are options for one database and 2 installations. I want this because, one of my clients site is hosted on ...
0
votes
1answer
1k views

mySQL query. ORDER BY meta_key

I'm fighting this quite long already and start to think I'm missing something big. CPT posts could have or not metadata ( _vip_post [0|1], _thumbnail_id [null|numeric] ). If i query for ...
0
votes
1answer
661 views

Export posts with postmeta without ID?

I have some select posts on one database that I need to export and import into a different database. Because both databases are operating independently, there is overlap with post IDs so I can't ...