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

learn more… | top users | synonyms

0
votes
0answers
16 views

WP Meta Query - mixed AND / OR query doesn't work

I am absolutely boggled by this one. I am creating a search function for a property site - simple enough. Simple queries such as max_price, max_beds, rent_or_buy work ok. But I am trying to create a ...
-1
votes
0answers
18 views

Why is it saving multiple rows at once just after login?

I want to save user login time. When I logins it save multiple rows in the table user_logins. Here is the code from my plugin: function ai_save_user_login_test() { global $wpdb,$table_prefix, ...
0
votes
0answers
12 views

Nested if mysqli statement in PHP HTML [closed]

this is my code if (isset($_POST['firstName_in'])) $firstName_in = $_POST['firstName_in']; if (isset($_POST['surName_in'])) $surName_in = $_POST['surName_in']; if (isset($_POST['afirstName_in'])) ...
0
votes
0answers
18 views

upgraded a MySQL 5.1 database to 5.5 and now my wordpress site wont connect

I was upgrading my package with my ISP and they told me to export mySQL database create a new one and import the data via PhpMyAdmin. They neglected to mention that the new database would be ...
0
votes
0answers
18 views

Move to MariaDB [on hold]

I have just installed MariaDB on my VPS. I am having a strange issue when importing a working database into it. When logging into WordPress, it asks me to 'update' the database, just like if you were ...
-1
votes
1answer
19 views

SQL error #1062 - Duplicate entry '1' for key 'PRIMARY'

When I want to import database, I get the next error: Error SQL query: -- -- Dumping data for table wp_comments -- INSERT INTO wp_comments ( comment_ID , comment_post_ID , comment_author , ...
-4
votes
0answers
30 views

How to clear the below mentioned error [closed]

I am getting an error in my site how to clear this. PHP Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in ...
-3
votes
0answers
10 views

Upgrade from MySQL 4 to MariaDB [on hold]

I am currently hosting my Wordpress websites on MySQL 4.0. I have been doing a lot of performance tuning on my VDS recently and wonder if upgrading to MariaDB 10 will offer any performance boosts to ...
0
votes
1answer
11 views

Missing latest posts and options after DB migration via phpMyAdmin

The latest posts and options are not appearing after importing the database. I'm missing all the latest posts and the latest Advanced Custom Fields. The export is from the remote server and import to ...
0
votes
1answer
24 views

Remove Featured Image based on Date

I have an issue I can't seem to fold a solution for. I'm looking for a way to mass remove the featured images of posts older than X amount of days. 150 days is my target but if I can set it to ...
0
votes
0answers
11 views

Database collation and char set issue

I attempted to import my WordPress website from local host to live server online and i get an error #1115: that i have wrong db collation of utf8mb4. So i googled and changed the cllation to ...
0
votes
1answer
28 views

Wordpress Multisite with thousands of blog

I'm setting up a wordpress site where each user will need to have their own blog. My thought was it's the perfect use case of Wordpress Multisite. I've setup it with multisite using Sub-directory and ...
0
votes
0answers
19 views

After Submitting Form Successfully, The Values Not Stored In Wordpress Database

<?php /** * * Template Name: xoneform * */ echo "Welcome to Xone Form"; ?> <?php print_r($_POST); if ( isset( $_POST['submit'] ) ){ $insert = $wpdb->insert( 'wp_xone_form', ...
0
votes
1answer
19 views

Use variable in SQL statement

I have this: <?php $jerseys = $wpdb->get_results("SELECT order_item_id, order_id FROM wp_woocommerce_order_items WHERE order_item_name = 'Mystery Jersey'"); echo "<p>Jerseys</p>"; ...
0
votes
1answer
14 views

Weird characters displayed when importing WordPress MySQL db

I was thinking that it may be the collation, but I have no way of know what the production db collation is. The local one has been changed between UTF8_bin and UTF8_general_ci, to no avail. I'm seeing ...
0
votes
1answer
37 views

Restore woocommerce orders

Recently my server team replaced my database and they put our previous Database . So we lost our order details of one day[particular day] . Now the server team give the backup that contain the lost ...
0
votes
2answers
33 views

How to get Attachments(image) with specific width\height ratio

I need to get attachment images with horizontal orientation. I tried to use Meta_Query but I don't know how to compare two values (width and height) from one associative array that is in wp_postmeta ...
0
votes
0answers
33 views

Query can not search data with space?

I have following code $wpdb->get_results( 'SELECT * FROM '.$device_token_table.' WHERE user_pushtoken="'.$server_method['user_pushtoken'].'" AND user_id = '.$user_id,ARRAY_A ); ...
0
votes
0answers
23 views

Join Wordpress databases from 2 different installs

I'm just now getting into SQL and the core of Wordpress (PHP). So I'm not an experienced WP developer but not intimidated by the tools. But, if the answers could be dummied down a bit would be very ...
0
votes
1answer
26 views

How to add query vars with paginated URLs?

How I can insert some custom url parameters to pagination links? the code below display like page.php?cpage=2 But I would like to add a parameter category with value fruit. So, the final url will ...
0
votes
0answers
30 views

WP_Query order by number of likes

I'm trying to configure WP_Query to order by number of likes. I have a custom table called 'likes', which records which liker (user ID) likes which post: id | liker | post_id 1 | 11 | 120 2 ...
0
votes
0answers
36 views

How to delete a stuck post using phpMyAdmin

I was attempting to change some leftover http:// references in the DB using Update/Set SQL statements. I was getting confident and started doing them in bulk and stopped noting exactly what I was ...
-2
votes
1answer
53 views

Submit cf7 form to cfdb as pdf/BLOB

I have a form created in CF7 with a signature field. I am also using CFDB. Rather than do the usual submit, I would like to capture the form as an image in a pdf and insert it into CFDB in a BLOB. I ...
0
votes
0answers
14 views

WordPress Stored Procedure - Commands out of sync, you can't run this command now

I'm having trouble trying to call a stored procedure for my WordPress plugin. I am receiving the following error: CALL category_GetName(3) Commands out of sync; you can't run this command now ...
0
votes
0answers
38 views

How to create a coupon in the database?

I added over 1000 coupons (schedule ones) in the database. I had one line in wp_posts and several wp_postmeta tables per coupon. To add, I've saw how a coupon was represented there and I've made ...
0
votes
0answers
19 views

How to configure MySQL-SSL-Access to a MySQL Server 5.5 when a list of CIPHERS seems mandatory?

I have a MySQL 5.5 Server with SSL setup. I can connect with my MySQL user via command line from the webserver to the database server over TCP and verified the connection is encrypted. I figured out ...
0
votes
0answers
34 views

SQL Query for all posts in specific category

I try to add a custom field to all posts in specific category with a sql query. This query set meta_value of new meta_key as post_author value in ldn_posts table. Here is begin of the code (works for ...
0
votes
0answers
29 views

How to unwrap/separate Html tags in pages?

I have around 300 pages with some of them having wrong HTML formatting that I have to fix. I want to: Separate the H1 tag from the inner tags. Moving the TITLE (found in span) to H1. Get rid of the ...
0
votes
1answer
38 views

Error while importing database

A WordPress website is created and MySQL is the database for it. When tried to import the database to an empty database via Linux Command Shell we encountered below errors: ERROR 1146 (42S02): ...
0
votes
1answer
25 views

Accessing data from a non-WP database/table within a page content

I'm trying to convert a home built (PHP / MySQL) set of web pages to WP. I've installed the theme I want and have some basic pages working OK. However, I have a set of data within a MySQL database ...
0
votes
0answers
13 views

Database table not created without error

I have this code to run on activation to create the table $table_name = $wpdb->prefix . "codes" function code_install() { $sql = "CREATE TABLE IF NOT EXISTS " . $table_name . " ( id ...
0
votes
0answers
28 views

Send data from plugin to external database

I'm creating a plugin that I need write data to an external database (not the wp db that the plugin is on). I know I can use require_once with a separate config file with the external db details in ...
0
votes
2answers
37 views

Using wordpress function to retrieve data

I have been working on open source plugin and trying to add a new feature to it. For now I have been doing like this else if( $selected_report == "greport" ) { $sql = mysql_query( "SELECT ...
0
votes
0answers
18 views

wordpress query between zipcodes not working

Ok, I have this code that checks for zipcodes in the database, normally I can simply do a between query, but the zipcodes are stored in the following way: zip_code::2025 (meta_value in the usermeta ...
0
votes
0answers
40 views

WordPress database error Deadlock found

My website become slow due to this issue. WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_options WHERE option_name LIKE ...
0
votes
0answers
38 views

Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error

This is a bug in my WP install that has crept up unknowingly; I can't say for sure when it began. To describe it: there were menus created in the Appearance -> Menus page early in the site's history, ...
0
votes
1answer
57 views

How to merge local and live databases?

We've been developing for Wordpress for several years and whilst our workflow has been upgraded at several points there's one thing that we've never solved... merging a local Wordpress database with a ...
0
votes
0answers
21 views

Best Way To Merge My Existing Custom User Database With WordPress?

I'm sure this has been asked before though I can't seem to find a clear answer or clear direction on how to handle this. I would appreciate a point in the right direction. I have an existing custom ...
0
votes
0answers
16 views

change data in mysql but don't change in admin

I have a problem, I have changed the content of my page in MySQL, but when I reopen the same page in the WordPress Admin panel, the content hasn't changed why is this? I'm using the interconnect ...
0
votes
1answer
29 views

Do I need to prepare query before get_results(), get_row() and get_var()?

I know that we don't need to use prepare($query) when we put it in insert() and update() because these functions sanitize data for us but I'm not sure if we need to prepare query before putting it in ...
-1
votes
1answer
44 views

SQL command to convert all tags in lowercase?

I'm looking for a SQL query command to convert every single tag in every post ever used to be converted into lowercase.
1
vote
1answer
118 views

What SQL / WordPress queries would need a nonce?

I'm a PHP / JavaScript developer and I'm new to WordPress. Our company's website is build upon WordPress. However I created many custom PHP pages without minding the WordPress framework much. When ...
1
vote
1answer
41 views

Custom Plugin For Converting CSV To MySQL

I wrote a plugin to add a csv file to the database. I created a custom table to use. My file path looks like this, wuno-uploader/wuno-uploader.php wuno-uploader/inventory.csv On an settings option ...
1
vote
0answers
43 views

Visual/Text Editor displays blank pages in WP-Admin- but HTML on client side displays correctly

Theme: Hemingway, Twenty-Sixteen Host: Bluehost Browser(s): Safari, Chrome OS: OSX El Capitan 10.10.5 (14F1605) Website When I try to "Edit Page" visual editor screen is blank, in both Text and ...
1
vote
1answer
18 views

Function causing the loop display posting more (empty)

By using the function: add_action( 'pre_get_posts', 'add_custom_post_types_to_loop' ); function add_custom_post_types_to_loop( $query ) { if ( is_home() && $query->is_main_query() ) { ...
1
vote
2answers
55 views

Create WP_Query to search for posts by their categories or their parent/child categories

Hello I am really sorry if this has been asked before but I couldn't find the exact solution I need. So here's the problem I want to create a search in my Wordpress page. Whenever a user submits the ...
1
vote
1answer
15 views

Is there a way to recover the table wp_term_relationships?

I'm trying to help a Non-Profit Organization with their site (which is built with Wordpress) that suddenly became "buggy"/odd: menus were missing, categories were empty, etc. I'm no expert around ...
1
vote
0answers
29 views

How to translate this mySQL query to $wpdb query

I'm having trouble recreating a query from straight mySQL to $wpdb compatible. SELECT meta_value FROM `wp_postmeta` WHERE meta_key = 'review_rating' AND meta_value = 5 AND post_id IN ...
1
vote
2answers
42 views

Wordpress SQL Issue not returning correct reselts

So, I have been working on an SQL query involving the users and usermeta tables in wordpress. I am not getting the correct results. I have the following query written SELECT * FROM ...
1
vote
2answers
40 views

$wpdb select all meta for each post

I'm running the following query trying to get the data and associated meta data of a huge number of posts: SELECT wp_posts.post_title, wp_posts.post_date, wp_posts.ID, wp_postmeta.post_id, ...