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

learn more… | top users | synonyms

1
vote
2answers
724 views

Mysql query LIKE not working

I'm using this code. $blog_list = $wpdb->get_results( "SELECT " . $extra . "blog_id, last_updated FROM " . $wpdb->blogs. " WHERE public = '1' AND archived = '0' AND mature = '0' AND spam = '0' ...
0
votes
2answers
915 views

Cannot Upload Custom Header Image into Wordpress Dashboard

I'm having trouble uploading a custom image into Wordpress' dashboard. It says that it needs to be a custom 1000x288 image. When I upload it, I get the error of: Warning: ...
0
votes
1answer
1k views

Importing Wordpress Posts With Custom Meta Data As CSV Files Through PHPMyAdmin

I have been importing data records as posts with custom meta data directly into Wordpress via the CSV Importer plugin. It works okay, however, there are some issues with it. Issues: 1) It takes ...
0
votes
1answer
581 views

Cloning blog to localhost via WAMP

How do restore a Wordpress blog (actually, cloning would be the right word) from my server to localhost with WAMP? I backed up my blog with BackUpWordPress and got a .zip file ...
1
vote
1answer
1k views

Within the database, where is the flag which says that a user has Super Admin rights?

I have an user in a Wordpress Multisite installation and have access to the Mysql database, I would like to give myself super-admin rights to access the wp-admin/network page. Where can I do it on ...
4
votes
2answers
2k views

Set page template for all pages?

I know the page template is set in the wpdb as meta_key = _wp_page_template and meta_value = template.php. How can I write a SQL script to set each post where post_type = 'page' to a specific ...
0
votes
1answer
1k views

Difference between 'LIKE' and 'IN' in meta queries

You can use a variety of different comparison operators in meta queries, among which are 'LIKE', 'NOT LIKE', 'IN', and 'NOT IN'. What is the difference in use between LIKE and IN? Here's the ...
1
vote
3answers
2k views

Help With MySQL to WPDB Query Conversion

I have a problem. I've got a PHP script that tracks individual file downloads, and I'm looking for a way to display that number in individual posts. I've got a half-baked solution- a plain ol' MySQL ...
2
votes
2answers
230 views

Tons of Twitter rows in my database

I have 264,307 "http" (post_type = http) rows in my wp_posts table. 99% of those have them have this post_title: GET http://twitter.com/statuses/user_timeline/@xcentric.json?count=100 and "error" ...
-1
votes
1answer
48 views

problem with quotes on new post

