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

learn more… | top users | synonyms

0
votes
0answers
578 views

Insert data into mysql database with php and ajax

I made admin menu inside wordpress and I have form that allows admin to insert some values. I have html: <form id="prices_form" method="post" action=""> <div style=font-weight:bold;...
0
votes
1answer
276 views

Live search from database table

I have wordpress site. I made custom table and sotred values in one row. Now I made admin menu and added input field into it. <input id="location1" type="text" /> I need to predict search ...
0
votes
2answers
29 views

get_results() query not working only when entering strings

I'm trying to send a query to a database, WHERE works fine if I'm querying for a number but not for a string. Example, if I try: $all_pages = $wpdb->get_results('SELECT post_title, guid FROM ...
0
votes
0answers
112 views

Remove Special Characters from Wordpress Media File Names in HTML

I've removed all the special characters from media filenames in the database (meta_key - _wp_attached_file - filename), I've renamed the files in the FTP and rebuilt the thumbnails a few times. ...
0
votes
0answers
22 views

Error establishing a database connection But all is same

I was upload my web file and MySQL base to CPANEL. Database name, user and password is all SAME in my config.php file. BUT i cant connect my web. /** The name of the database for WordPress */ define('...
0
votes
2answers
43 views

How do I change the user via SQL?

I change a user via SQL in wordpress: SET @old_user='old_user'; SET @new_user='new_user'; UPDATE wp_users SET user_login = replace(user_login, @old_user, @new_user); UPDATE wp_users SET ...
0
votes
1answer
18 views

WP_Query with page_ids in arguments without a result

I want to get some pages with WP_Query: $resume_args = array(); $resume_args['post_type'] = 'resume'; $resume_args['posts_per_page'] = -1; //$resume_args['page_id'] = array(9046, 9346); //No ...
0
votes
0answers
33 views

Display data form externally table as posts?

I have an external MySQL table with roughly 4,000 rows and would like to display each row as a post within my Wordpress blog. The table grows almost daily so ideally I would like users to be able to ...
2
votes
1answer
53 views
18
votes
3answers
13k 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
0answers
26 views

Add/edit row/rows in tables

I've done some tables in my wordpress-database: area, producer and product where one area contains many producers and where the producer contains many products. How to do a menuoption in the Admin ...
0
votes
1answer
523 views

Processing ajax call to php to insert into mysql database

I made top menu in wp admin dashboard. There I will have input field. It will be input where admin can enter Google locations. After picking correct location admin will press save and location will be ...
0
votes
2answers
44 views

Re-writing MySQl query for execute faster

Can any one re-write this SQL query to perform better? At present this query takes about 29 seconds to execute in BlueHost server while it takes 6 seconds in HostGator.com server. My intention is ...
1
vote
1answer
313 views

MySql Query very slow

I have a problem with a query on my website. When I load the page it is incredibly slow and only after over 12 seconds the content starts showing. I have installed a debug plugin and found the query ...
0
votes
1answer
56 views

Gaining Login Access via the Database

I have been given a job to amend a Wordpress site. I have only been given access to Cpanel. My questions are can i log in to the back end of Wordpress via Cpanel? If you can't login via Cpanel can i ...
1
vote
0answers
127 views

Manually query posts by taxonomy with MySQL

I'm trying to query posts from the WP database with the category uncategorised, while also joining the post meta table, but I can't get it to work. I get an empty result. This is my query SELECT * ...
2
votes
3answers
530 views

Search and replace text across all posts

I had used the ZD Video Plugin for WP a long time, and now, since my move to WP 3.0.2, it doesn't work anymore. To embed a YouTube video using the plugin, I would just write [zdvideo]url-of-...
0
votes
0answers
39 views

Export User Info into CSV - Additional Column (post_title)

I'm using the 'Export Users to CSV' a plugin for wordpress. By default, The plugin only extracts wp_users and wp_usermeta I have been wanting to add post_title column from wp_posts. I was able to ...
0
votes
1answer
410 views

Inserting Post Meta From SQL

I'm trying to get post meta to be updated/replaced with $wpdb and running into issues. I have working SQL, but cannot get it work when coding it up for my WP plugin. Extra note: The post meta being ...
0
votes
1answer
554 views

Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]

I'm transferring a bunch of domains a new host. The site names remain the same, and for the sites I've already migrated, no manipulation was necessary in the database. It just works once name-servers ...
1
vote
1answer
14 views

My SQL function to change user_name

My wordPress database was hacked and all users_names were changed to the same thing. I'd like to write a mySql query to replace all usernames that = "x" to the user_nicename. I'm unsure how to do this ...
0
votes
1answer
86 views

How to properly send many mysql queries via php and what happens with ajax requests after they are sent?

I need to update the details of a few thousand accounts and I can't do it with pure MySQL, I need php too. With all the loops that's probably around 100k mysql queries. I chose to do it via a button ...
1
vote
0answers
23 views

Regarding “Insert query error” in wordpress

I am getting "Insert query error" in my WordPress eCommerce website when I click on the place order button. My error is: Insert query error - Table 'i1503672_wp6.wp_wa_product_orders' doesn't ...
1
vote
2answers
155 views

Changing Table Prefix for an Existing WordPresss Site

Hoping someone can assist with Wordpress table prefix for an already established site. What is the best approach in changing the existing table prefix within both DB and wp-config file to reflect new ...
1
vote
2answers
40 views

What happens if I overwrite the current wp_options table with a backup from a week ago?

I have a rather silly situation. I tried this query UPDATE wp_options SET option_value = 'a:0:{}' WHERE option_name = 'active_plugins'; which disabled all my plugins. I was testing some issues on ...
0
votes
1answer
48 views

Geographical proximity query using post_meta

I realise this might be an inefficient query, but I'm trying to grab latitude and longitude values from the post_meta table that are connected to posts to figure out the proximity of the posts to a ...
0
votes
1answer
38 views

Custom post order when using OR relation

I have a custom post type named Faculty. They can be any of the type MCT, MLT, or MT. MCT -> A, B MLT -> C, E MT -> C, D I want to list all MLT and MT faculty on a page in order by last ...
0
votes
0answers
21 views

Ordering topics by most replies in X days using MYSQL statement

I'm using the following MySQL statement to grab the topics (BBpress custom post type) that have the most replies (custom post type like comments) in the last X days. However I've found that I get ...
0
votes
1answer
22 views

Copy from wordpress for dev gives different output in browser

I'm trying to accomplish the following: Havin a copy of the current live site to do some development. I would currently prefer to have the dev site on the same server. I did the following: List ...
0
votes
1answer
953 views

MySQL: How to change url in posts from xxx.com to yyy.org?

Recently I switched my domain, unfortunately before that a lot of posts had internal linking to my own other posts by including the old yyy.com domain. I need to change it in all my posts, via MySQL ...
0
votes
1answer
64 views

What should a WordPress developer know about MySQL? [closed]

During my 1 year job, I usually get to work with the front end and rarely get a chance to run any query. I have written 0 queries so far. What knowledge of MySQL should a WordPress developer have?
0
votes
2answers
984 views

Custom MySQL Query for Post and Post Meta

I have a custom table called "tags" that contains a charity_id that is a reference to a post ID ... I need to query the "tags" table to grab this charity_id and then pull in the post title and a few ...
0
votes
1answer
80 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
127 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
67 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
58 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
80 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 form-edit-account....
0
votes
0answers
99 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
835 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
45 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
51 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
55 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
46 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
297 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 What ...
1
vote
2answers
162 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
103 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 ...