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

learn more… | top users | synonyms

0
votes
0answers
103 views

Delete all wordpress posts from db that matches a certain condition

Am trying to delete all posts from wordpress database, that are X days old and have a particular meta key-value attached to it. So simply something like this(pseudo sql): DELETE FROM `wp_posts` ...
0
votes
1answer
75 views

$wpdb returns duplicate posts

I have created a shortcode which shows the posts which were created after the user last logged in. The shortcode is working perfectly fine, but I am not sure why but I am getting 7 duplicate posts. So ...
0
votes
2answers
321 views

Saving custom term value to the database in new table

So I'm trying to save the value of a custom term to my database. The table is created as is the custom term. The code below outputs the text field onto my custom terms page but it just doesn't save ...
0
votes
0answers
178 views

Google-App-Engine[PHP]: Error trying to establish database connection

Hi to whom this may interest, I am finding a problem with the cloudsql as database connection is not being established. I have followed the following site step-by-step ...
0
votes
0answers
34 views

How to fix pagination issue on wordpress

I have a category with 2 subcategories. i have created a custom category template, to show the posts from the subcategories of that category, so it look like that: category page shows: Subcategory ...
0
votes
1answer
125 views

How to fetch all meta_key and meta_value using post_id wihout duplication of post meta using sql query

How to fetch all meta_key and meta_value using post_id wihout duplication of post meta using sql query. This query is repeting the post meta each time . $sql="SELECT * FROM wp_posts LEFT JOIN ...
0
votes
0answers
10 views

get_metadata() vs get_post_meta() vs custom query [duplicate]

I have 27 items of post_meta data that I need to get out in a class that I use through-out my website. Currently I'm using: $this->postMetaData = get_metadata("post", $postID); This returns an ...
0
votes
1answer
447 views

WordPress get pagination on wpdb get_results

How do I gee the numbered pagination of custom wpdb result? below code will show one latest post from each authors in the site. I want to show 20 posts per page with a numbered pagination. $postids ...
0
votes
1answer
204 views

worpress update post meta data(custom field) by post link

I have a post in my wordpress website, which has lot of custom fields. I have an excel sheet with "post link" - "custom field data" combination. That custom field(video url) is already set for each ...
0
votes
2answers
166 views

Show only one post for each author ( Page loads too slow )

I want to show only one latest post by each author and found this code that it working. However, it takes too long to load the page since I have over 100K authors and 100K posts in database. How can I ...
0
votes
1answer
42 views

Foreach only outputs if id is 0

I'm developing a plugin. On the activation hook i do this: /* Create category */ global $wpdb; $rpdb_category = $wpdb->prefix . "rp_category"; if($wpdb->get_var("show tables like ...
3
votes
1answer
597 views

Query both first_name and last_name from wp_usermeta at the same time

I'm trying to fetch both the first_name and last_name of all users at the same time, using the wpdb-object and the wp_usermeta table. I can't seem to figure out how to get both in the same query. ...
0
votes
2answers
3k views

Your PHP installation appears to be missing the MySQL extension which is required by WordPress

After I upload my website on server, I got that message .. I searched on Internet and I found on Wordpress community this link , I followed the installation steps, the error message gone, but I got ...
0
votes
1answer
100 views

Files on Localhost, Database on Server

With Wordpress, is it possible to work on localhost but have the DB on a server? So that workflow will be: 1) Work on localhost (but connected to remote database) 2) Upload JUST files via ...
6
votes
2answers
373 views

Optimize Wordpress Query that take 5 seconds to execute

I have a large wordpress database: rows in key tables: 730K wp_posts 404K wp_terms 752K wp_term_relationships 27K wp_term_taxonomy 1.8 Million wp_postmeta The issue is that I have a query ...
1
vote
1answer
190 views

How to remove 'GROUP BY' from SQL query produced from get_posts?

Wordpress, Archive Cateory page. From default WP_Query->get_posts() we are getting something like this: SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = ...
0
votes
1answer
166 views

Wordpress page and plugin list using sql query

