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

learn more… | top users | synonyms

0
votes
1answer
75 views

wp_usermeta - Read from database, but save function broken

I added a custom field to the profile-page of WordPress users called "uidnumber" and it reads values from the database just fine, however it just doesn't save anything. I'd rather save it in ...
2
votes
2answers
109 views

Proper way to work with wpdb to get user's firstname

I want to use $wpdb to get user's firstname. I know how to do it with php and mysql query, but I want to use $wpdb. The problem is that I don't know how to use it. I tried to create simple query to ...
0
votes
0answers
55 views

SQL Query to export Buddypress Profile data

I need to use sql query to export for http://wpdatatables.com, the code the plugin generates comes with error and I've tried phpmyadmin and sql pro with same error SELECT wp_bp_xprofile_data.value, ...
0
votes
0answers
42 views

Render a Wordpress menu from outside Wordpress?

I would like to render a menu in another system outside wordpress using SQL to fetch the menu contents and some logic to build the actual menu. I turned on mysql logging to see what wordpress was ...
0
votes
1answer
76 views

Edit Account - read and write to MySQL

I have user data that's being saved to and read from the database as they are all standard WordPress fields. example: $user->user_email And here's the code I have inside the ...
0
votes
0answers
88 views

What is the cron doing?

So I installed the P3 plugin to analyze the plugin load time at my site. It was OK at the actually analyzing but just a really poor plugin that basically crashed my server which has great specs over ...
1
vote
0answers
27 views

How to add a private user page populated from sql?

I have taken over management of a Boy Scout website for around 75 kids. The site is a vanilla WordPress site and has no access control (other than admin). I would like a scout/parent to be able to ...
1
vote
1answer
770 views

Unique Post Meta Values

I want to use Unique IDs like YouTube video IDs and WordPress post IDs in a custom field 'youtube_id'. I just created a front-end add post page and want to check if 'youtube_id' used or not used in a ...
0
votes
0answers
43 views

Posts page in WordPress dashboard very slow

I have a WordPress install that has about 4800+ posts. Most of the posts does heavy usages of categories and tags. My site itself is very responsive, but on dashboard, specifically Posts > All ...
0
votes
0answers
48 views
0
votes
0answers
16 views

SQL query to load a menu and contents [duplicate]

I would like to render a menu in another system outside wordpress using SQL to fetch the menu contents. I'm able to find a menu item based on the slug: SELECT * FROM `wp_terms` wt WHERE wt.slug = ...
0
votes
0answers
51 views

Unique ID based on SQL Table

how can i create or generate a unique id that will based on a table like users.id then insert that result to an different table column field? this is how i call the table that need to insert results ...
0
votes
1answer
42 views

writing inner join in wpdb

I have a problem in writing SQL Inner Join syntax in wordpress, This logic should definitely work, I tried this in phpmyadmin and it works fine SELECT booking_calendars.cal_name FROM ...
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
286 views

