MySQL is an open-source, relational database management system.
1
vote
0answers
106 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 ...
1
vote
0answers
116 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 ...
1
vote
0answers
40 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 ...
1
vote
1answer
199 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.
...
1
vote
1answer
325 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
745 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.
...
1
vote
1answer
267 views
Using GROUP CONCAT in my-sql query with wp_usermeta table
I have a query that is meant to return user details from Wordpress tables. It would be fine if I was just SELECTing column names that I want, but within Wordpress there is a usermeta table which has 2 ...
1
vote
4answers
264 views
Migration: Copying database content to a different server
I'm migrating our WordPress site from one server to another. I need some hint on how to deploy a database dump (which I have) from the original server to the new one. There is no phpmyadmin (at least ...
1
vote
0answers
261 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
246 views
Wordpress Post # of # filtered by category slug
I want to show post #4/100 at the top for each post
for which I'm using following code
function updateNumbers() {
/* numbering the published posts: preparation: create an array with the ID in ...
1
vote
1answer
568 views
Call to undefined function get_user_meta() - trying to access data in MySQL from custom fields
I am trying to access data from some custom fileds in my MySQL db so that I can add them to a webpage that will be printed out. The data is held in a column called "paypal_user" and I need to access ...
1
vote
3answers
322 views
My WordPress site always displays a cached version of its homepage
First of all, sorry if I'm making a mistake. I already asked this on the ServerFault forum, but got no answers at the moment and I thought it would be a good idea to ask the question here, considering ...
1
vote
1answer
277 views
WP-DownloadManager - Query most download per week/month etc
I'm using this plugin (http://wordpress.org/extend/plugins/wp-downloadmanager/) as my download manager. While it's very simplistic and does great for what i need, the statistics to output on the site ...
0
votes
2answers
5k views
Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
I'd like to pull data from a mySQL database and put it in some tables in a WP page. I'm using WP 3.1.1.
Imagine that I've got a table of sales figures that I want to pull from a mySQL database and ...
0
votes
3answers
523 views
Code to remove authors with no posts connected to them
I am looking for SQL code that I can run from phpmyadmin to remove all registered users on the blog that do not have any post associated with them.
0
votes
2answers
413 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, ...
0
votes
1answer
448 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
122 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) ...
0
votes
2answers
577 views
Help!! I Screwed up my WP
I was trying to clear up some empty tables left behind by other previously used plugins. As such i was trying to delete the GD Star rating plugin and now I cannot access my WP admin. i get the 'You do ...
0
votes
2answers
129 views
Can Categories be used to hack a Multisite-like setup w/ a single MySql db?
I have a project which will effectively create multiple blogs that will be fed existing content (don't worry, this isn't copyrighted content from other blogs or anything like that). From a DB ...
0
votes
2answers
2k views
Scanning Database for malicious Data
After a site of a friend has been hacked I told him he should just clean up the mess and restart from scratch so he know that no file has been altered.
I could scan the site for him with tools like ...
0
votes
1answer
108 views
What do these phpMyAdmin errors mean on my WordPress databaes?
I'm getting 3 very similar phpMyAdmin errors on one of my WordPress databases.
More than one INDEX key was created for column `comment_approved`
More than one FULLTEXT key was created for column ...
0
votes
1answer
71 views
Create a WordPress administrator without access to back-end
My site recently got hacked, and all my admin users lost their administrator level access. But when I access mySQL database, I saw all the users still exist.
How can I create an administrator when I ...
0
votes
1answer
253 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 ...
0
votes
1answer
334 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
2answers
55 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 ...
0
votes
1answer
372 views
Speeding SQL queries for a large database?
I am using a WordPress plugin called feedwordpress in order to run a planet like website on wordpress (See it here).
The plugin is great except for one thing - it hogs down my (VPS) server into ...
0
votes
3answers
559 views
How to find if a post with custom_field == X exists?
I need to find if a post with a custom field X equal to Y exists in a wordpress installation.
Should I do it with a simple sql query or is there something build in that can help me achieve it?
0
votes
2answers
534 views
Have working sql query… trying to adjust it to use $wpdb
So I have this code that queries a custom plugin generated table in the wp database. It works perfectly as is. But I'm trying to adjust it to use $wpdb instead of the $con function I have set up.
...
0
votes
1answer
828 views
How can I SQL update a meta_value to remove the dollar signs that were entered with the value? (so just the value remains)
For all the "price" custom fields of a site, the dollar sign was entered with the value. I need to remove the dollar sign and leave the just the values.
I know very little about SQL queries. The ...
0
votes
1answer
526 views
query users by role
I have a custom plugin which queries users and usermeta, but I now need to filter admins out of the results. A very simplified version of my sql query is:
SELECT * FROM usermeta LEFT JOIN users ON ...
0
votes
2answers
730 views
Wordpress(wpdb class) and mysql stored procedures
$query = "CALL ..........";
$result = $wpdb->get_results($query);
print_r($results);
Is returning an empty array and $wpdb->query does not return anything, how do you run stored procedures from ...
0
votes
1answer
24 views
Best practice to limit results in get_row()?
This is my query to check if a title exists (it's in a loop, therefore [$i]).
$wpdb->get_row("SELECT * FROM wp_posts WHERE post_title = '" . $titles_arr[$i] . "'", 'ARRAY_A');
Anyway, I would ...
0
votes
1answer
45 views
Creating Database Table vs. Adding MetaData to Post & User
I am creating some event functionality for my wordpress site.
Each event will have a set of tickets associated with it.
A user who is purchased at least one ticket will additionally have a set of ...
0
votes
2answers
72 views
Make a database query using WordPress
I am working on a Wordpress theme that has a homepage slider. I have a table in Wordpress database that stores post view counts and I would like to make my slider show the top viewed posts.
This is ...
0
votes
1answer
362 views
WordPress mysqli and PDO
Does wordpress code base use mysqli or PDO?
I know PDO is superior to mysqli but mysqli is not bad neither. Plus from one of the features of what makes PDO is superior to mysqli ( that is being ...
0
votes
1answer
137 views
Defining the same price to all WooCommerce Products
All of my products on my site are $1 and during an import I did using WooCommerce import it didn't save all the _regular_price & _sale_price values, so there is no way for the user to buy that ...
0
votes
2answers
93 views
How and where is wordpress adding mySQL content to database?
I am currently following this steps to change server and domain for my website. I have been exporting and importing mySQL from one data base to the other. I am about to delete the mySQL content of the ...
0
votes
1answer
324 views
Change featured image urls in database
Im storing my images on another server and Ive managed to change the urls in the database but I cant seem to change the featured image urls?
I will not be adding any more images so I just want to ...
0
votes
1answer
194 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.
0
votes
1answer
348 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
1k views
Query to delete all featured images and remove post meta?
I'd like to run an SQL query to find all featured images from posts and delete the file itself and any references to it.
Can anyone tell me how to accomplish this? Many thanks!
0
votes
1answer
266 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 ...
0
votes
1answer
248 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 ...
0
votes
1answer
193 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() && ...
0
votes
1answer
825 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
58 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 ...
0
votes
1answer
2k views
Should I use wpdb prepare?
I'm new to SQL and am wondering if I need to use wpdb->prepare for the following query to a table I've created
global $wpdb;
$tablename = $wpdb->prefix . "my_custom_table";
$sql = "SELECT * ...
0
votes
1answer
41 views
What's the sql for this condition?
I want to delete all records from wp_usermeta with user_id whose meta_value is "tonetone" which is spam accounts.
As you know already, there are many records with one user_id in wp_usermeta.
I tried ...
0
votes
1answer
350 views
Wordpress and MySQL: trying to print data using PHP from user_meta custom field data
I have some custom user_meta fields in my MySQL database. The data is stored in my DB as follows:
the meta_key is called "paypal_user" and the info is stored in the meta_value column as:
...