i have a little form to post: $post_content = '"Neque porro quisquam est qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit..."'; $post = array( 'post_author' => 1, ...
0
votes
2answers
2k views

Inserting data into MagicFields using mysql queries

PART 01: INTRO Hey Stackexchange Greetings from the Snowy alps of Norway I have now tried for two full consecutive days to reverse engineer Magic Fields. Why? Because I am a simple man, and want to ...
1
vote
3answers
1k views

MySQL query to set wp_postmeta using term_taxonomy_id value

I have a need to set the wp_postmeta value (in table: wp_postmeta) on every post that has a specific term_taxonomy_id (in table: wp_term_relationships): Specifically: run a query against every ...
4
votes
1answer
277 views

Built to scale, or worry later?

I'm starting a service that offers websites that runs on a giant Wordpress multi-site. I have a cloud based vps with nginx-php5-php-fpm-mysql. Storage with Amazon S3, distribution with MaxCDN. WP ...
5
votes
1answer
963 views

How does Wordpress handle MySQL row lock errors?

If there is a WordPress plugin which updates rows in a custom table, but that update encounters a row lock, what happens? E.g. two users simultaneously fire an update on TABLE1, one setting AGE=1 and ...
0
votes
2answers
378 views

Upgrade DB Loop - WordPress DB Version Conflict

So I did an auto update to WP 3.3 and got a screen telling me there was a DB upgrade needed. I hit continue and it said the upgrade was a success. I hit continue again and the same screen popped up ...
0
votes
1answer
139 views

Update some database fields when post is saved

I have a class that will count the Lines of Code, Source Lines of Code, and the Code disk space used. I would like to save these values into the database so that these values can be calculated only ...
0
votes
1answer
513 views

MySQL query performed 4 times inside loop

I have enabled custom php in my pages through the use of the exec-php plugin so I can run more complex pages than the standard WordPress page. I have had no problems with this plugin so far. I have ...
3
votes
2answers
89 views

Wordpress will not operate correctly

My website is ImASpy.com. If you click on the link, Findings, this takes you to my first Wordpress page. It appears to work fine until you click on comments, or you try to go to the about page, which ...
-1
votes
1answer
111 views

Custom wordpress SQL statement for a website

I'm trying to link specific columns from a few standard tables in a wordpress database. I specifically want to see a view/table that includes: post title post content guid meta value = image url ...
3
votes
1answer
326 views

Multipart/formatted MySQL query problem

I'm creating a plugin and I want to automate the creation of a MySQL Trigger on a table. The problem seems to be that $wpdb->query doesn't appear to accept either multipart statements and/or formatted ...
2
votes
3answers
2k views

Import 10,000 Users into Wordpress WITH a specific ID for each user

I have a website which has about 10,000 users. I am converting this site over to Wordpress. The new site is ready to roll, but I have to bring over all the users. There are a number of plugins ...
0
votes
1answer
242 views

Check against server time to display SQL entries - Radio Station DJ Rotator Plugin

I'm building a WordPress plugin that will create a radio station "On-Air Now" DJ rotator. Working options panel I've built so far: http://i.stack.imgur.com/SiYde.png I've based the idea on a PHP ...
0
votes
1answer
43 views

How to fix the amount of comments displayed for each post?

I've received an old wordpress 2.8 and successfully upgraded to WP3.2.1. I've just discovered that the amount of comments displayed in the WP Admin 's list of posts is wrong. Would you know how i ...
2
votes
1answer
1k views

How many 'wp_insert_post' calls can be performed in one shot, in a very long 'for' loop?

I'm working on a plugin which has bulk post inserts using a spreadsheet. This spreadsheet can have multiple thousand rows, each row corresponding to a post. I'm parsing this spreadsheet, looping over ...
0
votes
2answers
326 views

wpdb function insert doesn't work

It just won't insert anything, if I echo it, it will show everything fine, but it won't insert anything in database. The table name is correct. Code - global $wpdb; $meta2 = ...
1
vote
1answer
340 views

Query to import data from one MultiSite table to another (pages/sub-pages)

I'm updating a standard install with about 500 (eek!!) pages to a MultiSite for easier sub-site management. I basically want to take a sub-page and its children from the root site and copy the data ...
0
votes
1answer
1k views

MySQL Query that looks for post with Custom Field, then changes Category

I'm looking for a MySQL Query that will look for all the posts with custom field "meta_key_I_want_to_find", then if the custom field is detected, add a category to that post. The category has already ...
0
votes
1answer
2k views

Wordpress database error: [Query was empty] - using $wpdb->prepare()

I have edited my question, I'm now getting the error about checking my MySQL settings. I changed the $sql_dvalues variable to an array with the values instead of comma spaced values and now it is ...
3
votes
3answers
8k views

How to validate WordPress generated password in DB using PHP?

I am working with site that is done with WordPress, and I need to add some parts that are outside WP, and to check user login, Logging users outside WP. I tried with md5 of password but it's not... ...
1
vote
0answers
303 views

WPDB is not working when trying to run a custom query [closed]

I'm developing a WordPress plugin, and have no other plugins installed. The logging function is as simple as function log($message){ global $wpdb; $message = $wpdb->escape($message); ...
1
vote
1answer
641 views

MySQL Query To Select Post By Postmeta

I have two custom post types, type1 and type2. Type2 posts have a postmeta called postID that is the ID number of a post in type1. When showing type1 in single.php I want a mysql query that selects ...
0
votes
1answer
912 views

Query posts by custom taxonomy and sort by post_modified

I try to query 5 posts in cpt 'vacancy'. Query is very complex. For first I need posts that belongs to custom taxonomy with ID 18 and sorted by 'post_modified', then - all other posts in cpt 'vacancy' ...
0
votes
2answers
1k views

export individual posts to text files or a single csv file

I'd like to export my blog posts to plain text files so I can version control and update them using emacs org-mode via the org2blog package. However, I'm unfamiliar with SQL and the wordpress ...
3
votes
2answers
993 views

modify all posts of a category to “no comments allowed”

I'm looking for a way to modify all posts of a certain category to be "no comments allowed" without going into each post settings, one by one, and modifying manually. Perhaps a MySQL statement? ...
2
votes
1answer
116 views

theme options echoing multiple times

I tried to strip down the Twenty Eleven theme options page and add my own fields correction: I followed a tutorial somewhere, but when I try to echo the data, it comes out multiple times. Here is my ...
4
votes
1answer
1k views

Problems with DBDelta with FOREIGN key?

I have the following sql I am using with dbDelta: $sql .= "CREATE TABLE " . $location_table . " ( location_id MEDIUMINT(9) NOT NULL AUTO_INCREMENT, name VARCHAR (100), ...
1
vote
1answer
135 views

MySQL Rank & $wpdb

I need a rank column in my MySQL statement, for example: SET @rank=0; SELECT @rank:=@rank +1 as rank, player, points FROM my_table Is there a way to use the above with $wpdb? WordPress doesn't ...
0
votes
1answer
361 views

Find out how many times the user has logged in

I'd like to determine how many times a user has logged in. Does WordPress retain that information or will I have to add a db entry every time they log-in? if(is_user_logged_in() && ...
7
votes
4answers
5k views

How can I find the source of slow queries in Wordpress?

I have a WordPress site with more than 8000 posts and everytime I add a new one the site becomes unresponsive. I checked the MySQL slow queries log and found out that it is performing a select that ...
0
votes
1answer
1k views

Wordpress $wpdb get posts from category and sort by custom meta

I have a custom post type of 'events' which has a meta key 'event_date' Im using the following to retrieve those posts and arrange them by 'event_date' global $wpdb; $today = ...
0
votes
1answer
838 views

query for filtering published posts?

i need to filter count based on a date and post_status = 'publish', how to write a query to filter, as far as now i have filtered based on date, what is the query need to filter based published post. ...
0
votes
1answer
38 views

How to make that all posts with a category belong also to another

I'd like to make that all my posts in the category A belong also to category B (so after that they would belong both to A and B), is there any plugin or MySQL query that could allow me to do that ...
0
votes
1answer
175 views

How i can obtain all the post meta for a specific post as an array?

<?php $fields = get_post_custom($ID); ?> This will fetch the custom fields ($key => $value) for $ID in to the array $fields. I want ALL the fields (both custom & standard WP fields) ...
11
votes
2answers
4k views

The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?

Lately I've been reading about MariaDB and Percona Server, two strong alternatives to MySQL that have gained popularity since Oracle bought Sun. As far as I know, both of them could be used with ...
1
vote
2answers
278 views

Help running a MySQL query to update all wp_#_options tables in a Multisite install

I'd like to run a query through my WordPress database that updates the blog_public values on all individual sites. I'm stuck on how to have the statement look for wp_2_options, wp_3_options, etc. I ...
1
vote
1answer
578 views

Rewrite database urls

Is there a query I can run on my wordpress database so that I can change all instances of www.mydomain.com to localhost/mylocalsite.com?
0
votes
1answer
132 views

Wordpress tables and aliases?

I have imported some tables from my online wordpress database to my local to work on. However now I am getting some weird sql errors that I don't get online. I can see that the code of the plugin I ...
1
vote
1answer
525 views

User management system similar to wordpress one?

I am in very big need of a user management system just like the one that wordpress uses but without being blog related. I need to be able to manage users and apply certain privileges depending on user ...
0
votes
1answer
309 views

How to create a blogs category page with Blog-Types Plugin

I'm not a web developer so I don't know how to create an sql query to display information from my database. Here's what I wanted to do, I want to have a page that will display blog categories. When a ...
2
votes
1answer
1k views

PHP/MySQL issues when running WP on EC2 cloud [closed]

I am trying to create a wordpress blog on an Amazon EC2 instance. The amazon base image had apache and php already installed. I installed MySQL manually in my user directory. I am able to login to the ...