All Questions
7,885
questions
0
votes
2
answers
79
views
My Search function isn't working when I search by name
so I've tried creating a Wordpress plugin that searches data in a different MySQL database and it works when I search by license number but when I search for any kind of name I get sent to a "...
-1
votes
0
answers
39
views
Set, fill, copy product variation sale price of a Woocommerce variable product
I need to copy the regular_price to the sale_price of all variables in a variable product.
The sale_price needs to be filled minus 10%.
The sale_price is empty now.
I tried this sql script, but it's ...
1
vote
1
answer
44
views
Where is stored the order from WooCommerce product category terms?
I am trying to understand where the display order of product categories defined by the admin is stored in the database. I intend to use this field in an SQL query to retrieve and display product ...
-1
votes
0
answers
38
views
How to fix a Wordfence scan that doesn't finish? [duplicate]
I've used Wordfence for my website on Wordpress.org (through Hostinger) and my scan yesterday showed me this message:
Error writing value for wfsd_engine (MySQLi error: [2006] MySQL server has gone ...
0
votes
0
answers
31
views
Set Alt text for product images with the short description product with SQL for better SEO
I would like to update the alt description of an image assigned to a woocommerce product, and set it to the value of product short description.
I can select values like that
SELECT p.post_title, pm....
0
votes
0
answers
15
views
Mysql Query to retrieve featured posts published on the WordPress
I'm trying to build a Mysql Query to retrieve featured posts published on the WordPress homepage via PHP.
I can't understand in which column the fact that an article is featured and published on the ...
-1
votes
1
answer
44
views
MySQL is rejecting connection when using WordPress in XAMPP
I was developing a website locally on WordPress without any problems until today, when I got an error from MySQL stating, "Error establishing a database connection." Then, I checked the ...
1
vote
0
answers
42
views
is there anything i can do to resolve mysql database problem in xampp
how do I fix this
My MySQL server unexpectedly crashed, resulting in my WordPress website losing connection and the database shutting down. I'm using a Windows laptop and need assistance resolving ...
1
vote
2
answers
27
views
Can not get my SQL Select statement to work with CASE
SQL Noob here. Pulling some data from a custom table in a WP install and I want to get the user information from both user_meta and users table.
The resulting array should look like this.
array(
...
0
votes
0
answers
51
views
Chisel Wordpress Installation - Error: Failed to get current SQL modes
I've run into an issue trying to setup a WordPress using Chisel. I'm using VS Code, XAMPP on Windows.
After successful download of WP Chisel tries to setup connection with database and here I'm ...
0
votes
1
answer
23
views
Wordpress shortcode to get service prices from database effectively
I want to display service prices dynamically in my HTML. I have prices in MySQL db. I have created shortcode to get each service price individually, so if I have 10 services(i display some of them ...
0
votes
0
answers
23
views
How to add a table to database within a custom plugin in WordPress [duplicate]
$departments_sql = "CREATE TABLE IF NOT EXISTS '" . $departments . "'(
'ID' bigint(20) NOT NULL AND AUTO_INCREMENT,
'name' varchar(128) NOT NULL,
'parent' bigint(...
1
vote
0
answers
25
views
PMPRO Membership level name on post thumbnails
I'm trying to add css3 corner ribbon with the paid memberships pro level name for each post in acrhives, my function below is working fine on homepage but when I navigate to Wordpress category ...
0
votes
0
answers
32
views
How to Fix mySQL Database Error In WordPress
After making some changes to a WordPress installation, I started getting the error below. I spent much time checking and fixing the database, dropping and emptying... But the error below remains. Any ...
0
votes
1
answer
41
views
If older than todays date > change "published" to "draft" (Wordpress)
I'm using a plugin that allowes users to post events frontend.
They can choose publishing date, and expire date.
The plugin does its job by "unpublishing" events at the correct date, but is ...