MySQL is an open-source, relational database management system.
1
vote
1answer
31 views
Mysql query and order meta value
I made a mysql query to WordPress like this:
$querystr = "
SELECT $wpdb->posts.*
FROM $wpdb->posts, $wpdb->postmeta
WHERE $wpdb->posts.ID = $wpdb->postmeta.post_id
AND ...
-1
votes
1answer
39 views
Custom SQL Query for Wordpress page
I'm quite new to wordpress.
I'm trying to build a tableview within a wordpress page. Therfore I need a custom SQL Query to my MySQL Database.
Query data from my MySQL Database
Get the result somehow ...
1
vote
1answer
30 views
Universal problem: first request after ~25 second inactivity always slower (~1 second) than subsequent requests (~1/10sec)
It's something I noticed ever since I started working with WordPress. It's a universal issue, in the sense that it doesn't matter if the WP installation is on my shared hosting account (haven't tried ...
0
votes
1answer
40 views
How to prevent execution of default query, while preserving ability to use WP_Query in template?
PROBLEM: I'am trying to prevent execution of default WordPress query for custom category template. I have found a possible solution, but looks like it preventing execution of all post queries:
...
-1
votes
1answer
42 views
How can I debug my database connection for unit testing?
I've set up a wordpress environment on my Mac with MAMP and I'm running 3.5.1 locally (i.e. http://localhost:8888/blog works). I'm trying to run the unit test suit from wordpress.org and having ...
0
votes
1answer
28 views
Print output of Table Creation
I am creating a few tables and I getting the following message:
The plugin generated 440 characters of unexpected output during
activation. If you notice “headers already sent” messages, ...
1
vote
2answers
39 views
Error establishing database connection - high traffic?
I have a WordPress 3.5.1 site that's getting a little bit of traffic (80 concurrent visitors, ~5 clicks/pageviews per second). The site runs fine until it spikes to ~85 visitors. There are usually 4 ...
0
votes
0answers
14 views
SQL overload - weird query [migrated]
My hoster claims the following SQL query is overloading the server and causing it to perform slowly and threatens to disable my account. I can't seem to find a bottleneck - can anyone help me detect ...
0
votes
0answers
20 views
Using HyperDB to connect to a MS SQL database
I have successfully split my WordPress database into two MySQL databases (using hyperDB). And it works well. Now I want to dive into the unknown and have one database use MYSQL and the other MS ...
0
votes
0answers
27 views
Wordpress post saves until Apostrophe (’) is used
I've installed wordpress onto a fresh VPS with nginx + php-fpm, the installation works fine apart from whenever I post something with a ’ the post ends there.
It's looks to be some sort of escape ...
0
votes
0answers
41 views
Custom query on Wordpress custom table
I am working with a custom table where some values will be inserted or updated if they already exists, I have checked and rechecked the syntax and it seems to be working fine, if I run the same query ...
0
votes
0answers
89 views
Creating a custom Jquery modal form to upload data in wordpress 3.5.1 [closed]
i am new to jquery.I looked to various demos but can't find what i am looking for.
I want to add a upload item feature in my wordpress website.This feature is available to the end user after he/she ...
0
votes
2answers
53 views
How to copy post titles to post slug in phpmyadmin
I just imported 1000 post into a custom post type on a site and the slugs are all blank. There is a problem with the importing plugin i'm using. My SQL is weak :-/ know what i need to do but not sure ...
0
votes
0answers
22 views
Automatically create a user with author rights from outside of Wp-admin
Need to create a user on the fly based on the following steps...
User clicks a link in an email with a unique url such as
1234.domain.com/?auth=42344245534534535
when the user clicks through to ...
0
votes
0answers
25 views
Wordpress and BigDump
I am having a bit of a nightmare situation. I was given a testarea on a subdirectory of a friend's client server as a temporary favor in order to test my wordpress site. The path is as follows:
...
0
votes
3answers
26 views
Fetch a single row from a custom table for to a given ID
When I want to get a single row from a custom table of my WordPress database by providing a username through function call, it does not work. When I mention the username in where clause of the query, ...
0
votes
2answers
49 views
MySQL Syntax Error upon restoring database from backup
Performed a bad import to my Wordpress install and decided to restore from the mqSQL backup (full export) I had made minutes earlier.
Dropped all tables in the database and then did an import from my ...
0
votes
1answer
38 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
0answers
11 views
instantwp how to shutdown mysql for testing?
I am using instantwp for a standalone project and i need to try out the follow scenario/problem:
"instantwp seems to be running but WP can't established a database connection"
This happened to me by ...
0
votes
1answer
39 views
Woocommerce: Grab total revenue of a product over all orders
I need to display the total revenue of all orders for my products depending on if the logged-in user is the author of the product or not.
I can't use the Quantity field as a multiplier either because ...
0
votes
0answers
29 views
query optimization and benchmarking question to fetch term_taxonomy_id for the provided `name` of term
I have been writing a some plugin for which I need to fetch the term_taxonomy_id from the term_taxonomy table of WordPress for the provided term name.
Though I tried to benchmark them but in best and ...
0
votes
0answers
36 views
How to retrieve data from google places api and save it in mysql database? [closed]
Hi I am developing an android app for blind people where I want to send the nearby locations and bus stops to the user.
I don't want to use google map to display palces in our app but I need to send ...
-3
votes
1answer
20 views
get value from mysql [closed]
i am using this code:
<?php
define('WP_USE_THEMES', false);
require('./wp-blog-header.php');
global $wpdb;
$varrriable = $wpdb->get_var("SELECT ID FROM $wpdb->posts WHERE post_title = ...
0
votes
1answer
27 views
Database create or redirect
I am working on a site ABC.com, I have only access to the root folder. I am planning to install wordpress. I need to somehow create a database without any cPanel.
or the second option that comes in ...
0
votes
0answers
23 views
Dissapered all posts by 2013 year
Dissaperd all posts posted in 2013. There are no posts, images and tags for this year. I've checked it in the phpMyAdmin and find them. But they don't shows in administrtor panel. Any idea? Thanks!
-1
votes
0answers
72 views
How to insert featured image using MySQL alone [closed]
I'm building a Windows-based app to manage WordPress and need to be able to set the featured image for a post entirely using MySQL. I understand I need the post_id, but I want to use a full URL for ...
-4
votes
0answers
34 views
and or or is faster in querying [closed]
which of the 2 queries below would be faster in wordpress query posts API?
tag a or tag b
vs
tag a and tag b
in other words, is the "or" or the "and" operator puts more strain on the SQL?
This ...
-2
votes
1answer
64 views
Woocommerce - Bulk Edit Stock Level
I have 30k products in my Woocommerce store. And I would like to mass edit all products to become "out of stock" before I add new batches of products.
Can anyone please let me know how to do it in ...
1
vote
1answer
35 views
Pushing stored procedure to a multisite database in WordPress
I am given a WordPress multisite and need to extract information from the site.
I have written a stored procedure that recursively builds a tree relationship for posts of a certain kind.
Now I am ...
0
votes
0answers
46 views
Use $_GET with permalinks on page
I'm currently trying to use a $_GET to populate a MySQL query with in a URL on another page within a Wordpress site.
URL sample:
<a href="http://site.com/file.php?alabama">Alabama</a>
...
0
votes
0answers
33 views
Do someone know how to fetch post images sizes via MYSQL Query?
i am developing a web-services using PHP with adodb classes. what i trying to do is that i need the image sizes of the post i.e(thumbnail, medium, large) size. I am able to fetch the post original ...
0
votes
1answer
16 views
Convert many posts from having a specific meta_key to use a post_format
I have 350 posts that were using a plugin-provided option stored in a meta_key ("custom_post_template", to be precise).
I want to convert these posts to assign them a specific post_format ...
0
votes
0answers
12 views
Mysql Like doesn't work with prepare? [duplicate]
i need to get a result using LIKE in mysql , so i have write code like below
$sql = $wpdb->prepare( "SELECT nr, homeTeamId, awayTeamId, homeScore, awayScore
FROM ...
0
votes
1answer
39 views
How do I Split one Table into to lists for two seperate drop down boxes
I am driving myself crazy trying to find an answer, although I know it would most likely be something simple.\
I have a mysql table with the following columns:
id
first_name
family_name
...
0
votes
1answer
22 views
Problem with a query in custom posts
I'm making a search form to select available rooms.
I have a custom post for the rooms called "Products" and a post meta value called "availability" (format: Y-m-d).
And I want to find all rooms ...
0
votes
1answer
90 views
Running Wordpress from MySQL Cluster with HAPRoxy
I'm trying to install a wordpress installation where the DB will sit on a MySQL cluster (Galera/Percona XtraDB Cluster) and connected through HAProxy.
Everything outside of the Wordpress install ...
0
votes
0answers
47 views
using wordpress page templates programmatically
hello I am having a dilemma with a wordpress plugin, its more logic than a code problem so I hope you guys can still help me. over all here is the function of the plugin, again all code works fine ...
0
votes
0answers
34 views
Custom Wordpress Meta Query
I have a post type (course) that has some meta data associated with it, namely the following two:
City and State
The two pieces of data above are stored in the postmeta table, with meta_keys ...
1
vote
1answer
75 views
Custom MySQL Query with logic
I have wp e-commerce plugin installed and custom building custom global search
My query looks like this
SELECT * FROM aka_v_posts
LEFT JOIN aka_v_postmeta
ON aka_v_posts.ID=aka_v_postmeta.post_id
...
0
votes
1answer
32 views
Mysql query and odd results
I've a query here :
$sql = "SELECT ID,post_title,post_content,post_date,post_type
FROM {$wpdb->posts}
WHERE post_content LIKE {$stuff}
AND post_status = 'publish'
AND post_type = ...
1
vote
1answer
68 views
Set up Network Locally on a Flash Drive
I've previously used WAMP for developing WordPress themes locally using a WordPress Network using sub domains. Having to set it all up again every time I want to develop on a new computer is a pain, ...
1
vote
1answer
104 views
Large database causes slow load
I have a 2GB WordPress database (using InnoDB Storage Engine) and I noticed my site loads slow when I press the publish button right after I selected a featured image in the media library.
I had a ...
0
votes
0answers
45 views
need get_adjacent_post query to check for meta_key value
I'm using this excellent replacement for get_adjacent_post that allows you to use the function for custom post types. My question is, how do I form the sql in the 'where' line to make the function ...
0
votes
1answer
68 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
23 views
Filtering problem
I got the custom_post_type_data in which I store some variables when I make a new post. Variables likes Author, Price etc.
I implemented a filtering by author, so when you click on James (for ...
1
vote
1answer
71 views
WordPress plugin overloading with tmp tables
I have asked at the plugin's (WordPress Popular Posts) support a few days ago, since no response hope to get some insight or help here. Thanks.
Hesitant to tweak settings like max_heap_table_size ...
0
votes
2answers
50 views
querying user bookmarks from a large number of bookmarks
I am trying to access the bookmarks created by a single user. The key is stored in the links table, attribute link_owner.
However, get_bookmarks() seems to load the entire table and all I am left ...
2
votes
1answer
149 views
Inserting Hundreds of Thousands of Posts at Once
I have a project in which I create an array of 200k+ lines w/ 25 fields that run the wp_insert_post and update_post_meta. To start it processes pretty fast the slows down a lot after 10k records or ...
-3
votes
2answers
153 views
Preventing duplicate entries in mySQL database with PHP
I have a contact form (Contact Form 7) that submits all fields into a mySQL database (via the Contact Form 7 to Database Plugin), everything is working fine with that. I want it to however, throw the ...
0
votes
2answers
61 views
WordPress Site - Connection to MySQL Database: The Basics [closed]
What is/are the best source/s to check to find the nuts and bolts of connecting a MySQL database to my WordPress website? Thanks.