I want to get all published pages and activated plugins of my word press site,i want all pages and plugin using mysql query.i don't want to copy paste all pages from wp admin.i want to get this list ...
1
vote
2answers
99 views

How do i fix? WordPress database error: You have an error in your SQL syntax;

I am Using Wordpress for making a website and getting below Error only on my pages and No shortcodes are working due to this error. This error ONLY seen on PAGES they are working fine on POSTS. I ...
0
votes
1answer
129 views

Alternative functions for mysql_free_result and mysql_ping in wordpress functions

what are the alternative function for mysql_free_result and mysql_ping in WordPress functions , does WordPress function provides all the functions like php ? is it necessary to Free result memory for ...
1
vote
0answers
120 views

mysql_real_escape_string() vs. esc_sql() in WordPress

Does mysql_real_escape_string() and esc_sql() in WordPress both do the same thing? I tried the following: $fetch_row='<p>And again for single posts</p>' echo mysql_real_escape_string( ...
0
votes
1answer
131 views

$wpdb->prepare is not working like mysql_real_escape_string

I'm working on a WordPress plugin and recently I have planned to migrate from SQL to $wpdb. I'm using a method called $wpdb->prepare instead of mysql_real_escape_string but it does not work. Here ...
1
vote
1answer
209 views

Term and sub term from custom post type query

I have created a custom post type and taxonomy for a goods catalogue for a hire website. This works fine. I am trying to generate a report that lists all items and their category and sub category. I ...
0
votes
1answer
412 views

“Error 1064” when importing msql database after updating wordpress version to 4.2.1

I have a error in importing my sql file that contains the db of my site When i export from local, is ok my settings Server: mysql wampserver (127.0.0.1 via TCP/IP) Server type: MySQL Server version: ...
1
vote
1answer
226 views

Safe to delete blank postmeta?

We have a lot of rogue custom fields. I feel that we can clear significant space in the DB if we remove the blank values. If I query my database with the following: select * from wp_postmeta where ...
2
votes
0answers
5k views

How to use update and delete query in wordpress

First i write manually update, delete, insert and select query and execute data with mysql_query function Like this: Select query $prefix = $wpdb->prefix; $postSql = "SELECT DISTINCT post_id ...
0
votes
1answer
167 views

WordPress and SQL - Update and Insert from another table if column value doesn't exist

Stuck with some mysql for my wordpress site. All within 1 DB. I am attempting to update wp_options table from wp_2_options (Multisite). They both have option_name (unique_key) and option_value ...
0
votes
1answer
366 views

Wordpress with php5-fpm and nginx

I am trying to complete an install of wordpress using php5-fpm and nginx, with a database on a remote server. However, wordpress doesn't recognize the existence of mysql to allow me to connect to the ...
0
votes
1answer
167 views

live site do not update after importing sql database

My live website is not updating after importing sql database from wamp local server until last time all went perfect but last night I was not able to see the changes live made in local. what I did: ...
0
votes
0answers
27 views

More efficient remove meta data from posts?

Looking for a better way to do this, bulk remove custom field from all pages with a taxonomy -> people -> term of names. Any thoughts ? This is attached to a single button on a custom admin panel not ...
0
votes
1answer
114 views

Add value to array in database

I have a custom database in my WordPress site where I want to save multiple values to one row. Let's say I have an entry: id: auto increment pageid: id of current page time: text (is an array ...
2
votes
1answer
150 views

Are database queries created using WordPress filters protected from SQL injection?

I'm using the WordPress 'posts_where' filter (https://codex.wordpress.org/Plugin_API/Filter_Reference/posts_where) to alter my queries as below: function filter_my_search($where=''){ ...
0
votes
1answer
41 views

Stop my loop to register data twice

I am facing a problem here. The code below is running on my site and when i fill in the form and check my database the data has been registered twice. Please the the following php code from my ...
0
votes
1answer
92 views

Function returning queried meta value based on current post ID

I have written several queries which sums download counts grouped by the post they are associated with, and other relations. They work great for exporting to CSV and other uses outside of WordPress, ...
0
votes
2answers
179 views

Wordpress SQL injection

How to make below code safe from sql injection ... I am working in wordpress. global $wpdb; if($wpdb->insert( 'votes', array( 'votes' => ...
0
votes
1answer
437 views

Get updated query results on page after insert in database

I am working in wordpress. You will see two queries one is select and the other is insert query. I want that after my insert query is run i get updated results on my page. The select query has a form ...
1
vote
1answer
221 views

Connect to MySQL using Windows Authentication

Is it possible to have Wordpress/PHP connect to my MySQL database using Windows Authentication on IIS? I can connect just fine using the normal MySQL command line utilities. I get the following error ...
0
votes
1answer
1k views

Get the id of the row from database on click of a button [closed]

I am using wordpress and I am fetching images from the mysql database with below code. And I display the image and there is a button just with every image and what I want is that when that button is ...
0
votes
0answers
132 views

MySQL: get post_tag items that are tags (not SEO keywords)

I need to extract the post tags from a Wordpress database using MySQL. My current take is this: SELECT * FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id ...
1
vote
1answer
370 views

Can I run multiple queries with $wpdb->prepare?

I have a query(actually multiple queries) that runs perfectly in phpmyadmin, (I've also tried get_var in place of get_results, but I think I might need an alternative to $wpdb->prepare. How can I ...
-2
votes
1answer
142 views

If meta_key exists then don't select this post?

I'm trying to select all posts EXCEPT ones with a meta_key somekey. SELECT * FROM wp_posts JOIN wp_postmeta ON wp_posts.ID = wp_postmeta.post_id WHERE meta_key != 'somekey' But this is still ...
0
votes
0answers
283 views

Dynamic data from external database - display in several WP sites

I have looked at similar questions, they don't seem to answer my specific question. I have an external database (not using tables in the WP database). I have several sites that need to pull dynamic ...
1
vote
1answer
42 views

WSoD being caused by this piece of code

This is a function I'm writing which is supposed to post an input along with some other information, to a database. As of right now, activating the plugin produces a WSoD, when the function is removed ...
0
votes
1answer
2k views

Jquery ajax to custom php file: returning blank data

I created a custom php file, put it in my folder. The files does insert some data to the database to a custom table i created. require wp_path() . "/wp-load.php"; global $wpdb; $favorite_table = ...
0
votes
0answers
36 views

How do I transfer an existing website running on Joomla to Wordpress?

I am currently the Admin of a site that is running on Joomla 2.5 and I am looking to migrate existing content to wordpress. Please help.
0
votes
0answers
116 views

Alter wp_post table vs. post_meta performance/speed

I'm searching for the most efficient way to link a post to multiple users. By default each post in wp_post has a post_author column, which is linked to the corresponding user ID in wp_users. Assume ...
0
votes
1answer
156 views

dbDelta not creating tables with composite keys

I've been trying to figure this one out for 3 days now, reading every reference on dbDelta I can find. My ultimate goal is to create a table of unique ad_id, ad_trigger pairs. This does not create a ...
0
votes
1answer
113 views

Wordpress upload images not displaying

Hello I have a wordpress site and I upload images to media library but the images do not display. In wp-content/upload folder there are other folders like 2015/ and then in that folder there are ...
0
votes
1answer
91 views

Custom redirects with using SQL

We have pages with urls like this: http://example.com/?page_id=3&user_id=5 http://example.com/?page_id=6&user_id=9 etc. page_id and user_id located in table MySQL Database. And this table has the ...
0
votes
0answers
20 views

Pages edit as posts

I'm currently dealing with the fallout of the following question (How to change post to page). I got all my pages back though all the pages' URLs were changed so there is no hierarchy and when I try ...
0
votes
1answer
32 views

Converting Posts to Pages

So my site backend had issues and my hosting company had fixed it up for me. In doing that, they inadvertently made all my pages, posts. I'm looking at the database that hosts this and there is a ...