`#1215 - Cannot add foreign key constraint

create table wp_pageviews ( ID BIGINT(20), count integer, primary key(ID), FOREIGN KEY (ID) REFERENCES wp_posts(ID) ) Error : #1215 - Cannot add foreign key constraint ...
1
vote
2answers
127 views

Query All users that has post

I have this query so far : $user_args = array( 'role' => 'frontend_vendor', 'orderby' => 'display_name', 'order' => 'ASC', ...
0
votes
1answer
21 views

Get multisite count without php?

I'm writing a program in Python that outputs information about Wordpress installations and I'm adding some features to detect Multisite installations and their details. I would like it to print how ...
0
votes
0answers
82 views

Fill table in WordPress with MySQL data

I'm unsure on how to do this as I've never coded a MySQL database directly into a website, so I appreciate any help I can get. What I want to accomplish: I have a MySQL table in my website's ...
0
votes
1answer
85 views

Inner join overrides Advanced Custom Fields plugin's get_field [closed]

I have this search that I made with inner join and where clause. I no longer get get_field() values, they all return false. How can I get ACF to work again? It must be something silly that I don't ...
0
votes
1answer
73 views

How to get product order by two custom taxonomy in wordpress

Yesterday i stuck in the middle of code that how could i retrieve product belong to specific custom taxonomy ordered by other taxonomy. Table wp_posts: id | post_title ---------------------- ...
0
votes
1answer
414 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 ...
0
votes
2answers
5k views

SQL - Pull products of particular category from a remote WordPress woocommerce db

I connected to the db and successfully pulled products data. Now I want to to display products from specific category. The store is using woocommerce. The landing page is in different location so I ...
0
votes
0answers
84 views

Best practice for writing backend forms to interact with database

I am responsible for a Wordpress site where ingredients, recipes, allergens and similar data is inserted into the database. All the columns in the database are separate from the Wordpress database, ...
0
votes
1answer
380 views

Second completely independent and disposable Wordpress installation in subdirectory?

I know this may have been asked before, but I didn't find an exact answer, so yeah ... I have a wordpress installation in the main directory of my Webspace (hosted @ Strato) and I want to install a ...
0
votes
1answer
167 views

Remove empty rows from the database

I'm writing a script to alter the post content column in the database and I just notice it has a lot of empty rows, these seem to be deleted posts that now have no content or anything, I don't like ...
0
votes
1answer
40 views

How to set max users to 17.000

For a website i need a range of user_id's from 10.000 to 17.000 I've already been able to set the minimum, but i'm clueless as how to set the maximum. I've been Googling around for a while now, hoping ...
0
votes
1answer
98 views

Removing the first image in content

I've been using this code: function remove_first_image ($content) { if (!is_page() && !is_feed() && !is_feed()) { $content = preg_replace("/<img[^>]+\>/i", "", $content, 1); ...
0
votes
1answer
143 views

How to create a post based on data in a table?

I have a MySQL table which I created that contains fields for a Title and a Body. There about 100 records in this table. I would like to create a Wordpress post for each row in this table. Is that ...
0
votes
0answers
363 views

How to export table from database in CSV file format (making custom plugin)

I am making a plugin. It stores emails in table of a database via html form and displays the emails in administrator page. I also want to include a button, that enables the export of emails in CSV ...
1
vote
0answers
232 views

Slow SQL_CALC_FOUND_ROWS Query

We are experiencing very slow performance with queries that use SQL_CALC_FOUND_ROWS within the admin section of WordPress. We currently have about 125,000 posts on our site and use Varnish to cache ...
0
votes
1answer
190 views

What might be the reason of Couldn't fetch mysqli_result on another domain?

I'm developing a plugin and it works fine on my Wordpress website, but I've tested it on other domains with different Wordpress instances. When trying to activate the plugin on some other sites and ...
2
votes
1answer
34 views

What are conventions about the schema of the $table_prefix

I wonder if there are any conventions or best practices about the table prefix of any WordPress set up. The official documentation on wordpress.org does not make any statements to that topic. ...
0
votes
1answer
54 views

Changing order of db results when encoding to JSON

There is probably a very simple solution to this but I just can't work it out. I am getting some info from the wp database, bypassing WP's built in classes, then echoing the results as encoded JSON ...
0
votes
1answer
73 views

WP_Query always returning the last custom post

I have code that works fine on our live system, and I'm porting it to a new theme. In the new theme, the WP_Query always seems to return the last custom post. My function is: function ...
0
votes
1answer
70 views

Wordpress mysql table double prefixes

Currently working on updating a wordpress website for a client of mine. The wordpress mysql database has double prefixes in it though. The standard wp_ prefix and her own custom prefix for the ...
0
votes
1answer
81 views

WP Database generate content for post_name column

I ran a query that deleted all content in post_name (used for SEO-friendly URLs) column. UPDATE wp_posts SET post_name = '' I thought that WordPress would automatically populate new ones if I ...
0
votes
0answers
53 views

Setting up automated post status change / delete system

Haha, first of all, I've been asking all my WP questions in stackoverflow and then wondered why everybody said they don't know nothing about WP. My question is simple: What's the best way in your ...
0
votes
1answer
50 views

Conditional statement within WP SQL query

I have a form on a Wordpress page posting data to a table called 'members'. I have a second page displaying this data in a table. All is working well. The data is being displayed using: $myrows = ...
0
votes
1answer
103 views

MySQL Select within WP Page template

I have one WP page which contains a form that posts data to a table in the Wordpress database called "members", data such as first name, surname, email, role and bio. Table posts fine and data is ...
0
votes
1answer
66 views

Check if a database is well installed

I tried to install wordpress under eclipse and xampp under ubuntu. I created the database (user: root, password: empty) by a sql command create database wordpress;, that is it. The wordpress seems to ...
0
votes
1answer
131 views

What are the issues associated with upgrading MySQL for Wordpress?

What are the issues associated with upgrading MySQL from 5.1 up to 5.5 for a server hosting multiple Wordpress sites? Will there be problems with the database after the upgrade? I have Plesk 12 ...
1
vote
2answers
53 views

How to get the total number of meta_values based on a custom post type?

I need to display the total number of votes that have been made for a specific custom post type. Here's an example of how the wp_postmeta table looks for these keys/values: meta_id post_id meta_key ...
0
votes
1answer
55 views

Mysql SELECT posts

how i can get posts via MYSQL from posts where language is 'en' and 'ru' I have this query $sql = "SELECT p1.*, wm2.meta_value FROM wp_posts p1 LEFT JOIN wp_postmeta wm1 ON ( wm1.post_id = ...
0
votes
0answers
21 views

Does WP query update accept variables being built into it?

Trying to figure out if this is a WP specific quirk. The var_dump code shows the correct string to be inserted but the last query dump at the end shows an incomplete query with no variable being ...
0
votes
1answer
48 views

Can I use mysql queries to replace query_posts()?

I have a template that seems to only accept variables given though query_posts(), which appears to work like get_posts(), but it's too restricting. So I need to either do it somehow without ...
0
votes
1answer
56 views

New post from database

I have data stored in DB (mysql) I want to creat new post for each row I have created custom post type with custom fields Beside xml rpc is there any other way. Cheers
0
votes
1answer
67 views

Create a new table on the database and save parameters from a contact form

I have a wordpress function in functions.php which gets parameters from a form I made and gets parameters like IP addresses and UTM tags (from the URL) and sends them to me by email. I want to get ...
0
votes
0answers
36 views

$wpdb how can i save my postmeta table before querying it

This function is in my functions.php file. The query returns the value I'm looking for via phpmyadmin, but only AFTER the function has been run in WordPress. add_action( 'transition_post_status', ...
0
votes
0answers
75 views

MySQL query in Functions.php using inner join to override/add to search

I'm setting up a radial geo-location search. I have users select a zipcode and a radius to search within. I want to use the regular search site.com?/s=abcd&zipcode=90210&radius=10 I look up ...
1
vote
0answers
374 views

Wordpress Deadlock Error

I see more of this error these days in error_log. I see that someone asked this question here a year ago but no solution. Please advise what is causing this issue. Already, tried deactivating some ...